Importing multiple citations

Hi all. I’ve been working the past few years to index the available civil records (B/M/D) for one of my ancestral Italian towns. I’m at the point now (having done about 30 years of records from 1809-1840) where I also want to use that information to start a one place study, adding families and connections in Gramps (5.1.5, Win 10) and then exporting a GEDCOM to share and/or publish online in WikiTree. I have all the indexed data in a Google sheet (about 16,000 records so far), enough with each record to create basic profiles for every person.

I’ve figured out how to manipulate the data in my Google sheets to import the people and create the relationships and events into Gramps through CSV. The rough part is the sources/citations. I’m only using one source (Comune of Modugno Civil Acts). Gramps creates citations from the import for each event, but they are just dummy placeholders. There’s no way that I can see to import the full citation info (year, record type, act number, url to page). Instead I need to go into one of the dummy citations and add all that info, then merge the citations with other citations that were created for the various events related to the family record. It gets quite tedious since just the first year of births (less than 300 records) resulted in about 550 citations (about 300 births and about 250 estimated birth years for parents) that now have to be edited and merged to whittle down to the 291 actual citations for the year.

Is there an easier way I wonder? Or maybe Gramps isn’t the tool for this job?

1 Like

You’ll want to importing the citations concurrently to the import of Birth/Marriage/Death Events under each Person.

I am assuming that you are connecting the Birth/Death Events to People and Marriage Events to Families during the import. Not stitching them together manually. Likewise, that you are adding People to Families during import.

The process of having a Citation reference created during import is very similar.

Looking at the wiki, the CSV Import and Export webpage does not give an example of a Citation header. For items that are not explicitly listed in those webpages, you can always create an example. In a dummy Tree of Gramps, create a linked record manually (or filter to a representative record in the Example.gramps tree) and export the view(s) to CSV.

1 Like

A good alternative is to manually create a Sample family in a fresh blank Tree. Then export that to CSV as your reference.

Add a family with parents & a child, with sourced Events for all. Add samples all Event types that you intend to import… making certain to add a Marriage event that is under the Family, not redundantly attached under each spouse. Include a hierarchical Place with GPS coordinates and citations to at least 2 different sources. (I recommend using the Place Cleanup add-on Gramplet to create the best quality Place hierarchy example. It takes some configuring to access the GeoNames webservice. But it is worth the effort.) Then export the entire 3-person Tree to CSV.

Unfortunately, the CSV export does not include citations. It only includes the source name and no other information.

Confirmed that that the CSV only supports Source (as strings, not hierarchical records) and not citations.

Amended bug report 10346 with inquiry about adding faster ID-based citation CSV support to supplement slow string-based Source support.

1 Like

You could try Transged which is a :clipperton_island: software to transform a formatted CSV file into a Gedcom file

So, similar to Excel2Ged?

Sorry, I don’t know, I never use Excel to enter genealogical data to avoid these kind of issues, I just know these translation programs exists

If you use Excel the easiest way is to create a vba to write to json or more advanced xml.

Create the different objects you need in Gramps, export to json, examene the json file, create a vba that write a json with the cell data…

here is one exemple that might help (not creating a “gramps” json, but a json file):

How does one export from Gramps to JSON? Please explain to the non-programmer, as I don’t see JSON as an option in the export wizard.

The JSON importer/exporter is an Add-on.

Another format is displayed in those options when it has been installed via the Gramps Plugin Manager and then Gramps is restarted.

Because there are no interface options, there is no wiki page for it. And it isn’t in the wiki’s Add-on List either.

If you cannot find it, Matt’s webpage lets you search the Gramps addons for importers/exporters. The JSON add-on IS listed there. (But you’d have to install an external download manually.)