Desktop App Kobo annotation exporter - Page 2

davidfor · 05-29-2016, 12:46 AM

Quote:

Originally Posted by Toxaris

Frankly, I wouldn't know. In the program there is no variable startIndex. Can you tell me what you tried that gave this error? Can you see the books at all when you select the Kobo reader?

I would need the .kobo directory of your reader to see what is going on. That way I would be able to simulate the activity.

Since this is the second report about this (the other about a Kobo HD) I suspect Kobo changed something.

I saw the other post last night and did a little experimenting. I am seeing the same error with my Glo HD and Aura H2O. Both have over 2000 books on the. For the Touch and Glo, the list of books with annotations is displayed with not problems. These have about 150 and 40 books respectively.

For me, the error happens when I hit the "Reload" button.

Could it be the number of books? I am seeing the same error with my Glo HD and Aura H2O. But, for the Touch and Glo, the list of books with annotations is displayed with no problems. I can see two differences.

The Glo HD and the Aura H2O are both on firmware 3.19.5761 but the Touch and Glo are still on 3.19.5613. But, there are no database changes between the two versions. And I cannot see any difference in how the data is stored in the Bookmarks table.

The other difference is the number of book. The Glo HD and Aura H2O are both have over 2000 books on them. The Touch and Glo have about 150 and 40 books respectively. I can see the possibility of this causing a problem, but it happens as soon as I hit the "Reload" button. If it was a number of books problem, I would normally expect it to happen after some time.

Toxaris · 05-29-2016, 02:02 AM

The number of books should not be a problem, it is not that much data actually. Since there is a difference in firmware I suspect Kobo did make a change, perhaps not in the database, but on another level. Can you sent me the .kobo directory? I don't need the books of course. That way I can emulate a Kobo and do some testing.

davidfor · 05-29-2016, 04:41 AM

Quote:

Originally Posted by Toxaris

The number of books should not be a problem, it is not that much data actually. Since there is a difference in firmware I suspect Kobo did make a change, perhaps not in the database, but on another level. Can you sent me the .kobo directory? I don't need the books of course. That way I can emulate a Kobo and do some testing.

Unfortunately for that theory, I upgraded both the Glo and Touch to 3.19.5761. Both work fine. I examine the database carefully with each firmware release to see what has changed. Nothing has for the last couple. And I haven't needed to change the Annotations plugin for this.

What are you looking at other than the database? For the initial list, I can't think of anything else you need to look at. This should just be a select joining the contents table with Bookmarks.

Toxaris · 05-29-2016, 09:17 AM

Quote:

Originally Posted by davidfor

Unfortunately for that theory, I upgraded both the Glo and Touch to 3.19.5761. Both work fine. I examine the database carefully with each firmware release to see what has changed. Nothing has for the last couple. And I haven't needed to change the Annotations plugin for this.

What are you looking at other than the database? For the initial list, I can't think of anything else you need to look at. This should just be a select joining the contents table with Bookmarks.

There is more to it than that. The database is of course the major part, but not the only one. Especially since it fails at the 'reload' action seems to indicate that the error occurs before the database is read. Like I said, I need a copy of the .kobo directory to try to emulate and solve this.

Koboyashi · 05-29-2016, 03:10 PM

Nice Tool. Runs flawlessly on Win7Pro x64 and Kobo Glo, Firmware 2.6.35.3 (yessir

).

But the App Icon with this white background ... I attached a slightly changed Icon
(.ico, .png, .psd) - maybe you like it.

Edit: 1st post has version 1, on your site: version 1.1.1.

davidfor · 05-30-2016, 08:12 AM

Quote:

Originally Posted by Toxaris

There is more to it than that. The database is of course the major part, but not the only one. Especially since it fails at the 'reload' action seems to indicate that the error occurs before the database is read. Like I said, I need a copy of the .kobo directory to try to emulate and solve this.

I have to take back the comment about how long it takes for the error after pressing reload. I cleaned up the Aura HD a bit. Then I connected and ran the the annotations exporter. This time it was about ten seconds before the error was displayed. But, if I hit reload again, it was displayed immediately. The same happen with the Glo HD.

The application also doesn't display its window if these devices are connected when I start it. I can see it in the task list, then it disappears with no error or anything displayed.

What are you actually looking at in the .kobo directory? If I give you that, I'm giving you over 600MB of stuff. Of course, there isn't any point in looking at most of that. Other than the database, only the version file makes sense. The device.salt.conf might makes sense if you have worked out how to use that to decrypt something. But, you wouldn't need that until you actually tried to read a DRM protected kepub. The affiliate.conf also doesn't have anything of interest. The Kobo eReader.conf, might makes sense, but there isn't anything in it related to the annotations. Except maybe the locale settings.

Toxaris · 05-31-2016, 05:05 AM

I checked the code again and indeed there is nothing called startIndex. I am mostly interested in the database of course. Can you tell me the exact name and location of the database? As far as I know, it should be .kobo/KoboReader.sqlite. Is that correct?
It might be possible to recreate the error with just the database, but I am not sure. What is the name of the readerdrive when you attach it to your computer?

Toxaris · 05-31-2016, 05:07 AM

Quote:

Originally Posted by Koboyashi

Nice Tool. Runs flawlessly on Win7Pro x64 and Kobo Glo, Firmware 2.6.35.3 (yessir

).

But the App Icon with this white background ... I attached a slightly changed Icon
(.ico, .png, .psd) - maybe you like it.

Edit: 1st post has version 1, on your site: version 1.1.1.

I know, I haven't updated the first post. The latest version is always on my site. I will fix the first post.

I will take a look at your version of the icon. The background should be transparent, at least it is on my pc.

tshering · 05-31-2016, 05:32 AM

Quote:

Originally Posted by Toxaris

I checked the code again and indeed there is nothing called startIndex.

What about ObjectListView.dll?

latepaul · 05-31-2016, 06:28 AM

A little googling on the error message suggests that startIndex is not a variable in your code but the name of a parameter to a method, probably SubString.

davidfor · 05-31-2016, 07:41 AM

Quote:

Originally Posted by Toxaris

I checked the code again and indeed there is nothing called startIndex. I am mostly interested in the database of course. Can you tell me the exact name and location of the database? As far as I know, it should be .kobo/KoboReader.sqlite. Is that correct?
It might be possible to recreate the error with just the database, but I am not sure. What is the name of the readerdrive when you attach it to your computer?

Yes, that is the correct name for he database file. In the application, the device is shown in the drop-down as "KOBOeReader (F

".

I have sent you a PM with the link to a copy of the database from my Aura HD.

Toxaris · 05-31-2016, 09:27 AM

Quote:

Originally Posted by davidfor

Yes, that is the correct name for he database file. In the application, the device is shown in the drop-down as "KOBOeReader (F

".

I have sent you a PM with the link to a copy of the database from my Aura HD.

Thanks, that will enable me to try to emulate the kobo and see what is going on.

Toxaris · 05-31-2016, 09:28 AM

Quote:

Originally Posted by tshering

What about ObjectListView.dll?

Could be.

Quote:

Originally Posted by latepaul

A little googling on the error message suggests that startIndex is not a variable in your code but the name of a parameter to a method, probably SubString.

I hardly use substring in my programming due to various reasons, but it could be that it has been used. I will check for that.

davidfor · 05-31-2016, 09:50 AM

Quote:

Originally Posted by latepaul

A little googling on the error message suggests that startIndex is not a variable in your code but the name of a parameter to a method, probably SubString.

Quote:

Originally Posted by Toxaris

I hardly use substring in my programming due to various reasons, but it could be that it has been used. I will check for that.

Something like "startIndex" could be used in a lot of places. I'm fairly sure I've written code that used it as a variable name for searching a list or something. From the message, it could be a string search, compare or something like that. An operation on a zero length string might get this. Some of the columns in the database can contain an empty string rather than null.

Toxaris · 05-31-2016, 10:41 AM

I have found the issue and it can be solved quickly enough. However, it seems that there is a deeper issue with the way Kobo stores and references its books. I want to solve that as well.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PRS-T1 PRS-T1 Annotations Exporter	Yoths	Sony Reader	52	12-15-2016 05:14 AM
Display Kobo Annotation on PC	4StarGen	Kobo Developer's Corner	2	07-09-2015 05:22 AM
Glo Highlight/Annotation compatibility Kobo/Calibre/Adobe Acrobat Pro	kobokobe	Kobo Reader	8	05-19-2013 08:02 PM
kobo annotation and non-Kobo files	carandol	Kobo Reader	2	11-26-2011 03:15 PM

05-29-2016, 02:02 AM	#17
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	The number of books should not be a problem, it is not that much data actually. Since there is a difference in firmware I suspect Kobo did make a change, perhaps not in the database, but on another level. Can you sent me the .kobo directory? I don't need the books of course. That way I can emulate a Kobo and do some testing.

05-31-2016, 05:05 AM	#22
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	I checked the code again and indeed there is nothing called startIndex. I am mostly interested in the database of course. Can you tell me the exact name and location of the database? As far as I know, it should be .kobo/KoboReader.sqlite. Is that correct? It might be possible to recreate the error with just the database, but I am not sure. What is the name of the readerdrive when you attach it to your computer?

05-31-2016, 06:28 AM	#25
latepaul Wizard Posts: 1,270 Karma: 10468300 Join Date: Dec 2011 Device: a variety (mostly kindles and kobos)	A little googling on the error message suggests that startIndex is not a variable in your code but the name of a parameter to a method, probably SubString.

05-31-2016, 10:41 AM	#30
Toxaris Wizard Posts: 4,520 Karma: 121692313 Join Date: Oct 2009 Location: Heemskerk, NL Device: PRS-T1, Kobo Touch, Kobo Aura	I have found the issue and it can be solved quickly enough. However, it seems that there is a deeper issue with the way Kobo stores and references its books. I want to solve that as well.