Gedcom files

Question

Post reply

Gedcom files

S Allanson

SSC Veteran

Points: 297
More actions
March 13, 2007 at 5:22 am

#62135

Can anyone tell me if a Mysql database will accept a gedcom file, please?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135374 More actions · Answer 1

Maybe someone will know the answer, but this is not a mysql site

This site handles Microsoft SQL Server.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

S Allanson SSC Veteran Points: 297 More actions · Answer 2

Thank you 🙂

My web hosting site only support MsSql and MySql databases, but seem unable to tell me if either will support a gedcom file (used in genealogy).

I'm blundering around trying to find out what sort of databases these are and if they will allow me to put my research (a group of unrelated families) online.

Can anyone enlightened me - preferably in words of one syllable?

Sandra.

Todd Townley Ten Centuries Points: 1320 More actions · Answer 3

GEDCOM files are simply text files. The information within the GEDCOM file uses a pre-defined format/structure (called GEDCOM - hence the name) that relates the data. If you have a GEDCOM file handy, you can open it with any text editor to see what I'm talking about. So while the GEDCOM file is a "database" in the sense that it is an organized collection of data, it is not a "database" in the sense of containing tables, indexes, supporting queries, etc.

There are utilities around that allow you to convert the GEDCOM data into XML. (Note that once the data is converted it is no longer GEDCOM data, it's now XML data!) One that I've used in the past is laid out in Michael Kay's "XSLT Programmer's Reference, 2nd edition" (published by Wrox), starting at page 676.

Of course, once the data is in an XML format, it becomes simply an XML exercise to put that data into any database (such as SQL Server) that supports XML.

S Allanson SSC Veteran Points: 297 More actions · Answer 4

Many thanks, Newbie 🙂

Food for thought and exploration...

As you will have gathered, I am very much a newbie to the workings of a computer, although a terrified user of many years standing.

I will carefully explore your information and see where it leads me.

Sandra.