Registers records - Appendix

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
IndiBirthPlace	ignoré	x	x	x	place of birth or place of origin
IndiBirthDate	x	x	x	x	date of birth . For a birth it is by default the date of the event.
IndiAge	ignoré	x	x	x	age
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
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	occupation
IndiMotherResidence	x	x	x	x	home
IndiMotherComment	x	x	x	x	comment for mother
WifeLastName	ignoré	x	ignoré	x	wife (marriage) or witness n°2 (miscellaneous acts)
WifeFirstName	ignoré	x	ignoré	x	firstname
WifeSex	ignoré	ignoré	ignoré	x	sex
WifePlace	ignoré	x	ignoré	x	birthplace or orgine
WifeBirthDate	ignoré	x	ignoré	x	birthdate
WifeAge	ignoré	x	ignoré	x	age
WifeOccupation	ignoré	x	ignoré	x	occupation
WifeResidence	ignoré	x	ignoré	x	home
WifeComment	ignoré	x	ignoré	x	comment by the wife or speaker n°2
WifeMarriedLastName	ignoré	x	ignoré	x	Ex-spouse of the woman or speaker n°2
WifeMarriedFirstName	ignoré	x	ignoré	x	firstname
WifeMarriedDead	ignoré	x	ignoré	x	deceased or not
WifeMarriedOccupation	ignoré	x	ignoré	x	occupation
WifeMarriedResidence	ignoré	x	ignoré	x	home
WifeMarriedComment	ignoré	x	ignoré	x	comment by the woman's ex-spouse or speaker no. 2
WifeFatherLastName	ignoré	x	ignoré	x	Father of the wife or of the speaker n°2
WifeFatherFirstName	ignoré	x	ignoré	x	firstname
WifeFatherAge	ignoré	x	ignoré	x	age
WifeFatherDead	ignoré	x	ignoré	x	deceased or not
WifeFatherOccupation	ignoré	x	ignoré	x	occupation
WifefatherResidence	ignoré	x	ignoré	x	home
WifeFatherComment	ignoré	x	ignoré	x	father's commentary
WifeMotherLastName	ignoré	x	ignoré	x	Mother of wife or speaker n°2
WifeMotherFirstName	ignoré	x	ignoré	x	firstname
WifeMotherAge	ignoré	x	ignoré	x	age
WifeMotherDead	ignoré	x	ignoré	x	deceased or not
WifeMotherOccupation	ignoré	x	ignoré	x	occupation
WifeMotherResidence	ignoré	x	ignoré	x	home
WifeMotherComment	ignoré	x	ignoré	x	mother's commentary
Witness1LastName	x	x	x	x	witness n°1 or godfather
Witness1FirstName	x	x	x	x	firstname
Witness1Occupation	x	x	x	x	occupation
Witness1Comment	x	x	x	x	comment from the witness or godfather
Witness2LastName	x	x	x	x	witness n°2 or godmother
Witness2FirstName	x	x	x	x	firstname
Witness2Occupation	x	x	x	x	occupation
Witness2Comment	x	x	x	x	comment from the witness or godmother
Witness3LastName	x	x	x	x	witness n°3
Witness3FirstName	x	x	x	x	firstname
Witness3Occupation	x	x	x	x	occupation
Witness3Comment	x	x	x	x	witness's comment
Witness4LastName	x	x	x	x	witness n°4
Witness4FirstName	x	x	x	x	firstname
Witness4Occupation	x	x	x	x	occupation
Witness4Comment	x	x	x	x	witness's comment
GeneralComment	x	x	x	x	general 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.

 

Column	Birth	Marriage	Death	Miscellaneous	Description	Importing in Ancestris
"NIMEGUEV3"	x	x	x	x	Mandatory
CityCode	x	x	x	x		ignored
CityName	x	x	x	x
CountyCode	x	x	x	x		Ancestris uses CountyCode if CountyName is empty
CountyName	x	x	x	x
EventType	"N"	"M"	"D"	"V"	Mandatory	Cannot be empty
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-spouse
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-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
Witness1LastName	x	x	x	x	witness n°1 or godfather
Witness1FirstName	x	x	x	x
Witness1Comment	x	x	x	x
Witness2LastName	x	x	x	x	witness n°2 or godmother
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	register'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)

 

Column	Birth	Marriage	Death	Miscellaneous	Comment
EventType	"birth"	"marriage"	"death"	"marriage contract" "will"	Event type (mandatory)
CountyCode	x	x	x	x	county code
CityName	x			x	city name
ParishName	x	x	x	x	parish name if there is more than one in the city
NotaryName	ignored	ignored	ignored	x
Cote	x	x	x	x
PhotoNo	x	x	x	x	photo number
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	ignored	x	x	x
IndiPlace	ignored	x	x	x
IndiComment	x	x	x	x	Writing: ancestris adds the date of birth, occupation and information on the former spouse (for a marriage, death or miscellaneous record).
IndiFatherFirstName	x	x	x	x	Reading: Ancestris uses the same name as the son (IndiLastName)
IndiFatherDead	x	x	x	x
IndiFatherComment	x	x	x	x	Writing: Ancestris adds occupation
IndiMotherLastName	x	x	x	x
IndiMotherFirstName	x	x	x	x
IndiMotherDead	x	x	x	x
IndiMotherComment	x	x	x	x	Writing: Ancestris adds profession
WifeLastName	ignored	x	x	x
WifeFirstName	ignored	x	x	x
WifeDead	ignored	x	x	x
WifeAge	ignored	x	x	x
WifePlace	ignored	x	ignored	x
WifeComment	ignored	x	x	x	Writing: Ancestris adds the date of birth, profession and information on the former spouse (for a marriage, death or miscellaneous record).
WifeFatherFirstName	ignored	x	ignored	x	Reading: Ancestris uses the same name as the girl (WifeLastName)
WifeFatherDead	ignored	x	ignored	x
WifeFatherComment	ignored	x	ignored	x
WifeMotherLastName	ignored	x	ignored	x
WifeMotherFirstName	ignored	x	ignored	x
WifeMotherDead	ignored	x	ignored	x
WifeMotherComment	ignored	x	ignored	x
Heirs	ignored	ignored	ignored	x	heirs Reading: Ancestris adds this field in the general comment (GeneralComment)
Witness1LastName	x	x	x	x	witness n°1 or godfather
Witness1FirstName	x	x	x	x
Witness1Comment	x	x	x	x
Witness2LastName	x	x	x	x	witness n°2 or godmother
Witness2FirstName	x	x	x	x
Witness2Comment	x	x	x	x
GeneralComment	x	x	x	x	Writing: Ancestris adds the 3rd and 4th witnesses