[www.theword.net]

Twitter live feed  
View unanswered posts | View active topics It is currently Wed Sep 20, 2017 11:48 pm



Reply to topic  [ 12 posts ] 
 Sync two verse highlight files 
Author Message

Joined: Tue Dec 16, 2008 5:58 am
Posts: 79
Location: TN, In
Post Sync two verse highlight files
Hello,

Further to the subject, following is the scenario:

Day 1: I do highlight Gen 1:1-2 on my laptop
Day 2: I do highlight Gen 1:3-4 on my desktop pc.
Day 3: I need to have the verse highlightings of both day 1 and day 2 on both my devices

For a normal file syncing, I use a third-party freeware (freefilesync) between my installations, and on USB drives for portable purposes.

But when it comes to above verse highlighting scenario, i would like to know that how can this be done? I am ready to use any Softwares/techniques even out side theWord..i.e. like using SQLite viewer, etc. (But i have no clue about the db commands to get this done).

Could someone help on this?

Thank you.

Ps: Windows 10 pro is the OS on both devices.

@Costas: Can you help me to solve this? Because, i cannot sync both devices either everyday end / in a regular interval. I will use desktop by default and will use laptop when not able to access my desktop. As i would be highlighting a considerable number of verses on both devices before i sync, solving this would be a big help for me not to loose any of my highlighting. I now have bhls db from both my devices, having 10k and 11k rows. ( I just browsed the dbs and i know nothing more). Any help is appreciated.

_________________
Love,

JEM

And now abideth faith, hope, love, these three; but the greatest of these [is] love. (I Cor 13:13 [AMP])
For our conversation is in heaven; from whence also we look for the Saviour, the Lord Jesus Christ: (Phil 3:20 [KJV])


Fri Oct 07, 2016 5:02 pm
Profile
Site Admin

Joined: Tue Aug 29, 2006 2:09 pm
Posts: 8551
Location: Corfu, Greece
Post Re: Sync two verse highlight files
Yes, I can help with custom sql commands. You will need an sqlite editor. Do you have one. If yes, which one? I use sqlite3Explorer which is just an .exe (no installation needed).
I cannot promise 100% perfect results all the time, but it will usually work. Are you sure?
Costas


Sun Oct 16, 2016 11:32 pm
Profile WWW

Joined: Tue Dec 16, 2008 5:58 am
Posts: 79
Location: TN, In
Post Re: Sync two verse highlight files
I am having and was browsing the db using "Sqlite database browser" from sqlitebrowser dot org. But now i have sqlite3Explorer ready.

You may consider adding a feature request in your todo list for a future feature, which is a standalone tool for this sync purpose like importer. There is an another similar scenario with regard to syncing is Verse Notes/comments. So, developing such a tool will really help syncing theWord between devices/installations. Your thoughts on this are welcome.

JEM

_________________
Love,

JEM

And now abideth faith, hope, love, these three; but the greatest of these [is] love. (I Cor 13:13 [AMP])
For our conversation is in heaven; from whence also we look for the Saviour, the Lord Jesus Christ: (Phil 3:20 [KJV])


Mon Oct 17, 2016 4:32 pm
Profile
Site Admin

Joined: Tue Aug 29, 2006 2:09 pm
Posts: 8551
Location: Corfu, Greece
Post Re: Sync two verse highlight files
Sorry for the delay, here it is: viewtopic.php?f=2&t=7098

Please test and report if it works, i didn't test it really
Costas


Tue Nov 01, 2016 10:57 am
Profile WWW

Joined: Tue Dec 16, 2008 5:58 am
Posts: 79
Location: TN, In
Post Re: Sync two verse highlight files
Thanks Costas for your help. I first tried the command sequence with Sqlitebrowser (as the UI was comparatively bit easier than sqlite3explorer, for a novice like me). Till the command lines inner join and outer join, everything went on without any error. But in those lines the app says that "Syntax error: inner join" and "Syntax error: outer join". I could not proceed further.

Also, my default bible is TAMIL (India) and all these highlights are only with this bible. So my requirement is with this one single bible. This is fyi, may help you to alter the commands accordingly.

_________________
Love,

JEM

And now abideth faith, hope, love, these three; but the greatest of these [is] love. (I Cor 13:13 [AMP])
For our conversation is in heaven; from whence also we look for the Saviour, the Lord Jesus Christ: (Phil 3:20 [KJV])


Wed Nov 02, 2016 5:16 pm
Profile
Site Admin

Joined: Tue Aug 29, 2006 2:09 pm
Posts: 8551
Location: Corfu, Greece
Post Re: Sync two verse highlight files
JEM,
the commands work, Jon tested them also.
It must be something with your sql editor.
Try running them one at a time.
Costas


Wed Nov 02, 2016 6:21 pm
Profile WWW

Joined: Tue Dec 16, 2008 5:58 am
Posts: 79
Location: TN, In
Post Re: Sync two verse highlight files
Thank you Costas ( and Jon for testing). The complete set of commands works perfectly with sqlite3Explorer with the very first attempt. There was no error at all. The file (my.bhls.twm) currently i use with theWord is having the highlights of both my desktop and my laptop. It really has helped me a lot and from now on I can sync the dbs of my desktop and laptop in a regular interval and share it between my Pcs. It is really a big help for me.

Just to understand, I hope the new updated my.bhls.twm will not have any duplicate entries...because desktop tW is my base and I had copied the Compact Installation to my laptop to start with.

Thank you once again Costas.

_________________
Love,

JEM

And now abideth faith, hope, love, these three; but the greatest of these [is] love. (I Cor 13:13 [AMP])
For our conversation is in heaven; from whence also we look for the Saviour, the Lord Jesus Christ: (Phil 3:20 [KJV])


Wed Nov 02, 2016 7:52 pm
Profile

Joined: Tue Dec 16, 2008 5:58 am
Posts: 79
Location: TN, In
Post Re: Sync two verse highlight files
Could you please help me to sync my verse notes/commentaries too? The same scenario & requirement. Yes, all my verse notes are only on Tamil Bible.

_________________
Love,

JEM

And now abideth faith, hope, love, these three; but the greatest of these [is] love. (I Cor 13:13 [AMP])
For our conversation is in heaven; from whence also we look for the Saviour, the Lord Jesus Christ: (Phil 3:20 [KJV])


Thu Nov 03, 2016 9:34 am
Profile
Site Admin

Joined: Tue Aug 29, 2006 2:09 pm
Posts: 8551
Location: Corfu, Greece
Post Re: Sync two verse highlight files
You can drag-n-drop from within theWord to do that. There is not trivial way to do it with SQL commands


Thu Nov 03, 2016 10:30 am
Profile WWW

Joined: Tue Dec 16, 2008 5:58 am
Posts: 79
Location: TN, In
Post Re: Sync two verse highlight files
Costas, can you explain that drag n drop? I am not getting it clearly...drag and drop from within theWord..how?

_________________
Love,

JEM

And now abideth faith, hope, love, these three; but the greatest of these [is] love. (I Cor 13:13 [AMP])
For our conversation is in heaven; from whence also we look for the Saviour, the Lord Jesus Christ: (Phil 3:20 [KJV])


Sat Nov 19, 2016 3:42 pm
Profile
Site Admin

Joined: Tue Aug 29, 2006 2:09 pm
Posts: 8551
Location: Corfu, Greece
Post Re: Sync two verse highlight files
See here: http://www.theword.net/manual/copy_movi ... topics.htm


Wed Nov 23, 2016 9:38 pm
Profile WWW

Joined: Tue Dec 16, 2008 5:58 am
Posts: 79
Location: TN, In
Post Re: Sync two verse highlight files
Got it. Thank you costas.

_________________
Love,

JEM

And now abideth faith, hope, love, these three; but the greatest of these [is] love. (I Cor 13:13 [AMP])
For our conversation is in heaven; from whence also we look for the Saviour, the Lord Jesus Christ: (Phil 3:20 [KJV])


Thu Nov 24, 2016 9:07 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 12 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.