Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 07-15-2013, 05:17 PM   #1
timss
Member
timss began at the beginning.
 
Posts: 13
Karma: 44
Join Date: Jul 2012
Device: kobo touch
Shelf management on Touch

I have a Touch with a lot of books on an SD card. Most are non-fiction, and organized in categories by folder name. Converting these folders into shelves one book at a time is an extremely tedious process. Is calibre the only way to create the shelves I want, or is there another way to do it by accessing the sqlite file directly?

Maybe Kobo will eventually provide shelf management in Kobo desktop, or is that too much to hope for?

Thanks
timss is offline   Reply With Quote
Old 07-15-2013, 07:09 PM   #2
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 6,946
Karma: 43999669
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
See this for one approach
Quote:
Originally Posted by deufeufeu View Post
Hi,
I just got a new Kobo Touch yesterday but the shelves feature seemed broken by the fact that I couldn't do a "check all" while searching to add books.
So I wrote a python script that will build shelves based on the directory in which your ebooks are located. For example if you have all IronThrones books in the folder /mnt/onboard/IronThrones it will make a shelf named IronThrones with all books of this folder added.
The script is here http://pastebin.com/hX2kqQ9b .
I don't have time to explain how to make it works, but I'm sure those having rooted their kobos will have no problem.
PeterT is online now   Reply With Quote
Old 07-15-2013, 11:55 PM   #3
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 5,651
Karma: 5651616
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
You can also add multiple books to the shelf through the device. From the shelf, press the menu icon in the bottom right and select "Manage". On the next screen, press the "Add Books" at the top. The list of all books is displayed. Press the "+" to add each to a shelf. You can also press the magnifying glass to do a search and select books to add from the result.

The above is using the latest firmware. The exact options have changed over time, so maybe older firmware is different.
davidfor is online now   Reply With Quote
Old 07-16-2013, 01:32 PM   #4
timss
Member
timss began at the beginning.
 
Posts: 13
Karma: 44
Join Date: Jul 2012
Device: kobo touch
I've been doing the multiple selection method, but it's still tedious, and I still have a few hundred books to go...

I'm not a programmer, so I wouldn't know how to use PeterT's script.

I was hoping there might be a way to use an sqlite utility to select books by folder and add them to an existing shelf.
timss is offline   Reply With Quote
Old 07-16-2013, 08:06 PM   #5
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 5,651
Karma: 5651616
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
Sorry, I haven't seen anything else. There have been a couple of scripts similar to the one Peter pointed to. If you are confident in you SQL skills, you can use any SQLite browser to create the appropriate rows in the tables. Once there are a few, it is obvious what is needed.

Note: for anyone who thinks of trying it, the script Peter pointed to is for older firmware. When it creates the shelf, it puts a NULL into a column that no longer allows NULLs. If you want to use this, you need to change the line:

Code:
c.execute("INSERT INTO Shelf VALUES ('2012-07-25T19:59:29Z', NULL, '%s', '2012-07-25T19:59:29Z', '%s', NULL, 'false', 'true', 'false')" % (shelf,shelf))
To:
Code:
c.execute("INSERT INTO Shelf VALUES ('2012-07-25T19:59:29Z', '%s', '%s', '2012-07-25T19:59:29Z', '%s', NULL, 'false', 'true', 'false')" % (shelf,shelf,shelf))
And the timestamps should be set to the current time.
davidfor is online now   Reply With Quote
Old 07-16-2013, 08:22 PM   #6
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 6,946
Karma: 43999669
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
What you could do is to add the shelves and a few sample books on the Kobo. Then open the database via a tool like Dbeaver and take a look at the ShelfContent table. It shoul
PeterT is online now   Reply With Quote
Old 07-18-2013, 12:12 AM   #7
timss
Member
timss began at the beginning.
 
Posts: 13
Karma: 44
Join Date: Jul 2012
Device: kobo touch
Quote:
Originally Posted by PeterT View Post
What you could do is to add the shelves and a few sample books on the Kobo. Then open the database via a tool like Dbeaver and take a look at the ShelfContent table. It shoul
I'll take a look it. I can display the contents of shelves with sqlite administrator, but my current knowledge of SQL commands is about nil.

BTW I think your post got cut off or something...
timss is offline   Reply With Quote
Old 07-18-2013, 12:24 AM   #8
PeterT
Taking a break; Fed up
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 6,946
Karma: 43999669
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
Quote:
Originally Posted by timss View Post
I'll take a look it. I can display the contents of shelves with sqlite administrator, but my current knowledge of SQL commands is about nil.

BTW I think your post got cut off or something...
Lol... It did... I was typing on my tablet and meant to come back to it.

What I was going to say was this.

For simplicity, create the shelves on the Kobo itself.

Then using any tool capable of editing SQLite tables you want to insert rows into the ShelfContent table. The key bits of info are:
ShelfName: The internal name from the Shelf table
ContentId: The location of the book going onto the shelf.
This can be found from the content table.
PeterT is online now   Reply With Quote
Reply

Tags
shelves, touch

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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 413 10-14-2014 12:41 AM
K5 Touch management bundle twobob Kindle Developer's Corner 5 09-02-2013 07:21 AM
Ebook/shelf management similar to Bebook One Slone Which one should I buy? 4 10-17-2012 09:12 PM
Thinking of getting a Kobo Touch - Battery + Book Management questions nila Kobo Reader 17 06-23-2012 04:42 PM
Kindle Touch Collection Management RRRrrr Amazon Kindle 21 05-23-2012 05:05 AM


All times are GMT -4. The time now is 05:36 AM.


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