Jump to: navigation, search
note to self : new gramp4.2.1 place import feature has duplicate key "title" in name and in "title" in place
There are three main uses for this format:
# You can export your core gramps Gramps data into a spreadsheet format, edit it with a text or spreadsheet program, and import the changes and additions back into grampsGramps. This is handy for sending to others to fill in, or for taking on the road when you don't have your full gramps Gramps application.# You can import new data into your gramps Gramps database. For example, if you have a set of new people to add to your database, but don't want to hunt and peck your way to finding where they go, you might find it easier to type them into a spreadsheet, and then quickly bring all of them in at once. This is handy if you have a large amount of data that you are cutting and pasting from another application or the web. An example of this is [[Narrative_Website_Import|restoring your Gramps database]] by loading the Narrative Website into a spreadsheet.
# You can also import a set of corrections and additions. Say that you have printed out a report, and you are going through it marking corrections. If you make each correction a section of a spreadsheet, you can "script the edits" and then execute them all at once.
To export your database:
# Start grampsGramps
# Select "Export" from the Family Trees menu
# Select "Comma Separated Values Spreadsheet (CSV)"
;Places: Places, Title, Name, Type, Latitude, Longitude, Code, Enclosed_by, Date
The first column in each area is the gramps Gramps ID. That is what will tie your edits back to the correct data, so don't alter those data. Load this file into your favorite spreadsheet using comma separated, double-quote text delimited, and Text format (any encoding for now). Then you can add or correct data, and save it back out, keeping the same format. You can then import the data back on top of your old data and it will be corrected.
{{man note|LibreOffice allows you to turn off auto-formatting when you open the CSV file.|If you don't do this, LibreOffice may interpret the dates incorrectly. Change the type of the column to Text rather than Standard. If your spreadsheet program doesn't allow you to format the fields before you get it into columns (eg, Excel) you need to change the display format of dates in Gramps before you export. You can do this under {{man menu|Edit -> Preferences -> Display -> Date Format}}}}.
# use the file from above, or create a spreadsheet (described below) with genealogical data
# start up grampsGramps
# import the file into your current database

Navigation menu