Thread: Touch Shelf management on Touch
View Single Post
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: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
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 offline   Reply With Quote