Filling a Custom Column with Auto-Incremented Values

Laurelton · 12-10-2012, 10:30 PM

Hello,

I've imported 200+ PDFs and I want to have this custom column of mine have values from 001 to 200. Is there a simple way to do this via editing metadata in bulk? I'm obviously new to this and lost. Please point me to an area/topic where might be explained, if do-able. Thanks so much!

speakingtohe · 12-11-2012, 10:56 PM

If you just want to sort your books so they will always be in the same order you can use the date column.

Or you could make a custom column with for keeping series like information and use bulk edit metadata to populate it by giving all of the books the same series name.

Helen

chaley · 12-12-2012, 08:46 AM

Quote:

Originally Posted by Laurelton

Hello,

I've imported 200+ PDFs and I want to have this custom column of mine have values from 001 to 200. Is there a simple way to do this via editing metadata in bulk? I'm obviously new to this and lost. Please point me to an area/topic where might be explained, if do-able. Thanks so much!

The only way to do this is the one suggested by speakingtohe: use a custom series column and number the series starting at one. The reason: the template language has no way to access information for other books in the library and no way to update columns.

If you are python-literate then you could write a plugin to do it. For all I know an existing plugin might be able to do something like what you want.

kiwidude · 12-12-2012, 10:27 AM

If you have the books and the number you want for each in something like a CSV file, then you could use the Import List plugin to do such an update. If you don't have such a CSV, you could export the books using the catalog function in calibre to such a file, then add the column with your desired values and then reimport it using Import List.

Laurelton · 12-13-2012, 02:25 AM

Thank you all. The series suggestion seemed like the right way to go so I changed things around a bit and I think this will work fine.

Thanks again!

12-10-2012, 10:30 PM	#1
Laurelton Junior Member Posts: 3 Karma: 10 Join Date: Jun 2011 Location: Louisville, Kentucky Device: Kindle	Filling a Custom Column with Auto-Incremented Values Hello, I've imported 200+ PDFs and I want to have this custom column of mine have values from 001 to 200. Is there a simple way to do this via editing metadata in bulk? I'm obviously new to this and lost. Please point me to an area/topic where might be explained, if do-able. Thanks so much!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hacks Custom line spacing values for K3	Vroo	Amazon Kindle	2	05-26-2012 09:09 AM
Custom Column with list of permitted values	Eugenie	Library Management	1	01-10-2012 03:57 AM
Boolean custom column values	sengian	Library Management	4	01-05-2012 05:39 PM
Multiple comma separated values in custom column?	silentguy	Library Management	8	04-19-2011 05:10 AM
displaying multiple values in the same column beneath each other	Firedancer885	Calibre	2	11-27-2010 03:13 PM

12-11-2012, 10:56 PM	#2
speakingtohe Wizard Posts: 4,812 Karma: 26912940 Join Date: Apr 2010 Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet	If you just want to sort your books so they will always be in the same order you can use the date column. Or you could make a custom column with for keeping series like information and use bulk edit metadata to populate it by giving all of the books the same series name. Helen

12-12-2012, 10:27 AM	#4
kiwidude Calibre Plugins Developer Posts: 4,636 Karma: 2162064 Join Date: Oct 2010 Location: Australia Device: Kindle Oasis	If you have the books and the number you want for each in something like a CSV file, then you could use the Import List plugin to do such an update. If you don't have such a CSV, you could export the books using the catalog function in calibre to such a file, then add the column with your desired values and then reimport it using Import List.

12-13-2012, 02:25 AM	#5
Laurelton Junior Member Posts: 3 Karma: 10 Join Date: Jun 2011 Location: Louisville, Kentucky Device: Kindle	Thank you all. The series suggestion seemed like the right way to go so I changed things around a bit and I think this will work fine. Thanks again!

Advert

Advert