Author Topic: converting Access Database to Gedcom  (Read 483 times)

0 Members and 1 Guest are viewing this topic.

Offline Andy B

  • VIP
  • Newbie
  • *
  • Posts: 3
    • View Profile
converting Access Database to Gedcom
« on: December 10, 2021, 15:59:56 »
Has anyone converted an MS Access database to a gedcom format. If so could you help me convert mine please. I watched a YouTube by Fredric Lapeyre from Ancestris streamed in May of 2021 in which he said he had done it, so it is possible.  https://www.youtube.com/watch?v=728poLdQZCM ..    I have 15 years work in the database and really don't want to start from scratch ;D   Many thanks

Offline Zurga

  • VIP
  • Supernatural Member
  • *
  • Posts: 2 614
    • View Profile
Re: converting Access Database to Gedcom
« Reply #1 on: December 10, 2021, 16:36:11 »
It's always possible to convert from one format to another.
But, Access is a generic database. Converting it needs some programming and data-mining to check the current definition of the database scheme to create the correct translation program.

How this base has been created ?

Zurga

Offline Andy B

  • VIP
  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: converting Access Database to Gedcom
« Reply #2 on: December 10, 2021, 23:20:43 »
As i built the database from scratch it's inner workings are all known to me, so mining it should not be a problem, have already done that for a mapping program and graphical data display software. Just never built a gedcom before :(

Offline Zurga

  • VIP
  • Supernatural Member
  • *
  • Posts: 2 614
    • View Profile
Re: converting Access Database to Gedcom
« Reply #3 on: December 10, 2021, 23:37:54 »
GEDCOM file is basically a hierarchical file.
Each line is composed by a hierarchical level then a tag then a value

You can find the complete description of the 5.5.1 GEDCOM File here : https://gedcom.io/specifications/ged551.pdf

You can see it as an XML or JSON file where the delimiters are replaced by increasing level number.

For example, this type of thing :
 "indi" : {
                "id" : I001,
                "Name" : {
                                "SURN" : Durand,
                                "GIVN" : John
                               }
                 "Birt" : {
                             "Date" : 16 Nov 1800,
                             "Plac" : London, United Kingdom
                            }
                 }

This can be translated in GEDCOM as :
0 @I001@ INDI
1 NAME John /Durand/
2 SURN Durand
2 GIVN John
1 BIRT
2 DATE 16 NOV 1800
2 PLAC London, United Kingdom

The GEDCOM file has a header to describe what is in and how it is done and a trailer to close the file (0 TRLR )

Zurga

Offline Andy B

  • VIP
  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: converting Access Database to Gedcom
« Reply #4 on: December 11, 2021, 03:59:04 »
Thank you. I'll have a look at the link you sent and see what i can do with it.

Offline Zurga

  • VIP
  • Supernatural Member
  • *
  • Posts: 2 614
    • View Profile
Re: converting Access Database to Gedcom
« Reply #5 on: December 11, 2021, 07:35:25 »
The specifications are not very clear on each point.
Don't hesitate to ask questions on it.
Ancestris uses the GEDCOM format as native persistency model, so we have faced almost all difficulties of the specifications.

Zurga