My module is now done and dusted ! I created the references file in MS-Word, then made a .csv file by copy-pasting the data into notepad++, saved it in .csv format, then imported it into SQLite (dropdown menu in top-left corner > File > Import > “Table from CSV file...”) into my already ToolTip-created bible module and voilà. It took me a few days for adding 1819 references in the NT. It works flawlessly, thanks to everyone for your recommendations.

Hello everyone,

There are several wrong statements here that I want to amend (apart from the numerous typos, which I’ll not go into). It may be due to the fact there’s a new version of both SQLite and e-Sword nowadays:

1. “Note: before working on any modules that are installed into e-Sword, copy the module you want to edit to another folder. Modules in your e-Sword folder in the Program Files cannot be written or saved to!”

That’s wrong: The changes are applied instantly in e-Sword when I edit the module with SLQLite and this, DIRECTLY INTO THE E-SWORD FOLDER (C:\Program Files\e-Sword). I am able to edit the module “on the fly”, with e-Sword open moreover. No need, even, to change tab and come back to see the changes, which is nothing short of amazing.

2. “Once the SQL Statement is pasted into the box, click the Apply Button near the bottom of the box. Clicking Apply will execute the SQL statement and create a new table in the module/database.”

Wrong again: one must click on the BLUE BUTTON (arrow) in order to do this, not “click the Apply Button” that is situated at the bottom-right corner. This blue arrow is situated ABOVE the box “Execute SQL”, below the tab. One can also hit the F5 key or do Ctrl+R or Ctrl+Return (in case you don’t have a mouse).

3. “and then add the following piece html code: <N1> . Click Apply to enter this code into the bible verse. The bible verse in the Bible table will look like this: And God said,<not>N1</not> Let there be light:<not>N2</not> and there was light.<not>N3</not>.”

Wrong too: from v.9 (as I recall, not sure) and beyond, e-Sword doesn’t read HTML code anymore. Instead, it looks like this now (this is one example of the module I did yesterday): {\fs18\super\cf2\b R16}.

\fs18 is for the Font Size of the reference (here, R16).

\super is to indicate it is a superscript.

\cf2 is to Color Font (here light blue in my case).

\b is for Bold.

R16 is “Reference 16).

I have 1819 references in the NT module I just recently created, from R16 to R1834 (the first 15 are in the Preface which I put in a .dctx module, along with all the references). It works flawlessly. The light blue color lower size superscript is discreet, doesn’t clutter the text too much, it’s perfect.

Also take note that one can IMPORT A TABLE in csv format (note.csv) into the bible module in SQLite. That is exactly what I did. I worked with MS-Word 2016, then copied-pasted the text into notepad++, saved it in the .csv format and voilà. In SQLite, in the dropdown menu, click on File, then Import, then “Table from CSV file...”. Then look for it on your computer, load it and SQLite will notice there’s already a table named “note”, will propose you to import the data into the existing table. Click ‘yes’ and that’s it. It is WAY easier to prepare your references with a word processor than to copy them one by one in SQLite, obviously. Unless you have time to lose. That option saved my life as I already had them ready in a .docx (MS-Word) file.

Hope that helps. God bless.

Just to add a tad more info on this, without reinventing the wheel, and using an existing one, particularly using a third party resource file, eg., a Bible file, one can use the SQLite to create a new version out of that file. That is the method I used for the creation of the Maori Bible.

 

I guess you can call this recycling.

 

Blessengs,

That's good to know, thanks!

The first thing you need to understand is the all e-Sword modules are SQL databases and can be edited using an SQL database editor. Tooltip NT does not have the functionality to create Popup notes however they can be easily created using an SQL database editor. 

I have posted the instructions for creating Popup notes the post that the previous poster provided a link to

Yep, that's exactly what I need, thanks!

You can find more info about making pop-up notes in e-Sword bibles here:

 

http://www.biblesupp...-bible-modules/

Thanks a lot, that's exactly what I was looking for !

Hello everyone, brothers and sisters.

I have a question for you: is ToolTip Tool NT the only program available for making e-Sword modules?

Because I'm currently trying to make a bible module in which there are hyperlinks (for ex. R123, for reference #123) wherein you hover the mouse over it and a popup window appears with either a remark, a reference or an explanation. So far, the only module I found achieving this is ESV+ (which module is not linked to any other module like a .cmtx or a .dctx, amazingly enough). How in the world did they manage to make it? Someone please tell me because this is not possible with ToopTip Tool NT.

Thanks and God bless you.