set metadata field

fr3d · 06-14-2012, 09:56 AM

Hi,

I'm new here. I need to import my csv data to calibre. As mentioned in the manual there's a command where i can update some fields. The manual says under the topic calibredb set_metadata that one can use te option --field instead of using opf files: "You can also set the metadata of individual fields with the –field option."

Has anyone an example of this. I got an error when I try to change a field:
"... file not found":

calibredb set_metadata 7 --field timestamp "01.01.2000"
Traceback (most recent call last):
File "site.py", line 58, in main
File "site-packages/calibre/library/cli.py", line 1301, in main
File "site-packages/calibre/library/cli.py", line 577, in command_set_metadata
File "site-packages/calibre/library/cli.py", line 500, in do_set_metadata
File "site-packages/calibre/ebooks/metadata/opf2.py", line 553, in __init__
IOError: [Errno 2] Datei oder Verzeichnis nicht gefunden: u'01.01.2000'

Thanks in advance !
Fr3d

kovidgoyal · 06-14-2012, 10:25 AM

--field=timestamp:01.01.2000

fr3d · 06-14-2012, 11:01 AM

Thanks for the hint !

It seems to be a problem: The day didn't change. It's always set to "2":

calibredb set_metadata 7 --field=timestamp:01.01.1961

Title : Der Judas-Code
Title sort : Judas-Code, Der
Author(s) : Rollins, James [James, Rollins,]
Timestamp : 1961-01-02T00:00:00+00:00
Published : 2012-06-14T13:29:23+00:00
Backing up metadata
Notifying calibre of the change

kovidgoyal · 06-14-2012, 11:02 AM

Yes, that is deliberate, to keep the month accurate in all timezones. first day of moth always becomes second day of month and alst day of month becomes last-1 day

fr3d · 06-14-2012, 11:05 AM

thats a quick answer, thanks.

How does it looks like ? Can you post an example .

By the way, I add a new field "gelesen" which has an boolean inside "yes" or "true". How can I manipulate this by the set_metadata command ?

fr3d · 06-14-2012, 11:13 AM

is there a workaround setting the correct date ?

fr3d · 06-14-2012, 11:25 AM

I found it out how to manipulate custom field:

calibredb set_custom gelesen 7 true

This command set to boolean to true.

The last issue I have is the one with the date. I would appreciate if you can give a hint for that.

Thanks a lot !

06-14-2012, 09:56 AM	#1
fr3d Member Posts: 22 Karma: 10 Join Date: Jun 2012 Device: Pocketbook 622 Touch	set metadata field Hi, I'm new here. I need to import my csv data to calibre. As mentioned in the manual there's a command where i can update some fields. The manual says under the topic calibredb set_metadata that one can use te option --field instead of using opf files: "You can also set the metadata of individual fields with the –field option." Has anyone an example of this. I got an error when I try to change a field: "... file not found": calibredb set_metadata 7 --field timestamp "01.01.2000" Traceback (most recent call last): File "site.py", line 58, in main File "site-packages/calibre/library/cli.py", line 1301, in main File "site-packages/calibre/library/cli.py", line 577, in command_set_metadata File "site-packages/calibre/library/cli.py", line 500, in do_set_metadata File "site-packages/calibre/ebooks/metadata/opf2.py", line 553, in __init__ IOError: [Errno 2] Datei oder Verzeichnis nicht gefunden: u'01.01.2000' Thanks in advance ! Fr3d

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Edit Metadata date field	BeccaPrice	Calibre	16	02-10-2012 01:39 PM
Custom Metadata Field	gpp	Sigil	6	02-22-2011 08:39 AM
metadata field list?	aabs	Calibre	1	01-02-2011 02:42 AM
ZXreader series field - how do I set it using Calibre?	Boreads	Calibre	3	12-08-2010 11:38 PM
'Published' metadata field	Suitecake	Calibre	1	12-04-2010 11:09 PM

06-14-2012, 10:25 AM	#2
kovidgoyal creator of calibre Posts: 43,978 Karma: 22669822 Join Date: Oct 2006 Location: Mumbai, India Device: Various	--field=timestamp:01.01.2000

06-14-2012, 11:01 AM	#3
fr3d Member Posts: 22 Karma: 10 Join Date: Jun 2012 Device: Pocketbook 622 Touch	Thanks for the hint ! It seems to be a problem: The day didn't change. It's always set to "2": calibredb set_metadata 7 --field=timestamp:01.01.1961 Title : Der Judas-Code Title sort : Judas-Code, Der Author(s) : Rollins, James [James, Rollins,] Timestamp : 1961-01-02T00:00:00+00:00 Published : 2012-06-14T13:29:23+00:00 Backing up metadata Notifying calibre of the change

06-14-2012, 11:02 AM	#4
kovidgoyal creator of calibre Posts: 43,978 Karma: 22669822 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Yes, that is deliberate, to keep the month accurate in all timezones. first day of moth always becomes second day of month and alst day of month becomes last-1 day

06-14-2012, 11:05 AM	#5
fr3d Member Posts: 22 Karma: 10 Join Date: Jun 2012 Device: Pocketbook 622 Touch	thats a quick answer, thanks. How does it looks like ? Can you post an example . By the way, I add a new field "gelesen" which has an boolean inside "yes" or "true". How can I manipulate this by the set_metadata command ?

06-14-2012, 11:13 AM	#6
fr3d Member Posts: 22 Karma: 10 Join Date: Jun 2012 Device: Pocketbook 622 Touch	is there a workaround setting the correct date ?

06-14-2012, 11:25 AM	#7
fr3d Member Posts: 22 Karma: 10 Join Date: Jun 2012 Device: Pocketbook 622 Touch	I found it out how to manipulate custom field: calibredb set_custom gelesen 7 true This command set to boolean to true. The last issue I have is the one with the date. I would appreciate if you can give a hint for that. Thanks a lot !

Advert

Advert