|
I'm using jobspy to update metadata in custom columns using a csv file. This works well for a text type column, but I am stuck with a date type column.
The csv is formatted like this:
title,#Borrowed
Le potager en pot,2022-03-24
The error reads like this:
calibre, version 5.42.0
ERROR: Some failures: Failed to apply updated metadata for some books in your library. Click "Show details" to see details.
Le potager en pot - Bertrand Dumont
Traceback (most recent call last):
File "calibre\gui2\actions\edit_metadata.py", line 887, in apply_mi
File "calibre\db\legacy.py", line 580, in set_metadata
File "calibre\db\cache.py", line 74, in call_func_with_lock
File "calibre\db\cache.py", line 1506, in set_metadata
File "calibre\db\cache.py", line 1443, in protected_set_field
File "calibre\db\cache.py", line 1421, in set_field
File "calibre\db\cache.py", line 1239, in set_field
File "calibre\db\write.py", line 561, in set_books
File "calibre\db\write.py", line 561, in <dictcomp>
File "calibre\db\write.py", line 73, in adapt_datetime
File "calibre\utils\date.py", line 113, in parse_date
File "dateutil\parser\_parser.py", line 1374, in parse
File "dateutil\parser\_parser.py", line 649, in parse
dateutil.parser._parser.ParserError: Unknown string format: YYYY-03-DD
************************************************** ******************************
I have also tried the following formats, which give the same error:
Le potager en pot,2022-01-24T00:00:00-05:00
Le potager en pot,2022-03-24
Le potager en pot,24 Jan 2022
Le potager en pot,20220324
Le potager en pot,24-01-2022
Any thoughts on this are appreciated! Thanks.
|