Submitted by jimspoon on 2020/04/15 20:40
 My desktop IQ (v115) is not updating my database from the more recent file in my sync folder.  The correct folder (C:\Users\jimsp\OneDrive\infoqube\sync) is specified in Tools > Options > Data Storage > Sync Folder.  The file with the most recent changes is in the folder, the IQ is just not updating from it.  Is there a way to force an update from the sync file?  From reading the manual, Ctrl+S seems to force an update to the sync file, not from it?  I wouldn't want to do Ctrl+S on my desktop and overwrite the sync file that contains the latest changes.
 
In case it helps, the two changes I made were to add to items to my Notes1 grid by checking the Notes1 checkmark field.  When I look at the two items on my Desktop, the Notes1 field is not shown in the Values section of the Properties pane, but "Notes1" is shown as the value for Home in the Basic section.  The Last Edit date (File > Properties) of my laptop version is after I made my changes.  The Last Edit date shown on my desktop is yesterday, before I made the changes this morning.  F5 (Refresh) doesn't help.
 
Sync has been working fine up to now.
 
UPDATE: as a test i went to my laptop and made a new item.  The sync file on my laptop was updated, it was uploaded to OneDrive sync folder, downloaded to OneDrive sync folder, and IQ on desktop promptly updated its loaded database from the sync file.  But I did not see the new item in the grid where I added it - I'll make a new post about that.

Comments

I've had similar problems with Dropbox. Here's what I did:
First, copy the more up-to-date file to a dated folder with description.
Then close IQ. If you're unsure / worried about making a mistake, make a copy of the non- updated file, again well labeled in a folder.
Now overwrite the non- updated file with the other.
 
In any backup / restore situation, I first make a labeled copy of each file to be on the safe side.

Pierre, Is IQ designed to update the sndb file whenever it finds a more recently dated file in the sync folder (Dropbox, OneDrive, etc)?  Right now there is a more recently dated sndb file in my sync folder on my desktop, but my desktop IQ is not prompting me to overwrite and reload it. 
 
As described above, I changed one field of one item on my laptop.  The laptop wrote the changed file to the sync folder on the laptop.  The changed file was then uploaded to the cloud and then download to the desktop sync folder, but there it sits.
 
Is there a way to force an overwrite of the loaded file with the more recent version in the sync folder?   As I understand it, Ctrl+S works in the other direction - forces an overwrite of the sync folder version with the more recent loaded version.
 
Thanks for any info.

Pierre_Admin

2020/07/02 21:29

Permalink

Hi Jim,
 
The sync does not use the file date (as unreliable) but uses the last modified item date
So it will not, as you observed, sync if only field definitions were changed. I should add this.
So, you can bold + unbold an item and then hit Ctrl+S to trigger a detectable change
 
Pierre_Admin
IQ Designer
 

jimspoon

2020/07/02 23:51

Permalink

Thanks PIerre, I'm continuing to experiment.  Bolding and unbolding works to get a change from laptop to desktop.  And it works quickly even if I don't press Ctrl+S; that's probably because I've got "Sync changes every X minutes" set to 1.
 
 

Pierre_Admin

2020/07/02 23:59

Permalink

[quote=jimspoon]And it works quickly even if I don't press Ctrl+S; that's probably because I've got "Sync changes every X minutes" set to 1.
[/quote]
Indeed
Dropbox is the fastest syncing service, because it only sends changes, but can be quite processor intensive, in particular for large files
I tend to sync every 5-10 minutes only and use Ctrl+S if I want immediate sync
 
YMMV
 
Pierre_Admin
IQ Designer
 

Would it be possible to make IQ to recognize "checkbox changes" as a data change and prompt to load from the sync folder?  I had forgotten the bold and unbold trick and had to find it here again.

Hi Jim,

It should register as a change. Can you confirm that when you click on that checkbox, the file name is not appended with a * ?
(it is here, as it should). Else provide detailed steps to reproduce it. Thanks !

I just did a little experimenting.  On my desktop PC, I checked a checkmark field box that wasn't previously checked - the * appeared next to the filename on the title bar; the file in the OneDrive sync folder was updated; the file was uploaded to the cloud; my laptop downloaded it; and IQ on my laptop prompted me to reload the file from the sync folder; I did so, and the check box I checked on the desktop is now checked on the laptop.  There seems to be a discrepancy though.  On my Desktop, File > Properties > Last Edit reports 14:44; but my Laptop reports 14:38.  Is it possible that File > Properties on my Laptop is not fetching the true Last Edit time?