13 replies to this topic

[Rgill]

Does anyone know of a program that ca read and print the SQlite databases in e-Sword? 

[PeanutGallery]

Does anyone know of a program that ca read and print the SQlite databases in e-Sword? 

You mean aside from sqlite3 in terminal?

I use DB SQLite Browser

There is also SQLite Studio

[APsit190]

Does anyone know of a program that ca read and print the SQlite databases in e-Sword?

You mean aside from sqlite3 in terminal?

I use DB SQLite Browser

There is also SQLite Studio

Building on what PG (saves my typing out all of his handle, and with having typed all of this out, I might as well have typed out all of his handle ) said, e-Sword is an actual Database reader. The only thing it doesn't do is read the database files in the way you see it in an actual Database application like SQLite Browser (see screenshot below) and etc. Not only that, but if the resource is third party, such as a Bible (bblx or bbli and etc) can only be edited using ToolTip Tool NT or SQLite Browser, Manager, Studio. Bible, Dictionary/Lexicon, Devotional, Commentary resources, and etc cannot be edited in e-Sword due to the fact that when these resources are loaded, they are loaded as "Read Only."

 

Resources from e-Sword and eStudySource are secured and cannot be edited at all in anything let alone e-Sword (just had to add that bit).

 

Trust you find this information helpful.

 

Blessings,

 

 

Edited by APsit190, 04 September 2022 - 10:52 PM.

[Rgill]

My goal is to print a list of all my topic note titles. Perhaps someone knows an easier way to do this?

[DoctorDaveT]

Hey, Rgill,

 

Here is a handy utility tool called "e-Sword Library Manager" (download from biblesupport.com here). While I am unsure if it will print your .topx/.refx library titles, it will allow you to see them. This particular utility should get far more visibility than it does.

[PeanutGallery]

My goal is to print a list of all my topic note titles. Perhaps someone knows an easier way to do this?

Do you mean list the rows containing only the column marked Title from the Topic.topx

as in: SELECT Title FROM Topics

OR

Do you mean to list all files in directory with .topx extension

as in: dir *.topx

Edited by PeanutGallery, 09 September 2022 - 06:38 PM.

[APsit190]

Hey, Rgill,

 

Here is a handy utility tool called "e-Sword Library Manager" (download from biblesupport.com here). While I am unsure if it will print your .topx/.refx library titles, it will allow you to see them. This particular utility should get far more visibility than it does.

Hi Dave,

I just checked it out, and nah, it doesn't print anything out.

 

Now, if I knew the programming language it was written in, then I'd hack into (decompile) it and then extract the source code, and then rewrite the program adding a print capability to it. That part isn't difficult at all if its written in C# (C Sharp). If its C++, then I'd be stuffed.

 

 

[JPG]

It was written in C#

[APsit190]

It was written in C#

Thanks Jon.

I got me a neat little decompiler called dotPeek by a company called JetBrains. The beaut thing about this program is its free. So you can't beat that. Another thing is that you can export the code have it opened in Visual Studio.

 

All the software I've written are in C#, including the e-Sword Installer Menu (ESM). If you downloaded dotPeek and installed it, you be able to decompile ESM and view the code. (EEKS! I've just given a way for anyone to hack into a program.)

 

Blessings,

Stephen (Php 1:21).

[JPG]

I have used a different decompiler in the past. Good to know of another one integrated to Visual Studio.

I find one issue with decompiled code is that it does not have comments to the code, so it is more difficult to understand.

 

Also I have your code for ESM... you emailed it to me a while back.