Database Develop

[Q] Noob 0.6.7 questions

Hello,
The Nook Color is my first Android device and so far I love it. I am booting .0.6.7 from an sd and I have a couple of questions I hope can be answered.
1. I got the Kindle app, but I cannot find it's menu (to buy from amazon or change font etc.). I have tried uninstalling and reinstalling, but all I can do so far is read the free books it came with.
2. How do I get ebooks onto the Nooks internal memory? I have an epub file in internal memory (under my files) that I could read with the stock reader, but the nook app and the kindle app does not list it.
Thanks in advance, I am trying to read and learn as much as I can, but it is a little overwhelming!

xenuprime said:
1. I got the Kindle app, but I cannot find it's menu (to buy from amazon or change font etc.). I have tried uninstalling and reinstalling, but all I can do so far is read the free books it came with.
Click to expand...
Click to collapse
1. Use soft keys to bring up the row of virtual buttons. To bring up soft keys you need to either do a single or double tap on your nook button. It just depends on your configuration.
2. Select the menu button.
3. Select either Archived Items or Kindle Store.
Hope this helps with at least the first part of your issue.

Thanks a lot!
Where are the archived files from? It wants me to connect to the internet when I press it and I don't have a signal right now.
When I plug the nook (or just the sd card) into my computer how do I add books to it?

xenuprime said:
Thanks a lot!
Where are the archived files from? It wants me to connect to the internet when I press it and I don't have a signal right now.
When I plug the nook (or just the sd card) into my computer how do I add books to it?
Click to expand...
Click to collapse
Archived files would be books that you've already purchased from Amazon that have not been downloaded to your device. Your nook would need an Internet connection to access those files (if you have any) as they are stored on Amazon's servers.
I'm not sure about the answer to your second question just yet. If I figure it out I'll let you know.

I appreciate the help. I am trying to get used to the menus and the way androis works.
What I did figure out is:
1.Take out the sd card and load files (epub, movies, etc)onto the stock Nook.
2.Put the sd card back in, boot up froyo, then use astro to transfer files back and forth between the internal and sd.

I recommend Aldiko for reading your own EPUBs and PDFs. It has a file browser so you can simply browse to wherever and import them. Also it supports Adobe DRM so you can download Library eBooks straight from their sites.
____________________________________________________
Sent from Nookie Froyo using Tapatalk

That sounds a lot easier than my workaround. I will try it tonight!
Speaking of library access, I heard the Philadelphia library sells memberships to anyone for $15 a year.

xenuprime said:
That sounds a lot easier than my workaround. I will try it tonight!
Speaking of library access, I heard the Philadelphia library sells memberships to anyone for $15 a year.
Click to expand...
Click to collapse
WTF??? They make you pay??? My library is free and gives me access to online Audiobook/eBook loaning. Some of the other Libraries in it's network make you pay for things like DVD loans but I can understand that. But $15 for a Membership, that sortof defeats the purpose of a Library. I heard Philly was seriously cutting back on their Library budget (even closing a few) but Paid Membership? What's this world coming too?
____________________________________________________
Sent from Nookie Froyo using Tapatalk

I should have clarrified. If you are out of state you have to pay the $15 fee.

xenuprime said:
I should have clarrified. If you are out of state you have to pay the $15 fee.
Click to expand...
Click to collapse
Oohhh... Ok that makes more sense. Sorry about going off the wall a bit.
____________________________________________________
Sent from Nookie Froyo using Tapatalk

Help - Amazon App Won't Sync

I have the Customized Nookie Froyo found here: http://forum.xda-developers.com/showthread.php?t=922324
I downloaded Amazon's Kindle app and it won't sync with a free book I tried to get. I uninstalled, rebooted and reinstalled the app figuring it was worth a shot but that didn't work.
All the other apps I've tried appear to be working correctly.
Any suggestions/help greatly appreciated. Thanks in advance.

amstarshine said:
I have the Customized Nookie Froyo found here: http://forum.xda-developers.com/showthread.php?t=922324
I downloaded Amazon's Kindle app and it won't sync with a free book I tried to get. I uninstalled, rebooted and reinstalled the app figuring it was worth a shot but that didn't work.
All the other apps I've tried appear to be working correctly.
Any suggestions/help greatly appreciated. Thanks in advance.
Click to expand...
Click to collapse
Do you have an SD card inserted? I noticed I can't get Kindle to sync or download books if the SD is unmounted or if there isn't one. The App must download books to SD instead of internal memory (kind of annoying considering how tiny books are...going to try tricking it into downloading to internal by creating a symlink)

Yes, the SD is inserted. The OS is running off the SD card and there appears to be plenty of memory. I'll have to double check that when I get home though.

I had a similar problem to this. Sync would not bring up my books. Then in the menu I found "Archived items" and all of my books were there then I was able to (re)download them and that brought hem into the main section in the Kindle app.

This is going to sound silly but how do you get in the menu? I don't see a menu or info button of any sort on the main Kindle screen. I'm sure it's probably really obvious and I will kick myself for not seeing it.
ETA: I just switched the Kindle app from the unit to the SD card and tried to send a (free) book to my NC again. It gave a sync error message and told me to try again later.
2nd Edit: I'm such a dork today. I found the menu. *smacks self V8 style*

I rebooted my NC and tried to sync again. This time it at least recognized the book but still wouldn't download. I'm on the wi-fi at work so I'll try this again when I get home where I have more control over the amount of bandwidth available.
ETA: I don't want to bump the thread but I do want to leave a note about the fix that finally worked in case others have this problem.
Go into settings>applications>manage applications>downloaded
Select Amazon Kindle
Under Data select move to SD card
Reboot
Open the Kindle App and it should sync after that.

Im having a problem syncing the Amazon App store to my nook table. i had my nook rooted and it was synced but i procrastinated and didnt put titanium on it and stop the OTA so i had to fix it. now everything is back to what it was but i cant get Amazon to sync this time. Is there something that i did to mess it up and can i fix it?

Sync Nook books with Android

I have a few epub books I side-loaded onto my NC but they are not showing up on the B&N "My Nook Library," section of my online account management which means they are also unavailable on my android phone. Is there a way (a specific location to move them to on the Nook) to get them to sync? I don;t do a lot of reading from my phone, but it'd be nice to pick up where I left off for a few minutes when i have time.

Anybody?
.

AFAIK, side loaded books do not sync.

Kayak83 said:
I have a few epub books I side-loaded onto my NC but they are not showing up on the B&N "My Nook Library," section of my online account management which means they are also unavailable on my android phone. Is there a way (a specific location to move them to on the Nook) to get them to sync? I don;t do a lot of reading from my phone, but it'd be nice to pick up where I left off for a few minutes when i have time.
Click to expand...
Click to collapse
You could sync the Files with Dropbox... but you wont be able to sync your place in the books if that is what you are looking for.

therealguppy said:
You could sync the Files with Dropbox... but you wont be able to sync your place in the books if that is what you are looking for.
Click to expand...
Click to collapse
...with some creativity it might be possibe to use Dropbox and a few symlinks in the appropriate data folders to sync places (..assuming android supports symlinks like other linux/unix os's... )

Side loaded books won't sync with the Nook. They will sync with the Kindle app if you're willing to do some hacking.

Get aldiko in the market. It reads epub and pdf protected books. I normally have to open the file in astro or similar for aldiko to see.
If possible just download to ur nc and skip the sideloading.

What do you mean by sync? Are you expecting sideloaded books to get pushed up to B&N and pulled down to other nook readers?
If you can't see your sideloaded books in Nook-Android on HC, go here:
http://forum.xda-developers.com/showthread.php?t=966339&highlight=can't+books

MNMichael said:
What do you mean by sync? Are you expecting sideloaded books to get pushed up to B&N and pulled down to other nook readers?
Click to expand...
Click to collapse
Yes, actually. But I can see why B&N doesn't allow it.

jaybert45 said:
Get aldiko in the market. It reads epub and pdf protected books. I normally have to open the file in astro or similar for aldiko to see.
Click to expand...
Click to collapse
I also use Aldiko in the Rooted NC to read epub books. FBReader is also a good alternative.

Nook android app and sideloaded epub

Anyone know how to get the nook android app to show the covers for epubs? Only downside of going cm7 vs stock eclair.

I just found a way
You need the book ID that the Nook app uses to identify each book.
This can be found inside the nook.db SQLite database used by the Nook app, look at the "ean" field inside "products" table. The easiest way to find it is by using the SQLite editor app from the Market.
Each ean should be a string of 64 chars, like this:
686B5DF3A725532E508C8A4741166F748F7419C0801FC0B638B6F5C246244AD3
Now you just have to put the cover and its thumbnail inside /sdcard/Nook/Images, in PNG format and using names like:
686B5DF3A725532E508C8A4741166F748F7419C0801FC0B638B6F5C246244AD3_thumb.png
and
686B5DF3A725532E508C8A4741166F748F7419C0801FC0B638B6F5C246244AD3_cover.png
Hope this helps.

I created an app and placed it in the market call "Nook Book Cover Helper", which pulls the title and ean numbers from the database and displays them or allows you to export them to a text file. It's a little simpler then searching with sqlite.

I get library sync errors whenever I do this mod. The covers show up OK, but whenever I go in or out of the application, I eventually start getting the errors.
I tried with both _thumb and _cover pngs and with just _cover or just _thumb files. It seems that either way works. I eventually wind up clearing data (which changes all the EAN #s and messes up the covers again).
I tried just doing one cover and about a dozen (out of about 18 sideloaded books). They are all EPUB books. I did notice that the EAN #s are longer for sideloaded books than for books purchased from B&N.
Anybody else seeing this issue?

keyodi said:
I created an app and placed it in the market call "Nook Book Cover Helper", which pulls the title and ean numbers from the database and displays them or allows you to export them to a text file. It's a little simpler then searching with sqlite.
Click to expand...
Click to collapse
keyodi, thanks so much for releasing this. Finally I'm able to see images in the library! The process is still cumbersome, for which I blame BN. I copied each EAN code compiled by the apk, pasted the data as the new name for the cover image in each folder created by Calibre, copied all image files, and pasted them into the image directory. After futzing around for a while, everything synced up just great. I noticed that when I had to make some minor modifications to some of the epub files (for example, changing some metadata), I had to create the image files all over again. I'm very grateful to keyodi for creating the Nook Book Cover Helper, but completely annoyed with BN for making the process that difficult. Let's hope the Nook app will get updated someday.

Unfortunately, the ean numbers will get recreated if the epub is modified in any way or if you clear the data. I guess it's just another way for BN to force you to buy books from them
DiDGR8, what errors do you get? Force closes on the Nook app? Do you have latest Nook app installed?

keyodi said:
DiDGR8, what errors do you get? Force closes on the Nook app? Do you have latest Nook app installed?
Click to expand...
Click to collapse
The app is up-to-date and does not force close. I get a error dialog stating that an error has occurred while synchronizing library contents. The dialog is occasionally continuous until I close the app. I didn't do problem isolation on the wifi (it may or may not occur with wifi off). When the error is not continuous, the book listing resets to a new order (books sort around in a different order and my most recently read book is no longer the first one listed).
It's annoying but not serious, but I don't value the book covers enough to put up with the hassle of figuring out the new EANs or putting up with the errors so I go back to "generic" covers. No biggie.

keyodi said:
I created an app and placed it in the market call "Nook Book Cover Helper", which pulls the title and ean numbers from the database and displays them or allows you to export them to a text file. It's a little simpler then searching with sqlite.
Click to expand...
Click to collapse
Wow, that's nice.
If you feel like doing some more programming, you could try to automatically extract the cover from the epub files and adding it to the library.
You could search epubs (which are just zip archives) for a file called cover.*, convert it to PNG if needed and put it in Nook library with the right name. This should work with a lot of epubs (e.g. those converted with Calibre).
I know it involves much more work than just extracting the names but...

met67 said:
Wow, that's nice.
If you feel like doing some more programming, you could try to automatically extract the cover from the epub files and adding it to the library.
You could search epubs (which are just zip archives) for a file called cover.*, convert it to PNG if needed and put it in Nook library with the right name. This should work with a lot of epubs (e.g. those converted with Calibre).
I know it involves much more work than just extracting the names but...
Click to expand...
Click to collapse
I was able to extract the cover images from the epub, so I may publish the updated app today or tomorrow.
Edit: Updated app on market

Keyodi, thank you for the updated app. For some reason, I get a "no database found" message when I try to scan my nook folder. It was working fine before but now I can't get it to work. I tried rebooting but that didn't help. The books still show up in the Nook app, though. Any ideas?

If you receive the "No database found" message, then the app was unable to connect to the db. Can you verify that the locker.db exists under /data/data/bn.ereader/databases/?
You can also try clearing data on the nook app (Application Setting/Manage settings), but it will require you to log in again and re-download your books and cover images.
I also updated the app to 1.5.1, which fixed a couple of bugs, so maybe this version will fix your issues.

keyodi said:
If you receive the "No database found" message, then the app was unable to connect to the db. Can you verify that the locker.db exists under /data/data/bn.ereader/databases/?
You can also try clearing data on the nook app (Application Setting/Manage settings), but it will require you to log in again and re-download your books and cover images.
I also updated the app to 1.5.1, which fixed a couple of bugs, so maybe this version will fix your issues.
Click to expand...
Click to collapse
The bug fix alone did the trick. This updated version is fantastic. I can't thank you enough!

keyodi said:
I was able to extract the cover images from the epub, so I may publish the updated app today or tomorrow.
Edit: Updated app on market
Click to expand...
Click to collapse
I get a blank screen; after the intro page, the header and status bar are there, and menu pops up an "Export" button, and back works, but no books are listed; there should be dozens.
I have some leftover epubs in my /emmc from before I installed CM7; would that confuse things?

Are your books showing up under my files? The blank page just means no epubs were found in the db. I probably should display that message instead of a blank page.
You can try a couple of things:
-Press refresh in the NOOK app
-upload the locker.db, so I can take a look at it
-Rename the locker.db to lockerbk.db under /data/data/bn.ereader/databases/ and launch the nook app

keyodi said:
Are your books showing up under my files?
Click to expand...
Click to collapse
After much screwing around, I find that /sdcard/Nook/Content appears to contain my B&N-bought .epubs, with names like "12345678901234567890_Title.epub". Damn, that makes them hard to browse. I won't attempt to correlate the numbers with some field in a database. There are also InfoJson_12345... files as well; these appear to be tables of contents. /sdcard/Nook/Images appears to contain covers and thumbnails (named 1234_thumb.png or 1234_cover.png) for books both downloaded and viewed on the "Shop" page. Lots more thumbnails than covers, but covers are for both downloaded and inspected (I looked at the details) books.
The blank page just means no epubs were found in the db. I probably should display that message instead of a blank page.
Click to expand...
Click to collapse
Updated the app; I now get the "No epubs found..." message. I feel better already! However, the db has 200+ entries, so something is still amiss.
You can try a couple of things:
Click to expand...
Click to collapse
I reordered your suggestions to make me feel better...
-Press refresh in the NOOK app
Click to expand...
Click to collapse
No change.
-Rename the locker.db to lockerbk.db under /data/data/bn.ereader/databases/ and launch the nook app
Click to expand...
Click to collapse
Had to sign in, took for-bloody-ever while "Syncing Library". Still no change.
-upload the locker.db, so I can take a look at it
Click to expand...
Click to collapse
Attached (I hope). The rebuilt one is slightly larger than the original; the new one is attached. Should I change my B&N password now?

I don't see the locker.db attached.

keyodi said:
I don't see the locker.db attached.
Click to expand...
Click to collapse
Damn. Let me try again.
I do have another question, though: my numbers look to be in a different format than those discussed earlier in this thread, and 1234_cover.png files that do exist are not displayed by the Nook app. This seems like a bad thing...

The db doesn't list any side-loaded epubs. Are all your epubs located in /Nook/MyDocuments folder on the sd card?

keyodi said:
The db doesn't list any side-loaded epubs. Are all your epubs located in /Nook/MyDocuments folder on the sd card?
Click to expand...
Click to collapse
My B&N-bought stuff is all in /sdcard/Nook/Content; I've been using eReader and aldiko for side-loaded content. Aldiko appears to import into /sdcard/eBooks.
I haven't tried to use the Nook app to read sideloaded books, I was under the impression that it didn't work. Can you point me to a clue? Do you just drop the .epubs in /sdcard/Nook/Content?
sigh
Thanks!

The nook app can read sided-load epubs, but you have to place them in sdcard/Nook/MyDocuments. Try copying one or two epubs from the /sdcard/eBooks folder into sdcard/Nook/MyDocuments.

[Q] Updated B&N application not downloading??

I have CM7 on rooted nook. Last night my B&N application was acting funny, so I went to the new market, uninstalled the new market updates, then went back to the old market, found the B&N update and installed it. Now my previously purchased books can't download, says there is an error. Anyone experiencing this problem? Does it have to do with the new B&N application not recognizing the device? Also on the Application, I can't get to its settings or help tab, in order to check for the sd card assignment. I tap and tap, and nothing. I can tap on the books but get the errors and can't download come.

The Nook app changed names, that generally means that you have to erase data or even uninstall/reinstall.
I cleared data and all is well.
Sent from my NookColor using xda premium

Depending on how old your app was you have to sign out and then sign in and reload your books all over again.