Jump to content
TNG Community

Problem with eventdate, eventdatetr and eventplace being empty during import


Jan Wessel

Recommended Posts

Problem with eventdate, eventdatetr and eventplace being empty during import

I have imported a gedcom file into TNG.
Now I noticed that on an individuals page the events like BIRTh, OCCUpation, RESIdence, EDUCation  and DEATh are neatly presented in chronological order.
However the events that have the tag "EVEN" in the admin's Custom Event Types pages are presented on the individual's page in a random order.

So I looked in the tng_events table and noticed that the columns eventdate  and eventplace are empty and eventdatetr is set to a default value of "0000-00-00" for all rows that contain the tag EVEN.

I checked the file gedimport_misc.php contains this piece of code:
$query = "INSERT INTO $events_table (eventtypeID, persfamID, eventdate, eventdatetr, eventplace, age, agency, cause, addressID, parenttag, info, gedcom)  VALUES(\"$eventtypeID\", \"$persfamID\", \"" . $eventptr['DATE'] . "\", \"" . $eventptr['DATETR'] . "\", \"" . $eventptr['PLAC'] . "\", \"" . $eventptr['AGE'] . "\", \"" . $eventptr['AGNC'] . "\", \"" . $eventptr['CAUS'] . "\", \"" . $eventptr['ADDR'] . "\",  \"" . $eventptr['parent'] . "\", \"$eventinfo\", \"$tree\")";

I then put in some echo statements and concluded that during import the variables 
$evendate , $eventdatetr, $eventplace
are empty.

One can change and update those events using the Edit Existing Person , Other Events table, but this seems a bit cumbersome as I have hundreds of those events.

My question, has anyone seen this behaviour and more important, has anyone got a solution for me?

Thanks 

Jan Wessel

P.s. I did send an email to Darrin some weeks ago, but have not had a reply from him yet.
 

Link to comment
Share on other sites

Hi,

Maybe it's something to do with the way that the gedcom is structured or how the variables are named (not compatible with TNG)?

You could see if this is so and then try editing the gedcom before import so that it is more compatible with TNG.

There are word processor programs out there where you can change all instances of a certain phase or terminology with another.

Link to comment
Share on other sites

Hi Merv,

Thx for responding.

This is a piece of the GEDCOM file with an event and residence.

The date and place of the EVEN are not, and the date and place of the RESI are correctly imported.

Seems pretty GEDCOM 5.5 or 5.5.1 to me. But maybe not, please tell me where I am wrong.

1 EVEN
2 DATE FROM 8 OCT 1924 TO 8 NOV 1924
2 PLAC Netherlands
3 _GPS 52.152355,5.292970
3 NOTE @N1102@
2 TYPE ss Kon. der Nederlanden
2 OBJE
3 TITL Baars_F_L-1924-passlijst-KonderNederlanden.jpg
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Baars_F_L-1924-passlijst-KonderNederlanden.jpg
3 FORM jpg
2 NOTE @N609@
1 RESI
2 DATE FROM 8 NOV 1924 TO 28 FEB 1925
2 PLAC Netherlands
3 _GPS 52.152355,5.292970
3 NOTE @N1102@
1 EVEN
 

Jan

Link to comment
Share on other sites

Hi, To be honest, it's a little foreign to me. Others here may be able to advise you better.

Have you got the piece of code from 0 to 0? (Which is the entire code for the individual) This would give a better idea of how individuals are structured within the gedcom file.

Link to comment
Share on other sites

Hi, yes I have, it's a lot though.

Although there is only 1 individual in the GEDCOM file.

Hope someone can point me in the right direction.

 

0 @I5@ INDI
1 NAME Hannie  /Baars/
1 SEX F
1 RESI
2 DATE 5 NOV 1918
2 PLAC Yogyakarta, Kodya Yogyakarta, Special Region of Yogyakarta, Indonesia
3 _GPS -7.800485,110.363895
2 AGE 0
1 BIRT
2 DATE 5 NOV 1918
2 PLAC Yogyakarta, Kodya Yogyakarta, Special Region of Yogyakarta, Indonesia
3 _GPS -7.800485,110.363895
1 OBJE
2 TITL Baars_Hannie_1918-portrait-1962.jpg
2 _DATE 1962
2 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Baars_Hannie_1918-portrait-1962.jpg
2 FORM jpg
2 _KEY 6101A; Hannie (1918) Baars; Pieter Langendijkstraat
1 OBJE
2 TITL Braam_H_van-1937-passagier-Baloeran-6-jul-1937.jpg
2 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_H_van-1937-passagier-Baloeran-6-jul-1937.jpg
2 FORM jpg
1 OBJE
2 TITL Braam_H_van-1946-JvanOldenbarnevelt.jpg
2 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_H_van-1946-JvanOldenbarnevelt.jpg
2 FORM jpg
1 OBJE
2 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_Henriette_van_1895-met -Hannie-1919.jpg
2 TITL Braam_Henriette_van_1895-met -Hannie-1919.jpg
2 _DATE ABT 1919
2 FORM jpg
2 _LOC Malang
2 _KEY Hannie (1918) Baars; Henriette (Jet) (1895) van Braam
1 OBJE
2 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_Henriette_van_1895-met-kleinkinderen-Hannie-abt-1953.jpg
2 TITL Braam_Henriette_van_1895-met-kleinkinderen-Hannie-abt-1953.jpg
2 FORM jpg
2 _KEY Hannie (1918) Baars; Henriette (Jet) (1895) van Braam; Jan Hendrik (1925) Wessel; Loekie (1947) Groesgen; Robert Hans Groesgen (1950); Wenda Groesgen (1948)
1 CHAN
2 DATE 3 FEB 2018
3 TIME 00:01:10
1 _GCID 7E581D56-446A-40AB-BE63-32A87057E170
1 RESI
2 DATE FROM 6 NOV 1918 TO 1 SEP 1922
2 PLAC (Suikerfabriek Medarie) Sleman, Sleman, Special Region of Yogyakarta, Indonesia
3 _GPS -7.702540,110.337025
3 NOTE @N960@
2 AGE 0 to 4
1 RESI
2 DATE 1 SEP 1922
2 PLAC Situbondo, Situbondo, East Java, Indonesia
3 _GPS -7.703900,114.011940
1 RESI
2 DATE 20 MAY 1923
2 PLAC Jendogo of eigenlijk Tjindaga
3 _GPS -7.874190,113.914520
1 RESI
2 DATE 20 MAY 1923
2 PLAC Jendogo of eigenlijk Tjindaga
3 _GPS -7.874190,113.914520
2 NOTE @N950@
2 OBJE
3 TITL Cindogo of Tjindaga of ook Jendogo of Tjendogo
3 FILE http://ubl.webattach.nl/cgi-bin/iipview?krtid=10505&name=05120-438.JPG&marklat=-7.8793&marklon=113.8991&sid=ds6ijk5064888&seq=6&serie=1&lang=1&ssid=&resstrt=0&svid=546181&dispx=1407&dispy=1519#focus
3 FORM url
1 EVEN
2 DATE FROM 8 OCT 1924 TO 8 NOV 1924
2 PLAC Netherlands
3 _GPS 52.152355,5.292970
3 NOTE @N1102@
2 TYPE ss Kon. der Nederlanden
2 OBJE
3 TITL Baars_F_L-1924-passlijst-KonderNederlanden.jpg
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Baars_F_L-1924-passlijst-KonderNederlanden.jpg
3 FORM jpg
2 NOTE @N609@
1 RESI
2 DATE FROM 8 NOV 1924 TO 28 FEB 1925
2 PLAC Netherlands
3 _GPS 52.152355,5.292970
3 NOTE @N1102@
1 EVEN
2 DATE FROM 28 FEB 1925 TO 10 APR 1925
2 PLAC Indonesia
3 _GPS -2.464561,117.995819
3 NOTE @N1099@
2 TYPE ss Kon. der Nederlanden
2 OBJE
3 TITL Baars_F_L-1925-passlijst-KonderNederlanden.jpg
3 _DATE FROM 8 FEB 1925 TO 3 APR 1925
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Baars_F_L-1925-passlijst-KonderNederlanden.jpg
3 FORM jpg
1 RESI
2 DATE FROM MAY 1925 TO AUG 1926
2 PLAC Batavia (Current Jakarta)
3 _GPS -6.182250,106.836605
2 AGE 7
2 OBJE
3 TITL Batavia-1947.jpg
3 _DATE 1947
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Batavia-1947.jpg
3 FORM jpg
1 EVEN
2 DATE FROM 1926 TO 15 SEP 1926
2 PLAC The Hague, South Holland, Netherlands
3 _GPS 52.071485,4.309895
2 TYPE ss Slamat
2 ADDR Vertrek Batavia - aankomst Rotterdam
1 RESI
2 DATE FROM 15 OCT 1926 TO 11 FEB 1929
2 PLAC Nymegen, Nijmegen, Gelderland, Netherlands
3 _GPS 51.839325,5.848785
3 NOTE @N965@
2 ADDR St Annastraat 348
2 AGE 8
2 OBJE
3 TITL St Annastraat 348 in Nijmegen (Foto gemaakt in 1927) 
3 _DATE 1927
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_Henriette_van-1927-St_Annastraat_348-Oma.jpg
3 FORM jpg
2 OBJE
3 TITL St Annastraat 342 in Nijmegen (Foto gemaakt in 2016 door Google) ; straat is hernummerd, voorheen was het nummer 348.
3 _DATE 2016
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_Henriette_van-2016-St_Anna_straat-342-Google.jpg
3 FORM jpg
2 OBJE
3 TITL Archief Nijmegen; ANNASTRAAT ST_342_ (voorheen 348)
3 _DATE 1926
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_H_van-1926-ANNASTRAAT ST_342_V_00000395.JPG
3 FORM JPG
2 OBJE
3 TITL Adresboek Nijmegen 1928 (Braam_Henriette)
3 _DATE 1928
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Braam_Henriette_van-1928-Adresboek-Nijmegen.jpg
3 FORM jpg
1 EVEN
2 DATE FROM 12 FEB 1929 TO 16 MAR 1929
2 PLAC Batavia (Current Jakarta)
3 _GPS -6.182250,106.836605
2 TYPE ss Kon. der Nederlanden
2 ADDR Aankomst in Tandjong Priak
1 EVEN
2 DATE 21 FEB 1929
2 PLAC Nymegen, Nijmegen, Gelderland, Netherlands
3 _GPS 51.839325,5.848785
3 NOTE @N965@
2 AGE 10
2 TYPE Ontmoeting
2 ADDR Station Nijmegen
2 OBJE
3 TITL Nijmgen-1929-Station-ontm-div-familie-1.jpg
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Nijmgen-1929-Station-ontm-div-familie-1.jpg
3 FORM jpg
2 OBJE
3 TITL Nijmgen-1929-Station-ontm-div-familie-2.jpg
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Nijmgen-1929-Station-ontm-div-familie-2.jpg
3 FORM jpg
1 RESI
2 DATE FROM MAR 1929 TO 1935
2 PLAC Bandoeng
3 _GPS -6.903375,107.644783
1 EVEN
2 DATE FROM 7 JUL 1937 TO 28 JUL 1937
2 PLAC Marseille, Bouches-du-Rhone, Provence-Alpes-Cote d'Azur, France
3 _GPS 43.306584,5.429320
2 TYPE ms Baloeran
2 ADDR Vertrek Tandjong Priok - Aankomst Marseille
3 CONT Verder per Rotterdam LLoyd Rapide 
3 CONT Aankomst Rotterdam 29 jul 1937
1 RESI
2 DATE FROM 28 JUL 1937 TO MAY 1938
2 PLAC The Hague, South Holland, Netherlands
3 _GPS 52.071485,4.309895
2 ADDR Beukstraat 2
3 CONT (vlgens Bartjes)
2 NOTE @N603@
1 EVEN
2 DATE FROM 29 JUN 1938 TO 28 JUL 1938
2 PLAC Indonesia
3 _GPS -2.464561,117.995819
3 NOTE @N1099@
2 TYPE ms Sibajak
2 ADDR Vertrek Rotterdam aankomst Tandjong Priak
3 CONT H. Baaars-van Braam met kinderen
1 RESI
2 DATE EST AUG 1938
2 PLAC Bogor, Kotamadya Bogor, West Java, Indonesia
3 _GPS -6.591140,106.791088
2 ADDR Schenk de Jongweg 8
2 AGE 19
2 NOTE @N581@
2 SOUR @SR3@
1 EDUC Rijbewijs A
2 DATE 5 MAY 1939
2 PLAC Bogor, Kotamadya Bogor, West Java, Indonesia
3 _GPS -6.591140,106.791088
2 ADDR Schenk de Jongweg 8
2 NOTE @N582@
2 SOUR @SR3@
1 EDUC Typediploma Handelstypiste
2 DATE 10 MAY 1939
2 OBJE
3 TITL Baars_H-1939-typediploma-1939.jpg
3 _DATE 1939
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Baars_H-1939-typediploma-1939.jpg
3 FORM jpg
2 OBJE
3 TITL Baars_H-1939-typediploma.jpg
3 _DATE 1939
3 FILE /Users/imacjan/Data/Gynealogie/GEDitCOM-II-files/Wessel_Family/Fam_Wessel/Multi_Media/Baars_H-1939-typediploma.jpg
3 FORM jpg
1 RESI
2 DATE FROM 28 DEC 1939
2 PLAC Batavia (Current Jakarta)
3 _GPS -6.182250,106.836605
2 ADDR Laan Holle 11
1 EVEN
2 DATE FROM 25 JUL 1946 TO 23 AUG 1946
2 PLAC Netherlands
3 _GPS 52.152355,5.292970
3 NOTE @N1102@
2 AGE 28
2 TYPE ms J.van Oldenbarnevelt
2 ADDR Vertrek T.Priok - aankomst Amsterdam
1 RESI
2 DATE 23 AUG 1946
2 PLAC The Hague, South Holland, Netherlands
3 _GPS 52.071485,4.309895
2 ADDR Frederik Hendrikplein 29
1 RESI
2 DATE EST 1950
2 PLAC The Hague, South Holland, Netherlands
3 _GPS 52.071485,4.309895
2 ADDR van Swietenstraat 140
2 NOTE @N599@
1 EVEN
2 DATE 31 MAR 1950
2 PLAC The Hague, South Holland, Netherlands
3 _GPS 52.071485,4.309895
2 TYPE Marriage
1 RESI
2 DATE EST 1952
2 PLAC The Hague, South Holland, Netherlands
3 _GPS 52.071485,4.309895
2 ADDR Pieter Langendijkstraat 422
1 RESI
2 DATE EST 1966
2 PLAC Rijswijk, South Holland, Netherlands
3 _GPS 52.037224,4.325275
2 ADDR Ocarinalaan 124
1 RESI
2 DATE EST 1977
2 PLAC Hoogezand, Hoogezand-Sappemeer, Groningen, Netherlands
3 _GPS 53.164721,6.750755
1 DEAT
2 DATE 4 JAN 1994
2 PLAC Haren, Haren, Groningen, Netherlands
3 _GPS 53.172331,6.612280
0 @N950@ NOTE
1 CONC 2016 : Geboorte Adriaan Francois
1 CONT 2017: Moet zijn geboorte Nora Leonie
1 REFN 14 JUN 2016 11:46:16
2 TYPE Creation Date
1 _GCID 4AACD36E-2DEE-42A3-A49C-AB7BC12AB66B
1 CHAN
2 DATE 6 SEP 2017
3 TIME 11:37:21
0 @N609@ NOTE
1 CONC 8 oct 1924 vertrek Tandjong Priok
1 CONT 10 oct 1924 vertrek Singapore
1 CONT 11 oct 1924 vertrek Padang
1 CONT 12 oct 1924 vertrek Belawan
1 CONT 14 oct 1924 vertrek Sabang
1 CONT 16 oct 1924 vertrek Colombo
1 CONT 17 oct 1924 vertrek Perim
1 CONT 31 oct 1924 verwacht te Genua
1 CONT 8 nov 1924 verwacht te Amsterdam
1 CONT
1 CONT Aldus diverse Scheepsmeldingen in diverse kranten
1 REFN 4 MAR 2016 12:21:13
2 TYPE Creation Date
1 _GCID 7A837425-8DF2-4985-AE0C-35474737CC1D
1 CHAN
2 DATE 4 MAR 2016
3 TIME 12:27:13
0 @N603@ NOTE
1 CONC 6 dec 1937
1 CONT Stichting "Onderling Pensioenfonds" stuurt brief aan 
1 CONT Wed. H. Baars- van Braam
1 CONT Beukstraat 2
1 CONT Den Haag
1 CONT
1 CONT
1 REFN 3 MAR 2016 11:49:51
2 TYPE Creation Date
1 _GCID 07E48A46-0C84-47B6-9881-56EDE66FC777
1 CHAN
2 DATE 3 MAR 2016
3 TIME 11:51:31
0 @N581@ NOTE
1 CONC Volgens bijschrift bij foto in fotoarchief ....
1 REFN 29 FEB 2016 20:23:04
2 TYPE Creation Date
1 _GCID 3489128A-8F79-4192-BA8E-1ACB16BA8A72
1 CHAN
2 DATE 29 FEB 2016
3 TIME 20:27:11
0 @N582@ NOTE
1 CONC Rijbewijs in fotoarchief J.H. Wessel
1 REFN 29 FEB 2016 20:48:47
2 TYPE Creation Date
1 _GCID 4A12D197-0F0E-4BAE-B397-33E12E1D9CCD
1 CHAN
2 DATE 29 FEB 2016
3 TIME 20:49:11
0 @N599@ NOTE
1 CONC Confrom een brief van de voogdijraad betr. alimentaite dd 29 nov 1950
1 REFN 3 MAR 2016 09:09:44
2 TYPE Creation Date
1 _GCID F9204069-8348-4752-BD66-3953A09E3C7A
1 CHAN
2 DATE 3 MAR 2016
3 TIME 09:10:33
1 SOUR @SR3@
0 @SR3@ SOUR
1 TITL Archief J.H. Wessel (1953)
1 AUTH J.H. Wessel
1 REFN 29 FEB 2016 16:43:39
2 TYPE Creation Date
1 _GCID 8D827322-1C05-4669-8EA9-95A62072B664
1 CHAN
2 DATE 13 APR 2016
3 TIME 14:00:25
0 TRLR
 

Link to comment
Share on other sites

The problem looks to be that the 1 EVEN line is not immediately followed by the 2 TYPE line.  Since TNG does not know what type of event it is until it sees this line, it is ignoring the lines between 1 EVEN and the 2 TYPE.  BIRT, RESI, EDUC, and DEAT are standard tags for standard events, so they are being pulled in as expected.

Link to comment
Share on other sites

bhemph,

Great!

I changed the order of the lines and that did most of the trick.

Now I have something to go on. Need to tweak my inputfile so that lines are in the correct order for TNG to process.

Tweaking so that also ADDR and AGE are processed correctly.

Thanks again, happy customer again.......

 

Jan

 

 

Link to comment
Share on other sites

Yeah, I fixed it. I apparently have not been programming PHP for a long time, it took longer than expected.

Created a PHP-script to convert my outputfile from GeditIICom to an inputfile that TNG can correctly process.

This results in all events (1 EVEN) to be presented in chronological order on an individual’s page.

Thanks all who responded,

Jan

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...