How I managed to set up Dropbox cloud sync with KOReader step by step

[pongsak]

Today, curl command in the started post is not correct for me, I must use this command instead.

curl https://api.dropbox.com/oauth2/token -d code=<Access Code Generated> -d grant_type=authorization_code -u <key:secret>

[gereksizuser]

I tried to do as described in the guide (I only did step 5 as @allanahk said because I couldn't get the token with "\") but I get this error message.
"cannot fetch list of folder contents please check your configuration or network connection"
I updated the Koreader to the new version (v. 2024.03.1), did everything again, even with the new dropbox account, but the result is always the same.
Does anyone have any idea how I can fix it?

[gereksizuser]

Originally Posted by gereksizuser

I tried to do as described in the guide (I only did step 5 as @allanahk said because I couldn't get the token with "\") but I get this error message.
"cannot fetch list of folder contents please check your configuration or network connection"
I updated the Koreader to the new version (v. 2024.03.1), did everything again, even with the new dropbox account, but the result is always the same.
Does anyone have any idea how I can fix it?

Ok, I finally got it working, the mistake I made was that I didn't delete the <> symbols when I wrote the tokens and keys. Works great now.

[Tome]

3. To double check that you have the correct scope for your refresh token, when you run the curl command in terminal, check the "scope" parameter contain your chosen permissions (it will appear in the same output as the [B][/B]refresh token). For some reason my permissions didn't stick the first time and I was generating a token with only account_info.read, leading to a lot of frustration and confusion


open/close the app tab couple times and make sure the permissions is there, and you press submit changes to permission at the bottom of the page, in app main menu if you hover over


6. In KOReader, I went to Menu > Tools > Reading Statistics > Settings > Cloud sync. Here I pressed Add Service, and selected Dropbox for type.
In the second field (dropbox refresh token or long-lived token) I entered the token obtained in step 5 refresh_token.

[TDUK]

Instructions were perfect - worked great on my Kobo Clara HD. I am awaiting for my Libra2 to turn up, when it does, can I just copy the cloudstorage.lua over to that device and get instant access to my dropbox ?

[hius07]

Originally Posted by TDUK

Instructions were perfect - worked great on my Kobo Clara HD. I am awaiting for my Libra2 to turn up, when it does, can I just copy the cloudstorage.lua over to that device and get instant access to my dropbox ?

Yes, the credentials are stored right there.

[TDUK]

Originally Posted by hius07

Yes, the credentials are stored right there.

thanks !

So my Clara HD is sending the reading stats to a folder on Dropbox.

When i get my Libra 2 and connect it to the same Dropbox, will it sync my reading stats?

Like the total books read / calendar view / pages read per day etc ?

Just worried that one device might overwrite the other device stats?

[Farley1240]

At the risk of sounding like an idiot, what's curl and how would said idiot use it?

[Dipaksomak]

Perfect instructions...followed it line by line, not rushing to read the next one.
Only after painstakingly put in the authorization code, 20+ AlphHANuMeric and same for APP KEY and Secret, did I read the next line that said...type in some stuff and then edit on your computer...LOL.
But it works, and thank you for taking time and effort to provide such good instructions.

[Dipaksomak]

Originally Posted by Farley1240

At the risk of sounding like an idiot, what's curl and how would said idiot use it?

on your Windows PC, type "cmd" it will bring up a command window prompt like an old Win 3.2 screen. In there type the curl command. Ignore the "\" as they are just to show you a carriage return....so the actual command would look like ...

C:\>curl https://api.dropbox.com/oauth2/token -d code=authcodeBLAHBLHA -d grant_type=authorization_code -u APP_KEY:keyblhablah:secretblahblah

[Farley1240]

Originally Posted by gereksizuser

Ok, I finally got it working, the mistake I made was that I didn't delete the <> symbols when I wrote the tokens and keys. Works great now.

I keep getting this error too. I've triple checked everything and can't see what I'm doing wrong. I really shouldn't start stuff I know is beyond my ability haha

[soyatti]

Originally Posted by 305869

So I just wanted to explain how I managed to get Dropbox cloud sync for reading statistics working in April of 2023.

305869, i registered here only to say thank you for the tutorial. it works, i can see and download files from dropbox to kindle.

Farley1240, you can try to post here your /mnt/us/koreader/settings/cloudstorage.lua
NB: make sure to obfuscate all secrets

[Farley1240]

Originally Posted by soyatti

305869, i registered here only to say thank you for the tutorial. it works, i can see and download files from dropbox to kindle.

Farley1240, you can try to post here your /mnt/us/koreader/settings/cloudstorage.lua
NB: make sure to obfuscate all secrets

Sorry for the late reply.

I forgot all about it to be honest but before posting my set up I went through it all from the start again and this time it's worked fine thankfully.

Thanks so much for the guide!!

[emmur0]

Thank you for posting the steps.

How is everyone using the .sqlite3 file that ends up in Dropbox? I don’t have much experience with those file types so wondering if there is a that reads and lays out the data in an easily digestible format. Currently my output looks like a spreadsheet and wondering if I’m missing something.

[5moufl]

Originally Posted by emmur0

Thank you for posting the steps.

How is everyone using the .sqlite3 file that ends up in Dropbox? I don’t have much experience with those file types so wondering if there is a that reads and lays out the data in an easily digestible format. Currently my output looks like a spreadsheet and wondering if I’m missing something.

I  do not get any sqlite file. are you talking about a KOReader file?

You can easily export sqlite tables using the command line: https://stackoverflow.com/questions/...-as-a-csv-file