Glo KOBO shelf --> Calibre

buralex · 09-26-2013, 07:30 AM

I've got myShelves being loaded from Calibre to KOBO working great. Thanks for the very clear instructions but need to go the other way.
i.e. if I've assigned shelves on my KOBO can I update Calibre with shelf changes made on it?

All books initially assigned (from Calibre) to "notRead-Shelf"
As I read them on KOBO I change shelf from "notRead-Shelf" to "Read-shelf"
This makes it easier to find books not yet read.

Problem: The "Manage" button on lower right stopped working and KOBO support told me to try a Factory Reset (which clears all ebooks) making it necessary to reload from my Calibre library but want to set shelf in Calibre to match current shelves on KOBO before reloading.

If that can't be done automagically can anyone tell me if currently assigned shelf/shelves on KOBO is hidden anywhere in the folders/files visible in Windows Explorer?

I was hoping it might be in one of the subfolders by author in Digital Editions (Annotations and Manifest - containing XML files) but no joy. The other possibility seems to be one of the sub-folders of .kobo though that all seem to be binary data. I did recognize in some of them some ascii text that appears to be names of shelves but no (obvious) way to figure out which titles have which shelves.

PeterT · 09-26-2013, 08:04 AM

It's unfortunately one way; from calibre to Kobo.

The actual info is stored within the Kobo database in two tables; Shelf and ShelfContent.

Shelf lists the shelves that exist (column Name contains the actual name of the shelf), and ShelfContent what is on all the shelves (ShelfName the shelf in question, and ContentID the file name of the book on the shelf).

On thing worth knowing though is that it's fairly simple using calibre to automate the creation of a "Finished" shelf via retrieval of the reading % of the books via the Kobo Utilities plugin (and additionally one step of doing that is to retrieve the reading status of all books, which can then be restored afterwards.)

John F · 09-26-2013, 11:56 AM

Wouldn't doing a sync (with Kobo) solve the problem? Sync, factory reset, sync, and all the shelves would be back?

taming · 09-26-2013, 12:46 PM

The Kobo server does not sync the non-Kobo (non-kepub) books on shelves.

PeterT · 09-26-2013, 02:51 PM

The shelf names are synced along with any Kobo purchased kEpubs on them.

jackastor · 09-26-2013, 03:03 PM

Would replicating the shelves in Calibre with the books not achieve the result desired?

buralex · 09-26-2013, 07:19 PM

Quote:

Originally Posted by PeterT

It's unfortunately one way; from calibre to Kobo.

The actual info is stored within the Kobo database in two tables; Shelf and ShelfContent.

Shelf lists the shelves that exist (column Name contains the actual name of the shelf), and ShelfContent what is on all the shelves (ShelfName the shelf in question, and ContentID the file name of the book on the shelf).

Thanks Peter. Am I correct that the data base(s) are the <random number> files in ...\.kobo\kepub ? Are these standard SQL or MYSQL so that I could look inside with some tool (bonus points if you can tell me which

)

Quote:

On thing worth knowing though is that it's fairly simple using calibre to automate the creation of a "Finished" shelf via retrieval of the reading % of the books via the Kobo Utilities plugin (and additionally one step of doing that is to retrieve the reading status of all books, which can then be restored afterwards.)

I'l check that out. Thanks for the pointer.

PeterT · 09-26-2013, 07:36 PM

Its the .kobo/KoboReader.sqlote file which yoiu can access with any tool that handles sqlote.

PeterT · 09-26-2013, 07:37 PM

The files with random numbers are the kEpubs format books from lobo.

09-26-2013, 07:30 AM	#1
buralex Junior Member Posts: 7 Karma: 11514 Join Date: Mar 2013 Device: KOBO GLO	KOBO shelf --> Calibre I've got myShelves being loaded from Calibre to KOBO working great. Thanks for the very clear instructions but need to go the other way. i.e. if I've assigned shelves on my KOBO can I update Calibre with shelf changes made on it? All books initially assigned (from Calibre) to "notRead-Shelf" As I read them on KOBO I change shelf from "notRead-Shelf" to "Read-shelf" This makes it easier to find books not yet read. Problem: The "Manage" button on lower right stopped working and KOBO support told me to try a Factory Reset (which clears all ebooks) making it necessary to reload from my Calibre library but want to set shelf in Calibre to match current shelves on KOBO before reloading. If that can't be done automagically can anyone tell me if currently assigned shelf/shelves on KOBO is hidden anywhere in the folders/files visible in Windows Explorer? I was hoping it might be in one of the subfolders by author in Digital Editions (Annotations and Manifest - containing XML files) but no joy. The other possibility seems to be one of the sub-folders of .kobo though that all seem to be binary data. I did recognize in some of them some ascii text that appears to be names of shelves but no (obvious) way to figure out which titles have which shelves. Last edited by buralex; 09-26-2013 at 07:31 AM. Reason: typo

09-26-2013, 08:04 AM	#2
PeterT Grand Sorcerer Posts: 12,283 Karma: 74007256 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	It's unfortunately one way; from calibre to Kobo. The actual info is stored within the Kobo database in two tables; Shelf and ShelfContent. Shelf lists the shelves that exist (column Name contains the actual name of the shelf), and ShelfContent what is on all the shelves (ShelfName the shelf in question, and ContentID the file name of the book on the shelf). On thing worth knowing though is that it's fairly simple using calibre to automate the creation of a "Finished" shelf via retrieval of the reading % of the books via the Kobo Utilities plugin (and additionally one step of doing that is to retrieve the reading status of all books, which can then be restored afterwards.) Last edited by PeterT; 09-26-2013 at 08:07 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Quick Guide to Shelf Management with calibre 0.9.1 & above (Touch / Glo / Mini /Aura)	PeterT	Kobo Reader	576	09-17-2022 04:50 PM
Kobo Glo / Shelf syncing	FencepostErr1r	Kobo Reader	16	07-23-2013 09:23 AM
Using series name as shelf name when sending to Kobo?	khahoon	Devices	1	07-19-2013 01:03 PM
Glo Changing .kepub collections/shelf using Calibre.	chadrizard	Kobo Reader	4	02-25-2013 01:00 PM
Touch Shelf names	davidfor	Kobo Developer's Corner	10	08-26-2012 04:45 AM

09-26-2013, 11:56 AM	#3
John F Grand Sorcerer Posts: 7,255 Karma: 65432101 Join Date: Feb 2009 Device: Kobo Glo HD	Wouldn't doing a sync (with Kobo) solve the problem? Sync, factory reset, sync, and all the shelves would be back?

09-26-2013, 12:46 PM	#4
taming Trying for calm & polite Posts: 4,012 Karma: 9455193 Join Date: May 2010 Location: Mostly in Canada Device: kobo original, WiFI, Touch, Glo, and Aura	The Kobo server does not sync the non-Kobo (non-kepub) books on shelves.

09-26-2013, 02:51 PM	#5
PeterT Grand Sorcerer Posts: 12,283 Karma: 74007256 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	The shelf names are synced along with any Kobo purchased kEpubs on them.

09-26-2013, 03:03 PM	#6
jackastor Wizard Posts: 1,847 Karma: 3212428 Join Date: Jun 2011 Device: iphone stanza, kobo touch,ASUS TF300,KOBO GLO, Kobo Aura HD, Kobo Mini	Would replicating the shelves in Calibre with the books not achieve the result desired?

09-26-2013, 07:36 PM	#8
PeterT Grand Sorcerer Posts: 12,283 Karma: 74007256 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	Its the .kobo/KoboReader.sqlote file which yoiu can access with any tool that handles sqlote.

09-26-2013, 07:37 PM	#9
PeterT Grand Sorcerer Posts: 12,283 Karma: 74007256 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	The files with random numbers are the kEpubs format books from lobo.

Advert

Advert