Series info into Tags field for Stanza's Groups

RoninTech · 07-05-2010, 11:31 PM

Hi Kovid,

Stanza (for ipod, iphone and ipad) can list books in 3 ways: by Title, Author and Groups. The Groups field sorts based on Calibre's Tags field. Currently Stanza's Groups listing is unusable for me because each book has extensive tag info.

It would be nice to see a list of series when browsing by Groups. To do this I'd just need to overwrite the Calibre Tags field with the book's Series info. Any idea how I could do this easily?

kovidgoyal · 07-06-2010, 01:18 AM

There's no way to do it, other than to put the series info into the tag field.

RoninTech · 07-06-2010, 10:16 AM

Quote:

Originally Posted by kovidgoyal

There's no way to do it, other than to put the series info into the tag field.

Is there a way to automate this moving of Series Info to the Tags field to save me doing it manually on hundreds of books? I know code fu if that helps.

kovidgoyal · 07-06-2010, 10:17 AM

if you can write sql queries it should be easy. Just do this:

Code:

calibre-debug -c "from calibre.library import db; db = db(); db.conn.execute('the sql query'); db.conn.commit()"

RoninTech · 07-06-2010, 10:23 AM

There we go that's the tip I was looking for. Thanks!

07-05-2010, 11:31 PM	#1
RoninTech Groupie Posts: 168 Karma: 1000036 Join Date: Oct 2008 Location: Citizen of the World Device: iPod Touch, Nook Colour, Kobo Touch, Kobo Glo, Nexus 7, Nexus 5, Pixel	Series info into Tags field for Stanza's Groups Hi Kovid, Stanza (for ipod, iphone and ipad) can list books in 3 ways: by Title, Author and Groups. The Groups field sorts based on Calibre's Tags field. Currently Stanza's Groups listing is unusable for me because each book has extensive tag info. It would be nice to see a list of series when browsing by Groups. To do this I'd just need to overwrite the Calibre Tags field with the book's Series info. Any idea how I could do this easily?

07-06-2010, 10:17 AM	#4
kovidgoyal creator of calibre Posts: 45,609 Karma: 28549044 Join Date: Oct 2006 Location: Mumbai, India Device: Various	if you can write sql queries it should be easy. Just do this: Code: calibre-debug -c "from calibre.library import db; db = db(); db.conn.execute('the sql query'); db.conn.commit()"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can not get series info in titles on 505	tomd365	Calibre	5	03-21-2010 06:20 AM
don't download series info	jjansen	Calibre	2	03-06-2010 03:09 PM
Newbie q about series and tags	hnoto	Calibre	3	08-06-2009 10:24 PM
Help with meta tags/info	s0nya	Sony Reader	10	06-04-2009 08:44 PM
Series Info HELP!	diana.stout	Sony Reader	8	07-24-2008 07:22 PM

07-06-2010, 01:18 AM	#2
kovidgoyal creator of calibre Posts: 45,609 Karma: 28549044 Join Date: Oct 2006 Location: Mumbai, India Device: Various	There's no way to do it, other than to put the series info into the tag field.

07-06-2010, 10:23 AM	#5
RoninTech Groupie Posts: 168 Karma: 1000036 Join Date: Oct 2008 Location: Citizen of the World Device: iPod Touch, Nook Colour, Kobo Touch, Kobo Glo, Nexus 7, Nexus 5, Pixel	There we go that's the tip I was looking for. Thanks!

Advert

Advert