Changes

Jump to: navigation, search
no edit summary
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. You must use special names for the columns. Currently they are:
 
=== Place ===
 
<pre>
place - a reference to this place
title - title of place
name - name of place
type - type of place (eg, City, County, State, etc.)
latitude - latitude of place
longitude - longitude of place
code - postal code, etc.
enclosed_by - the reference to another place that encloses this one
date - date that the enclosed_by place was in effect
</pre>
=== People ===
baptismplaceid - place id of baptism
baptismsource - source title of baptism
grampsid - give a particular gramps id
deathdate - date of death
deathplace - place of death
gender - male or female (you should use the translation for your language)
[You can put gender here, or in person above]
</pre>
 
=== Place ===
 
<pre>
place - a reference to this place
title - title of place
name - name of place
type - type of place (eg, City, County, State, etc.)
latitude - latitude of place
longitude - longitude of place
code - postal code, etc.
enclosed_by - the reference to another place that encloses this one
date - date that the enclosed_by place was in effect
</pre>
You can have multiple areas of each kind on a spreadsheet. The only limitation is that if you refer to a person, you must do that in a row lower than where that person is described. Likewise, if you refer to a marriage, you must do that in a row lower than where the marriage is described. References to enclosed_by places must already exist in the database, or be defined in rows above in the spreadsheet.
 
If you use the 'grampsid' as a way to assign specific ids, be very careful when importing to a current database. Any data you enter will overwrite the data assigned to that grampsid. If you use ids in the place, person, marriage, or family columns that are surrounded by brackets '[]', the values you use will be interpreted as grampsids as well. If you are adding new items, you are encouraged to avoid use of the '[]' or grampsid columns, so as to avoid accidentally overwriting your data.
If you are entering the data in a text file, and if you wish to have a comma inside one of the values, like "Clinton, Co., MO" then you need place the entire value in double-quotes and put the first double-quote right after the preceding comma. For example:
266
edits

Navigation menu