Menu

Importing a gedcom

Help
josegg
2010-08-25
2013-05-30
  •  josegg

    josegg - 2010-08-25

    Is there anybody can help me with importing a gedcom file?
    I uploaded direcly a gedcom file to a directory I created on the server.  I tried to import this ged com into the PDV.  I tried different gedcom files created from different programs, but I always get nothing when import, even changing settings of time. I did set the permissions to the highest.   The import hangs up, so I can't get PGV to work.
    Thanks for looking into this

     
  • Stephen Arnold

    Stephen Arnold - 2010-08-25

    Josegg
    Once again, you have failed to divulge important information about your system and your configuration which would allow anyone to advise you properly. Without knowing  - its all guesswork.

    System? (Apache 2.2.14, php 5.2.3, MySQL 5.1….etc)
    PGV (version? 4.2.1, 4.2.2, 4.2.3, 4.2.3-svn ?)
    PHP timeout setting in php.ini and in PGV
    Memory devoted to PGV (both system setting and config setting)
    Size of GEDCOM (how many mb?)
    Percentage of import before hanging?

    If the import starts and fails, you probably have one of two problems, a corrupted GEDCOM, or not enough memory.
    After your reply, we'll provide further advice, but with incomplete information it is impossible to give you a well-constructed answer.

    Finally, I have previously provided you with the email addy for sending the GEDCOM to me for review for problems, but we have yet to receive it. mailto:gedcoms - at - myarnolds - dot - com    if you want us to inspect and try an import on our offline system.
    -Stephen

     
  •  josegg

    josegg - 2010-08-25

    I believe I did answer the questions I was asked.
    Iim running PGV 4.2.3
    I already said that I have tried all timeouts: first from 60 sec., then from 5 sec to 200 sec.
    Different percentage of import with different gedcoms., from 9% to 60%
    My gedcoms sizes are from 800KB to 2200KB
    The system is hosted by orgfree.com, and I understand they have the latest versions of Apache, Mysql and php
    I do not know of the memory(system and/or config)
    The gedcom I used was generated by FTM, the one I preffer. I also tried gedcoms generated by PAF, and by Rootsmagic.  All of them came our of different sizes??
    I would try to send you the gedcom in question, which I want to keep private.

     
  • Stephen Arnold

    Stephen Arnold - 2010-08-25

    Josegg sent one GEDCOM. It has 3683 INDI's. Despite several important problems with the GEDCOM (bad formatting - ANSI, not UTF-8, bad tags like SSN as PLAC, and bad date formatting), the GEDCOM imported on my laptop in 155 seconds and on my server in 23 seconds.

    We would suspect that Josegg has insufficient memory allocated to PGV. Use the WIKI to determine how to set the system requirements.
    -Stephen

     
  •  josegg

    josegg - 2010-08-26

    okbigkid,  I noticed that when validating the gedcom, those problems showed up, but PGV said it will correct them.
    in your experience what genealogy  program converts to a good gedcom, or tyhere is a good way to make the gedcom proper?
    When I say that PGV hangs up I meant that waiting 3 hours, nothing has happened, nor any message appeared.
    Where do you change the php execution time of 30 sec/script?

     
  • Gerry Kroll

    Gerry Kroll - 2010-08-26

    We need to find out the execution time and memory limits set by your hosting service.  These limits are absolute, meaning that PhpGedView may request lowering of the limits, but it's not normally allowed to increase them.

    Launch PhpGedView and log in as Administrator.  Access the Admin menu.  Near the top, on the right side, you see the option "PHP information".  Click on this.

    In the output of this PHP Info, look for a line that contains the text "max_execution_time".  Tell us the two values shown.

    Look also for a line that contains the text "memory_limit" and tell us the two values shown.

    If you are not able to get PhpGedView started or you can't access the Admin menu, let us know.  There is another way to get the same information.

     
  • Stephen Arnold

    Stephen Arnold - 2010-08-27

    Jose
    Difference between 'adapting' to your data errors and 'fixing'. How would the program properly guess at what you intended? It will move the data into perhaps a different tag, but it still won't be correct (SSN), it can't add your USA to all your US state addresses, it can't interpret what you meant by the date format you entered. It can correct the ANSI formatting, but that takes a LOT of memory. I gave it 128mb with a pretty fast (dual iCore 5, 2.53) processor. Ideally, you would clean up all this data and fix the file format (UTF-8 to maintain all your accents), before attempting to import into PGV.

    What you may interpret as 'no problem' with other programs may be only complicating the matter, mucking up or trashing your data without your knowing it. GEDitCOM , PGV, and **webtrees{/b] all have a mantra - try their best to do no damage to your underlying data.

    We'll wait for your reply to Gerry's inquiry on your settings.
    -Stephen**

     
  • Gerry Kroll

    Gerry Kroll - 2010-08-27

    Jose, Stephen:
    There's no problem with importing a GEDCOM created by Famly Tree Maker into PGV.  I do that all the time.

    Tell FTM to export the database with the following options:
    (a) Save the file as type GEDCOM
    (b) destination: FTM
    (C) GEDCOM version: 5.5
    (d) Character set: ANSI
    (e) Indent records checkbox: not checked
    (f) Abbreviate tags checkbox: checked

    When importing into PGV, let PGV convert the file character set to UTF-8.  You won't lose your accents.  Also, let PGV correct errors.

    Jose:
    Stephen recommends that you add proper country names to all places.  That is correct.  You might want to do that inside FTM, using FTM's search-and-replace, or you might want to do that with a text editor working on the GEDCOM.  Which you choose to do depends on whether you'll be continuing with FTM or switching to doing everything with PGV.

    I maintain my database with FTM, and use PGV for web publishing and showing media.  I just find FTM's user interface to be more intuitive when I'm entering a bunch of family members.  I'm using FTM 2006 (it works, why update?)

     
  •  josegg

    josegg - 2010-08-27

    Thanks to all of you for the answers, but in a momento of despair I deleted all the PGV folder from the server and try to start all over from the beginnig.  I like the way FTM 2006 does for entering data and also is easier to navigate, so I preffer not to change programs, which otherwise I don´t like how they manage the data, they are too complicated.  My intentions was used the host for showing media for my family members and use FTM to manage the tree.
    I'll try to start from cero, and hopefully now I have more info to rely upon, but I will post if I encounter a problem.  I'm new at this and I'm in the process of learning about publishing, and I have to find time to devote to this.  I do like the way PGV shows the data, and its potential.  I saw myarnolds page and it is very impresive.  I will try to have 3 different families when I'm finish.
    I'll keep you posted.  Thanks

     
  • Gerry Kroll

    Gerry Kroll - 2010-08-27

    Jose:
    Too bad that you deleted your PGV installation and are re-installing everything.  I think it would have been useful to figure out why the Import wasn't working.

     
  •  josegg

    josegg - 2010-09-02

    I'm back after reinstalling PGV in the server.
    In step 4 I set up max memory limit: 128M, and used a 400 sec. to import 800KB gedcom with the following result:  83% imported with 6% of time, In both cases I got the following message:  "Fatal error: Maximum execution time of 15 seconds exceeded in /home/vhosts/joseglez.orgfree.com/PhpGedView/includes/functions/functions_import.php on line 692"
    Then I tried to import another gedcom file (2100KB) with same settings, 400 sec and the process stopped when 34% imported at 6% of the time and the same error message came out.
    It is funny the in all cases the error message came out at 24 sec of the process???
    What should I do to correct the problem?

     
  • Stephen Arnold

    Stephen Arnold - 2010-09-02

    Jose

    Fatal error: Maximum execution time of 15 seconds
    exceeded

    FIX THIS. You'll be unable to use PGV with a PHP script execution limit of 15 second.
    Probably misconfigured in your PHP.INI file, but there is a second setting in the CONFIG.php for PGV.
    Open your ADMIN > PHP INFO and look at your settings (memory and execution settings) to see which is misconfigured. PGV can only assign as much as its given from PHP.

    Also, WHY would you set your script for 400 seconds. Ideally, you should have a 15-30 second setting. Many hosted sites limit scripts to 30 seconds.

    Jose - none of these aggravations would be necessary if you checked conformation to the system requirements before you began.  PGV is quite specific in the WIKI:
    http://wiki.phpgedview.net/en/index.php?title=Installation_Guide_v4.2.x#Requirements

    -Stephen

     
  • Gerry Kroll

    Gerry Kroll - 2010-09-02

    Jose:
    You have not yet revealed the results of the PHP information that I asked you to run (my post, 26 August).

    You will need to talk to your hosting service support.

    Please ask them to increase the execution time limit for PHP scripts from 15 seconds to 60 seconds.  Also, ask them to make sure that the memory limit for PHP scripts is at least 64 Mb, with 128 Mb being MUCH better.

    When the hosting service has increased the execution time limit to 60 seconds, you should set the Import time limit to 55 seconds, so that PhpGedView can pause the Import before the server's time limit runs out.

     
  •  josegg

    josegg - 2010-09-03

    Because I'm new to this I may not understand all the things you tell me to do. but I'll try. 
    I did follow the advise from okbigkid and tried to load the gedcom with a 25 sec time and not automatic continue.  Then the gedcom file was loaded in 55 sec.  So I get it working now, but still I do not know if the settings are Ok, are wrong, or what.
    Php  version on server is 5.2.12
    I asked them to changed the memory limit on php.ini file, to which I do not have access, but I did not get any answers yet.
    I tried to look the ADMIN>PHP INFO and I get this: 

    width="800"pan="3" class="facts_label03"> />ERROR 2: phpinfo() has been disabled for security reasons
    0 Error occurred on in function phpinfo
    1 called from line 49 of file pgvinfo.php

    … so I can not see any other thing.
    Do you have something else to tell me?  
    If I upload a different gedcom file, how can I select the gedcom to use?

     
  • ggpauly

    ggpauly - 2010-09-04

    There are hosting companies that specialize in PGV.  See

    http://wiki.phpgedview.net/en/index.php?title=Web_hosting

     
  • Gerry Kroll

    Gerry Kroll - 2010-09-04

    If they've disabled phpinfo, there's no telling what else has been disabled.  Probably  some functions that are essential to the proper running of PhpGedView have also been disabled.

    Look for a different hosting company.

     
  • Stephen Arnold

    Stephen Arnold - 2010-09-04

    Jose
    If they block phpinfo, they most likely supply you with a different method to check your configuration, perhaps a control panel or other web interface for management of your site?
    Else, they are not very interested in being a supportive provider -> find another.
    -Stephen

     
  •  josegg

    josegg - 2010-09-08

    I'll see what I can do.  My regular work keeps me busy.

     

Log in to post a comment.