Open letsgocodego opened 3 days ago
Hi @letsgocodego, I have a question about SQLite. Where do you know(get) data in SQLite. I need to know source of it for knowing structure of blob type
Hello @chyccs,
Thank you so much for your reply!
The SQLite file was called "dat" and stored in C:\Users\myWindowsUser\AppData\Local\Packages\7B14F62F.351886EABBB75_psgr8aj8jhtw0\LocalState . I'll attach it so you can see: dat.zip
I think the source is just what was transferred from my N2 pen to the windows Neo Notes application.
I'm really just trying to extract the coordinate and timestamp data for a university project. If there is a more accessible way of extracting that data that I'm just not seeing, I would also be very grateful for any suggestions or pointers to the relevant information for how to do so.
Thank you!
Hi @letsgocodego, I am sorry. I have no information about it. I can not expect accessing information of neo-notes application. because data structure is private property of company.
I guess struct of blob first 1 byte is type of dot. next 4 byte is x typed float. and next 4 byte is y typed float. it is just my opinion.
Hello,
I am trying to extract coordinate and timestamp data from the dat SQLite file on a neo smartpen N2.
My understanding is that the coordinate and timestamp data are stored in the Dots column of the Stroke table which has a data type of BLOB. I cannot figure out how to parse the BLOB to extract useful timestamp and coordinate data. I have looked through the SDK and API documentation extensively and cannot figure it out. I do see that each BLOB is 21 bytes per DotCount.
@chyccs , I see that you're active here and seem to know a lot about this SDK, could you help me parse the BLOB to extract the timestamp and coordinate data? Thank you so much for your time in reading this.