* Export to CSV from FH 6.2

Importing from another genealogy program? This is the place to ask. Questions about Exporting should go in the Exporting sub-forum of the General Usage forum.
Post Reply
avatar
japlah
Newbie
Posts: 1
Joined: 26 Nov 2016 14:07
Family Historian: V6

Export to CSV from FH 6.2

Post by japlah » 26 Nov 2016 14:48

Export from FH 6.2 to csv ? Is there a tool or required sequence to get all or collections of the stored data into generic external file format such as CSV ?

I am familiar with File-maker(relational database) and ubiquitous spreadsheet databases and although more cumbersome, would prefer to deal with the data with those programs.

Initial foray into FH 6.2 has left me baffled. Probably because I am not approaching the FH from a genealogist mindset. Not to mention I am old enough to be curmudgeon and unwilling to learn any further scripts or buttons !

Should add that I have been kindly ? "bequeathed" a family tree by my cousin, of which I am part, but my track record on keeping up with our extended family is not that good. That was my wife's speciality : all done with an address book, Christmas card list and the relationships all in her head. Not a computer in sight !

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

Re: Export to CSV from FH 6.2

Post by tatewise » 26 Nov 2016 15:57

Welcome to the FHUG.

Effectively, the genealogical data in FH is structured somewhat similar to a relational database.
There are multiple record types, and each record type has hierarchically nested field structures.
So I'm sure you understand it is extremely difficult to represent all that data in a flat CSV file.

You say you're a curmudgeon unwilling to learn further scripts or buttons, so how & why did you get involved in FH?

How much genealogical data have you got in FH that needs to be exported?

What exactly are your objectives?
Are you planning genealogical family history research, or just a contacts address book?

FH is not really that difficult to use at a basic level. You do not have to use all its bells & whistles.
There is a companion book "Getting the Most From Family Historian" that would get you started.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
Valkrider
Megastar
Posts: 1534
Joined: 04 Jun 2012 19:03
Family Historian: V7
Location: Lincolnshire
Contact:

Re: Export to CSV from FH 6.2

Post by Valkrider » 26 Nov 2016 17:11

One way of getting your FH file into a CSV file is to use the free programme called GedXlate. It will read the FH gedcom and convert it to several different formats. It is old but still runs happily on Windows 7 & 8 but I don't have 10 to test it on.

You can get it from http://www.gedmagic.com/gedxlate.htm

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

Re: Export to CSV from FH 6.2

Post by tatewise » 26 Nov 2016 18:01

Colin, will that cope with all the new FH V6.2 features such as Place records, etc.

See fhugdownloads:contents:utility_gedxlate|> Utility ~ GEDxlate.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
Valkrider
Megastar
Posts: 1534
Joined: 04 Jun 2012 19:03
Family Historian: V7
Location: Lincolnshire
Contact:

Re: Export to CSV from FH 6.2

Post by Valkrider » 26 Nov 2016 19:03

Mike,

No it doesn't it only exports a subset of the valid Gedcom tags. See the attached image to see which tags it exports. But given the OP's original request I thought it would give him what he needs.
gedxlate.png
gedxlate.png (149.87 KiB) Viewed 5906 times

avatar
TimTreeby
Famous
Posts: 168
Joined: 12 Sep 2003 14:56
Family Historian: V6.2
Location: Ogwell, Devon
Contact:

Re: Export to CSV from FH 6.2

Post by TimTreeby » 26 Nov 2016 21:11

Well surely depending on exactly what info is required the easiest way is to run a Query and then save as CSV file.

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

Re: Export to CSV from FH 6.2

Post by tatewise » 27 Nov 2016 00:52

Maybe Tim, but there would have to be a Query for all the types of record Individual, Family, Note, Source, etc...

With Individual and Family records it is almost impossible to include all the Facts and multiple Names and Family links are tricky. Try it and you will see. So there would also need to be a Fact Query and even then multiple Source Citations are tricky. In fact multiple instances of anything is tricky.

That is why I asked what the background and purpose of the request is all about.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Post Reply