How to update metadata information from excel (Publication Date,Tags)

mahaveer · 09-14-2011, 01:44 AM

I have a catalog of about 30000 books in excel. I have added those books in the calibre database using the command

=CONCATENATE("calibredb.exe add -e -a """&A2&""" -t"""&B2&"""")

which generates

calibredb.exe add -e -a "Warwick Deeping" -t "Exiles"

Using the above add I am only able add the Title and Author field.
I need to update the other fields :-

-Publication Date
-Tags

How can this be done ? It is very tedious for to do it manually for a list of 30000 books.

--Mahaveer

mahaveer · 09-16-2011, 06:27 AM

Kindly let me know if its possible ?

Manichean · 09-16-2011, 07:10 AM

I believe the only option would be to use the calibre-db set-metadata command. However, you'd need to somehow construct an OPF file containing the relevant metadata. I'm thinking that should be possible with VBScript (or whatever the current incarnation of Excel's scripting language is called).

mahaveer · 09-26-2011, 12:55 PM

Thank you for your response..I will try it.

09-14-2011, 01:44 AM	#1
mahaveer Junior Member Posts: 3 Karma: 10 Join Date: Sep 2011 Device: 123mahaveer@gmail.com	How to update metadata information from excel (Publication Date,Tags) I have a catalog of about 30000 books in excel. I have added those books in the calibre database using the command =CONCATENATE("calibredb.exe add -e -a """&A2&""" -t"""&B2&"""") which generates calibredb.exe add -e -a "Warwick Deeping" -t "Exiles" Using the above add I am only able add the Title and Author field. I need to update the other fields :- -Publication Date -Tags How can this be done ? It is very tedious for to do it manually for a list of 30000 books. --Mahaveer

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically changing Publication Date	crossi	Library Management	0	01-30-2011 07:02 PM
Multiple Edit Metadata Information Update.	scotmad	Calibre	4	01-23-2011 03:48 PM
Date of Publication Metadata	crutledge	Sigil	5	01-10-2011 01:27 PM
sony 650 date of publication	capjap	Sony Reader	5	12-11-2010 11:26 AM
Is there any way to control publication date?	weasal	Recipes	4	09-27-2010 12:37 PM

09-16-2011, 06:27 AM	#2
mahaveer Junior Member Posts: 3 Karma: 10 Join Date: Sep 2011 Device: 123mahaveer@gmail.com	Kindly let me know if its possible ?

09-16-2011, 07:10 AM	#3
Manichean Wizard Posts: 3,130 Karma: 91256 Join Date: Feb 2008 Location: Germany Device: Cybook Gen3	I believe the only option would be to use the calibre-db set-metadata command. However, you'd need to somehow construct an OPF file containing the relevant metadata. I'm thinking that should be possible with VBScript (or whatever the current incarnation of Excel's scripting language is called).

09-26-2011, 12:55 PM	#4
mahaveer Junior Member Posts: 3 Karma: 10 Join Date: Sep 2011 Device: 123mahaveer@gmail.com	Thank you for your response..I will try it.

Advert