Skip to main content

Registers records - Appendix

Mapping between register and Gedcom data

Case of a birth

Birth certificateIndividual  
IndiLastName

IndiFirstName

INDI:NAMEOptionalreplaces the name and lastname of the individual with the name in the record
IndiSexINDI:SEXOptionalreplaces the sex of the individual with the sex in the record
IndiBirthDateINDI:BIRT:DATEMandatoryadds (or replaces) the individual's date of birth with the date of birth from the IndiBirthDate record or, if the latter is blank, with the event date from the EventDate record.
IndiPlaceINDI:BIRT:PLACOptionaladds (or replaces) the place of birth.
IndiCommentINDI:NOTEOptionaladds the comment in the note of the birth of the individual
    
IndiFatherLastName

IndiFatherFirstName

father:NAMEOptional

If the individual already has parents,

If the individual has no parents: searches for families with the same parents' names and with dates compatible with the date of birth (date of marriage, date of birth and death of the parents) If he has several, they are displayed in a list and the user chooses.

If the individual does not already have an associated father in the gedcom: searches for individuals who could be the father (same surname and first name, date of birth and death consistent with that of the individual's birth). If he has several, they are displayed in a list and the user chooses. If no potential father is found, creates a new individual who will be the father and creates a family with the individual as a child.

IndiFatherOccupationfather:OCCUOptional 
IndiFatherDead

IndiFatherComment

father:NOTEOptional 
    
IndiMotherLastName

IndiMotherFirstName

mother:NAMEOptionalsame algo as for father IndiFatherLastName
IndiMotherOccupationmother:OCCUOptionalsame algo as for father's profession IndiFatherOccupation
IndiMotherDead

IndiMotherComment

mother:NOTEOptionalsame algo as for Father IndiFatherComment
    
GeneralComment


Witness1LastName Witness1FirstName Witness1Occupation Witness1Comment Witness2LastName Witness2FirstName Witness2Occupation Witness2Comment Witness3LastName Witness3FirstName Witness3Occupation Witness3Comment Witness4LastName Witness4FirstName Witness4Occupation Witness4Comment

INDI:BIRT:NOTEOptionalThese fields are concatenated and added in the note of the birth of the individual.
EventPlaceINDI:BIRT:SOURMandatorysearches for the source associated with the common place of birth. Proposes to create a source if there is no corresponding source.
CoteSOUR:REFNOptional 
PhotoINDI:BIRT:SOUR:NOTEOptional 
ParishINDI:BIRT:SOUR:NOTEOptional 

 

Case of a marriage

<To be completed>

Case of an event of a death

<To be completed>

Case of a miscellaneous act

<To be completed>

 

Import and export file format

ANCESTRIS  format

All four types of statements have the same format: the lines consist of 82 fields separated by a semicolon. The contents of the fields are encoded in UTF-8 format. Each line ends with the separator "\r\n" (end of line in Windows format).

If the semicolon separator character is present inside a field, the field is enclosed in quotation marks when writing to the file. In the same way, if the quote character is present inside a field, a second quote is added after it (see RFC 4180).

Some fields are ignored when Ancestris reads the file depending on the type of event, see the table below.

Tip: It is possible to create a file in Ancestris format with a spreadsheet program to, for example, reuse data already entered with a spreadsheet program.

  1. create a table of 90 columns with the spreadsheet program
  2. put ANCESTRISV4 in the first column of all rows
  3. fill in the other columns as defined below. It is possible to leave cells empty except for the 1st and 8th columns.
  4. save data in CSV or TXT format (with semicolon as cell separator)

 

ColumnBirthMarriageDeathMiscellaneousComment
"ANCESTRISV4"xxxxversion of the format (mandatory)
CityNamexxxxcity name
CityCode    city code
CountyNamexxxxcounty name
StateNamexxxxstate name
CountryNamexxxxcountry
ParishNamexxxxparish name
EventType"N""M""D""V"event type
EventTypeTagignoréignoréignoréxgeneric event type
EventTypeNameignoréignoréignoréxdescription of generic event type
EventDatexxxxevent date
SecondDateignoréignoréignoréxdate of insinuation or recording of the event
CotexxxxRegister's reference
Freecommentxxxxphoto or folio number
Notaryignoréignoréignoréxname of the notary
      
IndiLastNamexxxx

Name of the :

if N: new born, if M: spouse, if D: deceased, if V: speaker n°1

IndiFirstNamexxxxfirstname
IndiSexxxxxsex
IndiBirthPlaceignoréxxxplace of birth or place of origin
IndiBirthDatexxxxdate of birth . For a birth it is by default the date of the event.
IndiAgeignoréxxxage
IndiOccupationignoréxxxoccupation
IndiResidenceignoréxxxhome
IndiCommentxxxxcomment from the individual or speaker no. 1
      
IndiMarriedLastNameignoréxxxformer spouse
IndiMarriedFirstNameignoréxxxfirstname
IndiMarriedDeadignoréxxxdeceased or not
IndiMarriedOccupationignoréxxxoccupation
IndiMariedResidenceignoréxxxhome
IndiMarriedCommentignoréxxxcomment of former spouse
      
IndiFatherLastNamexxxxfather's lastname
IndiFatherFirstNamexxxxfirstname
IndiFatherAgexxxxage
IndiFatherDeadxxxxdeceased or not
IndiFatherOccupationxxxxoccupation
IndiFatherResidencexxxxhome
IndiFatherCommentxxxxcomment for father
      
IndiMotherLastNamexxxxmother's lastname
IndiMotherFirstNamexxxxfirstname
IndiMotherAgexxxxage
IndiMotherDeadxxxxdeceased or not
IndiMotherOccupationxxxxoccupation
IndiMotherResidencexxxxhome
IndiMotherCommentxxxxcomment for mother
      
WifeLastNameignoréxignoréxwife (marriage) or witness n°2 (miscellaneous acts)
WifeFirstNameignoréxignoréxfirstname
WifeSexignoréignoréignoréxsex
WifePlaceignoréxignoréxbirthplace or orgine
WifeBirthDateignoréxignoréxbirthdate
WifeAgeignoréxignoréxage
WifeOccupationignoréxignoréxoccupation
WifeResidenceignoréxignoréxhome
WifeCommentignoréxignoréxcomment by the wife or speaker n°2
      
WifeMarriedLastNameignoréxignoréxEx-spouse of the woman or speaker n°2
WifeMarriedFirstNameignoréxignoréxfirstname
WifeMarriedDeadignoréxignoréxdeceased or not
WifeMarriedOccupationignoréxignoréxoccupation
WifeMarriedResidenceignoréxignoréxhome
WifeMarriedCommentignoréxignoréxcomment by the woman's ex-spouse or speaker no. 2
      
WifeFatherLastNameignoréxignoréxFather of the wife or of the speaker n°2
WifeFatherFirstNameignoréxignoréxfirstname
WifeFatherAgeignoréxignoréxage
WifeFatherDeadignoréxignoréxdeceased or not
WifeFatherOccupationignoréxignoréxoccupation
WifefatherResidenceignoréxignoréxhome
WifeFatherCommentignoréxignoréxfather's commentary
      
WifeMotherLastNameignoréxignoréxMother of wife or speaker n°2
WifeMotherFirstNameignoréxignoréxfirstname
WifeMotherAgeignoréxignoréx

 

age
WifeMotherDeadignoréxignoréxdeceased or not
WifeMotherOccupationignoréxignoréxoccupation
WifeMotherResidenceignoréxignoréxhome
WifeMotherCommentignoréxignoréxmother's commentary
      
Witness1LastNamexxxxwitness n°1 or godfather
Witness1FirstNamexxxxfirstname
Witness1Occupationxxxxoccupation
Witness1Commentxxxxcomment from the witness or godfather
      
Witness2LastNamexxxxwitness n°2 or godmother
Witness2FirstNamexxxxfirstname
Witness2Occupationxxxxoccupation
Witness2Commentxxxxcomment from the witness or godmother
      
Witness3LastNamexxxxwitness n°3
Witness3FirstNamexxxxfirstname
Witness3Occupationxxxxoccupation
Witness3Commentxxxxwitness's comment
      
Witness4LastNamexxxxwitness n°4
Witness4FirstNamexxxxfirstname
Witness4Occupationxxxxoccupation
Witness4Commentxxxxwitness's comment
      
GeneralCommentxxxxgeneral comment

 

NIMEGUE format

The four types of statements have different formats.

  • Birth rows contain 30 columns
  • The wedding rows contain 60 columns
  • The death rows contain 38 columns.
  • Rows for miscellaneous acts contain 64 columns

The fields are separated by a semicolon. The last field of the line is always followed by a semicolon. Lines are separated by 2 characters x0A x0D If the semicolon separator character is present inside a field, it is replaced by a period when writing to the file because Nimegue does not support the RFC 4180 recommendation.

 

ColumnBirthMarriageDeathMiscellaneousDescriptionImporting in Ancestris
"NIMEGUEV3"xxxxMandatory 
CityCodexxxx ignored
CityNamexxxx  
CountyCodexxxx Ancestris uses CountyCode if CountyName is empty
CountyNamexxxx  
EventType"N""M""D""V"MandatoryCannot be empty
Datexxxx  
IncompletDatexxxx  
Cotexxxx  
Freecommentxxxx  
EventTypeName   x  
EventTypeTag   x  
       
IndiLastNamexxxx  
IndiFirstNamexxxx  
IndiSexx xx  
IndiPlace xxx  
IndiBirthDate xxx  
IndiAge xxx  
IndiCommentxxxx  
IndiOccupation xxx  
       
IndiMarriedLastName xxxex-spouse 
IndiMarriedFirstName xxx  
IndiMarriedComment xxx  
IndiMarriedOccupation  x   
       
IndiFatherLastNamexxxx  
IndiFatherFirstNamexxxx  
IndiFatherCommentxxxx  
IndiFatherOccupationxxxx  
       
IndiMotherLastNamexxxx  
IndiMotherFirstNamexxxx  
IndiMotherCommentxxxx  
IndiMotherOccupationxxxx  
       
WifeLastName x x  
WifeFirstName x x  
WifeSex   x  
WifePlace x x  
WifeBirthDate x x  
WifeAge x x  
WifeComment x x  
WifeOccupation x x  
       
WifeMarriedLastName x xex-spouse 
WifeMarriedFirstName x x  
WifeMarriedComment x x  
       
WifeFatherLastName x x  
WifeFatherFirstName x x  
WifeFatherComment x x  
WifeFatherOccupation x x  
       
WifeMotherLastName x x  
WifeMotherFirstName x x  
WifeMotherComment x x  
WifeMotherOccupation x x  
       
Witness1LastNamexxxxwitness n°1 or godfather 
Witness1FirstNamexxxx  
Witness1Commentxxxx  
Witness2LastNamexxxxwitness n°2 or godmother 
Witness2FirstNamexxxx  
Witness2Commentxxxx  
Witness3LastName x x  
Witness3FirstName x x  
Witness3Comment x x  
Witness4LastName x x  
Witness4FirstName x x  
Witness4Comment x x  
GeneralCommentxxxx  
RecordNoxxxxregister's number 

 

EGMT format

All four types of statements have the same format: the lines consist of 44 fields separated by a semicolon. The contents of the fields are encoded inUTF-8 format.

If the semicolon separator character is present within a field, the field is enclosed in quotation marks when writing to the file. Similarly, if the quote character is present inside a field, a second quote is added after it (see RFC 4180).

Some fields are ignored when Ancestris reads the file, see the table below.

Tip: It is possible to create a file in EGMT format with a spreadsheet program to, for example, reuse data already entered with a spreadsheet program.

  1. create a table of 44 columns with the spreadsheet program
  2. fill in the columns according to the definition below. It is possible to leave cells empty except for the first column.
  3. save data in CSV or TXT format (with semicolon as cell separator)

 

ColumnBirthMarriageDeathMiscellaneousComment
EventType"birth""marriage""death""marriage contract"

"will"

Event type (mandatory)
CountyCodexxxxcounty code
CityNamex  xcity name
ParishNamexxxxparish name if there is more than one in the city
NotaryNameignoredignoredignoredx 
Cotexxxx 
PhotoNoxxxxphoto number
Dayxxxx 
Monthxxxx 
Yearxxxx 
   
IndiLastNamexxxx 
IndiFirstNamexxxx 
IndiSexxxxx 
IndiAgeignoredxxx 
IndiPlaceignoredxxx 
IndiCommentxxxxWriting: ancestris adds the date of birth, occupation and information on the former spouse (for a marriage, death or miscellaneous record).
      
IndiFatherFirstNamexxxxReading: Ancestris uses the same name as the son (IndiLastName)
IndiFatherDeadxxxx 
IndiFatherCommentxxxxWriting: Ancestris adds occupation
IndiMotherLastNamexxxx 
IndiMotherFirstNamexxxx 
IndiMotherDeadxxxx 
IndiMotherCommentxxxxWriting: Ancestris adds profession
      
WifeLastNameignoredxxx 
WifeFirstNameignoredxxx 
WifeDeadignoredxxx 
WifeAgeignoredxxx 
WifePlaceignoredxignoredx 
WifeCommentignoredxxxWriting: Ancestris adds the date of birth, profession and information on the former spouse (for a marriage, death or miscellaneous record).
      
WifeFatherFirstNameignoredxignoredxReading: Ancestris uses the same name as the girl (WifeLastName)
WifeFatherDeadignoredxignoredx 
WifeFatherCommentignoredxignoredx 
WifeMotherLastNameignoredxignoredx 
WifeMotherFirstNameignoredxignoredx 
WifeMotherDeadignoredxignoredx 
WifeMotherCommentignoredxignoredx 
      
Heirsignoredignoredignoredx

heirs

Reading: Ancestris adds this field in the general comment (GeneralComment)

      
Witness1LastNamexxxxwitness n°1 or godfather
Witness1FirstNamexxxx 
Witness1Commentxxxx 
Witness2LastNamexxxxwitness n°2 or godmother
Witness2FirstNamexxxx 
Witness2Commentxxxx 
GeneralCommentxxxx

Writing: Ancestris adds the 3rd and 4th witnesses

 

 

 

Back to top