Read Gedcom file and store in Database

3
votes

I want to read a Gedcom file and store in sql server . GEDCOM is a file format which allows genealogy files to be shared between different genealogy software applications. GEDCOM stands for GEnealogical Data COMmunications.

Can any one help me on this issue ???

3
asp.netfilegedcom
Do you want to store the text of the file into the server, or do you want to convert the GEDCOM format into a data-structure you have defined? Will the user be uploading the file, or is it already on the server? What have you tried so far? - RB.
User will upload any gedcom file in my web page and i want to store that file in my database as according to that information i want to create a Family timeline . - Joshi
You'll want a GEDCOM parser then (google.co.uk/…). Which specific areas are you having problems with though? - RB.
I successfully read the gedcom file and converted that file into xml file. Now how can i maintain the relationship available in gedcom file and store that information in database - Joshi
You'll need to define an appropriate database structure. Without knowing your requirements, it's not obvious what that should be, but if you've managed to convert a GEDCOM file into an XML file (which is not easy in itself!) then your XML structure should be similar to the database structure you will need. - RB.

3 Answers

4
votes

One easy way I've found to query GEDCOM data in SQLServer is to use the import / export features that come with The Master Genealogist application. The Master Genealogist lets you export data to csv. Once you have the data in csv you can then use the Data Transformation Services wizards of SQLServer to import it.

I've certainly had success exporting data from The Master Genealogist into SQLServer but have not as yet tested the GEDCOM import feature.

Otherwise, you could always checkout the GenealogyJ codebase and take a look at the GEDCOM reader there. If java is not to your liking try the perl Gedcom module instead.

0
votes

Oxy-Gen is a tool that allows you to convert to the following formats :

  • HTML (Browser display)
  • CSV (Excel, Open Office, ...)
  • SQL (Oracle)
  • MySQL (PHP)
  • XML (machine 2 machine)

If you don't need automatic import/export features, this tool should suit your needs.

If you do need automatic import/export features, you might want to look for a GEDCOM parsing library in the programming language of your choice.