MobileRead Forums - View Single Post - Question about the "whispersync" file from AMazon user data

Rellwood · 07-02-2021, 05:20 PM

I would think that is the way, but the last read, and most recent read are both date/time data and not number data.

Maybe the last read is the last time I completed reading the book and most recent read is the most recent time I opened the book. There are date/times for created and last updated and most recent read.

There is only one way to manage this list and it's taking me forever to do it.
I have to separate each annotation type, and each format type.

It is a daunting list of over 10,000 entries and it includes every kindle Unlimited, Send to Kindle Doc and even audio books.

It lists every note (and the actual notes have their own column), highlight (what color I used) and bookmark. However, those bits of data are only given as a date/time and not a location. However, the created time, updated time, and most recent read info pertain to the dates/times of cretation and editing of said bookmark/highlight/note. It even shows the deleted ones by indicating if the annotation has been delted (t/f) - even audio clips get a column.

My goal is simple, but complicated. I want to break this list into understandable columns to import into Calibre for each book. I am having a hard time trying to figure out how to do this. The only thing I can think of right now is to just break each list down by format, annotation, and read-creation-edit date/time columns. So complicated.

I should just give up, but - I can't

LOL - if you have your own kindle/amazon you should get this data too!

Thanks for your help!

07-02-2021, 05:20 PM	#3
Rellwood Library Breeder (She/Her) Posts: 1,279 Karma: 1937891 Join Date: Apr 2015 Location: Fullerton, California Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)	I would think that is the way, but the last read, and most recent read are both date/time data and not number data. Maybe the last read is the last time I completed reading the book and most recent read is the most recent time I opened the book. There are date/times for created and last updated and most recent read. There is only one way to manage this list and it's taking me forever to do it. I have to separate each annotation type, and each format type. It is a daunting list of over 10,000 entries and it includes every kindle Unlimited, Send to Kindle Doc and even audio books. It lists every note (and the actual notes have their own column), highlight (what color I used) and bookmark. However, those bits of data are only given as a date/time and not a location. However, the created time, updated time, and most recent read info pertain to the dates/times of cretation and editing of said bookmark/highlight/note. It even shows the deleted ones by indicating if the annotation has been delted (t/f) - even audio clips get a column. My goal is simple, but complicated. I want to break this list into understandable columns to import into Calibre for each book. I am having a hard time trying to figure out how to do this. The only thing I can think of right now is to just break each list down by format, annotation, and read-creation-edit date/time columns. So complicated. I should just give up, but - I can't LOL - if you have your own kindle/amazon you should get this data too! Thanks for your help!