17 replies to this topic

[gad4]

What is the best way to edit a mysword bible?


When converting from esword, it changed all strongs numbers from g to h in simple bible reader and would like to do a universal replace.

[Katoog]

First, what do you have? Your busy module OR an module that already exist in mySword format?

 

And why do you change the g of Greek to the h of Hebrew?

The Strong's numbers are alphabetical and Greek is not Hebrew.

Do you have a Bible with both Testaments OR "only OT" OR "only NT".

 

 

 

 

[JPG]

First, what do you have? Your busy module OR an module that already exist in mySword format?

 

And why do you change the g of Greek to the h of Hebrew?

The Strong's numbers are alphabetical and Greek is not Hebrew.

Do you have a Bible with both Testaments OR "only OT" OR "only NT".

Notice the fine detail of the post. 

When converting from esword, it (meaning Simple Bible Reader) changed all strongs numbers from g to h in simple bible reader

 

 

 

What is the best way to edit a mysword bible?


When converting from esword, it changed all strongs numbers from g to h in simple bible reader and would like to do a universal replace.

So the question being asked is how can gad4 do a universal replace in the converted module to change the Strong's prefix letter.

[Katoog]

Ok, If you have a MySword module:
download DB Browser for SQLite
https://sqlitebrowser.org/dl/

Open the database then click file and export it as sql file and select all tables.
now you have a .sql that is a text file.
open with notepad and click edit and use the "replace all" option for the problem.
<WH
<WG

save the file and the click file and import with DB Browser for SQLite and save and quit.
remove the .db in the extension.

 

[gad4]

Thanks

I tried installing software and i exported.. made changes and imported

1. It asked if i wish to import it to same file or different.

2.. when i tried saving only choice was .sbqpro ( not db)

File at end said no bible books found.
Was very tiny

.i tried saving it to new file. Got db extension but not usable by mysword after renaming.

Edited by gad4, 20 January 2022 - 11:34 AM.

[Katoog]

You need to choose a different file by changing the .sql or txt into a .bbl.mybible extension

for example to: atest.bbl.mybible

 

If your file is the ABP: you can download it with the MySword program

click on the gear symbol and "download modules" and select Interlinear instead of English.

 

[gad4]

The mysword abp is not strongs searchable

I did rename the .db to bbl.mybible.
It still didn't recognize and was apx 3 m smaller

Edited by gad4, 20 January 2022 - 01:16 PM.

[modulist]

Probably what you need to do instead is just export the Bible table to CSV in the MySword database file. The easiest way would be to right-click the Bible table in DB Browser for SQLite, and choose "Export as CSV File." After you have saved it wherever you like, you can open the CSV file in the text editor of your choice (Notepad++ on Windows, for example, or BBEdit on the Mac, for another example). After doing you search and replace stuff on the file, save it and close your text editor.

 

Now, you should now delete the existing Bible table in your MySword file in DB Browser, and then choose "File>Import>Table from CSV File..." You shouldn't need to change any of the settings shown. This will re-create the Bible table.

 

The next thing you need to do is click the "Execute SQL" tab, and paste the following into the top section of the window:

CREATE INDEX "bible_key" ON "Bible" ("Book" ASC,
"Chapter" ASC,
"Verse" ASC
);

Then press F5 or click what looks like a play button just above where you paste the above code.

 

Lastly, save your changes by pressing Ctrl+S (Windows) or Cmd+S (MacOS).

 

I know this seems like a lot of steps, but it should work better for you. I hope these instructions are clear enough.

 

Hope it works out for you. 

[gad4]

I got this error when compiling:

Execution finished with errors.
Result: index bible_key already exists
At line 1:
CREATE INDEX "bible_key" ON "Bible" ("Book" ASC, "Chapter" ASC, "Verse" ASC );

This error in mysword:
Can't load the module abp+'s Exodus 2, chapter 2 and verse 0. Database file: /storage/emulated/0/mysword/bibles/aa1a.bbl.mybible. no such column: verse (code 1 SQLITE_ERROR[1]): , while compiling: select verse, scripture, rowid from bible where book=? and chapter=? order by verse

[JPG]

The mysword abp is not strongs searchable

I did rename the .db to bbl.mybible.
It still didn't recognize and was apx 3 m smaller

It is Strong's searchable. You have to select in the search window "Type" Full text search, which makes an index of all data. I just tried this on the ABP with a search for G746 and it got many hits.