MobileRead Forums - View Single Post - Custom Column for Folder Name AND Number??

BetterRed · 08-22-2016, 06:25 PM

@kksdragons - I can't imagine what purpose your Folder/folder_name column serves, or how you propose to maintain its value if and when a folder name changes.

If you want to open a book's folder press 'O', or click "Click to Open" in the Book Details sidebar (if it's not there then you need to select 'Path' in Preferences->Look and Feel->Book Details).

Here's most of the standard keyboard shortcuts ==>> calibre: Keyboard Shortcuts
----------------------

Kovid reserves the right to have calibre silently rename library sub-folders folders and files as and when necessary - he's done so on a least one occasion, and the vast majority users (3+ million) never even noticed.

As you know Calibre runs on a multitude of platforms - Operating Systems & File Systems in their various guises and versions.

Some platforms support very long path lengths, others support foreign alphabets, others are case sensitive, others disallow some characters. Calibre handles the variations by normalising the folder and file names to a common set of restrictions.

There could be a corner case, a change in a platform, or even a new platform (e.g. Microsoft's ReFS) that necessitates adjustment to the restriction set, which could result in silent name changes to existing library sub-folder and file names.
----------------------

I suspect those spurious files were present in your so-called 'perfect library' on your old computer, I'd put money it. I'd also put money on the fact that calibre itself didn't create them, and that there existence may have contributed to the problems you had in transferring your library.

IMO a 'perfect' library is one on which Check Library reports no errors. I run it against my libraries on a weekly basis (via the calibredb check_library command) if any errors are found I invariably know why - Ahhh, that would have happened when the power went out and I was editing that book.

I can't recall an instance where I couldn't attribute an error to something I did or didn't do. I fix any errors before doing my weekly backup.

One way to fix your library in part at least, after taking a back up of it, would be to select all books and copy them to an empty library using calibre's Copy to Library - delete after copy feature. It won't copy the spurious files, and if you set your Add Book preferences to Ignore incoming duplicates that will help you resolve your duplicates. The books that remain in your 'old' library are duplicates in respect of the Title, you need to decide what to do about them.

Once you've done that I suggest you run Find Duplicates on the new library looking for Similar Title and Author values.

BR

08-22-2016, 06:25 PM	#7
BetterRed null operator (he/him) Posts: 21,989 Karma: 30277294 Join Date: Mar 2012 Location: Sydney Australia Device: none	@kksdragons - I can't imagine what purpose your Folder/folder_name column serves, or how you propose to maintain its value if and when a folder name changes. If you want to open a book's folder press 'O', or click "Click to Open" in the Book Details sidebar (if it's not there then you need to select 'Path' in Preferences->Look and Feel->Book Details). Here's most of the standard keyboard shortcuts ==>> calibre: Keyboard Shortcuts ---------------------- Kovid reserves the right to have calibre silently rename library sub-folders folders and files as and when necessary - he's done so on a least one occasion, and the vast majority users (3+ million) never even noticed. As you know Calibre runs on a multitude of platforms - Operating Systems & File Systems in their various guises and versions. Some platforms support very long path lengths, others support foreign alphabets, others are case sensitive, others disallow some characters. Calibre handles the variations by normalising the folder and file names to a common set of restrictions. There could be a corner case, a change in a platform, or even a new platform (e.g. Microsoft's ReFS) that necessitates adjustment to the restriction set, which could result in silent name changes to existing library sub-folder and file names. ---------------------- I suspect those spurious files were present in your so-called 'perfect library' on your old computer, I'd put money it. I'd also put money on the fact that calibre itself didn't create them, and that there existence may have contributed to the problems you had in transferring your library. IMO a 'perfect' library is one on which Check Library reports no errors. I run it against my libraries on a weekly basis (via the calibredb check_library command) if any errors are found I invariably know why - Ahhh, that would have happened when the power went out and I was editing that book. I can't recall an instance where I couldn't attribute an error to something I did or didn't do. I fix any errors before doing my weekly backup. One way to fix your library in part at least, after taking a back up of it, would be to select all books and copy them to an empty library using calibre's Copy to Library - delete after copy feature. It won't copy the spurious files, and if you set your Add Book preferences to Ignore incoming duplicates that will help you resolve your duplicates. The books that remain in your 'old' library are duplicates in respect of the Title, you need to decide what to do about them. Once you've done that I suggest you run Find Duplicates on the new library looking for Similar Title and Author values. BR Last edited by BetterRed; 08-22-2016 at 06:56 PM.