Comments for Luventas Web Design Blog

Comment on Create a database from your GEDCOM file, PHP Version by René Janssen

René Janssen — Wed, 22 Feb 2012 17:09:10 +0000

hi Carsten,
What i mean is this.
I use the dutch program Alfaer to import the gedcom file.
for every birth, bapt, death and marriage are sources available. like this one 2 SOUR @S274@
You need to create extra colums in the person_st and one in the family tabel. example Birth_source, bapt_source.
After this is done there is to create another tabel because every source has an description
For @S274 is this
0 @S274@ SOUR
1 TEXT
2 CONC Bidprentje
In this example it means a Death source

Another thing what’s going wrong is the death date. if there’s no death date the program used this date
2 DATE 26 MAR 2010

0 @I5320@ INDI
1 RIN 5320
1 REFN 743
1 NAME Aldegundis Joannes/van der Aa/
1 SEX F
1 DEAT
1 FAMS @F1269610238@
1 _NEW
2 TYPE 1
2 DATE 26 MAR 2010
3 TIME 14:58:12
1 CHAN
2 DATE 17 MAR 2011
3 TIME 13:24:26

René

Comment on Create a database from your GEDCOM file, PHP Version by Jos Reintjens

Jos Reintjens — Tue, 14 Feb 2012 14:53:04 +0000

Hello, I found the problem. The memory_limit in the php.ini was set on 128M. I chenged it in 256M and it works great. Carsten Thank you for your help.
Greetings Jos Reintjens

Comment on Create a database from your GEDCOM file, PHP Version by luventas

luventas — Mon, 13 Feb 2012 21:02:39 +0000

I tried it with the original data of Jos and found no problem. It seems to be a problem of the configuration of the system.

Comment on Create a database from your GEDCOM file, PHP Version by Jos Reintjens

Jos Reintjens — Fri, 10 Feb 2012 21:49:51 +0000

Hello Carsten
I put the original script back. I loaded the file with 23000 persons. It worked. I took the file with 25000 persons, and got the same problem.

Start reading GEDCOM file
Start reading Person data
Start reading family data

Then I took the total file with 26000+, and I had the next screen writing:
Start reading GEDCOM file

Nothing more. I’m not a programmer only a guy who likes to do some coding. I’m out of solutions. Thank for your time and help. If you know something pease help me i’m out of solutions.

Greetings
Jos Reintjens

Comment on Create a database from your GEDCOM file, PHP Version by luventas

luventas — Fri, 10 Feb 2012 12:47:21 +0000

Hi Jos,

you changed the DB-column names in your insert statment. Do you also changed the names of the columns in your MySQL DB?
Original was:
DROP TABLE IF EXISTS `person_st`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_st` (
`persID` varchar(40) NOT NULL DEFAULT ”,
`name` varchar(255) DEFAULT NULL,
`vorname` varchar(255) DEFAULT NULL,
`marname` varchar(255) DEFAULT NULL,
`sex` char(1) DEFAULT NULL,
`birt_date` varchar(255) DEFAULT NULL,
`birt_plac` varchar(255) DEFAULT NULL,
`taufe_date` varchar(255) DEFAULT NULL,
`taufe_plac` varchar(255) DEFAULT NULL,
`deat_date` varchar(255) DEFAULT NULL,
`deat_plac` varchar(255) DEFAULT NULL,
`buri_date` varchar(255) DEFAULT NULL,
`buri_plac` varchar(255) DEFAULT NULL,
`occupation` varchar(255) DEFAULT NULL,
`occu_date` varchar(255) DEFAULT NULL,
`occu_plac` varchar(255) DEFAULT NULL,
`religion` varchar(80) DEFAULT NULL,
`confi_date` varchar(255) DEFAULT NULL,
`confi_plac` varchar(255) DEFAULT NULL,
`note` longtext,
PRIMARY KEY (`persID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

You have to change this also to:
DROP TABLE IF EXISTS `person_st`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_st` (
`record` varchar(40) NOT NULL DEFAULT ”,
`Achternaam` varchar(255) DEFAULT NULL,
`voornaam` varchar(255) DEFAULT NULL,
`marname` varchar(255) DEFAULT NULL,
`Geslacht` char(1) DEFAULT NULL,
`Geboortedatum` varchar(255) DEFAULT
etc.

And also the column name are needed in the whole application. Mybe it is better to leve the DB clumn names like they are. How they are named in view on website is not related to the DB column name.

Hope, this will help you.

Greetings
Carsten Fröhlich

Comment on Create a database from your GEDCOM file, PHP Version by Jos Reintjens

Jos Reintjens — Thu, 09 Feb 2012 22:27:42 +0000

Hello Carsten.
I made the time inputs larger. but it didn’t help.
I’ve got the next screen writings:

Start reading GEDCOM file
Start reading Person data
Start reading family data

Then it stops.

The apache time limits are set to:
Keep-alive timeout 500 (coming from 5)
Request timeout 1000 (coming from 300)

I did some changes to the script but i don’t think that’s the problem. The changes are:

## create single insert statement
$insert = “INSERT INTO person_st (`record`, `Achternaam`, `voornaam`, `marname`, `Geslacht`, `Geboortedatum`, `Geboorteplaats`, “;
$insert .= “`Doopdatum`, `Doopplaats`, `Overlijdendatum`, `Overlijdenplaats`, `Begrafenisdatum`, `Begrafenisplaats`, “;
$insert .= “`Beroep`, `occu_date`, `occu_plac`, `Gezindte`, `confi_date`, `confi_plac`, `Persooninfo`) “;

I hope you can point me to the problem.

Thanks Jos Reintjens

Comment on Create a database from your GEDCOM file, PHP Version by luventas

luventas — Thu, 09 Feb 2012 20:43:39 +0000

Hi Jos,

26000 Persons is really a lot, but I do not included a maximum value in the script. Maybe you have to extend your Apache settings. Normally there is a maximum time included, how long a script can run. I think, you reach this time limit with the 23000 Persons. If you run the script on your local system or on a server where you are able to administrate, then try to extend this time limit and test it again.

Greetings
Carsten Fröhlich

Comment on Create a database from your GEDCOM file, PHP Version by luventas

luventas — Thu, 09 Feb 2012 20:39:19 +0000

In which table should I add it? Sorry, but I do not understand this hint. Please explain it a bit more…

Comment on Create a database from your GEDCOM file, PHP Version by Jos Reintjens

Jos Reintjens — Thu, 09 Feb 2012 16:59:20 +0000

The script works for me until 22500 persons, with 25000 is doesn’t work any more. Is there a maximum in the script or is there another problem. I’am working on a webprogram for myself and got more than 26000 persons in my database. Is there a solution for the problem?
Greetings Jos Reintjens

Comment on Create a database from your GEDCOM file, PHP Version by rené janssen

rené janssen — Sat, 04 Feb 2012 16:35:44 +0000

Hi Carsten,
Nice tool you made here. I wonder if you compleet this tool by adding the sources in a tabel. That would be great.

René