It’s pretty easy to do with SuperTool. Try the following in the third field, Expression to display:
surname, firstname, birth.date, birth.place.name, death.date, death.place.name, [spouse.surname for spouse in spouses], [[(fevent.date, fevent.place.name) for fevent in family.events if fevent.type == "Marriage"] for family in families]
You’ll obtain something like that:
First line: A man married once
Second line: a woman and her two husbands name and mariage
Third line: another woman (with a more regular Gramps Id)
Fourth line: a man and his three wifes
Notice I’ve added gender at the beggining of my command line to know that more easily
Columns are:
- ID: Gramps ID
- Value 1: Gender
- Value 2: Surname
- Value 3: Fisrtname
- Value 4: Birth date
- Value 5: Birth place
- Value 6: Death date
- Value 7: Death place
- Value 8: Spouses list
- Value 9 Marriages date and place list
Then, to export results click on Download CSV button
Supertool Code:
[Gramps SuperTool script file]
version=1
[title]
SuperTool-People - Create Excel list of people, dates and places - Example
[category]
People
[initial_statements]
# https://gramps.discourse.group/t/create-excel-list-of-people-dates-and-places/3168/5
[statements]
[filter]
[expressions]
gender, surname, firstname, birth.date, birth.place.name, death.date, death.place.name, [spouse.surname for spouse in spouses], [[(fevent.date, fevent.place.name) for fevent in family.events if fevent.type == "Marriage"] for family in families]
[scope]
selected
[unwind_lists]
False
[commit_changes]
False
[summary_only]
False
You could change place.name by place.longname if you want to see the full place hierarchy:
gender, surname, firstname, birth.date, birth.place.longname, death.date, death.place.longname, death.place.longname, [spouse.surname for spouse in spouses], [[(fevent.date, fevent.place.longname) for fevent in family.events if fevent.type == "Marriage"] for family in families]
Another try (without “[” and “]”) maybe more easy to use in excel:
[Gramps SuperTool script file]
version=1
[title]
SuperTool-People - Create Excel list of people, dates and places - Example
[category]
People
[initial_statements]
# https://gramps.discourse.group/t/create-excel-list-of-people-dates-and-places/3168/5
[statements]
[filter]
[expressions]
gender, surname, firstname, birth.date, birth.place.name, death.date, death.place.name, death.place.name,
str([spouse.surname for spouse in spouses]).replace("[","").replace("]",""),
str([[(fevent.date, fevent.place.name) for fevent in family.events if fevent.type == "Marriage"] for family in families]).replace("[","").replace("]","")
[scope]
selected
[unwind_lists]
False
[commit_changes]
False
[summary_only]
False
