Difference between revisions of "Addon:ImportGramplet"

From Gramps
Jump to: navigation, search
m (Import CSV (spreadsheet input))
(Troubleshooting a Place list Import)
Line 30: Line 30:
  
 
=====Troubleshooting a Place list Import=====
 
=====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.
+
Every text parser has expectations of the format. So it is important to do that testing with a blank Family Tree.  Empty Family Trees 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.
+
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 have shown that any extra spaces after the Comma Separators made it ignore those quotes and the line breaks too.
  
 
<pre>Place,Name,Type,latitude,longitude
 
<pre>Place,Name,Type,latitude,longitude

Revision as of 00:34, 5 January 2021

Gramps-notes.png

Please use carefully on data that is backed up, and help make it better by reporting any comments or problems to the author, or issues to the bug tracker
Unless otherwise stated on this page, you can download this addon by following these instructions.
Please note that some Addons have prerequisites that need to be installed before they can be used.
This Addon/Plugin system is controlled by the Plugin Manager.


Import Text Gramplet - Addon - Showing Gramps XML example

The Import Text Gramplet allows you to paste the content of selected file formats and import directly into Gramps without having data in a file.

  • Gramps XML
  • CSV (spreadsheet input)
  • vCard files - The vCard (Virtual Contact File or VCF) import and export currently supports only the version 3.0 format with property types for the name (FN, N, NICKNAME, SORT-STRING), address (ADR), telephone number (TEL), birthday (BDAY), occupation (ROLE), URL (URL), email address (EMAIL), and gender (GENDER, X-GENDER). This is a core subset of the dozens of propertt types available in the vCard format.


Usage

From the Dashboard use the context menu (right-click) to add the Import Text Gramplet.

Example

Import CSV (spreadsheet input)

CSV pasted into Import Text Gramplet

To import a CSV you could:

  • Create a new Family Tree to test the following.
  • Add the Import Text Gramplet to your Dashboard.
  • Copy the contents of the CSV example from User manual
  • Paste the contents directly into the text input area of the Gramplet.
  • Then select the Import button only once unless you want the same information imported multiple times.
  • Then empty the text input area by selecting the Clear button.
  • View the imported results in Gramps
  • If you want to reverse the imported result because you made a mistake or pressed the the Import button multiple times you can select 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 important to do that testing with a blank Family Tree. Empty Family Trees 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 have shown that any extra spaces after the Comma Separators made it ignore those quotes and the line breaks too.

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,,

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 Generate hierarchy option of the 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.

Issues

  • allow import from pasted GEDCOM file 5436