struggling to get Dropbox to sync the database

Need help? - Post here and we will find a solution for you.
Locked
User avatar
G1YBB
Old Man
Posts: 114
Joined: 07 Jun 2015, 19:32
Location: Hereford, England
Contact:

struggling to get Dropbox to sync the database

Post by G1YBB »

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.
User avatar
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

Post by G4POP »

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
73 Terry G4POP
User avatar
G1YBB
Old Man
Posts: 114
Joined: 07 Jun 2015, 19:32
Location: Hereford, England
Contact:

Re: struggling to get Dropbox to sync the database

Post by G1YBB »

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..?
User avatar
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

Post by G4POP »

when I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?
Yes providing the home PC has Dropbox installed
73 Terry G4POP
User avatar
G1YBB
Old Man
Posts: 114
Joined: 07 Jun 2015, 19:32
Location: Hereford, England
Contact:

Re: struggling to get Dropbox to sync the database

Post by G1YBB »

G4POP wrote:
when I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?
Yes providing the home PC has Dropbox installed
Ah good. Fingers crossed for later! Thanks.
User avatar
G1YBB
Old Man
Posts: 114
Joined: 07 Jun 2015, 19:32
Location: Hereford, England
Contact:

Re: struggling to get Dropbox to sync the database

Post by G1YBB »

G4POP wrote:
when I fire up the home PC the new Log4OM folder and SQlite database will just pull down automatically..?
Yes providing the home PC has Dropbox installed
All worked very nicely :)
Locked