@Tim reports experiments with the SQLite export creates records of Events where the Event type is a numeric index. He hasn’t found the table being referenced and the add-on wiki page is kinda thin. Any suggestions?

Maybe we need to reference that Discourse thread on the Wiki page! [done]

Let me know if you want me to post anything here about my SQLite ‘experiments’. Happy for you to take the lead on this

[image] Tim: Let me know if you want me to post anything here about my SQLite ‘experiments Please do! Me inserting myself in the middle is only a good example of the “ Peter Principle ” I would just be exposing my technical ignorance and obfuscating issues for the people who actually understa…

[image] emyoulation: He hasn’t found the table being referenced The events type are referenced in gramps/gen/lib/eventtype.py To get the string value corresponding to the index, you must do: … event_type = [tup for tup in EventType._DATAMAP if tup[0] =…

[image] emyoulation: Maybe we need to reference that Discourse thread on the Wiki page! [done] See also these enhancement requests: https://gramps-project.org/bugs/view.php?id=12620 https://gramps-project.org/bugs/view.php?id=12765 https://gramps-project.org/bugs/view.php?id=12766 [done]

Thanks. I can use that, cutting and pasting into my jupyter notebook. which is where I’m familiar with using Python, but it illustrates another problem I have, namely not knowing how to access GRAMPS .py files with just an import statement. I can import soundex.py, because it has no relative referen…

OK - this is my SQLite ‘experiment’, though for the time being, it’s doing what I need [image] I exported from GRAMPS to SQLite, saving in the location fld + sqliteExported, then use sqlite3 to connect to it from my jupyter notebook, and after a not too long journey of discovery of the schema of …

You need to tell Python how to find the Gramps files. One way is to use PYTHONPATH before the Python interpreter starts. The other way is to make sure that the root directory of the Gramps files is appended to the sys.path in your code. This should be enough to help you web search for additional …

I thought I’d done that - “appended to the sys.path in your code” - with this [image] I’m going to ask someone who’s helped me before with this sort of thing to remote into my machine, and see if he can fix it. If he can, it’s going to be really helpful - and fun. Another option is for me to lea…

SQLite export clarification?

Help

GeorgeWilmes December 7, 2022, 4:42pm 2

Maybe needs to make the fixes mentioned here?

Topic		Replies	Views
Personal introduction - steers sought on programmatic interation Help	21	942	December 15, 2022
How to export Descriptions and Notes? Help	4	913	September 14, 2021
Read SQLite Database Development	7	162	April 6, 2025
Display and export Help	6	1081	April 21, 2020
How can I connect to the DB? Help	5	524	February 8, 2023

SQLite export clarification?

Related topics