Changes

Jump to: navigation, search
no edit summary
*[[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 3The CSV import and export both use the Edit/Preferences/Display/Place Format setting for places.3|Previously For most uses, sources were not exported, but now they arethe 'Full' setting for Place Formats should be used. Sources are referred to by their title text. You can add further details to a source after importing.}} {{man note|New feature since Gramps 4.2.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>
Place place - a reference to this placeTitle title - title of placeName name - name of placeType type - type of place (eg, City, County, State, etc.)Latitude latitude - latitude of placeLongitude longitude - longitude of placeCode code - postal code, etc.Enclosed_by enclosed_by - the reference to another place that encloses this oneDate date - date that the enclosed_by place was in effect
</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.
1,965
edits

Navigation menu