Event CSV Import Issue

  • I am running into issue when trying to import an Event from a CSV. I have constructed a CSV to the specifications outlined in the sample CSV document, and have included an image of part of the CSV below. When I then upload the CSV everything looks like it should import successfully, but after the first player of the eighth team, the player stats are no longer imported, though they are clearly uploaded as the table before import has the data. The import will still get the results, teams, and players, but after the first player of the eighth team the values “kills” and “games played” of player stats are not imported, even though in the import menu the table is filled with this data.

    Note that the eight team is “Ole Miss” and the first player on the CSV for that team in this Event is “oinks_”.

    Correctly Formatted CSV for Event Import:

    View post on imgur.com


    After Uploading CSV File:

    View post on imgur.com


    After Importing CSV File:

    View post on imgur.com

    View post on imgur.com


    Data in Question After Upload But Before Import (player data is clearly uploaded):

    View post on imgur.com


    Data in Question After Upload And After Import (player data after “oinks_” not imported):

    View post on imgur.com

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Tristan Kimball

    (@rhygrass)

    I have no idea how or why but this issue is now resolved, after waiting about a day and re-importing it works as expected.

    Thread Starter Tristan Kimball

    (@rhygrass)

    I thought the issue was resolved but it is not.

    Roch

    (@rochesterj)

    Hi @rhygrass

    Thanks for reaching out.

    What did you have in the previous step that made you think it was resolved? Maybe it’s something we can replicate.

    So far it looks like an issue in either your import file (CSV) or your server that may be blocking the file, causing a partial import.

    Thanks!

    _drg_

    (@_drg_)

    I’ve had trouble importing as well. For me, it turned out to be a memory problem. I had to increase the memory allocated to WP (and memory limit in PHP).
    Some troubleshooting steps to try:

    – If you remove oinks_ data/lines from the file and it stops at about the same place, then its probably memory.
    – If you try and import only the oinks_ data/linese and it works, then it’s more proof that it’s probably a memory problem.
    – If you remove oinks_ data/lines from the file and it all imports, then i probably isn’t a memory problem -it’s probably a special character problem.

    I can’t remember exactly what I had to change (something in wp-config, as well as a PHP setting with the host). In the end, I still run out of memory if the file is too big. So I cut it into chunks and import.

    Roch

    (@rochesterj)

    Hey @_drg_

    Thanks a lot for your help. Indeed these are great ideas

    Thanks! ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Event CSV Import Issue’ is closed to new replies.