I’m still struggling to set this up to work, so I can sync my Log4OM database between PCs.
I think it is a problem on the dropbox side more than anything to do with Log4OM.
I already have dropbox on my main home PC, which syncs with files uploaded to my dropbox from my Android phone using the dropbox app and another app called dropsync (which fills what I consider a stupid lack of functionality in the dropbox app).
My PC then pulls down and syncs with whatever is upload to my dropbox cloud by the phone.
I’ve seen Terry say to ensure you use the ‘proper’ PC dropbox, so I thought I’d start over with a clean install on another PC in case the one on my home PC was not.
I went here
https://www.dropbox.com/
and clicked the “Download the app” link, which was an installer, and then installed the app. It looks and operates the same as the home PC as I see. By default it offered all the folders up on my dropbox cloud.
As I doubt the user based documents path will be the same across all PCs I might want to sync across, I figured a Log4OM folder in root of C: was a pretty bombproof place to put it, so created a folder.
I already had made a Log4OM folder (empty) on the cloud via browser.
I was able to right click the PC folder ( C:\Log4om ) and “send to” Dropbox.
I created a test.txt file on my HD to simulate having something to sync UP to the cloud. (Which I how I assume it can only work.)
Nothing happens. It appears that my PC based dropbox is only set to receive, and never transmits?
Have I the wrong thing installed?
I cannot see any setting that seems to instigate an upload from the PC.
struggling to get Dropbox to sync the database
- G4POP
- Log4OM Alpha Team
- Posts: 11592
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: struggling to get Dropbox to sync the database
Create a folder named Log4OM in the Dropbox folder on each of your computers, so:
C:\.....\YOUR USER NAME\Dropbox\Log4OM
Now on your main computer copy the G1YBB.sqlite File (Just an example because I don't know what you call your database) into the C:\.....\YOUR USER NAME\Dropbox\Log4OM that you just created
You should then find that all of your computers have the following file when they have been turned on and connected to the internet for a while - Give them time to synchronise
C:\.....\YOUR USER NAME\Dropbox\Log4OM\G1YYB.sqlite
Now in Log4OM on each computer go to file/Open database and navigate to the C:\.....\YOUR USER NAME\Dropbox\Log4OM\G1YYB.sqlite file and click "Open"
Now all instances of Log4OM are reading and writing to the same central file located in Dropbox and will keep in sync
ONE CEVEAT YOU CANNOT WRITE TO THE CENTRAL FILE SIMULTANEOUSLY FROM EACH COMPUTER AS MAY BE THE CASE WITH A CONTEST SET UP - THERE MUST BE A TIME INTERVAL BETWEEN SAVING QSO's
If however you log a QSO on one computer and then walk across the room and log the next QSO on a second computer that is fine you just can't write to the file at the same EXACT instant
Once this os set up no further synchronising action is required by the user the file syncs automatically
C:\.....\YOUR USER NAME\Dropbox\Log4OM
Now on your main computer copy the G1YBB.sqlite File (Just an example because I don't know what you call your database) into the C:\.....\YOUR USER NAME\Dropbox\Log4OM that you just created
You should then find that all of your computers have the following file when they have been turned on and connected to the internet for a while - Give them time to synchronise
C:\.....\YOUR USER NAME\Dropbox\Log4OM\G1YYB.sqlite
Now in Log4OM on each computer go to file/Open database and navigate to the C:\.....\YOUR USER NAME\Dropbox\Log4OM\G1YYB.sqlite file and click "Open"
Now all instances of Log4OM are reading and writing to the same central file located in Dropbox and will keep in sync
ONE CEVEAT YOU CANNOT WRITE TO THE CENTRAL FILE SIMULTANEOUSLY FROM EACH COMPUTER AS MAY BE THE CASE WITH A CONTEST SET UP - THERE MUST BE A TIME INTERVAL BETWEEN SAVING QSO's
If however you log a QSO on one computer and then walk across the room and log the next QSO on a second computer that is fine you just can't write to the file at the same EXACT instant
Once this os set up no further synchronising action is required by the user the file syncs automatically
73 Terry G4POP
Re: struggling to get Dropbox to sync the database
OK. I have done more fiddling and playing, and it does seem I have got uploads working on a file, and that file is a SQlite in use by my Log4OM.
Edit: You have posted (Terry) while I was writing.
Thanks for the missing links, I think I will have this cracked now. Won't be able to tell until at home later, but I'm thinking I'm in.
One point.
I got a message (at some point in my testing) from the local dropbox on this PC saying a folder already exists on my cloud dropbox, should I merge the two.
I'm assuming the correct answer is yes?
Either that or when I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?
Edit: You have posted (Terry) while I was writing.
Thanks for the missing links, I think I will have this cracked now. Won't be able to tell until at home later, but I'm thinking I'm in.
One point.
I got a message (at some point in my testing) from the local dropbox on this PC saying a folder already exists on my cloud dropbox, should I merge the two.
I'm assuming the correct answer is yes?
Either that or when I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?
Steve http://g1ybb.uk/
- G4POP
- Log4OM Alpha Team
- Posts: 11592
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: struggling to get Dropbox to sync the database
Yes providing the home PC has Dropbox installedwhen I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?
73 Terry G4POP
Re: struggling to get Dropbox to sync the database
Ah good. Fingers crossed for later! Thanks.G4POP wrote:Yes providing the home PC has Dropbox installedwhen I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?
Steve http://g1ybb.uk/
Re: struggling to get Dropbox to sync the database
All worked very nicelyG4POP wrote:Yes providing the home PC has Dropbox installedwhen I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?

Steve http://g1ybb.uk/