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 registerrecord
IndiSex	INDI:SEX	Optional	remplacereplaces lethe sexesex deof l'individuthe parindividual celuiwith duthe relevésex in the record
IndiBirthDate	INDI:BIRT:DATE	Mandatory	ajouteadds (ouor remplace)replaces) lathe individual's date deof naissancebirth dewith l'individu par lathe date deof naissancebirth dufrom relevéthe IndiBirthDate ourecord ,or, siif cettethe dernièrelatter estis vide,blank, parwith lathe event date d'événementfrom duthe relevéEventDate EventDate.record.
IndiPlace	INDI:BIRT:PLAC	Optional	ajouteadds (ouor remplace)replaces) lethe lieuplace deof naissance.birth.
IndiComment	INDI:NOTE	Optional	ajouteadds lethe commentairecomment dansin lathe note deof lathe naissancebirth deof l'individuthe individual
IndiFatherLastName IndiFatherFirstName	father:NAME	Optional	Si l'individu If athe déjàindividual desalready has parents, SiIf l'individuthe n'aindividual pashas deno parents :parents: recherchesearches lesfor famillesfamilies avecwith lesthe mêmessame nomsparents' denames parentsand et avec leswith dates compatiblescompatible avecwith cellethe dedate laof naissancebirth (date deof mariage ,marriage, date deof naissancebirth etand dedeath décèsof desthe parents) S'ilIf enhe has several, they are displayed in a plusieurs,list iland sontthe affichésuser dans une liste et l'utilisateur choisit.chooses. SiIf l'individuthe n'aindividual pasdoes déjànot unalready pèrehave associéan dansassociated lefather gedcomin :the recherchegedcom: lessearches individusfor quiindividuals pourraientwho êtrecould lebe pèrethe father (mêmesame nomsurname etand prénom,first name, date deof naissancebirth etand dedeath décèconsistent with that of the individual's cohérente avec celle de la naissance de l'individu)birth). S'ilIf enhe has several, they are displayed in a plusieurs,list iland sontthe affichésuser danschooses. uneIf listeno etpotential l'utilisateurfather choisit.is Sifound, aucuncreates pèrea potentielnew n'estindividual trouvé,who créewill unbe nouvelthe individufather quiand seracreates lea pèrefamily etwith créethe uneindividual familleas aveca l'individu comme enfant.child.
IndiFatherOccupation	father:OCCU	Optional
IndiFatherDead IndiFatherComment	father:NOTE	Optional
IndiMotherLastName IndiMotherFirstName	mother:NAME	Optional	mêmesame algo queas pourfor le pèrefather IndiFatherLastName
IndiMotherOccupation	mother:OCCU	Optional	mêmesame algo queas pourfor lafather's profession du père IndiFatherOccupation
IndiMotherDead IndiMotherComment	mother:NOTE	Optional	mêmesame algo queas pourfor le commentaire du pèreFather IndiFatherComment
GeneralComment Witness1LastName Witness1FirstName Witness1Occupation Witness1Comment Witness2LastName Witness2FirstName Witness2Occupation Witness2Comment Witness3LastName Witness3FirstName Witness3Occupation Witness3Comment Witness4LastName Witness4FirstName Witness4Occupation Witness4Comment	INDI:BIRT:NOTE	Optional	CesThese champsfields sontare concaténésconcatenated etand ajoutésadded dansin lathe note deof lathe naissancebirth deof l'individuthe individual.
EventPlace	INDI:BIRT:SOUR	Mandatory	recherchesearches lafor the source associéeassociated àwith lathe communecommon lieuplace deof naissance.birth. ProposeProposes deto créercreate unea source s'ilif n'ythere ais pasno decorresponding source correspondante.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 duof the format (mandatory)
CityName	x	x	x	x	nomcity de la communename
CityCode					city code de la commune
CountyName	x	x	x	x	nomcounty ou code de départementname
StateName	x	x	x	x	régionstate ou étatname
CountryName	x	x	x	x	payscountry
ParishName	x	x	x	x	nomparish de la paroisse s'il y en a plusieurs dans la communename
EventType	"N"	"M"	"D"	"V"	event type d'événement (mandatory)
EventTypeTag	ignoré	ignoré	ignoré	x	taggeneric d'unevent type d'événement divers. Ex :PM, TEST, ...
EventTypeName	ignoré	ignoré	ignoré	x	libellédescription associéof augeneric tagevent divers . Ex:: Publication de mariage, Testament, ......type
EventDate	x	x	x	x	event date de l'événement
SecondDate	ignoré	ignoré	ignoré	x	date d'of insinuation ouor d'enregistrementrecording deof l'événementthe event
Cote	x	x	x	x	coteRegister's du registrereference
Freecomment	x	x	x	x	numéro de photo ou deor folio number
Notary	ignoré	ignoré	ignoré	x	nomname duof notairethe notary
IndiLastName	x	x	x	x	Nom du : siName N of the : nouveau if né,N: sinew M :born, époux,if siM: D :spouse, décédé,if siD: V :deceased, intervenantif V: speaker n°1
IndiFirstName	x	x	x	x	prénomfirstname
IndiSex	x	x	x	x	sexesex
IndiAge	ignoré	x	x	x	âgeage
IndiBirthDate	x	x	x	x	date deof naissancebirth . PourFor unea naissancebirth c'estit paris défautby ladefault the date deof l'événement.the event.
IndiBirthPlace	ignoré	x	x	x	lieuplace deof naissancebirth ouor lieuplace d'origineof origin
IndiOccupation	ignoré	x	x	x	professionoccupation
IndiResidence	ignoré	x	x	x	domicilehome
IndiComment	x	x	x	x	commentairecomment defrom l'individuthe ouindividual deor l'intervenantspeaker n°no. 1
IndiMarriedLastName	ignoré	x	x	x	ex-conjointformer spouse
IndiMarriedFirstName	ignoré	x	x	x	prénomfirstname
IndiMarriedSex	ignoré	x	x	x	Ancestris renseignesets IndiMarriedSex avecwith lethe sexeopposite opposésex defrom IndiSex
IndiMarriedDead	ignoré	x	x	x	décédédeceased ouor nonnot
IndiMarriedOccupation	ignoré	x	x	x	professionoccupation
IndiMariedResidence	ignoré	x	x	x	domicilehome
IndiMarriedComment	ignoré	x	x	x	commentairecomment deof l'ex-conjointformer spouse
IndiFatherLastName	x	x	x	x	nomfather's du pèrelastname
IndiFatherFirstName	x	x	x	x	prénomfirstname
IndiFatherAge	x	x	x	x	âgeage
IndiFatherDead	x	x	x	x	décédédeceased ouor nonnot
IndiFatherOccupation	x	x	x	x	professionoccupation
IndiFatherResidence	x	x	x	x	domicilehome
IndiFatherComment	x	x	x	x	commentairecomment dufor pèrefather
IndiMotherLastName	x	x	x	x	nommother's de la mèrelastname
IndiMotherFirstName	x	x	x	x	prénomfirstname
IndiMotherAge	x	x	x	x	âgeage
IndiMotherDead	x	x	x	x	décédéedeceased ouor nonnot
IndiMotherOccupation	x	x	x	x	professionprofessionoccupation
IndiMotherResidence	x	x	x	x	domiciledomicilehome
IndiMotherComment	x	x	x	x	commentairecomment defor la mèremother
WifeLastName	ignoré	x	ignoré	x	épouse ( mariage ) ou intervenant n°2 (acte divers)
WifeFirstName	ignoré	x	ignoré	x	prénom
WifeSex	ignoré	ignoré	ignoré	x	sexe
WifeAge	ignoré	x	ignoré	x	âge
WifeBirthDate	ignoré	x	ignoré	x	date de naissance
WifePlace	ignoré	x	ignoré	x	lieu de naissance ou origine
WifeOccupation	ignoré	x	ignoré	x	profession
WifeResidence	ignoré	x	ignoré	x	domicile
WifeComment	ignoré	x	ignoré	x	commentaire de l'épouse ou de l'intervenant n°2
WifeMarriedLastName	ignoré	x	ignoré	x	Ex-conjoint de la femme ou de l'intervenant n°2
WifeMarriedFirstName	ignoré	x	ignoré	x	prénom
WifeMarriedSex	ignoré	x	ignoré	x	Ancestris renseigne WifeMarriedSex avec le sexe opposé de WifeSex
WifeMarriedDead	ignoré	x	ignoré	x	décédé ou non
WifeMarriedOccupation	ignoré	x	ignoré	x	profession
WifeMarriedResidence	ignoré	x	ignoré	x	domicile
WifeMarriedComment	ignoré	x	ignoré	x	commentaire de l'ex-conjoint de la femme ou de l'intervenant n°2
WifeFatherLastName	ignoré	x	ignoré	x	Père de l'épouse ou de l'intervenant n°2
WifeFatherFirstName	ignoré	x	ignoré	x	prénom
WifeFatherAge	ignoré	x	ignoré	x	âge
WifeFatherDead	ignoré	x	ignoré	x	décédé ou non
WifeFatherOccupation	ignoré	x	ignoré	x	profession
WifefatherResidence	ignoré	x	ignoré	x	domicile
WifeFatherComment	ignoré	x	ignoré	x	commentaire du père
WifeMotherLastName	ignoré	x	ignoré	x	Mère de l'épouse ou de l'intervenant n°2
WifeMotherFirstName	ignoré	x	ignoré	x	prénom
WifeMotherAge	ignoré	x	ignoré	x	âge
WifeMotherDead	ignoré	x	ignoré	x	décédée ou non
WifeMotherOccupation	ignoré	x	ignoré	x	profession
WifeMotherResidence	ignoré	x	ignoré	x	domicile
WifeMotherComment	ignoré	x	ignoré	x	commentaire de la mère
Witness1LastName	x	x	x	x	témoin n°1 ou parrain
Witness1FirstName	x	x	x	x	prénom
Witness1Occupation	x	x	x	x	profession
Witness1Comment	x	x	x	x	commentaire du témoin ou parrain
Witness2LastName	x	x	x	x	témoin n°2 ou marraine
Witness2FirstName	x	x	x	x	prénom
Witness2Occupation	x	x	x	x	profession
Witness2Comment	x	x	x	x	commentaire du témoin ou marraine
Witness3LastName	x	x	x	x	témoin n°3
Witness3FirstName	x	x	x	x	prénom
Witness3Occupation	x	x	x	x	profession
Witness3Comment	x	x	x	x	commentaire du témoin
Witness4LastName	x	x	x	x	témoin n°4
Witness4FirstName	x	x	x	x	prénom
Witness4Occupation	x	x	x	x	profession
Witness4Comment	x	x	x	x	commentaire du témoin
GeneralComment	x	x	x	x	commentaire général
RecordNo	x	x	x	x	numéro du relevé

 

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