Jump to content
TNG Community

Gedcom Import doesn't get past "Opening"


rfj1001

Recommended Posts

I've just upgraded to rhe latest version of TNG and am taking the opportunity to upload and update my gedcom file and images since I last did a similar update about a year ago.

My main family history program is Family Historian and I used a pluig-in to create a gedcom file in utf8 format with specific settings for TNG. That I uploaded to my website by ftp.  (The file comprises about 15,000 individual records and is about 19M in size.)

On the gedcom import screen, I can select the required file, it is imported into the main tree and I have the Replace option set to Matching Records only.

As soon as I click on the Import Data Button, I get the message 'Opening' followed by the expected filename. I've fila attached a screenshot.

There's no progress bar showing, all there is is a spinning circle.   .. and it will be like that 2 hours later.

I'm assuming that's not correct.

Would be grateful for any assistance in getting the import working

Many thanks.

Rob

 

 

 

1.jpg

Link to comment
Share on other sites

have your imported files of this size before on this server? also are you importing from a file on the server or are you uploading a local file?

Link to comment
Share on other sites

I have this problem on occasions depending on the PHP/Apache version. What are you using?

Link to comment
Share on other sites

Brett/KevyNC

Thanks for the replies.

I'm running PHP 7.4.16, no version number for Apache. The setup/diagnositcs screen is showing all greens (acceptable)  in relation to the website environment checks done by TNG.

The gedcom file is on the webserver in the directory structure of the TNG installation. I've imported from this directory previously.

In terms of file size, I can't be sure whether I've done it before. I definitely had to split the gedcom file into smaller sections with a text editor but I can't remember whether that was to get around an ftp problem or a TNG import issue. I've checked all my archived tng emails around the date I split the gedcom file and I drewa blank on finding anything relevant.

 

Link to comment
Share on other sites

You could try clicking the Stop link at the point you only see the spinning icon and then clicking the resume link once it indicates the import is stopped.  Sometimes that works.

On my hosting service the PHP Settings allows selecting FPM with OPcache as the PHP Handler.   When I use that selection, then the import screen shows no progress bar nor the counts if you select to import using the old style import by checking the box for Old style import (no progress bar)  on the Import screen

While my hosting service cPanel, shows

Quote

FPM with OPcache (recommended): FPM significantly speeds up PHP execution by maintaining workers that handle PHP requests. FPM is paired with OPcache - a caching system that keeps precompiled script bytecode in the server memory, which further improves PHP performance.
 

I have to change the PHP Handler to CGI in order to do Imports.  

Link to comment
Share on other sites

You could try checking the Rootpath setting in TNG Admin ------> Setup ------> Paths and Folders...

Set it to blank/empty and save the settings. (You could copy it first and paste it into a text document to save it)

Then open the Paths and Folders settings again and TNG will have filled in below that box what it thinks it should be - you can copy that and paste it into the box and save again, and then paste it into the same text document as previously and compare - were they the same or different?

Try the import again.

Roger

Link to comment
Share on other sites

Ken Roy/theKiwi,

Many thanks for the suggestions :

I tried Stop/Resume after which I got the message 'Reopening Maintree'. There's no spinning icon so I've no idea if anything is happening. After ten minutes I did another stop and resume and got the same message. If I stop/start the whole import I get the message in the original screenshot.

I also deleted the Root Path info and reopened the page as suggested. Below the box was identical information which has been copied back in.

The only php setting I can change in my control panel is the php version number. (choice of 7.3, 7.4 (recommended, and 8.0)

Link to comment
Share on other sites

Thanks everyone for the advice - particularly bhemph.

I renamed the file as behmph suggested and the import worked :)

It was slightly disconcerting as the Progress Bar came up immediately but after about 5 minutes, it was still showing nil progress.

I just left it and after about 10 minutes in total the import was shown as complete. A quick check has shown the correct number of records imported.

Once again thanks to everyone

Link to comment
Share on other sites

Sounds like OPcache is running on your site, because that is the way it behaves - just dumps the completed statistics at the end.  No progress bar, nor counts if you try to use the old style import.

I am lucky in that my hosting service allows me to switch to the CGI PHP handler when I want to do imports from the FPM with OPcache that can run for everything else.

Link to comment
Share on other sites

27 minutes ago, Ken Roy said:

switch to the CGI PHP handler

So Ken, is there noticeably better response/thruput  or other benefits to switch in OPcache when not doing imports?  We are both on ICDSoft, so I am able to do so as well.

Link to comment
Share on other sites

Ron,

Sorry, I do not really know and do not dare ask them because I am continually exceeding MySQL execution time.  Import was the only part of TNG that appears impacted by using FPM with OPcache as the PHP Handler on their site.

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...