how to move tags data into a new custom column

smoothrolla · 11-09-2011, 04:58 PM

Hi guys

first post, great website, i salute you

I have a huge library and have downloaded all the tags from goodreads (so they populate as simple genres)

However, recently I have learnt to create a custom column #genre

i would now like to move the data in the tags field to the #genre one, automatically.. is this possible?

i would then download the tags from multiple sources to get true tags to make my library more descriptive and searchable

Any help appreciated!

chaley · 11-10-2011, 04:50 AM

Use bulk metadata search/replace. Assuming that your genre column has the type "comma-separated text, like tags...", use the following process.

Make a backup of your library in case things go very wrong.
Select all the books you wish to change
Press 'E' to get bulk metadata edit
Select the search/replace tab
Search field: tags
Search for: leave empty
Replace with: leave empty
Destination field: #genre
Press Apply
Click the "Basic metadata" tab
Check the "Remove all" box next to "Remove tags"
Press OK

All the tags will have be copied to #genre and deleted from tags.

smoothrolla · 11-10-2011, 05:48 AM

Thanks Chaley, great instructions, much appreciated!!

Mush easier than i thought, and here i was learning templates and pyhon code to achieve it, doh!

Thanks!

Mrs_Often · 05-30-2018, 06:51 AM

I know this is a reeeeeally old thread, but moving tags is exactly what I am trying to do. I can follow the instructions 1-7, but the "Destination field" mentioned in step 8 is ehm... non-existent (or am I looking in the wrong place)? Of course we're a couple of Calibre versions further ahead by now, but is the above still possible with 3.24.2? And if not, is there a new way to move tags to the #genre column?

Mrs_Often · 05-30-2018, 06:58 AM

Never mind, I found the field! It was hiding beneath the "Search mode" (should be set to "Regular expression")

davidfor · 05-30-2018, 07:05 AM

You need to change the "Search mode" from "Character match" to "Regex". That will add the destination field.

Mrs_Often · 05-30-2018, 07:19 AM

Thanks David!

I added to changes (in bold) to the instructions for future reference:

Quote:

Originally Posted by chaley

Use bulk metadata search/replace. Assuming that your genre column has the type "comma-separated text, like tags...", use the following process.

Make a backup of your library in case things go very wrong.
Select all the books you wish to change
Press 'E' to get bulk metadata edit
Select the search/replace tab
Select "Regular Expression" from the "Search mode" menu
Search field: tags
Search for: type a space [ ]
Replace with: leave empty
Destination field: #genre
Press Apply
Click the "Basic metadata" tab
Check the "Remove all" box next to "Remove tags"
Press OK

All the tags will have be copied to #genre and deleted from tags.

11-09-2011, 04:58 PM	#1
smoothrolla Member Posts: 13 Karma: 10 Join Date: Nov 2011 Device: kindle	how to move tags data into a new custom column Hi guys first post, great website, i salute you I have a huge library and have downloaded all the tags from goodreads (so they populate as simple genres) However, recently I have learnt to create a custom column #genre i would now like to move the data in the tags field to the #genre one, automatically.. is this possible? i would then download the tags from multiple sources to get true tags to make my library more descriptive and searchable Any help appreciated!

11-10-2011, 04:50 AM	#2
chaley Grand Sorcerer Posts: 11,734 Karma: 6690881 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Use bulk metadata search/replace. Assuming that your genre column has the type "comma-separated text, like tags...", use the following process. Make a backup of your library in case things go very wrong. Select all the books you wish to change Press 'E' to get bulk metadata edit Select the search/replace tab Search field: tags Search for: leave empty Replace with: leave empty Destination field: #genre Press Apply Click the "Basic metadata" tab Check the "Remove all" box next to "Remove tags" Press OK All the tags will have be copied to #genre and deleted from tags.

05-30-2018, 06:51 AM	#4
Mrs_Often Wizard Posts: 1,775 Karma: 2694823 Join Date: Dec 2011 Location: The Netherlands Device: Kobo Touch, Glo, Clara HD	I know this is a reeeeeally old thread, but moving tags is exactly what I am trying to do. I can follow the instructions 1-7, but the "Destination field" mentioned in step 8 is ehm... non-existent (or am I looking in the wrong place)? Of course we're a couple of Calibre versions further ahead by now, but is the above still possible with 3.24.2? And if not, is there a new way to move tags to the #genre column? Attached Thumbnails

05-30-2018, 06:58 AM	#5
Mrs_Often Wizard Posts: 1,775 Karma: 2694823 Join Date: Dec 2011 Location: The Netherlands Device: Kobo Touch, Glo, Clara HD	Never mind, I found the field! It was hiding beneath the "Search mode" (should be set to "Regular expression") Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't get {size} data in a User Column?	CCarrot	Calibre	16	06-26-2012 11:39 AM
Sony PRS-T1 and plugboards "tags" from custom column	salines	Devices	8	10-31-2011 03:00 AM
Help with template for custom column from tags	africalass	Library Management	2	07-16-2011 11:47 AM
Can custom book data be displayed in a custom column?	kiwidude	Development	9	03-02-2011 05:35 AM
HTML column type in custom meta-data.	mukoan	Calibre	1	07-13-2010 08:59 AM

11-10-2011, 05:48 AM	#3
smoothrolla Member Posts: 13 Karma: 10 Join Date: Nov 2011 Device: kindle	Thanks Chaley, great instructions, much appreciated!! Mush easier than i thought, and here i was learning templates and pyhon code to achieve it, doh! Thanks!

05-30-2018, 07:05 AM	#6
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	You need to change the "Search mode" from "Character match" to "Regex". That will add the destination field.

Advert

Advert