InfoQube IM - Community

Submitted by jimspoon on 2015/08/13 15:56

I must have started editing one of my Dropbox IQ database replicas before changes from another replica were detected and the updated file synced over - because I ended up with a "conflicted copy" in my Dropbox infoqube sync folder. Later on, I noticed that the "conflicted copy" had disappeared from the sync folder.

Would it be possible to implement some sort of mechanism to detect precisely the differences between conflicting copies of the database, present them to the user, and allow the user to select between them (or keep both versions). Could IQ be made to detect such differences by comparing item fields such as item ID numbers, create/modify dates, etc? This would provide a huge measure of confidence in using Dropbox to keep databases synchronized without fear of losing entered data.

Comments

Hi Jim,

The Dropbox "conflicting" copy are not really a conflict as far as your data is concerned. They appear if 2 instances of Dropbox (on 2 PCs) try to update your sync file at the same time. When this occurs, IQ will simply attempt to save the sync copy later on and automatically deleted the Dropbox generated "conflicting" copy.

IQ keeps track of the date of last data change and shows you a dialog to use the most recent one. The systems works really well, but I agree, that some more information on the changes (Items changed, etc) would be great to have. It should be quite easy to do. I'll add it to the wish list.

HTH !

Pierre_Admin

[quote=Pierre_Admin]

The Dropbox "conflicting" copy are not really a conflict as far as your data is concerned. They appear if 2 instances of Dropbox (on 2 PCs) try to update your sync file at the same time. When this occurs, IQ will simply attempt to save the sync copy later on and automatically deleted the Dropbox generated "conflicting" copy. [/quote]

my emphasis above -

does that mean it will save both sets of changes made, before deleting the conflicting copy?

Sounds good!

Here's what just happened with me, trying to understand it.

Two computers: s230u and inspiron

infoqube database: main.sndb

path on s230u: C:\Users\jsw\Documents\infoqube\main.SNDB

path on inspiron: C:\Users\Jim\Documents\main.SNDB

dropbox sync folder on both computers: c:\cloud\dropbox\infoqube databases\sync

main.sndb setting for sync folder is absolute path: c:\cloud\dropbox\infoqube databases\sync

I was putting a infoqube and main.sndb on the inspiron i recently purchased.

On inspiron, I copied main.sndb from dropbox sync folder to C:\Users\Jim\Documents\main.SNDB

On inspiron, I added a couple of items to main.sndb

Went back to s230u.

activated infoqube.

I was quickly prompted to update main.sndb from the sync folder. I selected the "update" option.

Looked at main.sndb on s230u - i thought it would have the items i added on inspiron, but it did not.

I waited a while to be prompted again to update s230u main.sndb from the sync folder.

No prompt appeared.

Looked at infoqube sync folder.

infoqube sync folder now contains two versions of main.sndb - "main.sndb", and "main (s230u's conflicting copy).sndb"

Shut down infoqube on s230u.

Copied c:\cloud\dropbox\infoqube databases\sync\main.sndb over C:\Users\jsw\Documents\infoqube\main.SNDB

restarted infoqube on s230u.

loaded C:\Users\jsw\Documents\infoqube\main.SNDB and looked at it.

Now main.sndb does have the items I added on inspiron.

I don't understand why s230u doesn't get the new items I added on inspiron, when I update the s230u sndb file from the sync folder.

will continue testing.

ok ... this time i got changes from inspiron to sync over to s230u without problem. On s230u, I waited for the update prompt to appear. I updated it with the main.sndb from the inspiron. Loaded it on inspiron - the item I added on the inspiron appeared on s230u.