I found a repo with python scripting (thats kind of outdated and i have some issues with the script because of that), for transforming exported data to sqlite:
the thing is, i think it works, but i got some the following issues with the sqlite version and keys (assignment__id) from table assignment__actions.
“sqlite3.IntegrityError: NOT NULL constraint failed: assignment__actions.assignment__id”
ok. the specific question is:
Zurab Sajaia (@vavalomi) is the creator of the repo
Since this scripting topic is quite specialized and closely tied to this forum, is it possible to reach out to the creator here in order to collaborate on script updates or modifications?
Has anyone else encountered the need to convert exported data into a SQLite format for post-analytics dashboards or analysis boards? If so, could you share your approach and how you handled this task?