matching column title with the file's name

campana · 11-09-2021, 02:43 PM

I've got dozens of books from a serie and each file name (ie each e-book) starts with a number. But the title in the metadata doesn't display the number ; so I'd like to replace this metadata with the file name and doing this by batch.

theducks · 11-09-2021, 03:03 PM

You have a Kobo: Are you using Send to device?
With Kobo's, disconnect after sending, wait until processed (on Kobo) is done, then connect again. When Calibres Job Wheel is done, Eject.
The Kobo will now list series

Note Messing with Metadata in Calibre can break other kinds of tasks.
Series AND index belong in the Series column
My Series [42]

campana · 11-15-2021, 10:51 AM

thank for your answer, the problem is that I'm not only using kobo (I'm not the only reader in the house !). Maybe I'll have to look for an other software for doing this. Any idea ?

davidfor · 11-15-2021, 07:03 PM

Quote:

Originally Posted by campana

thank for your answer, the problem is that I'm not only using kobo (I'm not the only reader in the house !). Maybe I'll have to look for an other software for doing this. Any idea ?

It might be an idea to explain what you are actually trying to achieve and the starting point. You first post makes it sound like you want to replace the title displayed in calibre with a file name. But, that is horrible idea to most of us. This post suggests you are trying to change what the user sees on the ereader. If that is the case, then you probably want to use a metadata plugboard to fiddle with the title and other metadata when sending the books to the device.

But, it might be something else. Without a better description of the problem you need to solve, it is hard to help.

campana · 11-16-2021, 07:22 AM

I'm really sorry if I didn't succeed in being clear enough, I try to do better. Although I'm must say that, yes, my first idea is that horrible one you describe much better than I did :
"to replace the title displayed in calibre with a file name"
Because before I discovered Calibre, I was managing my e-books with my windows file manager and therefore, renamed my files in a way that they display correctly within the file manager.
Now, I wish the name's file to be the same as the titles in calibre and in my reader. And this, specially with a série of books that are numbered from 1 to 36 that I'm keen to see sorted by the figure's name.
But, why is it an horrible idea ?

BetterRed · 11-16-2021, 03:27 PM

The names of folders and files in the library are determined algorithmically, the fact that they are Anglo-ised and ASCII-ised is arbitrary.

See ==>> Want to change folder structure or file names in the Calibre library?

Try creating a book with Title 披绿马甲、干黑勾当：伪环保假生态现象调查 and with Authors 励婕 and see what you get in the folder and file names.

BR

11-09-2021, 02:43 PM	#1
campana Junior Member Posts: 5 Karma: 10 Join Date: Oct 2021 Device: vivlio	matching column title with the file's name I've got dozens of books from a serie and each file name (ie each e-book) starts with a number. But the title in the metadata doesn't display the number ; so I'd like to replace this metadata with the file name and doing this by batch.

11-16-2021, 07:22 AM	#5
campana Junior Member Posts: 5 Karma: 10 Join Date: Oct 2021 Device: vivlio	I'm really sorry if I didn't succeed in being clear enough, I try to do better. Although I'm must say that, yes, my first idea is that horrible one you describe much better than I did : "to replace the title displayed in calibre with a file name" Because before I discovered Calibre, I was managing my e-books with my windows file manager and therefore, renamed my files in a way that they display correctly within the file manager. Now, I wish the name's file to be the same as the titles in calibre and in my reader. And this, specially with a série of books that are numbered from 1 to 36 that I'm keen to see sorted by the figure's name. But, why is it an horrible idea ? Last edited by campana; 11-16-2021 at 07:25 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to regex bulk update the Title column from another column?	halloleo	Library Management	10	04-16-2021 02:27 AM
Rules Editor: Matching something in identifiers column	ownedbycats	Library Management	1	02-27-2021 02:39 AM
matching last_modified with file date modified?	jiembe	Library Management	4	11-08-2020 08:10 AM
Matching title and Author	Graham Hurst	Library Management	9	11-15-2014 01:46 PM
libprs500 - title/author matching regex	Megatron-UK	Calibre	15	04-01-2008 04:39 PM

11-09-2021, 03:03 PM	#2
theducks Well trained by Cats Posts: 31,062 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	You have a Kobo: Are you using Send to device? With Kobo's, disconnect after sending, wait until processed (on Kobo) is done, then connect again. When Calibres Job Wheel is done, Eject. The Kobo will now list series Note Messing with Metadata in Calibre can break other kinds of tasks. Series AND index belong in the Series column My Series [42]

11-15-2021, 10:51 AM	#3
campana Junior Member Posts: 5 Karma: 10 Join Date: Oct 2021 Device: vivlio	thank for your answer, the problem is that I'm not only using kobo (I'm not the only reader in the house !). Maybe I'll have to look for an other software for doing this. Any idea ?

11-16-2021, 03:27 PM	#6
BetterRed null operator (he/him) Posts: 21,729 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	The names of folders and files in the library are determined algorithmically, the fact that they are Anglo-ised and ASCII-ised is arbitrary. See ==>> Want to change folder structure or file names in the Calibre library? Try creating a book with Title 披绿马甲、干黑勾当：伪环保假生态现象调查 and with Authors 励婕 and see what you get in the folder and file names. BR

Advert

Advert