Changes

Jump to: navigation, search
m
add-on > addon ( stick with one spelling )
{{man index|Gramps 5.1 Wiki Manual - Manage Family Trees|Gramps 5.1 Wiki Manual - Probably Alive|5.1}}
{{languages|Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export}}
{{#vardefine:chapter|5.16}}
{{#vardefine:figure|0}}
This section relates to using Gramps with the '''Comma Separated Values Spreadsheet(CSV)''' format.
*[[Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees#Gramps_CSV_import|Gramps CSV import]]
*[[Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees#Comma_Separated_Values_Spreadsheet.28CSV.29_export|Comma Separated Values Spreadsheet(CSV) export]]
 
You can also [[Gramps_5.1_Wiki_Manual_-_Settings#Export_View|Export]] the current list view to a Spreadsheet(*.ODT) or CSV file.
== Gramps Spreadsheet Import/Export ==
{{man warn|This spreadsheet format does not allow for 100% export of Gramps data.|It only exports (and imports) a subset of data, namely: people (names, gender, birth, baptism, death, and burial dates/places/sources); marriages (dates/places/sources); relationships (parents and children); and places (title, name, type, latitude, longitude, code, enclosed by, and enclosed date). Notes are not exported, but new notes are appended onto the end of existing notes.}}
{{man notewarn|New feature since Gramps 4The CSV import and export both use the Edit/Preferences/Display/Place Format setting for places.2 For most uses, the 'Full' setting for Place Formats should be used.1|Now you can export and If the place format setting doesn't match the CSV file for import place information. Also, you can refer to places in marriage and person sections by using a "may get the same place id". See below for created more detailsthan once.}}
There are three main uses for this format:
There are some columns that will be blank, specifically note and source columns. These are listed in the spreadsheet so that you can make notes for the import, but notes are never exported with this tool.
{{man note|From Gramps 3.3|you can now export source titles; previously no source data was exported.}}
Your data is broken up into four sections representing places, individuals, marriages, and children. The exported fields and column names are:
If you load this spreadsheet into LibreOffice, make sure you select each column as type '''Text''' rather than '''Standard'''. Standard will reformat your dates and numbers. Also, if you use Excel, you will probably want to select all cells once opened, and change the format of the cells to '''Text'''.
The spreadsheet is data made up of columns. Each column should have at the top of it the name of what type of data is in the column. The first column in each area is the Gramps ID reference. You must use special names for the columns. Currently they They are:
=== Place ===
<pre>
person - a reference to be used for families (marriages, and children)
grampsid - to assign a gramps Gramps id to the person
firstname - a person's first name
surname/lastname - a person's last name
gender - male or female (you should use the translation for your language)
note - a note for the person's record
 
birthdate - date of birth
birthplace - place of birth
birthplaceid - place id of birth
birthsource - source title for birth
 
baptismdate - date of baptism
baptismplace - place of baptism
baptismplaceid - place id of baptism
baptismsource - source title of baptism
 
deathdate - date of death
deathplace - place of death
deathsource - source title for death
deathcause - cause of death
 
burialdate - date of burial
burialplace - place of burial
burialplaceid - place id of burial
burialsource - source title of baptismburial occupationdate - date of occupationoccupationplace - place of occupationoccupationplace_id - place id of occupationoccupationsource - source title of occupationoccupationdescr - description of occupation residencedate - date of residenceresidenceplace - place of residenceresidenceplace_id - place id of residenceresidencesource - source title of residence attributetype - type of attributeattributevalue - value of attributeattributesource - source title of attribute
</pre>
== Details ==
Column names are not case-sensitive. You may use any combination of the columns, in any order. ('''Actually, you have to at least have a surname and a given name when defining a person, you have to have a marriage and child columns when defining children, and places need a place reference, but that is it.''') The column names are the English names given (for now) but the data should be in your language (including the words "male" and "female").
Top-to-bottom order is important in that if you want to reference something in one area to another, the definition MUST come first. For example, if you want to define families of people, the individuals must be defined before the families. The same applies to places. So it is usually best to put the Places data first, people next, then marriages and families.
</pre>
If you cut and paste that into a file (or use the [[Addon:ImportGramplet|Addon:Import Gramplet]]), you can import it directly.
A date can be any valid Gramps date, including dates formats like "26 JAN 1973" or "26.1.1973".
"D","[I0973]",,
</pre>
=== See also ===* [[Addon:ImportGramplet|Addon:Import (text) Gramplet]] 3rd party addon by Doug Blank - an interactive version of the [[Gramps_{{man version}}_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export|CSV Import]]
{{languages|Gramps_5.1_Wiki_Manual_-_Manage_Family_Trees:_CSV_Import_and_Export}}

Navigation menu