09/06/2011, 01:33 AM
Hey guys, who wants to help with a real kindle sideloading solution? I've done some kindle hacking in the past, and I'm pretty familiar with wispersync, so I'd like to get a real solution going so we don't have to use the download a book and replace it method...
I am pretty decent at bash/batch scripts (use them at work all the time), and I wrote one a little while ago for sideloaded books for the kindle. It will assign each book you want a legit (enough) ASIN number so that it'll sync progress across your devices. I'd like to use that script and use it as a base for what we need to do to make sideloading on the touchpad work.
I've been browsing the kindle books database in impostah and the source for the kindle app, so I think I would make a script that would use sqlite to inject the correct values into the database to read your real books. This script would be generated when you run my original script on your PC to assign ASIN numbers to your books and extract cover art.
Is there anyone who can help me with the sqlite script? I think my original script is mostly ready to go for the first part. We need to figure out which database its keeping the files in, and then we are set. Who is in?
Here is what the current solution is at this time.
The Kindle-Import tool found on Preware, will import books in the .palmkindle folder of your TP. It will determine meta info from the title of the file so they need to be named properly. Something like one of these:
Title - Author.mobi
Title - Author - ASIN.mobi
Title - Author - ASIN - Locations.mobi
It will also import the cover art associated with these books if they are named properly and in the right place (.palmkindle/coverCache). They have the same naming scheme, but will -medium or -small at the end (ex. Title - Author - ASIN-medium.jpg). The medium cover images need to be 120x170 px, and the small need to be 52x74 px.
I have written a batch script to do this all for you found here
So here is how you do everything:
1. Deregister and then Reregister the Kindle App.
2. Install Kindle-Import from Preware
3. Restart your TP.
4. Use my script to take care of naming and cover art by extracting the .zip file into the directory where all your .MOBI/.AZW files are stored (**EDIT It does a recursive scan now**). Then run the kindleSide.bat file. Your books will be properly named and placed in a folder called .palmkindle. The cover images in a subfolder folder called coverCache. Copy these to your TP (in their respective folders).
5. Run the Kindle-Import app to load and then import your books.
6. Enjoy them in the Kindle app
You will need all the meta data and coverart set properly in Calibre for this to work right.
I've updated the script to work with .AZW files, remove :'s from the Title of books (unable to use that as a filename), and made it recursive.
That means you can stick it in your Calibre library folder and it'll scan all of the subfolders and get everything it needs.