The platform I am using is Windows. I am looking at the database that gets created and the tables. I am trying to link individuals to each other for an export. I see various threads about the schema for the data but I dont see all of the columns for the tables.
Is there a specific plug-in that is required for this - anyone else trying to read the database via Windows?
Do you mean like Gramplet and Quickview Query addons by @dsblank for SimpleAccess?
The tables aren’t in a relational format. In fact the data is actually stored in the tables as a graph. Prior to Gramps 6.0, the data is stored (mostly) in a field called blob_data, and required Python unpickling, and then turned into Python objects.
In Gramps 6.0, the graph of each object is saved in each table (person, family, etc) in a field called json_data, and can be inspected easily by eye, and turned into Python objects more easily.
But, there are exports into more relational formats. There is a SQLite export (which is a bit confusing now because sqlite is the default database format). It should probably be renamed to something reflective of the fact that it makes relational friendly tables.
Does that help?
Yes, I am trying to read the database that is used and don’t see all of the tables. I installed the latest Windows version of the software and was hoping to put together multiple trees from other members of the family and not put everyone’s information into the application. I thought if I could extract the information from a GED import and merge that would be great -
I understand SQL but if this is just a resemblance of the database, I will need to learn/research more about python.
If you have any other thoughts, I would appreciate it. I did look at the export to SQLite but couldn’t get it to install properly - I believe it is an older version.
Oh, yes, I wrote that more than 7 years ago, and haven’t looked at it in as many years. But that isn’t the way to proceed generally.
Gramps has a lot of support (in Python) to import GEDCOM and other formats. I suggest you try using Gramps from the app first, before trying to dive down to the database layer.
At this moment the easiest way to get multiple trees into gramps will be to consolidate all your external file into either a Gramps xml file or a CSV fil for Gramps, the consolidation can be done in most workbook software or by using OpenRefine or a workflow software like KNIME.
Thanks for your input. While I was hoping that I could put tables together even after extracting to the SQLite file structure, I ended up taking one of the GEDCom files into Gramps and doing a filter and deleting that side of the family. Afterwards, I merged my line of the family. I now have a family tree that my side of the family can review and maintain.