I have a problem when importing Gedcom data into a MySQL database. Records from my gedcom file are perfectly imported into the pgv_other and pgv_sources tables but no record is inserted in the pgv_individuals and pgv_families tables.
The import process runs as follows. Messages are displayed apparently until the end of the FAM records is found (Found record xx ID yy Type FAM)
Then a 'Processed file for xx sec' message appears and next the 'Continue adding' button is displayed.
But if I click on this button the process seems to loop and no update of the individuals or families tables occurs.
Any idea about what goes wrong ?
I already had this problem with the 2.53 version but I successfully updated the database after several trials. Now with the 2.60 version I never succeeded in updating my database (several trials with three different Gedcom files).
--
Robert Weinland
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I changed the PHP time limit to a non zero value and doing so I fixed this problem. I suppose you might no longer be interested in the test I could do with your patched importgedcom script.
Do you want I do a test with a 0 value and the patched script ?
--
Robert
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I have a problem when importing Gedcom data into a MySQL database. Records from my gedcom file are perfectly imported into the pgv_other and pgv_sources tables but no record is inserted in the pgv_individuals and pgv_families tables.
The import process runs as follows. Messages are displayed apparently until the end of the FAM records is found (Found record xx ID yy Type FAM)
Then a 'Processed file for xx sec' message appears and next the 'Continue adding' button is displayed.
But if I click on this button the process seems to loop and no update of the individuals or families tables occurs.
Any idea about what goes wrong ?
I already had this problem with the 2.53 version but I successfully updated the database after several trials. Now with the 2.60 version I never succeeded in updating my database (several trials with three different Gedcom files).
--
Robert Weinland
The problem is that you are running out of time when importing your gedcom. First try increasing the PHP Timeout at Admin->Manage Gedcoms->edit.
How far in the process do you get? Do you see a message in bold text "Updating is dead status for INDI" or "Updating family names for FAM"?
--John
Hello John,
The PHP time limit value was set to '0' for the three Gedcom files a long time ago.
The 'Continue Adding' button is displayed before the 'Updating is dead status for INDI' messages that should be displayed and never are.
--
Robert
Hi Robert,
It could be the 0 setting that is causing the problem.
I've uploaded a patched importgedcom.php script for you to try in the patches section. You can download it here:
http://sourceforge.net/tracker/index.php?func=detail&aid=845949&group_id=55456&atid=477081
--John
Hi John,
I changed the PHP time limit to a non zero value and doing so I fixed this problem. I suppose you might no longer be interested in the test I could do with your patched importgedcom script.
Do you want I do a test with a 0 value and the patched script ?
--
Robert
If you have a chance could you do a test with the updated script and the TIME_LIMIT set to 0?
Thanks,
--John
John,
Successful tests for my three GEDCOM files with the patched importgedcom script and a 0 setting of the time limit value.
Many thanks for your help !
--
Robert