Database Develop

[Q] Noob: Moving personal ePub files to NC Froyo on SD Card

I am running the customized Nookie Froyo 0.6.8 on a SD Card and have the Nook eReader installed. I am not sure how I move my personal ePub files - free books downloaded, no DRM - to be read on the Nook eReader. I tried to connect to my PC with a USB cable, then enabled USB on the NC. Then in Windows Explorer I tried moving the files to various directories like Nook, Nook/My Documents, My Files etc., but no matter where I put the files when I go into the Nook eReader it does not see the files (I am looking in My Files section). I even tried using Aldiko - that did not work either. Calibre says the files are transferred to the SD Card.
Any ideas? Would appreciate any help. Thanks.

Never mind I found the answer here. Interesting that you have to use ADB to push ePub files and you cannot transfer them using Calibre or Windows Explorer. I thought ADB was for programs only.
Thanks to all you guys for the fantastic job in making the NC a working Android tablet.

I use dropbox for this as well. GIven that I had updated 4 or 5 different builds and ran on SD card for each of them, it was handy to just download the dropbox.apk and have all of my personal epubs available each time.

Thats a great solution! Can you tell me where I can get more information on how to use Dropbox? I see I already have the app.

janus2000 said:
Thats a great solution! Can you tell me where I can get more information on how to use Dropbox? I see I already have the app.
Click to expand...
Click to collapse
+1 for this. Running the same config and haven't messed around with adb at all.

Disclaimer : I don't use the nook app; I use fbreader, so ymmv with this.
Anyways, the way I get epubs out of Calibre onto the nook is via the Calibre webserver. Turn it on on your pc (In Calibre, Preferences->Sharing->Sharing over the net, set up what you need, then hit the Start Server button), then access it via your nook color's web browser (make sure you use the port you set up in the url, that that port isn't blocked by a firewall, etc).
From there, you can just click to download the epubs. On mine (nookie froyo), it asks whether I want to complete the action with the browser or with fbreader. I choose fbreader and it will download it and add it to its library (if you're curious where the files get dropped, on mine it's /mnt/sdcard/Books/<ip address of my desktop>/get/EPUB).
FBReader can also talk to OPDS servers for network libraries, which the calibre web server also talks (it's just a specifically formatted) xml feed). Go into Network Library, then click the Add Catalog link. The OPDS url to use:
http colon slash slash <your server ip>:<port you setup>/opds/
(gotta love new user link protection)
The resaon I go through the nook browser instead of the network library is because the calibre web server allows actual searching. The OPDS feed doesn't allow searching (though it does allow you to get at your library through a number of different categorizations, which might be sufficient for you). Fair warning, too, that since I haven't used OPDS much, there may be something I'm missing about it.

Thanks very much for the detailed response. Just got back in town - will try it this weekend.

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] Saving Files On Nook

I have just bought a Nook Color and slapped CM7 on it (very nice BTW). I would like to transfer files from my desktop to my Nook so they can be accessed at any time even when not on Wi-Fi.
At times of Wi-Fi, I can always use Dropbox, but how can I get them to stay on the Nook to be accessed whenver.
These files would usually be PDF, Excel, Word, other office type files.
Thanks.

Just use a micro SD card, I'm pretty sure cm7 requires one anyway, so there is no reason to have one.
Also, you can download files ffrom dropbox to your SD card for offline storage through the app itself
Sent from my B&N Nook Color

You can drag and drop the files when your Power cable USB is plugged into your PC.
You just need to open your NC notification bar - when it's plugged in - so your PC recognizes the device.

Sorry for the noob questions, but how would I open those files? Would I need to use a specific app? or will CM7 automatically open them?

If you long press on files in the dropbox app it gives you the choice to save them. They save to sdcard/dropbox. How they open depends on the file type. The nook can open several different kinds of files natively and you can download apps from the market to open anything that it won't. As for the actual process of opening files I usually use my file manager to navigate to the file I want to open and click on it. The nook will either open the file (if only one app handles that file type), ask which app I want to use to open the file, or nothing happens which means I have no app installed that can open that file type.
For office type files I suggest getting ezPDF free from the market and paying for Documents To Go. That way you can edit the MS Office stuff if you need to. RTFs suck. The only thing I know that will open them is the ebook app Cool Reader.
I hope this helps. We all started out as noobs.

also a noob here. i had copied the files to the nook already. so how do i access them now? i can't seem to get my way into this.
thanks!

To access your files use a file explorer such as root explorer.

nook-color said:
You can drag and drop the files when your Power cable USB is plugged into your PC.
You just need to open your NC notification bar - when it's plugged in - so your PC recognizes the device.
Click to expand...
Click to collapse
Palm to forhead... I was missing the notification bar part. Couldn't figure out why I couldn't access any files on the Nook from my PC. Now I just need to figure out if there is a default directory where I am supposed to put music and movies on the microSD card.

mogators1 said:
Palm to forhead... I was missing the notification bar part. Couldn't figure out why I couldn't access any files on the Nook from my PC. Now I just need to figure out if there is a default directory where I am supposed to put music and movies on the microSD card.
Click to expand...
Click to collapse
No default place for music and movies but it would be simplest to just make a folder called music and one called movies just so that they are easier for you to f/nd.
Sent from my NookColor using Tapatalk

[Q] File storage and computer connection

I apologize if these questions have already been answered but I didn't see them in any Nook HD+ forum/thread.
1) I downloaded some books from B&N prior to rooting the Nook. I then rooted the Nook HD+ and I can still read the books thru the default reader but I can't seem to locate them in any folder. I tried two different file viewers from Google Play and can't seem to find them anywhere. Does anybody have an idea of where they could be stored? I know they are stored locally somewhere since I have WiFi turned off. My reason for asking is I would like to access them from the new launcher (using another reader) rather then going to the B&N home page.
2) My next question involves connecting to my desktop. I use openSUSE and run WinXP in an Openbox VM. Whether in Linux or using WinXP in VM I can't access the folders on Nook. I was able to get the drivers working to use ADB (in the WinXP VM only), but I can't get any folders to show up in a file manager. Well, I actually get one folder to show up, called "NOOK", but it has very limited storage. I tried this with both developer mode on Nook turned on and off. I can transfer files to Nook (and see personal folders) when using Win Media player and Nook set to MTP, but I can't see any folders with a file manager. Any idea on what is going on? BTW, it would be nice if I could see everything from Linux without having to use WinXP.
Thanks for any help. Also, many, many thanks to Someone0 for the simple root instructions. Much better use of the Nook HD with general Android apps available.
Rich

B&N books are stored at /data/nookmedia/B&N Downloads/Books

Thanks
lkmiller said:
B&N books are stored at /data/nookmedia/B&N Downloads/Books
Click to expand...
Click to collapse
Thanks...that helps. Wonder what the purpose of the /sdcard/B&N Downloads directory is. Very confusing.

rfmhunt1 said:
Thanks...that helps. Wonder what the purpose of the /sdcard/B&N Downloads directory is. Very confusing.
Click to expand...
Click to collapse
No clue...the external sd card also gets a B&N Downloads folder.

FBReader for Nook Simple Touch

I have rooted my NST with NookManager, but i had problems with Aldiko and another apps and finally I use FBReader, it`s good and useful. The problem is, when I send a ebook to my NST, the app does not recognizes the internal fonts of the ebook, but the style of the ebook still. I want to know how I can use the fonts who come with the ebook.I want use the publisher defaults of a ebook. For Example, Harry Potter books use 2 differents fonts and bring with his own default publisher.
The fonts is not essentials to read, but... It´s a thing in the default reader takes andvantage.
Regards.:laugh:

kurono93 said:
I have rooted my NST with NookManager, but i had problems with Aldiko and another apps and finally I use FBReader, it`s good and useful. The problem is, when I send a ebook to my NST, the app does not recognizes the internal fonts of the ebook, but the style of the ebook still. I want to know how I can use the fonts who come with the ebook.I want use the publisher defaults of a ebook. For Example, Harry Potter books use 2 differents fonts and bring with his own default publisher.
The fonts is not essentials to read, but... It´s a thing in the default reader takes andvantage.
Regards.:laugh:
Click to expand...
Click to collapse
So...
What, in clear words, is it that you want?

thenookieforlife3 said:
So...
What, in clear words, is it that you want?
Click to expand...
Click to collapse
Thanks for your answer. I want the default publisher format when i am reading in my NST but with FBReader.

kurono93 said:
Thanks for your answer. I want the default publisher format when i am reading in my NST but with FBReader.
Click to expand...
Click to collapse
Hmmm. It's a good idea, but truth be told, I don't think it's possible. Unless, of course, someone took your APK and edited the file itself, I don't think there's another way to do it.
And that type of .apk editing is a bit beyond my league, in case you were wondering. I can do icons, but still have yet to learn how to edit how the apps actually work. :laugh: