Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 02-06-2014, 02:29 PM   #1
ZioNemo
Enthusiast
ZioNemo began at the beginning.
 
Posts: 48
Karma: 10
Join Date: Mar 2008
Device: HTC-p3000
calibredb format for "series" custom columns

I have custom column "ddlib" of type "series":
Code:
ddlib

{u'datatype': u'series',
 u'display': {},
 u'editable': True,
 u'is_multiple': False,
 u'label': u'ddlib',
 u'multiple_seps': {},
 u'name': u'DD_Library',
 u'normalized': True,
 u'num': 1}
I tried to set it with something like "calibredb set_metadata ... -f #ddlib:FR -f #ddlib_index:717 ...", but this does NOT seem to work.
I see no error, but _ddlib_index is always set to "1.0"

What is the right way to do that?
"calibredb set_metadata -h" does not give any info.

Similar problem for the "regular" series field: index is always "1.0".
Difference is in xml "catalog" dump:
Code:
  <record>
    <_ddlib>BB</_ddlib>
    <_ddlib_index>1.0</_ddlib_index>
    ...
    <series index="1.0">Books Of Blood</series>
    <library_name>cLib</library_name>
  </record>
Is this expected?
What I'm supposed to do, instead?

TiA
ZioNemo is offline   Reply With Quote
Old 02-06-2014, 04:53 PM   #2
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,421
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
don't use multiple -f options, just separate them by commas, e.g. "-f #ddlib:FR,#ddlib_index:717"
eschwartz is offline   Reply With Quote
Advert
Old 02-06-2014, 04:56 PM   #3
ZioNemo
Enthusiast
ZioNemo began at the beginning.
 
Posts: 48
Karma: 10
Join Date: Mar 2008
Device: HTC-p3000
Quote:
Originally Posted by eschwartz View Post
don't use multiple -f options, just separate them by commas, e.g. "-f #ddlib:FR,#ddlib_index:717"
Is that just for series/series_index or should I do it for ALL fields I wish to change?
ZioNemo is offline   Reply With Quote
Old 02-06-2014, 07:50 PM   #4
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,421
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Never mind, I misread the man page, that's just if you're setting identifiers/tags.

...

I have experimented, and I can get it to set the series and index like this:

Code:
calibredb set_metadata -f "series:randomness [22]" 698
but if I use the same code with #subseries instead:

Code:
calibredb set_metadata -f "#subseries:randomness [22]" 698
It doesn't affect the index at all. I think this may be a bug.
eschwartz is offline   Reply With Quote
Old 02-06-2014, 10:10 PM   #5
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,954
Karma: 22669822
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
https://github.com/kovidgoyal/calibr...3207a97fea9687
kovidgoyal is offline   Reply With Quote
Advert
Old 02-06-2014, 11:36 PM   #6
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,421
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
I'm running from source and I pulled this change. It is now setting custom #blah_index fields correctly, this works:
Code:
calibredb set_metadata -f "#subseries:randomness" -f "#subseries_index:22" 698


However, using
Code:
calibredb set_metadata -f "series:randomness [22]" 698
also works -- but only for the main series field. For custom series fields, using
Code:
calibredb set_metadata -f "#subseries:randomness [22]" 698
does not register the _index

As it does work for the main column, I think this should be fixed for custom columns too.


@ZioNemo, this will be fixed in the update that was just just released right now.

Last edited by eschwartz; 02-06-2014 at 11:39 PM.
eschwartz is offline   Reply With Quote
Old 02-06-2014, 11:52 PM   #7
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 43,954
Karma: 22669822
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Getting that notation to work with custom series fields is rather more effort than it is worth to me.
kovidgoyal is offline   Reply With Quote
Old 02-06-2014, 11:57 PM   #8
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,421
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Quote:
Originally Posted by kovidgoyal View Post
Getting that notation to work with custom series fields is rather more effort than it is worth to me.
Okay then. It's probably not what people are looking to use anyway.... Just wanted to make sure you knew it was doing that.

As always, thanks for the excellent support you provide us all!

Last edited by eschwartz; 02-07-2014 at 12:02 AM.
eschwartz is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
calibredb to read custom columns values diazlaz Development 1 12-27-2013 07:51 PM
Custom column: "Updated date", when adding new "versions" of the same file? enriquep Library Management 16 11-03-2011 10:46 AM
No data in "In Library" and "On Device" columns after upgrade ily426 Library Management 8 04-03-2011 02:53 PM
Error message : "Invalid Format" " Do you want to format your internal memory" narbeauchamp Sony Reader 11 07-22-2009 12:39 PM
"Dummies" Series Now Available in MobiPocket Format HarryT News 0 10-27-2007 09:58 AM


All times are GMT -4. The time now is 07:11 PM.


MobileRead.com is a privately owned, operated and funded community.