4,608
edits
Changes
m
→Import CSV (spreadsheet input)
* View the imported results in Gramps
* If you want to reverse the imported result because you made a mistake or pressed the the {{man button|Import}} button multiple times you can select {{man menu|Edit > Undo CSV import}} from the Gramps menu as many times as you need.
=====Troubleshooting a Place list Import=====
Every text parser has expectations of the format. So it is importance to do that testing with a blank Tree. barren Tree make it easier to find where each piece of data lands.
Generally, CSV files that contain text strings simply enclose that data with double-quotes to make it seem as a single block of text. Experiments with this parser showed that any extra spaces after the Comma Separators made it ignore those quotes and the line breaks too.
<pre>Place,Name,Type,latitude,longitude
[P001],"Columbus,Franklin,OH,USA",City,,
[P002],"Las Cruces,Dona Ana,NM,USA",City,,
[P003],"Dunellen,Middlesex,NJ,USA",City,,
[P004],"New York,New York,NY,USA",City,,
[P005],"Metairie,Jefferson,LA,USA",City,,
[P006],"Hopkins,Hennepin,MN,USA",City,,
[P007],"Camarillo,Ventura,CA,USA",City,34.2164,-119.0376
[P008],"San Antonio,Bexar,TX,USA",City,,
[P009],"Abilene,Dickinson,KS,USA",City,,
[P010],"Fairbanks,Fairbanks North Star,AK,USA",City,,
[P011],"Miami,Miami-Dade,FL,USA",City,,</pre>
Notice that the sample place list has placeholder commas when the Latitude and Longitude are missing for 10 of the 11 rows. And this test data has the Place name in the flat form. After importing, you can use the [[PlaceUpdate_Gramplet#Generating_a_place_hierarchy|Generate hierarchy]] option of the {{man label|[[PlaceUpdate_Gramplet|Place Update]]}} add-on Gramplet to convert the flat form into a hierarchy. Then filter for Unknown types and use the Place Type option to set the State and County types to an extended selection of the enclosing Places.
{{-}}
