How do I import a book series

CalRCH · 01-22-2019, 10:34 AM

A novice question - please redirect me if the question has been answered elsewhere.

I have a large library of books - some 20,000 items, including artwork. Some of these are book series. For example, I have the Amber series by Zelazny.

For any given book, I understand I need to retitle the file to be

Author - title.txt

They are currently stored in

Zelazny, Roger/The Amber Chronicles/number - title.txt

I propose to write a script to generate Calibre-friendly filenames, but cannot work out how to include the Series name and number.

This is quite a general problem, as elsewhere I have the three volume set of Feynman lectures, which will need similar treatment.

I imagine this has been done before, and would welcome all and any advice.

TIA
- Roger -

ilovejedd · 01-22-2019, 10:51 AM

Note, default Calibre import setting when getting metadata from filename is actually:

title - author

Regular expression (Preferences > Import/export > Adding books > Regular expression)

Code:

(?P<title>.+) - (?P<author>[^_]+)

You can certainly modify the regular expression to fit your needs (caveat, doesn't work with folder names afaik).

I think one of the pre-made options in the regex dropdown already include series in the format:

author - series 1 - title

Regular expression

Code:

(?P<author>[^_-]+) -?\s*(?P<series>[^_0-9-]*)(?P<series_index>[0-9]*)\s*-\s*(?P<title>[^_].+) ?

theducks · 01-22-2019, 11:59 AM

Calibre ADD, does not permit pathnames metadata as yo show.

A long time ago (Internet age

) I used a shareware program Metaporphose
to manipulate (flatfile) the path into the file name

BetterRed · 01-22-2019, 04:41 PM

@CalRCH - I would use a file rename utility (e.g. Bulk Rename Utility) to rename the files (or a copy thereof) into a form that calibre can handle via a regex such as that suggested by ilovejedd.

BR

CalRCH · 01-23-2019, 06:38 AM

Thank you, all. In particular, thank you, jedd. Just the hint I need.

01-22-2019, 10:34 AM	#1
CalRCH Junior Member Posts: 6 Karma: 10 Join Date: Jan 2019 Device: None	How do I import a book series A novice question - please redirect me if the question has been answered elsewhere. I have a large library of books - some 20,000 items, including artwork. Some of these are book series. For example, I have the Amber series by Zelazny. For any given book, I understand I need to retitle the file to be Author - title.txt They are currently stored in Zelazny, Roger/The Amber Chronicles/number - title.txt I propose to write a script to generate Calibre-friendly filenames, but cannot work out how to include the Series name and number. This is quite a general problem, as elsewhere I have the three volume set of Feynman lectures, which will need similar treatment. I imagine this has been done before, and would welcome all and any advice. TIA - Roger -

01-22-2019, 10:51 AM	#2
ilovejedd hopeless n00b Posts: 5,126 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	Note, default Calibre import setting when getting metadata from filename is actually: title - author Regular expression (Preferences > Import/export > Adding books > Regular expression) Code: (?P<title>.+) - (?P<author>[^_]+) You can certainly modify the regular expression to fit your needs (caveat, doesn't work with folder names afaik). I think one of the pre-made options in the regex dropdown already include series in the format: author - series 1 - title Regular expression Code: (?P<author>[^_-]+) -?\s(?P<series>[^_0-9-])(?P<series_index>[0-9])\s-\s*(?P<title>[^_].+) ?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Series to Kobo Android App	nexisrocks	Devices	2	03-15-2018 04:26 PM
Stripping series info on import	slantybard	Library Management	4	09-08-2015 04:06 AM
Import on Filename changes mid import due to book error	Vortex	Calibre	3	12-05-2014 12:49 PM
Series information is lost during the import	Tomita	Library Management	5	12-16-2013 10:23 AM
Need an import expression to use sub-foldername as series	santiagodraco	Calibre	3	06-10-2010 08:54 AM

01-22-2019, 11:59 AM	#3
theducks Well trained by Cats Posts: 31,264 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Calibre ADD, does not permit pathnames metadata as yo show. A long time ago (Internet age ) I used a shareware program Metaporphose to manipulate (flatfile) the path into the file name

01-22-2019, 04:41 PM	#4
BetterRed null operator (he/him) Posts: 22,015 Karma: 30277294 Join Date: Mar 2012 Location: Sydney Australia Device: none	@CalRCH - I would use a file rename utility (e.g. Bulk Rename Utility) to rename the files (or a copy thereof) into a form that calibre can handle via a regex such as that suggested by ilovejedd. BR

01-23-2019, 06:38 AM	#5
CalRCH Junior Member Posts: 6 Karma: 10 Join Date: Jan 2019 Device: None	Thank you, all. In particular, thank you, jedd. Just the hint I need.

Advert

Advert