Registers records - Appendix (L)

Mapping between register and Gedcom data

Case of a birth

Birth certificate	Individual
IndiLastName IndiFirstName	INDI:NAME	Optional	replaces the name and lastname of the individual with the name in the record
IndiSex	INDI:SEX	Optional	replaces the sex of the individual with the sex in the record
IndiBirthDate	INDI:BIRT:DATE	Mandatory	adds (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.
IndiPlace	INDI:BIRT:PLAC	Optional	adds (or replaces) the place of birth.
IndiComment	INDI:NOTE	Optional	adds the comment in the note of the birth of the individual
IndiFatherLastName IndiFatherFirstName	father:NAME	Optional	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.
IndiFatherOccupation	father:OCCU	Optional
IndiFatherDead IndiFatherComment	father:NOTE	Optional
IndiMotherLastName IndiMotherFirstName	mother:NAME	Optional	same algo as for father IndiFatherLastName
IndiMotherOccupation	mother:OCCU	Optional	same algo as for father's profession IndiFatherOccupation
IndiMotherDead IndiMotherComment	mother:NOTE	Optional	same algo as for Father IndiFatherComment
GeneralComment Witness1LastName Witness1FirstName Witness1Occupation Witness1Comment Witness2LastName Witness2FirstName Witness2Occupation Witness2Comment Witness3LastName Witness3FirstName Witness3Occupation Witness3Comment Witness4LastName Witness4FirstName Witness4Occupation Witness4Comment	INDI:BIRT:NOTE	Optional	These fields are concatenated and added in the note of the birth of the individual.
EventPlace	INDI:BIRT:SOUR	Mandatory	searches for the source associated with the common place of birth. Proposes to create a source if there is no corresponding source.
Cote	SOUR:REFN	Optional
Photo	INDI:BIRT:SOUR:NOTE	Optional
Parish	INDI:BIRT:SOUR:NOTE	Optional

 

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)

 

Column	Birth	Marriage	Death	Miscellaneous	Comment
"ANCESTRISV4"	x	x	x	x	version of the format (mandatory)
CityName	x	x	x	x	city name
CityCode					city code
CountyName	x	x	x	x	county name
StateName	x	x	x	x	state name
CountryName	x	x	x	x	country
ParishName	x	x	x	x	parish name
EventType	"N"	"M"	"D"	"V"	event type
EventTypeTag	ignoré	ignoré	ignoré	x	generic event type
EventTypeName	ignoré	ignoré	ignoré	x	description of generic event type
EventDate	x	x	x	x	event date
SecondDate	ignoré	ignoré	ignoré	x	date of insinuation or recording of the event
Cote	x	x	x	x	Register's reference
Freecomment	x	x	x	x	photo or folio number
Notary	ignoré	ignoré	ignoré	x	name of the notary
IndiLastName	x	x	x	x	Name of the : if N: new born, if M: spouse, if D: deceased, if V: speaker n°1
IndiFirstName	x	x	x	x	firstname
IndiSex	x	x	x	x	sex
IndiAge	ignoré	x	x	x	age
IndiBirthDate	x	x	x	x	date of birth . For a birth it is by default the date of the event.
IndiBirthPlace	ignoré	x	x	x	place of birth or place of origin
IndiOccupation	ignoré	x	x	x	occupation
IndiResidence	ignoré	x	x	x	home
IndiComment	x	x	x	x	comment from the individual or speaker no. 1
IndiMarriedLastName	ignoré	x	x	x	former spouse
IndiMarriedFirstName	ignoré	x	x	x	firstname
IndiMarriedSex	ignoré	x	x	x	Ancestris sets IndiMarriedSex with the opposite sex from IndiSex
IndiMarriedDead	ignoré	x	x	x	deceased or not
IndiMarriedOccupation	ignoré	x	x	x	occupation
IndiMariedResidence	ignoré	x	x	x	home
IndiMarriedComment	ignoré	x	x	x	comment of former spouse
IndiFatherLastName	x	x	x	x	father's lastname
IndiFatherFirstName	x	x	x	x	firstname
IndiFatherAge	x	x	x	x	age
IndiFatherDead	x	x	x	x	deceased or not
IndiFatherOccupation	x	x	x	x	occupation
IndiFatherResidence	x	x	x	x	home
IndiFatherComment	x	x	x	x	comment for father
IndiMotherLastName	x	x	x	x	mother's lastname
IndiMotherFirstName	x	x	x	x	firstname
IndiMotherAge	x	x	x	x	age
IndiMotherDead	x	x	x	x	deceased or not
IndiMotherOccupation	x	x	x	x	professionoccupationoccupation
IndiMotherResidence	x	x	x	x	domicilehomehome
IndiMotherComment	x	x	x	x	comment for mother
WifeLastName	ignoré	x	ignoré	x	épousewife (marriage) mariageor ) ou intervenantwitness n°2 (actemiscellaneous divers)acts)
WifeFirstName	ignoré	x	ignoré	x	prénomfirstname
WifeSex	ignoré	ignoré	ignoré	x	sexesex
WifeAge	ignoré	x	ignoré	x	âgeage
WifeBirthDate	ignoré	x	ignoré	x	date de naissancebirthdate
WifePlace	ignoré	x	ignoré	x	lieubirthplace deor naissance ou origineorgine
WifeOccupation	ignoré	x	ignoré	x	professionoccupation
WifeResidence	ignoré	x	ignoré	x	domicilehome
WifeComment	ignoré	x	ignoré	x	commentairecomment deby l'épousethe ouwife deor l'intervenantspeaker n°2
WifeMarriedLastName	ignoré	x	ignoré	x	Ex-conjointspouse deof lathe femmewoman ouor de l'intervenantspeaker n°2
WifeMarriedFirstName	ignoré	x	ignoré	x	prénomfirstname
WifeMarriedSex	ignoré	x	ignoré	x	Ancestris renseignesets WifeMarriedSex avecwith lethe sexeopposite opposésex deof WifeSex
WifeMarriedDead	ignoré	x	ignoré	x	décédédeceased ouor nonnot
WifeMarriedOccupation	ignoré	x	ignoré	x	professionoccupation
WifeMarriedResidence	ignoré	x	ignoré	x	domicilehome
WifeMarriedComment	ignoré	x	ignoré	x	commentairecomment deby l'the woman's ex-conjointspouse deor laspeaker femmeno. ou de l'intervenant n°2
WifeFatherLastName	ignoré	x	ignoré	x	PèreFather deof l'épousethe ouwife deor l'intervenantof the speaker n°2
WifeFatherFirstName	ignoré	x	ignoré	x	prénomfirstname
WifeFatherAge	ignoré	x	ignoré	x	âgeage
WifeFatherDead	ignoré	x	ignoré	x	décédédeceased ouor nonnot
WifeFatherOccupation	ignoré	x	ignoré	x	professionoccupation
WifefatherResidence	ignoré	x	ignoré	x	domicilehome
WifeFatherComment	ignoré	x	ignoré	x	commentairefather's du pèrecommentary
WifeMotherLastName	ignoré	x	ignoré	x	MèreMother deof l'épousewife ouor de l'intervenantspeaker n°2
WifeMotherFirstName	ignoré	x	ignoré	x	prénomfirstname
WifeMotherAge	ignoré	x	ignoré	x	âgeage
WifeMotherDead	ignoré	x	ignoré	x	décédéedeceased ouor nonnot
WifeMotherOccupation	ignoré	x	ignoré	x	professionoccupation
WifeMotherResidence	ignoré	x	ignoré	x	domicilehome
WifeMotherComment	ignoré	x	ignoré	x	commentairemother's de la mèrecommentary
Witness1LastName	x	x	x	x	témoinwitness n°1 ouor parraingodfather
Witness1FirstName	x	x	x	x	prénomfirstname
Witness1Occupation	x	x	x	x	professionoccupation
Witness1Comment	x	x	x	x	commentairecomment dufrom témointhe ouwitness parrainor godfather
Witness2LastName	x	x	x	x	témoinwitness n°2 ouor marrainegodmother
Witness2FirstName	x	x	x	x	prénomfirstname
Witness2Occupation	x	x	x	x	professionoccupation
Witness2Comment	x	x	x	x	commentairecomment dufrom témointhe ouwitness marraineor godmother
Witness3LastName	x	x	x	x	témoinwitness n°3
Witness3FirstName	x	x	x	x	prénomfirstname
Witness3Occupation	x	x	x	x	professionoccupation
Witness3Comment	x	x	x	x	commentairewitness's du témoincomment
Witness4LastName	x	x	x	x	témoinwitness n°4
Witness4FirstName	x	x	x	x	prénomfirstname
Witness4Occupation	x	x	x	x	professionoccupation
Witness4Comment	x	x	x	x	commentairewitness's du témoincomment
GeneralComment	x	x	x	x	commentairegeneral généralcomment
RecordNo	x	x	x	x	numéroregister's du relevénumber

 

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.

 

Column	Birth	Marriage	Death	Miscellaneous	Description	Importing in Ancestris
"NIMEGUEV3"	x	x	x	x	Mandatory
CityCode	x	x	x	x		ignoré
CityName	x	x	x	x
CountyCode	x	x	x	x		Ancestris utilise CountyCode si CountyName est vide
CountyName	x	x	x	x
EventType	"N"	"M"	"D"	"V"	Mandatory	ne doit pas être vide
Date	x	x	x	x
IncompletDate	x	x	x	x
Cote	x	x	x	x
Freecomment	x	x	x	x
EventTypeName				x
EventTypeTag				x
IndiLastName	x	x	x	x
IndiFirstName	x	x	x	x
IndiSex	x		x	x
IndiPlace		x	x	x
IndiBirthDate		x	x	x
IndiAge		x	x	x
IndiComment	x	x	x	x
IndiOccupation		x	x	x
IndiMarriedLastName		x	x	x	ex-conjoint
IndiMarriedFirstName		x	x	x
IndiMarriedComment		x	x	x
IndiMarriedOccupation			x
IndiFatherLastName	x	x	x	x
IndiFatherFirstName	x	x	x	x
IndiFatherComment	x	x	x	x
IndiFatherOccupation	x	x	x	x
IndiMotherLastName	x	x	x	x
IndiMotherFirstName	x	x	x	x
IndiMotherComment	x	x	x	x
IndiMotherOccupation	x	x	x	x
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		x	ex-conjoint
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
Witness1LastName	x	x	x	x	témoin n°1 ou parrain
Witness1FirstName	x	x	x	x
Witness1Comment	x	x	x	x
Witness2LastName	x	x	x	x	témoin n°2 ou marraine
Witness2FirstName	x	x	x	x
Witness2Comment	x	x	x	x
Witness3LastName		x		x
Witness3FirstName		x		x
Witness3Comment		x		x
Witness4LastName		x		x
Witness4FirstName		x		x
Witness4Comment		x		x
GeneralComment	x	x	x	x
RecordNo	x	x	x	x	numéro de relevé

 

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)

 

Column	Birth	Marriage	Death	Miscellaneous	Comment
EventType	"naissance"	"mariage"	"décès"	"contrat de mariage" "testament"	Type d'événement (mandatory)
CountyCode	x	x	x	x	numéro de département
CityName	x			x	nom de la commune
ParishName	x	x	x	x	nom de la paroisse s'il y en a plusieurs dans la commune
NotaryName	ignoré	ignoré	ignoré	x
Cote	x	x	x	x
PhotoNo	x	x	x	x	numéro de photo
Day	x	x	x	x
Month	x	x	x	x
Year	x	x	x	x
IndiLastName	x	x	x	x
IndiFirstName	x	x	x	x
IndiSex	x	x	x	x
IndiAge	ignoré	x	x	x
IndiPlace	ignoré	x	x	x
IndiComment	x	x	x	x	Ecriture : ancestris ajoute la date de naissance, la profession et les informations sur l'ex-conjoint ( pour un relevé de mariage, décès ou divers)
IndiFatherFirstName	x	x	x	x	Lecture : Ancestris utilise le même nom que le fils (IndiLastName)
IndiFatherDead	x	x	x	x
IndiFatherComment	x	x	x	x	Ecriture : ancestris ajoute la profession
IndiMotherLastName	x	x	x	x
IndiMotherFirstName	x	x	x	x
IndiMotherDead	x	x	x	x
IndiMotherComment	x	x	x	x	Ecriture : ancestris ajoute la profession
WifeLastName	ignoré	x	x	x
WifeFirstName	ignoré	x	x	x
WifeDead	ignoré	x	x	x
WifeAge	ignoré	x	x	x
WifePlace	ignoré	x	ignoré	x
WifeComment	ignoré	x	x	x	Ecriture : ancestris ajoute la date de naissance,la profession et les informations sur l'ex-conjoint ( pour un relevé de mariage, décès ou divers)
WifeFatherFirstName	ignoré	x	ignoré	x	Lecture : Ancestris utilise le même nom que la fille (WifeLastName)
WifeFatherDead	ignoré	x	ignoré	x
WifeFatherComment	ignoré	x	ignoré	x
WifeMotherLastName	ignoré	x	ignoré	x
WifeMotherFirstName	ignoré	x	ignoré	x
WifeMotherDead	ignoré	x	ignoré	x
WifeMotherComment	ignoré	x	ignoré	x
Heirs	ignoré	ignoré	ignoré	x	héritiers Lecture : Ancestris ajoute ce champ dans le commentaire général (GeneralComment)
Witness1LastName	x	x	x	x	témoin n°1 ou parrain
Witness1FirstName	x	x	x	x
Witness1Comment	x	x	x	x
Witness2LastName	x	x	x	x	témoin N°2 ou marraine
Witness2FirstName	x	x	x	x
Witness2Comment	x	x	x	x
GeneralComment	x	x	x	x	Ecriture : Ancestris ajoute les 3e et 4e témoins