08-21-2012, 11:16 PM | #1 |
Grand Sorcerer
Posts: 24,906
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Shelf names
I would like some information from someone with a Touch running firmware 2.0.0 or later that is setup to use a language other than English.
In the SQLite database on the Touch, there is table called "Shelf". This holds a row for each shelf that you create. It also holds a row for the "Shortlist" and the "Wishlist". In fact, in the database, these are in no way different to any other shelf. What I am interested in, is what values are in two of the columns for these shelves. The table has two name columns. One is "InternalName" and the other "Name". In the English version, these columns hold the same value for all shelves. This is the name you entered when creating the shelf. So, for the "Shortlist" shelf, both are set to "Shortlist". What I would like to know, is if this is different in other languages. I know how I would have done it, but I am curious to see how Kobo did. So, what I would like, is for someone running a non-English Touch with firmware 2.0.0 or later, to add a book or two to the Shortlist and Wishlist. Then have a look in the database on the Touch and report the values. Giving me a copy of the database after adding the books would also be handy, but I can understand if people don't want to do that. Thanks for any help. |
08-22-2012, 08:26 AM | #2 |
Enthusiast
Posts: 26
Karma: 10
Join Date: Aug 2012
Device: Kobo Touch
|
Unless they've done something very, very funky with their SQL implementation, I'd expect the two to be identical, unless you choose to use unicode characters in the shelf name.
My Touch is in English, so I'm not going to try anything directly, but I suspect that if you use unicode (Chinese, Japanese, Greek & possibly accented characters) in your names, the two will differ |
08-22-2012, 10:06 AM | #3 |
Grand Sorcerer
Posts: 24,906
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
But, if they are identical, why have them?
I hadn't thought about unicode. I was more thinking that for the Shortlist and Wishlist, that one would be the local word and used for display. The other would be the same every where used for linking in the database or other code. There isn't anything else that differentiates these shelves from the others. |
08-22-2012, 10:52 AM | #4 |
No Comment
Posts: 3,240
Karma: 23878043
Join Date: Jan 2012
Location: Australia
Device: Kobo: Not just an eReader, it's an adventure!
|
|
08-22-2012, 06:09 PM | #5 | |
Enthusiast
Posts: 26
Karma: 10
Join Date: Aug 2012
Device: Kobo Touch
|
Quote:
Lazy SQL programming (Or outdated toolsets) basically means that you only implement the non-unicode search method, and pull the 'real' unicode string from a separate field. |
|
08-22-2012, 07:58 PM | #6 | |
Grand Sorcerer
Posts: 24,906
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
As I said, there are two name columns in the table Shelf: InternalName and Name. In the ShelfContent table, there is column ShelfName. If you add a shelf, a row gets inserted with the two names the same. If you put a book on a shelf, a row for that book with the shelf name gets created. When I first looked at this, I assumed the join was Shelf.InternalName with ShelfContent.Name. But in my experiments, I have change the value of both InternalName and Name. The changes to InternalName didn't affect anything. Changing Name changed the name that was displayed on the shelf list. And it broke the link to the ShelfContents. No books where shown on the list. I'm beginning to suspect that murg is right and that it is a leftover from an earlier design. But maybe I'll be optimistic and say that it is planning for a future super-duper enhancement. And there is a reason for this beyond idle curiosity. |
|
08-22-2012, 11:03 PM | #7 |
Grand Sorcerer
Posts: 12,228
Karma: 74000000
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
|
When I finish the book I am on I will do a reset and change languages and see what changes.
|
08-23-2012, 12:42 AM | #8 |
Grand Sorcerer
Posts: 12,228
Karma: 74000000
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
|
I tried a factory reset (back to 1.9.6) then did setup; was not able to change language until after the setup was complete (and the upgrade done to 2.0.0 R41166, 12.07.12).
Picked German and then added a book to the Shortlist. Shelf name still shows as Shortlist. DB Dump shows Code:
INSERT INTO "Shelf" VALUES('2012-06-28T04:42:23Z','051b207e-882b-49eb-829a-a6e6bc80f6eb','Wishlist','2012-08-06T04:18:43Z','Wishlist','Custom','false','true','t rue'); INSERT INTO "Shelf" VALUES('2012-08-23T04:10:21Z',NULL,'Shortlist','2012-08-23T04:10:21Z','Shortlist',NULL,'false','true','false'); |
08-23-2012, 12:58 AM | #9 |
Grand Sorcerer
Posts: 24,906
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
That was quick reading. Or was it a short book?
While I was waiting I did try changing the language to French in the settings. It still used "Shortlist" for the shelf and in the database. But adding a book to the shortlist displayed a message in French. That makes it look like they are handling the names in code. |
08-23-2012, 01:12 AM | #10 |
Grand Sorcerer
Posts: 12,228
Karma: 74000000
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
|
I was about 1/2 through the book so just power read... and phew.... this time was still within the ADE device limit count
|
08-26-2012, 04:45 AM | #11 |
Grand Sorcerer
Posts: 24,906
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Well, I stumbled on a problem last night if the InternalName and the Name is different for a shelf. You can't delete it. Matched them up again, and they deleted with no problems
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Looking for an app with custom shelf view | jabberwock_11 | Android Devices | 5 | 08-19-2012 11:46 PM |
Library Shelf | Bronwyn | Kobo Reader | 1 | 07-31-2012 12:01 AM |
Can I change the shelf color? | wvcherrybomb | Kindle Fire | 4 | 02-22-2012 11:49 AM |
Been on the shelf for awhile so..... | d.culloch | Introduce Yourself | 2 | 10-09-2008 11:33 AM |
1 Shelf Clear, Many to Go | RWood | Lounge | 29 | 12-04-2007 10:44 AM |