I've got duplicates in my Calibre library

[Ptaker]

I use two computers to manage my list of books in Calibre. To sync the two Calibre lists, I use a cloud program (SugerSync) that merges the library files and folders in the cloud and syncs both computers.

My question: Recently I noticed that there are several authors that have duplicate listings for the same books (with different numbers after the book). Since I am trying to conserve the space I am using in the cloud backup, is there a way to eliminate the duplicate book listings. An example is attached.

If I re-direct the Calibre library to a different folder on the computer, will that "clean up" the duplicate book listing?

Bob

[theducks]

Originally Posted by Ptaker

I use two computers to manage my list of books in Calibre. To sync the two Calibre lists, I use a cloud program (SugerSync) that merges the library files and folders in the cloud and syncs both computers.

My question: Recently I noticed that there are several authors that have duplicate listings for the same books (with different numbers after the book). Since I am trying to conserve the space I am using in the cloud backup, is there a way to eliminate the duplicate book listings. An example is attached.

If I re-direct the Calibre library to a different folder on the computer, will that "clean up" the duplicate book listing?

Bob

Get Plugins: Find Duplicates

[itimpi]

It looks as if your Calibre database and the underlying files have got out of step. That is always a risk using a cloud based solution for storing files. If there are any syncing issues. It is the sort of issue that can happen if either:
- you had calibre running at two locations at the same time (so the metadata.db file could not be synced).
- you did not wait for sync to complete upload after running a Calibre session
- you did not wait for sync to complete download before running a Calibre session.

Running the Library Maintenance (via the Library icon) will help with finding which files are the ones that Calibre does not have in its current database.

Alternatively, if you use the Calibre facility to move your library to a new location, then any files left behind are ones that Calibre does not have a record of in the (current) database.

[Ptaker]

Thank you for the responses. I will try the library maintenance to straighten out the database.

PS: I do have Find Duplicates but there were no duplicates in Calibre.

Bob

[theducks]

Originally Posted by Ptaker

Thank you for the responses. I will try the library maintenance to straighten out the database.

PS: I do have Find Duplicates but there were no duplicates in Calibre.

Bob

FD has different Usage modes. Did you use the Arrow next to the Icon to choose the second library to compare against?

[Ptaker]

I used the Calibre library maintenance tools to remove the problem duplicate files.

I was trying to use Sugarsync (like drop box) to sync the database library between home and laptop computers. If I made an entry on one computer, I was looking to have it synced on the other through Sugarsync's cloud backup. I guess that is why the files got messed up.

Any suggestions on how to sync them without these problems other than copying the files from one computer to another?

Thanks for all the assistance.

Bob

[theducks]

Originally Posted by Ptaker

I used the Calibre library maintenance tools to remove the problem duplicate files.

I was trying to use Sugarsync (like drop box) to sync the database library between home and laptop computers. If I made an entry on one computer, I was looking to have it synced on the other through Sugarsync's cloud backup. I guess that is why the files got messed up.

Any suggestions on how to sync them without these problems other than copying the files from one computer to another?

Thanks for all the assistance.

Bob

1) Only have 1 computer running Calibre at any one TIME.

2) Allow the Sync to complete before starting up Calibre on the other computer.

[itimpi]

Do not forget you also need to allow sync to complete after closing Calibre before powering off that machine! I think this is one that sometimes gets forgotten.

[Frenchdummy]

Hello,
It's hard to understand all explanations when English is not our native language, so don't blame me if you find my question odd or if I really looks like an idiot. (Maybe I am)

So I've got also duplicates, in files AND/OR entries in the Calibre data I can't deal with.
A PM from a french user will be welcome, I know there are some (David P) ie.

A step by step video tuto would be greatly useful

The Question is what is the right structure of the folders and filenames.

The logical rule shouldn't be Name, fN / Title ?

[theducks]

Originally Posted by Frenchdummy

Hello,
It's hard to understand all explanations when English is not our native language, so don't blame me if you find my question odd or if I really looks like an idiot. (Maybe I am)

So I've got also duplicates, in files AND/OR entries in the Calibre data I can't deal with.
A PM from a french user will be welcome, I know there are some (David P) ie.

A step by step video tuto would be greatly useful

The Question is what is the right structure of the folders and filenames.

The logical rule shouldn't be Name, fN / Title ?

You do not worry about or use the folder/file structure inside the Library.
That is 100% managed by Calibre (and will NOT be changed).

The Find duplicates plugin can perform a number of comparisons (See the FD Help file in Plugins forum).

[Frenchdummy]

Originally Posted by theducks

You do not worry about or use the folder/file structure inside the Library.
That is 100% managed by Calibre (and will NOT be changed).

The Find duplicates plugin can perform a number of comparisons (See the FD Help file in Plugins forum).

Yeah, first thanks for your reply.
I said I could be idiot, and I were. (probably like all other users who have issues) I spent several days to change the structure. (folders/files.epub).
In addition, I used to add an extra space between Asimov,[space]Isaac in Calibre; I guess I shouldn't.

[itimpi]

Originally Posted by Frenchdummy

Yeah, first thanks for your reply.
I said I could be idiot, and I were. (probably like all other users who have issues) I spent several days to change the structure. (folders/files.epub).
In addition, I used to add an extra space between Asimov,[space]Isaac in Calibre; I guess I shouldn't.

Calibre has a tight coupling between the metadata database and the underlying files. If you rename any files/folders in Calibre then you are breaking this link which effectively means that Calibre will no longer be able to locate the actual ebook files. You should never manipulate the underlying files but only via the Calibre GUI.

You CAN control the format that is used when exporting ebooks from Calibre via the 'Send to Device' or 'Save to Disk' operations which are the recommended ways to get files out of Calibre. There is a usable editable template for each of these that can be set under Preferences.