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 08-15-2013, 03:33 PM   #1
Terri_B
Junior Member
Terri_B began at the beginning.
 
Terri_B's Avatar
 
Posts: 7
Karma: 10
Join Date: Jan 2013
Location: Ontario, Canada
Device: KOBO TOUCH
Unhappy Shelfs

I know this issue has been brought up and I have read through all the threads concerning this issue but I am not tech savvy, I don't use Caliber, Digital Additions or SQLite as mentioned in one of the threads. I don't know how to find files, change formats, etc.

So I was wondering if someone could tell me why when I deleted all my original shelves on my KOBO Touch e-reader and made all new ones that when I bought another book and synced my e-reader the old shelves showed up mixed in with my new shelves. I proceeded to delete all the shelves again but 2 of my authors shelves went triplicate and even though I have removed all the books off those shelves they will not delete and you can not rename them and when I sync my e-reader all the books I have taken off those triplicate shelves go right back on the shelves again. All the other authors shelves and I had 5 pages of them were able to be deleted.

I only upload e-pubs from KOBO, only use the KOBO desktop and only use the options available on my KOBO e-reader. With that in mind does anyone know how to delete these shelves since KOBO support has no idea how to do this which just baffles the heck out of me.

Thank You - Terri
Terri_B is offline   Reply With Quote
Old 08-15-2013, 03:48 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,117
Karma: 38639832
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
There have been issues with the Kobo servers that result in old sheved being resynced with devices.

Unfortunately there is no easy means of cleaning this up.
PeterT is offline   Reply With Quote
 
Enthusiast
Old 08-15-2013, 06:03 PM   #3
selina4books
Groupie
selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.
 
Posts: 172
Karma: 443433
Join Date: May 2011
Device: Kobo Aura, Mini, Glo, & Aura HD, KPW, Nook Glow, Nook HD
I have totally given up on shelves. My Aura now has 8 "Read" shelves, 4 "Library book" shelves and a ton of other duplications. Whatever the reason (I've added books from Calibre but never messed with the shelves using it, I have no idea why they keep returning and multiplying) they just keep on multiplying. I finally got rid of them then bam! One sync and they were back. With even MORE multiples. They're annoying and so I just stopped using them. Today I, once again, signed out of my account on the Aura and back in trying to fix issues (multiple shelves and the not communicating with device error). Not only did I get all the multiplying shelves back, and more, it no longer let me sign into Digital Editions...apparently it uses an authorization every time you sign out of Kobo and back in, then when you go back on ADE to download a book if you've used them all you're no longer authorized...and of course I couldn't read any of the books on the device I'd bought from Diesel Books, Books on Board, or borrowed from the library. I had to have Adobe reset My authorizations. It's really frustrating.
selina4books is offline   Reply With Quote
Old 08-15-2013, 07:54 PM   #4
davidfor
Wizard
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: 4,280
Karma: 3677996
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
The multiple shelves problem is something happening on the Kobo server. Or an interaction between the server and the device. As Kobo store the info about the shelves on the server, logging out or doing a factory reset will not fix this problem. When you log in again, the shelves will be downloaded from the server. This will include the duplicates.

There are three ways I can think of to fix this:

- Use calibre to delete all the shelves and then sync.
- Manual editing of the database to mark the duplicate shelves as deleted and then sync.
- Get Kobo support to delete the duplicates and then sync. If you do this, they will probably ask you to do a factory reset or log out first. Tell them you have just done this and they came back.
davidfor is offline   Reply With Quote
Old 08-16-2013, 02:47 AM   #5
selina4books
Groupie
selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.selina4books ought to be getting tired of karma fortunes by now.
 
Posts: 172
Karma: 443433
Join Date: May 2011
Device: Kobo Aura, Mini, Glo, & Aura HD, KPW, Nook Glow, Nook HD
Quote:
Originally Posted by davidfor View Post
There are three ways I can think of to fix this:

- Use calibre to delete all the shelves and then sync.
- Manual editing of the database to mark the duplicate shelves as deleted and then sync.
.
Are there step by step instructions somewhere how to do this because I can see nothing in calibre about shelves. Thanks!
selina4books is offline   Reply With Quote
Old 08-16-2013, 03:15 AM   #6
davidfor
Wizard
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: 4,280
Karma: 3677996
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by selina4books View Post
Are there step by step instructions somewhere how to do this because I can see nothing in calibre about shelves. Thanks!
I was afraid someone would ask

To do it using calibre:

1) Open the configuration for the Kobo driver you are using. This is either the main KoboTouch driver or the KoboTouchExtended driver.
2) Remove the column names you currently have in the shelf columns field. That is the last field before the check boxes.
3) Into the shelf columns field, enter the search name of another column in your calibre library. it needs to be a columns that displays text rather than a date or number.
4) Uncheck the "Create bookshelves" option
5) Make sure the "Delete empty bookshelves" option is selected.
6) Save the changes
7) Make sure that on the "Sending books to devices" page of the preferences that "Metadata management" is set to automatic.
8) Restart calibre
9) Connect the Kobo device and let calibre do its thing.
10) When calibre has finished eject the device
11) Check the shelves are all gone and sync to the Kobo server to tell it to delete the shelves.

The only problem with this is if there are books on the device that are not in the calibre library. If any of those books are on shelves, those particular shelves are not empty and the driver will not delete them.
davidfor is offline   Reply With Quote
Old 08-16-2013, 03:29 AM   #7
davidfor
Wizard
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: 4,280
Karma: 3677996
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
If you want to clean-up the shelves by directly editing the database, you can. But, as it is a dangerous thing to do, I will simply state the changes needed. If you understand them and want to risk it, go ahead. If you don't understand them, I recommend not attempting to do it.

The database on the device is an SQLite database. It is in ".kobo\KoboReader.sqlite". The shelves are stored in the "Shelf" table in the database. The columns to look at are "Name" and "_IsDeleted" and possibly one of the timestamps. Just deleting these rows is not enough. The next sync to Kobo will probably bring them back.

If you change "_IsDeleted" to "true" for all rows in the table, the shelves will be deleted from the device and the server at the next sync.

You can selectively change "_IsDeleted" to "true" for just the extra shelves. When I did this, I changed it for all duplicated shelves the except the one with oldest "CreationDate".
davidfor is offline   Reply With Quote
Old 08-16-2013, 09:54 AM   #8
anacreon
Zealot
anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.anacreon composes epic poetry in binary.
 
anacreon's Avatar
 
Posts: 139
Karma: 90050
Join Date: May 2012
Device: sony prs-t2, kobo glo + aura HD + aura
Quote:
Originally Posted by davidfor View Post
If you want to clean-up the shelves by directly editing the database, you can. But, as it is a dangerous thing to do, I will simply state the changes needed. If you understand them and want to risk it, go ahead. If you don't understand them, I recommend not attempting to do it.

The database on the device is an SQLite database. It is in ".kobo\KoboReader.sqlite". The shelves are stored in the "Shelf" table in the database. The columns to look at are "Name" and "_IsDeleted" and possibly one of the timestamps. Just deleting these rows is not enough. The next sync to Kobo will probably bring them back.

If you change "_IsDeleted" to "true" for all rows in the table, the shelves will be deleted from the device and the server at the next sync.

You can selectively change "_IsDeleted" to "true" for just the extra shelves. When I did this, I changed it for all duplicated shelves the except the one with oldest "CreationDate".
After backing-up of course, I went all out this morning, and deleted the full lines for all duplicated / triplicated active shelves (keeping the most recent), and all the obsolete shelves which were not even visible on the kobos. It worked fine, but I decided a while back not to sync with kobo when not absolutely necessary. When I had to, after I last had to do a factory reset, I started with eliminating from kobo desktop the very few books I'd bought from kobo (from the computer, to the computer, anyway), and I didn't notice kobocreated shelves in the database.
anacreon is offline   Reply With Quote
Old 08-16-2013, 01:52 PM   #9
6charlong
friendly lurker
6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.6charlong ought to be getting tired of karma fortunes by now.
 
6charlong's Avatar
 
Posts: 823
Karma: 2185840
Join Date: Apr 2007
Location: US
Device: Kindle, nook, Apple and Kobo
Quote:
Originally Posted by davidfor View Post
If you want to clean-up the shelves by directly editing the database, you can. But, as it is a dangerous thing to do, I will simply state the changes needed. If you understand them and want to risk it, go ahead. If you don't understand them, I recommend not attempting to do it.

The database on the device is an SQLite database. It is in ".kobo\KoboReader.sqlite". The shelves are stored in the "Shelf" table in the database. The columns to look at are "Name" and "_IsDeleted" and possibly one of the timestamps. Just deleting these rows is not enough. The next sync to Kobo will probably bring them back.

If you change "_IsDeleted" to "true" for all rows in the table, the shelves will be deleted from the device and the server at the next sync.

You can selectively change "_IsDeleted" to "true" for just the extra shelves. When I did this, I changed it for all duplicated shelves the except the one with oldest "CreationDate".
What line editor did you use?
6charlong is offline   Reply With Quote
Old 08-16-2013, 01:57 PM   #10
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,117
Karma: 38639832
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
I can't speak for David but I've been using DBeaver from http://dbeaver.jkiss.org/ for all my SQLite playing.
PeterT is offline   Reply With Quote
Old 08-16-2013, 02:48 PM   #11
BobC
Addict
BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.BobC ought to be getting tired of karma fortunes by now.
 
Posts: 304
Karma: 245754
Join Date: Dec 2008
Location: Lancashire, U.K.
Device: BeBook 1 (x2), Kobo Glo, Various Android Apps on JellyBean Tablet
SQLite Expert Personal is free from http://www.sqliteexpert.com/download.html and seems quite adequate for viewing and tinkering.

BobC
BobC is offline   Reply With Quote
Old 08-17-2013, 04:57 AM   #12
davidfor
Wizard
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: 4,280
Karma: 3677996
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
I usually use SQLite Manager which is a Firefox plugin.
davidfor is offline   Reply With Quote
Old 08-17-2013, 08:19 AM   #13
davidfor
Wizard
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: 4,280
Karma: 3677996
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
Preventing shelves from Syncing

While we are on the topic of shelves and syncing, there is a way to prevent shelves from syncing. Add the following line into your "Kobo eReader.conf" file in the "ApplicationPreferences":

SyncShelves=false

To enable shelf syncing again, either remove the line or change the value to "true".
davidfor is offline   Reply With Quote
Old 08-17-2013, 02:40 PM   #14
taming
Trying for calm & polite
taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.taming ought to be getting tired of karma fortunes by now.
 
taming's Avatar
 
Posts: 4,005
Karma: 9455193
Join Date: May 2010
Location: Mostly in Canada
Device: kobo original, WiFI, Touch, Glo, and Aura
Quote:
Originally Posted by davidfor View Post
While we are on the topic of shelves and syncing, there is a way to prevent shelves from syncing. Add the following line into your "Kobo eReader.conf" file in the "ApplicationPreferences":

SyncShelves=false

To enable shelf syncing again, either remove the line or change the value to "true".
Thanks for this. It would make a great addition to Peter's shelf guide for folks who always use calibre to manage shelves.
taming is offline   Reply With Quote
Old 08-17-2013, 03:41 PM   #15
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,117
Karma: 38639832
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
Quote:
Originally Posted by taming View Post
Thanks for this. It would make a great addition to Peter's shelf guide for folks who always use calibre to manage shelves.
Yeah Yeah..... I'll get round to it....

Done

Last edited by PeterT; 08-17-2013 at 10:49 PM.
PeterT is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Nook Simple Touch: Shelfs from tags and series? samy2 Calibre 1 07-13-2013 08:59 AM


All times are GMT -4. The time now is 10:45 AM.


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