* Flexible CSV importer - name type

For users to report plugin bugs and request plugin enhancements; and for authors to test new/new versions of plugins, and to discuss plugin development (in the Programming Technicalities sub-forum). If you want advice on choosing or using a plugin, please ask in General Usage or an appropriate sub-forum.
Post Reply
avatar
ogulbran
Gold
Posts: 19
Joined: 26 Dec 2017 22:31
Family Historian: V7
Location: Norway
Contact:

Flexible CSV importer - name type

Post by ogulbran » 05 Jun 2023 16:54

Hi

I am using the Flexible CSV importer - a good tool to append more data for existing persons (with the REFN column as key).

But I have a wish for one more field: The name type that can be filled in for a name through the All panel (f.ex. "Maiden"). I am using this to hold different variants of names - and a mass import from a csv would help my very much to get this data into FH.

Could that be solved as a detail level under P.Name?

Best regards,
Øivind

User avatar
tatewise
Megastar
Posts: 27075
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Flexible CSV importer - name type

Post by tatewise » 05 Jun 2023 19:51

Try the attached prototype Flexible CSV Importer plugin Version 1.9.2 Date 05 Jun 2023.
It allows a field such as P.NAME.TYPE with a value such as married.

Remember this must be in a second row but with the original REFN to add a 2nd instance of P.NAME and P.NAME.TYPE
e.g.

Code: Select all

REFN	P.NAME			P.NAME.TYPE	P.SEX
ID 1	Elizabeth Mayes				F	
ID 1	Elizabeth Packer	married
Last edited by tatewise on 14 Jun 2023 08:46, edited 1 time in total.
Reason: Attachment deleted as a better version is in the Plugin Store.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
ogulbran
Gold
Posts: 19
Joined: 26 Dec 2017 22:31
Family Historian: V7
Location: Norway
Contact:

Re: Flexible CSV importer - name type

Post by ogulbran » 06 Jun 2023 14:41

I have tested your attached version of the plugin. I suppose I should get "type" as a value in "detail label"? But there are only the name parts and source fields. Something wrong?

User avatar
tatewise
Megastar
Posts: 27075
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Flexible CSV importer - name type

Post by tatewise » 06 Jun 2023 14:47

Did you see my example CSV code?
What exactly did you put in the CSV file?

You put P.NAME.TYPE as a CSV column header just like you put P.NAME as a column header.
( I've just realised that the plugin does not handle the Detail label correctly for the TYPE field, but that does not prevent it from importing a P.NAME.TYPE column. I'll fix the Detail label entry later. )

Did the plugin say it was all valid?

I would expect to look in the All tab and expand the Name field by clicking [+] on the left to reveal the Type field.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
ogulbran
Gold
Posts: 19
Joined: 26 Dec 2017 22:31
Family Historian: V7
Location: Norway
Contact:

Re: Flexible CSV importer - name type

Post by ogulbran » 06 Jun 2023 15:36

I did not execute the "Import" because I thought something was wrong when I did not see type in the detail field... Tested again - and it works fine!

When I tested yesterday (without the type field) I think the names I imported through the csv file was appended (ie FH kept the existing namesnand added the new ones). While today (with the new version), it seems to replace names. Is that a change (or may be I remember wrong...)? Does not matter very much, as long as I know what is happening.

Thanks for excellent help!

Best regards,
Øivind

User avatar
tatewise
Megastar
Posts: 27075
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Flexible CSV importer - name type

Post by tatewise » 06 Jun 2023 18:28

The plugin will match the REFN and Names (P.NAME) in the CSV with existing REFN and Name fields in the Project.
If it finds a match then any other values on the same row as the Name will get imported against that Name.
If it does not find a match then that new Name is added for the REFN.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
ogulbran
Gold
Posts: 19
Joined: 26 Dec 2017 22:31
Family Historian: V7
Location: Norway
Contact:

Re: Flexible CSV importer - name type

Post by ogulbran » 06 Jun 2023 19:08

OK , thanks!
Øivind

User avatar
tatewise
Megastar
Posts: 27075
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Flexible CSV importer - name type

Post by tatewise » 06 Jun 2023 19:11

Try that attached version that now shows the Detail label correctly.
Last edited by tatewise on 14 Jun 2023 08:46, edited 1 time in total.
Reason: Attachment deleted as a version is in the Plugin Store.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
ogulbran
Gold
Posts: 19
Joined: 26 Dec 2017 22:31
Family Historian: V7
Location: Norway
Contact:

Re: Flexible CSV importer - name type

Post by ogulbran » 13 Jun 2023 20:11

Hello. Been too good weather for genealogy here, so not tested before today! But used the new version now and it works as expected - incl showing "type" in detail field.
Thanks again!
BR
Øivind

User avatar
tatewise
Megastar
Posts: 27075
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Flexible CSV importer - name type

Post by tatewise » 14 Jun 2023 08:45

Flexible CSV importer plugin Version 1.9.2 Date 13 June 2023 is now in the Plugin Store.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
ogulbran
Gold
Posts: 19
Joined: 26 Dec 2017 22:31
Family Historian: V7
Location: Norway
Contact:

Re: Flexible CSV importer - name type

Post by ogulbran » 29 Jul 2023 06:01

Hello.
Still working on cleaning up my name data - with your csv importer.
I am using "NameUsed" in FH, and that is not supported by the plugin.
Is it possible to get that in? (as a new detail label under Name)
Best regards,
Øivind

User avatar
tatewise
Megastar
Posts: 27075
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Flexible CSV importer - name type

Post by tatewise » 29 Jul 2023 15:52

Try the attached Flexible CSV Importer plugin Version 1.9.3 Date 29 Jul 2023.

It allows ...NAME.Used or ...Name:_USED or any similar variants.
Last edited by tatewise on 02 Aug 2023 14:34, edited 1 time in total.
Reason: Attachment deleted as a version is in the Plugin Store.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
ogulbran
Gold
Posts: 19
Joined: 26 Dec 2017 22:31
Family Historian: V7
Location: Norway
Contact:

Re: Flexible CSV importer - name type

Post by ogulbran » 30 Jul 2023 07:55

Perfect - works fine! Thank you very much.

Best regards,
Øivind

Post Reply