Plugin

Flexible CSV Importer

Takes a CSV file and creates people, adds facts and creates spouse and parent-child relationships in Family Historian. Columns in the CSV file can be mapped to the appropriate fields using an interface in the plugin - fixed column formatting or naming is not required.

The plugin can optionally append a source to every entry, and can create different citation details (i.e. "Where in Source") for each line of the CSV. Within each row, for each individual, it is assumed that any references to a fact type relate to the same occurrence of that fact. Custom references can be used to identify the same individual in different rows of the CSV either to build a more complex tree or to allow for multiple occurrences of a fact type.

The type of use intended when creating this was import of a variety of data that a one-name or place study might be interested in. For example, baptism transcripts which may include birth and baptism names, parents names and address all in the one line. Custom references allow for individuals to be linked across lines of the CSV to create larger family records, e.g. where the same parents had multiple children baptised.

This plugin is intended for use in a new Project, and will not link to individuals already present in the database.
Please check the import results carefully and report any bugs in the FHUG Plugin Discussions Forum.

Version 1.5 has better CSV syntax checks, more Source Citation options, a Help page and new dialogues.
Version 1.4 fixes a bug in mapping note fields.
Version 1.3 fixes a bug that sometimes occurs when creating families using custom references.
Version 1.2 adds option to discard Custom References, and fixes bug where they are listed multiple times.
Version 1.1 will append to, rather than overwrite, duplicated note fields and citation text fields. It also creates new facts instead of overwriting data if an individual has the same field type listed in multiple rows of the data.

Rating: Not Rated

+ Add Comment and optionally Rate the Plugin

This will not be displayed
please rate this plugin, 1 = Poor, 5=Excellent

Comments

Hi Mike,
I have downloaded the plug-in (v1.5) and inspected the lua code. Unless I am mistaken, the code appears to be corrupted starting at about line 31. Making most of the first 25% of the file get treated as comment, and uncommented code starting in the middle of a syntactical element.
Best regards,
Phil Young

Phil Young, March 16, 2020 at 6:18 pm


I was mistaken in my previous comment. The confusion arose because the "lua" syntax highlighting provided by my text editor ( and by the text editor used by FH when clickiing on View Source, on the web page) had not been configured to recognise [[ and ]] as string delimiters. Please accept my apology for any confusion caused. I will definitely look at the plug-in further to see whether it can help me import data collected for a one-name study.

Phil Young, March 23, 2020 at 9:25 pm