Importing library from BookCollector (Collectorz.com)

Georgie W · 01-10-2021, 02:57 PM

I've got details of ~1000 books sitting in a text file from the BookCollector programme. I want to bring all 1000 books into Calibre, with a minimum of re-keying.

I can see how to import the bare detail (author / title / publisher) into Calibre using the Import List plugin.

My issue is: how can I interpret the subject headings I've allocated in BookCollector as separate tags in Calibre? E.g. I've got a book with BookCollector subjects: History / England / Regency. In the text / .csv file, these appear in one column as "History; England; Regency;". BUT I can't see how to tell the Import List plugin to create separate tags for each of these items.

I've flirted with regex in the Adding books Preference, telling Calibre to keep tags if they match the pattern "(?P<tag>.+); (?P<tag>.+); (?P<tag>.+)" But I *really* don't know what I'm doing with regex, or even if that's the right way to translate the csv elements into discrete tags.

Any advice welcomed. Thanks.

capink · 01-10-2021, 03:11 PM

A better approach is to import the subject column into a custom column. After the import process is finished, you can use calibre's search and replace to migrate them to the tags columns as follows:

Code:

search field = you custom column name
search for = ;
replace with = ,
destination field = tags

Georgie W · 01-10-2021, 06:19 PM

@capink - worked like a dream. Thanks for swift and useful response.

01-10-2021, 02:57 PM	#1
Georgie W Connoisseur Posts: 83 Karma: 10 Join Date: Jan 2014 Location: Scotland Device: KT4 5.13.6	Importing library from BookCollector (Collectorz.com) I've got details of ~1000 books sitting in a text file from the BookCollector programme. I want to bring all 1000 books into Calibre, with a minimum of re-keying. I can see how to import the bare detail (author / title / publisher) into Calibre using the Import List plugin. My issue is: how can I interpret the subject headings I've allocated in BookCollector as separate tags in Calibre? E.g. I've got a book with BookCollector subjects: History / England / Regency. In the text / .csv file, these appear in one column as "History; England; Regency;". BUT I can't see how to tell the Import List plugin to create separate tags for each of these items. I've flirted with regex in the Adding books Preference, telling Calibre to keep tags if they match the pattern "(?P<tag>.+); (?P<tag>.+); (?P<tag>.+)" But I really don't know what I'm doing with regex, or even if that's the right way to translate the csv elements into discrete tags. Any advice welcomed. Thanks.

01-10-2021, 03:11 PM	#2
capink Wizard Posts: 1,087 Karma: 1948136 Join Date: Aug 2015 Device: Kindle	A better approach is to import the subject column into a custom column. After the import process is finished, you can use calibre's search and replace to migrate them to the tags columns as follows: Code: search field = you custom column name search for = ; replace with = , destination field = tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Library Management and Importing	wolfskies	Library Management	0	12-16-2020 02:16 PM
Importing old Calibre library?	Aqua-Andy	Calibre	2	01-28-2020 05:46 PM
Importing MobileRead library into calibre library	Alexander Turcic	Library Management	20	01-31-2015 09:57 AM
Importing one library into another one	chemi	Library Management	4	01-02-2013 10:24 AM
Importing the Calibre library into the Sony Reader Library	Fortissimo	Reading and Management	0	02-02-2011 02:18 PM

01-10-2021, 06:19 PM	#3
Georgie W Connoisseur Posts: 83 Karma: 10 Join Date: Jan 2014 Location: Scotland Device: KT4 5.13.6	@capink - worked like a dream. Thanks for swift and useful response.

Advert