Jump to content

Please read the Forum Rules before posting.

Photo
- - - - -

My Adventure with the KJV+TVM

Whole Bible

  • Please log in to reply
4 replies to this topic

#1 APsit190

APsit190

    e-Sword Tools Developer

  • Members (T)
  • PipPipPipPipPip
  • 2,861 posts
  • LocationLand of the Long White Cloud (AKA New Zealand)
Offline

Posted 07 April 2021 - 07:37 PM

Currently I've been working on editing the KJV+TVM Bible for e-Sword. Somehow I got a gut feeling that I've done a similar post on this before, bu just can't seem to remember where or when I did it. Anyway, I've created a kind of a tutorial of how this is being done using SQLite, showing both the editing of the font size and color.

 

This video is raw, as in unedited, but trust you will find it useful and interesting.

 

 

So, on that note, sit back and relax, and enjoy

 

Blessings,

Stephen (Php 1:21).


X (formerly Twitter)

 


#2 PeanutGallery

PeanutGallery

    e-Sword Fanatic

  • Members
  • PipPipPipPipPip
  • 148 posts
Offline

Posted 08 April 2021 - 06:18 AM

Is it possible to edit any Bible module using SQLite instead of ToolTip NT?



#3 APsit190

APsit190

    e-Sword Tools Developer

  • Members (T)
  • PipPipPipPipPip
  • 2,861 posts
  • LocationLand of the Long White Cloud (AKA New Zealand)
Offline

Posted 08 April 2021 - 05:20 PM

Is it possible to edit any Bible module using SQLite instead of ToolTip NT?


Yes, providing that the resource isn't locked, such as (if not most) all resources from this site. Basically, the only ones you can't edit are those you download via the e-Sword Download manager, and the ones you purchase from the Lockman Foundation and e-StudySource.

 

That said, when it comes to editing in SQLite, it should mainly be used for minor edits. Anything that's going to take a greater amount of editing should really be done in T4. In what I am doing, editing rtf code, is basically very quick, and pretty much straight forward. Not only that, because the when it comes to editing in SQLite, as seen in the video, you can see the result almost straight away without having to close the file. But when using T4, in order to review your work in e-Sword, you have  to close the file, and then reopen it to continue editing. For me, that's just way too much unnecessary work.

 

When it comes to doing screen recording, it only works on one Monitor. What I seriously would love to have is a very wide [curved] monitor; something like a 36" (3ft) one. That would be really cool because then one can actually have both e-Sword and SQLite Database Manager side by side and etc., working together. Not a bad idea.

 

Well, there it is, and so I trust you find this helpful.

 

Oh yeah, visit my DRailed4700 YouTube channel for other content relating to e-Sword and SQLite Database Browser; plus a heap of other stuff that might interest you. Also, feel free to download any content you feel might prove helpful to you. And finally, leave a like and subscribe to the the channel.

 

Blessings,

Autograph.png

Edited by APsit190, 08 April 2021 - 05:22 PM.

X (formerly Twitter)

 


#4 JPG

JPG

    Jon.

  • Moderators
  • 1,665 posts
Online

Posted 09 April 2021 - 05:20 AM

Stephen, as you are using DB Browser for SQlite, you could use a statement in the "Execute SQL" tab to achieve the same result but much quicker and not missing any verses either. I just did the whole module in 3.5 seconds

why not get another copy and try this SQL statement.

update Bible set Scripture = replace(Scripture,'\cf11', '\fs20\cf12') where Scripture like '%\cf11%';

Jon



#5 APsit190

APsit190

    e-Sword Tools Developer

  • Members (T)
  • PipPipPipPipPip
  • 2,861 posts
  • LocationLand of the Long White Cloud (AKA New Zealand)
Offline

Posted 09 April 2021 - 10:43 PM



Stephen, as you are using DB Browser for SQlite, you could use a statement in the "Execute SQL" tab to achieve the same result but much quicker and not missing any verses either. I just did the whole module in 3.5 seconds

why not get another copy and try this SQL statement.

update Bible set Scripture = replace(Scripture,'\cf11', '\fs20\cf12') where Scripture like '%\cf11%';

Jon

Hi Jon,

Did what you suggested, and yep, it worked.

 

So, with that, thanks a big heap for the suggestion as it saved a heap of time and work.

 

Also did a video of it in which I showed the steps, and the before of what it was like, and the after effects.

 

So with that, sit back and enjoy the video.

 

 

Blessings,

Autograph.png

Edited by APsit190, 09 April 2021 - 10:46 PM.

X (formerly Twitter)

 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users