K4 Mac or PC Kindle for PC Database

[Bluez]

Hi,

This is a cry for help from someone who knows SQLite.

I've been playing around with the database for Kindle for PC, since it would be much quicker to import my books' database than to manually add them all to collections and got quite stuck .

The database is in SQLite, so I've been using SQLite Database Browser.
I can see the tables and manipulate them in SQLite, save them but when I open up the Kindle for PC app, the edited files are removed from the collection, but it does not show up in the other collection.

Since I'm new to databases, I'm not quite sure if I'm doing something wrong.
Also, I just have the Kindle Apps, not an actual Kindle (I use my HTC Flyer to read).

Anby help would be greatly appreciated.

[nynaevelan]

Where did you find the k4pc database? What is it named?

[Mike L]

Yes, I'd like to know that as well.

[Bluez]

The database is located under:
C:\Users\UserName\AppData\Local\Amazon\Kindle\Cach e\db
There are two databases:
- sockeye.dat
- steelhead.dat
I've been using the sockeye.dat to try and manipulate the database.
It only seems to contain the collection databases.

[nynaevelan]

I am a newbie at this but I am very good at following instructions, have you figured out a way to re-order the way the collections show up? I see the ordinal number but I do not see a way to edit these numbers to change them to what you wish them to be.

Nyn

[Mike L]

Originally Posted by Bluez

The database is located under: ....

Got it. Thanks.

For the benefit of XP users, the equivalent path seems to be:

C:\Documents and Settings\<user name>\Local Settings\Application Data\Amazon\Kindle For PC\Cache\db

I can see lots of files in SQLLite format, but haven't got any further yet.

[Rebecca_06]

Anybody making any progress with this? I'm on OS X, and for me, the database appears to be in:

User\Library\Application Support\Kindle\Cache\Db

The sockeye.dat certainly seems to be the one that updates after I modify my collections (I've been fiddling around with it, after backing it up, of course). I'm particularly interested in finding away to import the content from the json file generated by the Kindle Collections plugin (which is discussed a bit here) but I haven't been able to make it work yet, probably because I don't know what I'm doing.

[nynaevelan]

Originally Posted by Rebecca_06

Anybody making any progress with this? I'm on OS X, and for me, the database appears to be in:



The sockeye.dat certainly seems to be the one that updates after I modify my collections (I've been fiddling around with it, after backing it up, of course). I'm particularly interested in finding away to import the content from the json file generated by the Kindle Collections plugin (which is discussed a bit here) but I haven't been able to make it work yet, probably because I don't know what I'm doing.

Same here and so far all I wanted to do was to put my collections in alpha order. I changed the ordinal number on them but when I open k4pc they are in the same order although they do show as changed in the db.