08-15-2013, 03:33 PM | #1 |
Junior Member
Posts: 7
Karma: 10
Join Date: Jan 2013
Location: Ontario, Canada
Device: KOBO TOUCH
|
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 |
08-15-2013, 03:48 PM | #2 |
Grand Sorcerer
Posts: 12,609
Karma: 74358024
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
|
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. |
08-15-2013, 06:03 PM | #3 |
Addict
Posts: 205
Karma: 459093
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.
|
08-15-2013, 07:54 PM | #4 |
Grand Sorcerer
Posts: 24,905
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
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. |
08-16-2013, 02:47 AM | #5 |
Addict
Posts: 205
Karma: 459093
Join Date: May 2011
Device: Kobo Aura, Mini, Glo, & Aura HD, KPW, Nook Glow, Nook HD
|
Are there step by step instructions somewhere how to do this because I can see nothing in calibre about shelves. Thanks!
|
08-16-2013, 03:15 AM | #6 | |
Grand Sorcerer
Posts: 24,905
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
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. |
|
08-16-2013, 03:29 AM | #7 |
Grand Sorcerer
Posts: 24,905
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
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". |
08-16-2013, 09:54 AM | #8 | |
Guru
Posts: 965
Karma: 3475832
Join Date: May 2012
Location: France
Device: Elipsa, Sage
|
Quote:
|
|
08-16-2013, 01:52 PM | #9 | |
friendly lurker
Posts: 896
Karma: 2436026
Join Date: Apr 2007
Location: US
Device: Kindle, nook, Apple and Kobo
|
Quote:
|
|
08-16-2013, 01:57 PM | #10 |
Grand Sorcerer
Posts: 12,609
Karma: 74358024
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
|
I can't speak for David but I've been using DBeaver from http://dbeaver.jkiss.org/ for all my SQLite playing.
|
08-16-2013, 02:48 PM | #11 |
Guru
Posts: 691
Karma: 3026110
Join Date: Dec 2008
Location: Lancashire, U.K.
Device: BeBook 1, BeBook Pure, Kobo Glo, (and HD),Energy Sistem EReader Pro +
|
SQLite Expert Personal is free from http://www.sqliteexpert.com/download.html and seems quite adequate for viewing and tinkering.
BobC |
08-17-2013, 04:57 AM | #12 |
Grand Sorcerer
Posts: 24,905
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
I usually use SQLite Manager which is a Firefox plugin.
|
08-17-2013, 08:19 AM | #13 |
Grand Sorcerer
Posts: 24,905
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
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". |
08-17-2013, 02:40 PM | #14 | |
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
|
Quote:
|
|
08-17-2013, 03:41 PM | #15 | |
Grand Sorcerer
Posts: 12,609
Karma: 74358024
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
|
Quote:
Done Last edited by PeterT; 08-17-2013 at 10:49 PM. |
|
Thread Tools | Search this Thread |
|
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 |