15 replies to this topic

[jocerva]

Blessings! 

 

I hope someone can help me. I tried to create modules for e-sword using sqlite because I don't have a pc, I haven't been successful and I haven't found information on the subject. 

 

Has anyone been able to create modules with sqlite? I will be very grateful for the support you can give me. 

[Katoog]

Too less info of the kind of modules that you like to make.

But learn first how it works and how to edit.

 

Find modules that are apple compatibly and not locked.

All apple modules ending with an i in the extension.

 

Download DB Browser for SQLite for your OS. (Mac, Linux)?

https://sqlitebrowser.org/dl/

 

start DB Browser for SQLite

click on File and Open Database

select All files (*) and find your apple modules

click on "Browse Data" and select the table

 

click on File and Export and Database to SQL file

select all the tables and Save

You have now a SQL file that is a txt file

add .txt and open it with a word processor.

 

study how it works and make some edits.

 

Then import (File and Import) the SQL file with DB Browser for SQLite

And save changes when you close SQL file with DB Browser for SQLite

remove the .db extension

 

Apple modules using HTM tags

<i>italics</i>

<b>bold</b>

<red>red</red>

<blu>blue</blu>

^{^superscript}

_{_subscript}

<br />

line-break

 

<grk>Ἑλληνικός</grk> Greek
<heb>עִבְרִי</heb> Hebrew, Aramaic or right to left reading script.

<num>G976</num> Strong's numbers.
<tvm>N-NSF</tvm> Robinson's Morphological codes (tvm means tense,voice,mood of a verb).

 

<not>N1</not> notes in gold-colour OR in combination with a table for the notes.
 

___

A tool that can help you with creating modules is "add prefix and suffix

https://www.miniwebt...fix-and-suffix/

This helps you to mark the beginning and end of a verse.

Then can you use the marks to edit before and after the text

Here are Gen 1:1-3 in my translation (Restored Holy Bible 15 HD edition)  in SQL code.

 

INSERT INTO "Bible" VALUES (1,1,1,'<font color=#008000>Scroll 01 Genesis.</font><br />               <font color=#008000>[Creation].</font><br />               In <i>the</i> beginning GOD created the Heavens and the Earth.');
INSERT INTO "Bible" VALUES (1,1,2,'And the Earth was without form, and void; and darkness <i>was</i> upon the face of the Abyss:<br />               and the Spirit of GOD was hovering upon the face of the waters.');
INSERT INTO "Bible" VALUES (1,1,3,'And GOD said, Let there be Light! And there was Light.');

 

Edited by Katoog, 07 October 2022 - 07:23 AM.

[modulist]

In addition to what Katoog has said, a very important tag is:

 

<ref>Mat 1:1</ref>

 

This creates "tool tipped" scripture references. Unlike in the Windows version, these must not have an underscore in between the book and chapter:verse reference. So don't write Mat_1:1, or the reference won't work. However, it will appear underlined automatically in e-Sword for Mac/iOS/Android.

 

I have indeed created resources using an DB Browser for SQLite on the Mac. It takes more technical knowhow to do it, obviously, but it can be done. Katoog has given you some good advice to get you started.

[Tj Higgins]

If you are using a MAC there is a program called Crossover MAC from a company called CodeWeavers that will allow you to run Windows Software on the MAC OS.

 

https://www.codeweav...m/crossover#mac

[APsit190]

Blessings! 

 

I hope someone can help me. I tried to create modules for e-sword using sqlite because I don't have a pc, I haven't been successful and I haven't found information on the subject. 

 

Has anyone been able to create modules with sqlite? I will be very grateful for the support you can give me. 

To give you a way less technical answer. Yes you can.

 

That said, here's a tip that you can use for when it come to creating different resource types.

 

You don't need to create a new database file. Simply use an existing third party database files as a template for what you want to create. Perhaps that is the simplest way to go about it. For example, when I created the Maori Bible for e-Sword (Click here for the iOS, android, and macOS edition), I used an existing third party Bible (bblx) file, renamed it, put in the information of that Bible and etc., then deleted the text in each verse and replaced it with the Maori text. A lot of copying and pasting.

 

Now, this goes with any resource you want to create, whether is a Bible, Devotional, Dictionary or whatever. And I found that is the best way to do in SQLite.

 

Also, here is a way you can configure SQLite DB Browser for opening e-Sword resource files:

 

Trust you find this helpful

 

Blessings,

Edited by APsit190, 07 October 2022 - 05:58 PM.

[Olaf Bacon]

To give you a way less technical answer. Yes you can.

That said, here's a tip that you can use for when it come to creating different resource types.

You don't need to create a new database file. Simply use an existing third party database files as a template for what you want to create. Perhaps that is the simplest way to go about it. For example, when I created the Maori Bible for e-Sword (Click here for the iOS, android, and macOS edition), I used an existing third party Bible (bblx) file, renamed it, put in the information of that Bible and etc., then deleted the text in each verse and replaced it with the Maori text. A lot of copying and pasting.

Now, this goes with any resource you want to create, whether is a Bible, Devotional, Dictionary or whatever. And I found that is the best way to do in SQLite.

Also, here is a way you can configure SQLite DB Browser for opening e-Sword resource files:


Trust you find this helpful

Blessings,

Hello APSit190,
Please, when you create a video, talk your way step-by-step through each and every point of what you are doing, please. In this you have something open on screen. What is it? Oh, evidently you opened SQLITE DATABASE BROWSER. Must I be standing in a new folder, to do this, so I do not overwrite something important? I must guess that you have SQLITE DATABASE BROWSER but you do not tell me so. You just start with a screen open, and forget to tell me what you opened, and whether this was on the desktop, or in a empty folder.

You tell us you are going to do something, I listen, but then I hear absolutely NOTHING WHATSOEVER - your voice dies away to the sound of silence. What are the characters you are typing into the screen? I try again, I tell the video entry to restart, from the beginning, and I close my eyes, to really, really, concentrate, and I listen ever so intently, but still I hear mostly the sounds of total silence. You do not start by introducing what you have opened, or where. If I am going to edit an existing module, must I put the module to be edited, into a spearate folder, where I will be working?

You are typing some words - but never tell me what you are typing. You say it is saved - how - you never mentioned what you have clicked to make it SAVE instead of just CLOSE. Saved to where, was the filename changed? When I open the database will I reopen on a "New", or What name? How will I find this modified entry again? will it be the same name?

So, Stephen, tell us what we are to see on the screen, and what you did to get that screen background to optn. Tell us where you are moving the pointer to, what word or icon you want us to tap on, and when you type words, or characters, please tell us in spoken words, exactly what to type to be able to emulate what you do. In your mind's eye, just imagine that I am unable to see your screen at all - I am partially blind, or your screen appears totally out of focus - so I am unable to clearly see what characters you are typing.

The asterisk [Shift 8] and the full stop, are tiny on the screen, and need to be mentioned by you, in words, then as you enter each abbreviation types - please spell out the characters that you tyoe them, letter by letter, including the spaces. You can see, and you know what you want to type, but for someone who is listening, and cannot see you, a newbie, where do we get those words from that you are typing? then tell me, step by step, what I must select, to get the file to open, then what will appear on the screen, where I must move my pointer to, and so on. In this file you have opened something - some kind of database editor - was it SQLITE DATABASE BROWSER, and where had you placed it? Was it in its own folder? What was that filename called? where did you obtain it? You have some screen open - WHAT is it? What type of e-Sword for Windows are you using, what app have you purchased, is it available from the Microsoft Store, for free, or to be purchased, and is there different versions - say we are using windows 10, or using windows 11, will it work on both? and what's the program called, did you select it from a folder? which you selected, and then opened on the screen. Do not forget to tell us this preliminary information in your talks, please.

Then when your screen opens, tell me in words what effects we are to try to emulate, and what exactly you want us to see on the screen. For example, if we want to change the tab name of a bible we have downloaded - give us an example, for example, if I have a .bblx and a .bbli file, and I want to see if the .bblx is coded in HTML or coded in RTF coding, how do I see this? I know the .bbli will be overwritten by the .bblx file, so I need to rename the tab of one, so as to have both .bbli and .bblx load at the same time, then I must change the tab abbreviation. If the .bblx has information that has blacked out with a background color, how do I remove the wrong color? Show an example, please. Thanks.

Edited by Olaf Bacon, 08 October 2022 - 04:31 PM.

[APsit190]

Olaf, the best way to watch a video is by:

1. On the bottom left hand corner, click on "Watch on YouTube," and then click on the Full Screen Button or hit the "f" key. Or
2. Click on the Full Screen button on the bottom right hand corner or hit the "f" key to view in full screen mode (without going on YouTube).

As to the volume bit, I don't have an issue with it as it works fine on my desktop. So the problem is with your machine. Suggest you toss it out and get yourself a new one. <<< I can see the reaction to that one. I reckon that would be like heart attack material.

Edited by APsit190, 09 October 2022 - 07:08 AM.

[jocerva]

Hello everyone

 

Thank you for your comments and advice, I am sure they will be of great help to me. Actually what I am looking for is to create a new file without the need to recycle any module. However I have learned from his advice 

 

Blessings! 

[Tj Higgins]

Hello everyone

 

Thank you for your comments and advice, I am sure they will be of great help to me. Actually what I am looking for is to create a new file without the need to recycle any module. However I have learned from his advice 

 

Blessings! 

If you are on a MAC computer you can install a Windows Emulator as I posted above and run e-Sword Tooltip NT to create the module 

Edited by Tj Higgins, 09 October 2022 - 01:29 PM.

[jocerva]

To give you a way less technical answer. Yes you can.

 

That said, here's a tip that you can use for when it come to creating different resource types.

 

You don't need to create a new database file. Simply use an existing third party database files as a template for what you want to create. Perhaps that is the simplest way to go about it. For example, when I created the Maori Bible for e-Sword (Click here for the iOS, android, and macOS edition), I used an existing third party Bible (bblx) file, renamed it, put in the information of that Bible and etc., then deleted the text in each verse and replaced it with the Maori text. A lot of copying and pasting.

 

Now, this goes with any resource you want to create, whether is a Bible, Devotional, Dictionary or whatever. And I found that is the best way to do in SQLite.

 

Also, here is a way you can configure SQLite DB Browser for opening e-Sword resource files:

 

Trust you find this helpful

 

Blessings,

 

Blessings! 

 

It is a good option only that when I have recycled a third-party module even if it deletes the information it is cached and makes the module heavier. However, I think that at the moment it is the best option 

 

Thank you for taking the time to respond