Import events limit?

lmhaffner
(@lmhaffner)

11 years, 2 months ago

I am trying to import a large number (~50+) of events, but very consistently only the first 29 are imported. The files are small (5-6k), so are not close to the 50M limit mentioned in the import page. Our WP memory is set to 64 MB, as recommended. Don’t think these are big enough to impact that either.

After the file is uploaded, the review table appears with all my events and the information is correctly parsed into event fields. All events in the file are listed on this page. But after hitting the “Import Events” button, it reports that 29 are imported (and 0 skipped), which can be confirmed back in the event posts list.

I have searched documentation and features to see if this was mentioned anywhere and even delved into the code. But I can’t find any obvious reason for the limitation. Splitting my input file up and doing multiple imports works fine. So I don’t think there’s a problem with a certain line in my csv file. I’ve run into the same problem with a completely different set of events as well.

Any ideas?

https://ww.wp.xz.cn/plugins/sportspress/

Viewing 6 replies - 1 through 6 (of 6 total)

amcwpadmn
(@amcwpadmn)

11 years, 1 month ago

I am having the same exact problem, but ours stops at 33 events for some reason. Any help would be greatly appreciated.

Plugin Author Brian
(@brianmiyaji)

11 years, 1 month ago

This appears to be related to server time limit and/or memory limitations. The importer creates each entry separately, and makes several calls to the database, which I’m aiming to improve in a future update.

bchiarmonte
(@bchiarmonte)

11 years, 1 month ago

I was importing from CSV exports from Football Club theme and my matches would not import properly. I found out that I needed to break up the csv to something less than 90 lines (might have been 80, I don’t remember at this point) and then run the import that way. My export had a game, results and player lists, I had to break it down so the entire player list for the game would need to fall before that threshold.

I tried it on both my hosting and a local xampp install (with loads of memory allocated) and ended up with the same result both times.

Give that a shot, I is a bit tedious, but it got the job done.

Thread Starter lmhaffner
(@lmhaffner)

11 years, 1 month ago

Yes, I had to trim mine down as well to get all the events imported. I didn’t have player lists, so just 2 lines per event. Each import would only ingest 59 lines (29 events * 2 teams/event + 1 header line).

Still, much better than entering by hand!

pjtorre
(@pjtorre)

10 years, 7 months ago

I did some debugging and I found that after reviewing and posting, the entire array of values is not being posted to the script. Was getting cut off at around 1000 (which is the default for the php max_input_vars variable). I fixed it by creating a .user.ini file in the root of my website with the following entry:

max_input_vars = 10000

Using the .user.ini file was what was recommended by my host, GoDaddy. Depending how you are hosting this could go in a php.ini or php5.ini file.

Hope this helps.

Roch
(@rochesterj)

10 years, 7 months ago

Thanks @pjtorre