![]() |
#31 | |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 112
Karma: 53342
Join Date: Jun 2013
Device: Sony PRS-600
|
Quote:
calibredb set_metadata -f publisher:'Some Publisher' -f comments:'big block of HTML' bookID does work as one would hope. My attempts at assigning multiple custom columns in one call, not so much. |
|
![]() |
![]() |
![]() |
#32 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,365
Karma: 27230406
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Use the correct field names, --list-fields is your friend.
|
![]() |
![]() |
Advert | |
|
![]() |
#33 |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 112
Karma: 53342
Join Date: Jun 2013
Device: Sony PRS-600
|
Indeed, and I am using the correct field names. (take '--with-library' as given):
works
works
works
respects only the first entry
do not recognize the custom field name (despite 'Custom Field', '#custfield' being returned when I query fields that can be set, using --list-fields)
does not recognize -f, as indeed I would not expect it to (but thought I would try anyway). If there is a way to assign multiple custom columns via a single call I will happily use it. It is not documented in calibredb (--help or the help page). Obvious permutations and applications of the set_custom and set_metadata commands don't work as one might hope. Multiple field specification when calling set_metadata does work (I don't see in the documentation that you can do this, but after you suggested it I tried and it worked), but I don't see how to get it to accept custom columns despite them being reported as available when I query using --list-fields. |
![]() |
![]() |
![]() |
#34 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,365
Karma: 27230406
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
You want
-f '#name:value' |
![]() |
![]() |
![]() |
#35 |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 112
Karma: 53342
Join Date: Jun 2013
Device: Sony PRS-600
|
That was not obvious from the documentation, but I think you just made my day.
Of course, the first entry I tried loading is missing a bunch of fields (the product page was missing, but I still have a "this product no longer available" response page). Second one populated everything as expected, though! 25 seconds per entry (connecting directly) down to ~6-7! Thank you! That reduces an 42+ hour job to 14 hours. I could conceivably have this entire thing uploaded by... the time I start work tomorrow. Right. I don't suppose 'calibredb add' can take "-f comments:'comment' -f publisher:'publisher' -f '#custom:value'" as well, so I can do it all in one pass? THANK YOU. Even if I can't do the entire thing in a single call, getting it down to 'add title' and one 'set remaining metadata' call is a big improvement. |
![]() |
![]() |
Advert | |
|
![]() |
#36 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 45,365
Karma: 27230406
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
That's how quoting for all shells works, you surround the entire argument with quotes. And yes you can set all fields including builtin and custom ones in a single call.
|
![]() |
![]() |
![]() |
#37 | |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 112
Karma: 53342
Join Date: Jun 2013
Device: Sony PRS-600
|
Quote:
-f publisher:'publisher with spaces' when you're telling me the correct quoting is -f 'publisher:some publisher with spaces' And "calibredb add" will accept -f as well? Time to give that a try. Last edited by kjdavies; 06-09-2020 at 01:47 AM. Reason: fixing (I hope) emoji |
|
![]() |
![]() |
![]() |
#38 | |
Zealot
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 112
Karma: 53342
Join Date: Jun 2013
Device: Sony PRS-600
|
Quote:
calibredb add -f 'publisher:some publisher' libraryspec myfile.cbz Fails with calibredb.exe: error: no such option -f Still, I'm down to two calls, so it's still good. Thank you again. |
|
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Support multiple instances of same format in same book entry | masp | Library Management | 3 | 09-23-2014 10:44 PM |
Multiple identical server instances detected | didierm | Calibre Companion | 2 | 08-17-2014 10:19 AM |
Two or multiple instances of Calibre on one computer | clockmaker | Library Management | 2 | 06-30-2012 01:55 PM |
Replace multiple matching instances within paragraph? | murphycc | Conversion | 2 | 02-23-2012 09:53 AM |
Trouble with multiple content server instances | perx | Calibre | 3 | 02-17-2012 01:24 AM |