Originally Posted by ApokrifX

I use virtual CC from CITI with $1 limit…
I suggested very same thing early.
And I have very same feeling met67 has: they don’t care about side-loaded books, might be even make thing harder on purpose.

It still might be worth a try to see if we can get them to fix it.

Originally Posted by GabrialDestruir

It still might be worth a try to see if we can get them to fix it.

I'm not against it

BTW: Wanna throw in an idea:
It was/is a thread about "Automating shelving" http://forum.xda-developers.com/show....php?t=1378510

It’s piece of cake to with very same insert trigger, the shelves are in same internal.db

---------- Post added at 04:43 AM ---------- Previous post was at 04:14 AM ----------

Started working on it and realized, met67 was talking about bookmarks, but I meant annotations. (annotations.db)
I have tons of annotations, plagued by same bug: some have ean, some filepath…
And I kept wondering, I did put a note here, where the heck did it go?
And then they showed up all of the sudden and then disappeared same way.
Crap…

So fix script should be smth. like this:
Update bookmarks.db and annotations.db - replace ean with filepath (lookup in internal.db)
Than clear ean in internal.db.
Any comments?

Originally Posted by ApokrifX

...
BTW: How do you fiddle with databases such as internal.db?
Use adb to pull/push and fiddle on PC, or use adb shell to do it on nook?
...

Both, actually.
I use SQLiteStudio to browse data and definitions, and a copy of sqllite3 found on this forum to modify the DB on the device via adb shell

Originally Posted by ApokrifX

...
BTW: Wanna throw in an idea:
It was/is a thread about "Automating shelving" http://forum.xda-developers.com/show....php?t=1378510

It’s piece of cake to with very same insert trigger, the shelves are in same internal.db
...

Yes, I also thought about this, but having tried the "Automatic shelving" (with a script) for a while, I found that shelves tend to be too much slow and I am not sure it is worth the effort (IMO, of course).

Originally Posted by ApokrifX

So fix script should be smth. like this:
Update bookmarks.db and annotations.db - replace ean with filepath (lookup in internal.db)
Than clear ean in internal.db.
Any comments?

Yes, I think this should work. I just erased bookmarks and annotation related to ean, since I don't have much of them.

Originally Posted by met67

Both, actually.
I use SQLiteStudio to browse data and definitions, and a copy of sqllite3 found on this forum to modify the DB on the device via adb shell

I.e. you don't have sqllite apk installed on Nook.
I thought, it'll be a bit easier...

---------- Post added at 07:35 PM ---------- Previous post was at 07:31 PM ----------

Originally Posted by met67

Yes, I also thought about this, but having tried the "Automatic shelving" (with a script) for a while, I found that shelves tend to be too much slow and I am not sure it is worth the effort (IMO, of course).

If you have many books, it’s real PiA to scroll to find the one you need. Or it’s just me?

Originally Posted by met67

Yes, I think this should work. I just erased bookmarks and annotation related to ean, since I don't have much of them.

Ok. I’ll work on scripts and post them here.

Tried to submit bug report to B&N - apparently it’s was done 09-15-2011 05:10 PM already.
http://bookclubs.barnesandnoble.com/...s/td-p/1081244
If you follow thread – only first bug was forwarded by Admin to developers.

Read last post: “I can't begin to describe my frustration that this was not fixed in the last update…“
That’s about it - thread looks abandoned - there is no use to post there.

I can add - for a developer it should take from 15 min to 1 hour to fix such a bug.
IMO, of course...

BTW: Anybody seen a NST firmware release report with all fixed and not bugs, as other companies do (Cisco, Juniper, etc.)?
Although, it’s probably done for different market segments, definitely not for “personal customer” one.

Originally Posted by ApokrifX

I.e. you don't have sqllite apk installed on Nook.
I thought, it'll be a bit easier...

If you mean SQLite Editor, yes, I have it on the Nook, but is a bit hard to use (scrolling tends to behave errantly).

Originally Posted by ApokrifX

If you have many books, it’s real PiA to scroll to find the one you need. Or it’s just me?

Yes, but, at least for me, having a shelf for each author is an even worst PiA.
ATM I have 326 book in My Library in 55 pages.
If I use a shelf for each author, I have 139 shelves in 70 pages!

Reading through this the issue seems to be something somewhere is applying ean in some places and filepath in another. While an initial script to change it all to one or another would be beneficial we really need to find where it's assigning either or both of those values so that we can try and modify the code to remove either ean or filepath from being assigned.

The second thing and more related to automatic shelving than to broken bookmarks is if we could find and disable the code that for some reasons says when new books get added, shelves get emptied out and/or deleted.

---------- Post added at 08:45 AM ---------- Previous post was at 08:40 AM ----------

Originally Posted by met67

If you mean SQLite Editor, yes, I have it on the Nook, but is a bit hard to use (scrolling tends to behave errantly).



Yes, but, at least for me, having a shelf for each author is an even worst PiA.
ATM I have 326 book in My Library in 55 pages.
If I use a shelf for each author, I have 139 shelves in 70 pages!

I personally think that arranging books by series (not author or some other method) would make it easier, or at the very least by Read/Unread/Reading then you could collapse a shelf you're not looking through and have less books.

Originally Posted by GabrialDestruir

Reading through this the issue seems to be something somewhere is applying ean in some places and filepath in another. While an initial script to change it all to one or another would be beneficial we really need to find where it's assigning either or both of those values so that we can try and modify the code to remove either ean or filepath from being assigned.

Since it is very same reader app, I’d guess, it is started with different arguments from “last book” and from library.
“ps -ef”, “ps -x” supposed to show full command line (i.e. app + arguments), but it doesn’t...
Anyway to see full command line to prove?

---------- Post added at 04:21 AM ---------- Previous post was at 04:11 AM ----------

Originally Posted by GabrialDestruir

>ATM I have 326 book in My Library in 55 pages.
>If I use a shelf for each author, I have 139 shelves in 70 pages!
I personally think that arranging books by series (not author or some other method) would make it easier, or at the very least by Read/Unread/Reading then you could collapse a shelf you're not looking through and have less books.

I didn’t think about that many books…
I’d say, multi-level shelves might be the way to go - first by series, than by author, etc.
Although, if I think a little bit, anyway I organize it, won’t be necessarily good for somebody else.

It shouldn’t be shelves, but some sort of filtering/drill-down built in into library:
I select 1st criteria (any metadata field, like series, [optionally, with wildcard]), then filter by 2nd (author), etc.

…Sorry, got carried away

---------- Post added at 04:26 AM ---------- Previous post was at 04:21 AM ----------

Originally Posted by met67

If you mean SQLite Editor, yes, I have it on the Nook, but is a bit hard to use (scrolling tends to behave errantly).

I meant command line only (on nook).
To use GUI on PC to develop/debug scripts, then exec on nook via command line sqlite.

Originally Posted by ApokrifX

I meant command line only (on nook).
To use GUI on PC to develop/debug scripts, then exec on nook via command line sqlite.

As I was saying, I use a copy of sqlite3 found on this forum to exec SQL commands on nook. It is not an apk, just a simple executable: place it in a suitable place (e.g. /bin), chmod +x it and have fun