Writing to the Logos db directly to import Prayer Lists, Notes, and custom data

I am looking to import content into my prayer list and notes from another source and I see the dbs are editable via SQLite. The code to insert the data is not hard to write, but while the inserts work. They never appear in LOGOS.

What I am looking for is either documentation or guidance on a way to do this. I have a T-SQL background, but am not having success getting the data to appear in the application. I think my issue is with inserting a GUID properly formatted and adding the other related records n other tables.

Find more posts tagged with

Comments

MJ. Smith

Unfortunately Faithlife discourages this. Among other things, the syncing of the data may be corrupted IIRC from Bradley's post a week or so ago.

Keep Smiling 4 Jesus :)

What I am looking for is either documentation or guidance on a way to do this.

Welcome [:D]

SQL for database replication has intriguing technical nuances/challenges. Personally have avoided trying to insert into SQLite databases since lack sync status processing insights: e.g. "trick" application into believing last use was offline where new stuff was entered that now needs sync (replication). Trying to insert/update/delete SQLite data while application is running can potentially damage lots of your data (since lack insight about what is cached in application memory so database storage modification is different than application cache).

For Notes, may want to investigate BibleWorks formatting since Faithlife recently wrote application code to import Notes from BibleWorks.

Logos Wiki has older => Importing from LDLS3 (since Libronix servers have been shutdown, not know about viability of older import code).

Keep Smiling [:)]

Bradley Grainger (Logos)

Logos 8 databases are not intended to be modified directly by users or by other programs. Editing them carries the risk of crashing Logos 8 or permanently corrupting your sync data. We do not support end-user modification of the databases (and will not provide any documentation or guidance on doing so).

Wesley Wilson

Thanks for the reply. The ability to migrate my intellectual property in and out is important to me if I am going to invest time into a service.

I'll need to research other import methods or not use the content creation functions of logos.

Was hoping to bring in my content from other apps and services to one.

Keep Smiling 4 Jesus :)

https://community.logos.com/discussion/comment/1032541#Comment_1032541

I'll need to research other import methods or not use the content creation functions of logos.

One content creation option is Personal Books, which use docx files (print to pdf could be used for access on mobile devices in a different app: e.g. iCloud drive). Logos wiki has

Logos Training: Personal Books + Personal Books

Keep Smiling [:)]

Pieter J.

I am looking to import content into my prayer list and notes from another source

Wesley, I know it's almost a year later, but I would just like to inform you and others on this ...

There are several other native ways to do what you would like to accomplish. The best way of all those I researched is as follow:

Convert your data into old Libronix DLS 3 formatted documents
Import those documents into Logos (Importing Libronix DLS Documents)

According to the Help Documentation you can import:

•      Favorites
•      Highlighting
•      Notes document
•      Passage List document
•      Prayer List document
•      Sentence Diagram document
•      Syntax Search document
•      Word List document

I don't know if Logos 8 still support this. The "Import All" command is still available in L8 and therefore I assume this will be possible. You'll need an old L3 installation to figure out the format or the knowledge of the old format specification.
The Note files you create should be in the "MyDocuments\Libronix DLS\Annotations" directory.

Here is a sample of the annotation file format (*.lbxnot):

<?xml version="1.0"?>
<lbx-annotations category="Annotations" name="TemplateName" guid="{6FD5A249-D11B-408F-B685-49D1AD83D745}">
<metadata>
<document created="2014-03-21T20:48:46Z" modified="2014-03-21T20:51:41Z"/>
</metadata>
<annotation guid="{678B2A53-046E-40C7-9579-ACF5372718D7}" created="2014-03-21T20:49:50Z" modified="2014-03-21T20:50:12Z" type="comment" style="highlight" color="red" state="not-posted" level="0">
<title>A</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{3BA4096E-B89B-42DB-943B-98B80E894233}" created="2014-03-21T20:50:13Z" modified="2014-03-21T20:50:25Z" type="comment" style="highlight" color="blue" state="not-posted" level="1">
<title>B</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{02E8DD06-1ADB-4197-B602-6C3EB9F0DFA1}" created="2014-03-21T20:50:27Z" modified="2014-03-21T20:50:49Z" type="comment" style="highlight" color="purple" state="not-posted" level="1">
<title>C</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{94071742-274D-4703-B8F1-BB206330C174}" created="2014-03-21T20:50:52Z" modified="2014-03-21T20:51:03Z" type="comment" style="highlight" color="green" state="not-posted" level="0">
<title>D</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{97FDEF6A-366A-44C7-B65F-79D8894E69DE}" created="2014-03-21T20:51:07Z" modified="2014-03-21T20:51:17Z" type="comment" style="highlight" color="maroon" state="not-posted" level="1">
<title>E</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{157D746A-DAD9-47BA-8947-CA0E5BC90453}" created="2014-03-21T20:51:21Z" modified="2014-03-21T20:51:31Z" type="comment" style="highlight" color="maroon" state="not-posted" level="1">
<title>F</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{4595995F-DDE6-4637-BD6D-F9247E92F202}" created="2014-03-21T20:51:31Z" modified="2014-03-21T20:51:41Z" type="comment" style="highlight" color="maroon" state="not-posted" level="1">
<title>G</title>
<content>
<![CDATA[]]>
</content>
</annotation>
</lbx-annotations>

If you didn't accomplish your goal yet, let me know. There's always another way to do it.

Andrew Batishko

https://community.logos.com/discussion/comment/1074534#Comment_1074534

I don't know if Logos 8 still support this. The "Import All" command is still available in L8 and therefore I assume this will be possible.

You had better be quick. Support for this will be removed in Logos 8.9, which will be released soon.

https://community.logos.com/forums/t/183225.aspx

Simon’s Brother

https://community.logos.com/discussion/comment/1074534#Comment_1074534

I could be wrong but I believe this command is no longer works.

I am looking to import content into my prayer list and notes from another source

Wesley, I know it's almost a year later, but I would just like to inform you and others on this ...

There are several other native ways to do what you would like to accomplish. The best way of all those I researched is as follow:

Convert your data into old Libronix DLS 3 formatted documents

Import those documents into Logos (Importing Libronix DLS Documents)

According to the Help Documentation you can import:

•      Favorites
•      Highlighting
•      Notes document
•      Passage List document
•      Prayer List document
•      Sentence Diagram document
•      Syntax Search document
•      Word List document

I don't know if Logos 8 still support this. The "Import All" command is still available in L8 and therefore I assume this will be possible. You'll need an old L3 installation to figure out the format or the knowledge of the old format specification.
The Note files you create should be in the "MyDocuments\Libronix DLS\Annotations" directory.

Here is a sample of the annotation file format (*.lbxnot):
<?xml version="1.0"?>
<lbx-annotations category="Annotations" name="TemplateName" guid="{6FD5A249-D11B-408F-B685-49D1AD83D745}">
<metadata>
<document created="2014-03-21T20:48:46Z" modified="2014-03-21T20:51:41Z"/>
</metadata>
<annotation guid="{678B2A53-046E-40C7-9579-ACF5372718D7}" created="2014-03-21T20:49:50Z" modified="2014-03-21T20:50:12Z" type="comment" style="highlight" color="red" state="not-posted" level="0">
<title>A</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{3BA4096E-B89B-42DB-943B-98B80E894233}" created="2014-03-21T20:50:13Z" modified="2014-03-21T20:50:25Z" type="comment" style="highlight" color="blue" state="not-posted" level="1">
<title>B</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{02E8DD06-1ADB-4197-B602-6C3EB9F0DFA1}" created="2014-03-21T20:50:27Z" modified="2014-03-21T20:50:49Z" type="comment" style="highlight" color="purple" state="not-posted" level="1">
<title>C</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{94071742-274D-4703-B8F1-BB206330C174}" created="2014-03-21T20:50:52Z" modified="2014-03-21T20:51:03Z" type="comment" style="highlight" color="green" state="not-posted" level="0">
<title>D</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{97FDEF6A-366A-44C7-B65F-79D8894E69DE}" created="2014-03-21T20:51:07Z" modified="2014-03-21T20:51:17Z" type="comment" style="highlight" color="maroon" state="not-posted" level="1">
<title>E</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{157D746A-DAD9-47BA-8947-CA0E5BC90453}" created="2014-03-21T20:51:21Z" modified="2014-03-21T20:51:31Z" type="comment" style="highlight" color="maroon" state="not-posted" level="1">
<title>F</title>
<content>
<![CDATA[]]>
</content>
</annotation>
<annotation guid="{4595995F-DDE6-4637-BD6D-F9247E92F202}" created="2014-03-21T20:51:31Z" modified="2014-03-21T20:51:41Z" type="comment" style="highlight" color="maroon" state="not-posted" level="1">
<title>G</title>
<content>
<![CDATA[]]>
</content>
</annotation>
</lbx-annotations>
If you didn't accomplish your goal yet, let me know. There's always another way to do it.

Pieter J.

https://community.logos.com/discussion/comment/1074536#Comment_1074536

You had better be quick. Support for this will be removed in Logos 8.9

All good things come to an end [:)] My offer to help with another solution still stands.