Solution to Calibre in Google Drive

Mattes · 03-11-2013, 11:11 AM

Hi,

I move sometimes my Calibre Library using Google Drive, and I'm facing the problem with the books ids between parenthesis all the time.

So I wrote a small program to fix your library.

On the computer with the library without the ids in the folders name, open my program and indicate the directory of the calibre library, and click "Fix". It will add the correct ids to the folders name according to the data in the metadata.opf file of each books.

Only works under Windows at the time, requires .Net Framework 3.5 Client.

Hope this helps!

DoctorOhh · 03-11-2013, 11:06 PM

Thanks for this work. I updated the Sticky post above to point to this post as a possible solution to repairing a library damaged by Google drive.

Mattes · 03-11-2013, 11:12 PM

You're welcome.

masterninja01 · 04-22-2013, 07:00 AM

Thank you for your work in creating this fix. However, is there a version for OSX (Mac)?

Mattes · 04-22-2013, 02:31 PM

Unfortunately I don't program on OSX yet.

masterninja01 · 04-22-2013, 06:06 PM

How does the script fix the missing catalog numbers, if you do't mind me asking. Maybe I or someone with more knowledge can make one for OSX.
Thanks again

Mattes · 04-22-2013, 06:09 PM

That's why I also include the sources in this post. License is WTFPL ;-)

Basically each book is stored in a folder, and there is a file in XML format (metadata.opf) in each folder, which contains the ID. Read the source code, it's pretty straightforward.

Ellachanted · 11-10-2013, 01:03 PM

Will this fix work with Windows 8?

My library is big & I seem to have screwed it up even though I was trying to be safe by only using google drive as a back up. I have other options but because I was on the google drive when it messed up, I can't get Calibre 64 to change the library to my second backup that doesn't seem to be affected. Calibre 32 is still working so I will try to fix it from there.

It seems it wasn't a problem until I synced it to my Windows 7 computer. Sometimes too many backups isn't so good!
Thanks

Mattes · 11-11-2013, 08:14 AM

There should not be any problem. Make a backup first then try.

Ellachanted · 11-12-2013, 03:08 PM

Quote:

Originally Posted by Mattes

There should not be any problem. Make a backup first then try.

Thanks! Since the Google drive is my backup, I pointed it in the direction of the drive after disconnecting the drive from Google and I get a (Not Responding)

Does this mean it is working or that it is not working? I will let it sit for a while and see if anything happens. Thanks!

mendhak · 06-02-2014, 05:13 PM

For future searchers, I've created a similar script here in Python so it should work on Linux/other OSes. I created another thread because I don't want to disrupt this one.

retval · 09-01-2025, 11:34 PM

Greetings, has this problem been resolved considering it's 2025? I'm trying to sync the library between two computers, but it fails. There's a large .db file that I assume is the calibre database that isn't updating.
What other options are there to sync a large library (40,000 books) between 2 Windows PCs?

slm · 09-01-2025, 11:39 PM

In my experience Dropbox works well BUT ONLY IF you never run Calibre on both machines at the same time.

JSWolf · 09-14-2025, 04:32 AM

I use Onedrive as one backup source for my calibre libraries. Works well with FreeFileSync.

04-22-2013, 07:00 AM	#4
masterninja01 Junior Member Posts: 3 Karma: 10 Join Date: Feb 2011 Device: none	Fix for OSX Thank you for your work in creating this fix. However, is there a version for OSX (Mac)?

04-22-2013, 06:09 PM	#7
Mattes Junior Member Posts: 5 Karma: 1234 Join Date: Mar 2013 Device: none	That's why I also include the sources in this post. License is WTFPL ;-) Basically each book is stored in a folder, and there is a file in XML format (metadata.opf) in each folder, which contains the ID. Read the source code, it's pretty straightforward. Last edited by Mattes; 04-22-2013 at 06:12 PM.

11-10-2013, 01:03 PM	#8
Ellachanted Connoisseur Posts: 50 Karma: 10 Join Date: Oct 2013 Device: Kindle touch	Will this fix work with Windows 8? My library is big & I seem to have screwed it up even though I was trying to be safe by only using google drive as a back up. I have other options but because I was on the google drive when it messed up, I can't get Calibre 64 to change the library to my second backup that doesn't seem to be affected. Calibre 32 is still working so I will try to fix it from there. It seems it wasn't a problem until I synced it to my Windows 7 computer. Sometimes too many backups isn't so good! Thanks Last edited by Ellachanted; 11-10-2013 at 01:12 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
WARNING - Google Drive Incompatible with Calibre!	DoctorOhh	Related Tools	0	02-12-2013 01:59 AM
Google Drive Incompatable with Calibre!	Yack	Related Tools	10	02-02-2013 05:37 AM
[Google Drive Warning] Issue migrating Calibre Library to a different computer	cptnemo	Related Tools	7	01-22-2013 12:03 AM
[Google Drive Warning] Trouble moving/combining Calibre libraries	vermontcathy	Related Tools	4	11-24-2012 08:37 AM
PRS-T1 Google Drive	JB.	Sony Reader Dev Corner	1	04-25-2012 08:02 PM

03-11-2013, 11:06 PM	#2
DoctorOhh US Navy, Retired Posts: 9,897 Karma: 13806776 Join Date: Feb 2009 Location: North Carolina Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen	Thanks for this work. I updated the Sticky post above to point to this post as a possible solution to repairing a library damaged by Google drive.

03-11-2013, 11:12 PM	#3
Mattes Junior Member Posts: 5 Karma: 1234 Join Date: Mar 2013 Device: none	You're welcome.

04-22-2013, 02:31 PM	#5
Mattes Junior Member Posts: 5 Karma: 1234 Join Date: Mar 2013 Device: none	Unfortunately I don't program on OSX yet.

04-22-2013, 06:06 PM	#6
masterninja01 Junior Member Posts: 3 Karma: 10 Join Date: Feb 2011 Device: none	How does the script fix the missing catalog numbers, if you do't mind me asking. Maybe I or someone with more knowledge can make one for OSX. Thanks again

11-11-2013, 08:14 AM	#9
Mattes Junior Member Posts: 5 Karma: 1234 Join Date: Mar 2013 Device: none	There should not be any problem. Make a backup first then try.

06-02-2014, 05:13 PM	#11
mendhak Junior Member Posts: 4 Karma: 10 Join Date: Oct 2013 Device: Kindle Paperwhite	For future searchers, I've created a similar script here in Python so it should work on Linux/other OSes. I created another thread because I don't want to disrupt this one.

09-01-2025, 11:34 PM	#12
retval Enthusiast Posts: 38 Karma: 10 Join Date: Mar 2011 Device: none	Greetings, has this problem been resolved considering it's 2025? I'm trying to sync the library between two computers, but it fails. There's a large .db file that I assume is the calibre database that isn't updating. What other options are there to sync a large library (40,000 books) between 2 Windows PCs?

09-01-2025, 11:39 PM	#13
slm Fool Posts: 498 Karma: 4660650 Join Date: Feb 2003 Device: Kindle: Voyage,PW1,KOA, Kobo: Clara Colour, Nook GLP, Pocketbook verse	In my experience Dropbox works well BUT ONLY IF you never run Calibre on both machines at the same time.

09-14-2025, 04:32 AM	#14
JSWolf Resident Curmudgeon Posts: 80,746 Karma: 150249619 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	I use Onedrive as one backup source for my calibre libraries. Works well with FreeFileSync.