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

Page 1 of 1 (10 items)
This post has 9 Replies | 2 Followers

Posts 2
Wesley Wilson | Forum Activity | Posted: Thu, Feb 7 2019 7:46 PM

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.

Posts 27916
Forum MVP
MJ. Smith | Forum Activity | Replied: Thu, Feb 7 2019 8:16 PM

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.

Orthodox Bishop Hilarion Alfeyev: "To be a theologian means to have experience of a personal encounter with God through prayer and worship."

Posts 18059
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Thu, Feb 7 2019 10:10 PM

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

Welcome Big Smile

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 Smile

Posts 8130
LogosEmployee

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).

Posts 2
Wesley Wilson | Forum Activity | Replied: Sat, Feb 9 2019 4:34 AM

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.

Posts 18059
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Sat, Feb 9 2019 5:17 AM

Wesley Wilson:
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 

Keep Smiling Smile

Posts 353
PJ | Forum Activity | Replied: Thu, Nov 7 2019 12:03 PM

Wesley Wilson:
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:

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.

Posts 2163
LogosEmployee

PJ:
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

Posts 5257
DIsciple II | Forum Activity | Replied: Thu, Nov 7 2019 12:24 PM

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

PJ:

Wesley Wilson:
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:

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.

Posts 353
PJ | Forum Activity | Replied: Thu, Nov 7 2019 7:46 PM

Andrew Batishko (Faithlife):
You had better be quick. Support for this will be removed in Logos 8.9

All good things come to an end Smile My offer to help with another solution still stands.

Page 1 of 1 (10 items) | RSS