2 replies to this topic

[openglgnzd]

Hello,

 

I'm a complete newbie who has a (non-encrypted, free-to-use) sqlite3 file of a bible version in my local dialect. I've scoured the forums and the web for information on how to turn this sqlite3 file into bblx, without success. I've looked into T4 and e-sword converter tools, but can't figure out how or whether they can do the task. Can anyone please help?

 

Much thanks for a quick and kind reply.

 

gil

[earnest17]

till now no one answer this;;?

[Kamau Mweru]

Hi Gil,

 

The easiset way, if you have the bibletext and know some databse SQL etc... Is to create the bblx modeule this way.

 

--
-- File generated with SQLiteStudio v3.2.1 on Tue Aug 20 23:37:45 2019
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: Bible
DROP TABLE IF EXISTS Bible;
CREATE TABLE 'Bible' (Book INT, Chapter INT, Verse INT, Scripture TEXT);
INSERT INTO Bible (Book, Chapter, Verse, Scripture) VALUES (40, 1, 1, 'Detta är boken om Jesu Kristi, Davids sons, Abrahams sons, släkttavla.');
And so on the rest of the book,chapter,verse you have....
INSERT INTO Bible (Book, Chapter, Verse, Scripture) VALUES (66, 22, 21, 'Vår Herre Jesu Kristi nåd <i>vare</i> med er alla. Amen.*');

-- Table: Details
DROP TABLE IF EXISTS Details;
CREATE TABLE Details (Description NVARCHAR (250), Abbreviation NVARCHAR (50), Comments TEXT, Version INT, RightToLeft BOOL, OT BOOL, NT BOOL, Apocrypha BOOL, Strong BOOL);
INSERT INTO Details (Description, Abbreviation, Comments, Version, RightToLeft, OT, NT, Apocrypha, Strong) VALUES ('MyVerision', 'MyVer', 'Some description', 4, 0, 1, 1, 0, 0);

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;

 

/Kjell aka Kamau

Edited by Kamau Mweru, 20 August 2019 - 02:35 PM.