# 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:NAMEOptionalIf 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
IndiLastNamexxxxName 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
Heirsignoredignoredignoredxheirs Reading: Ancestris adds this field in the general comment (GeneralComment)
Witness1LastNamexxxxwitness n°1 or godfather
Witness1FirstNamexxxx
Witness1Commentxxxx
Witness2LastNamexxxxwitness n°2 or godmother
Witness2FirstNamexxxx
Witness2Commentxxxx
GeneralCommentxxxxWriting: Ancestris adds the 3rd and 4th witnesses