Import CSV temp crashes server

This topic contains 10 replies, has 3 voices, and was last updated by  Paolo 8 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • November 23, 2015 at 11:34 pm #61308

    coulterjohnson
    Expired Member
    Post count: 25

    I am trying to import a CSV that has 630 records. It stops importing on different records each time so I know it is not a strange character. The host is Amazon… so it can’t be due to an under powered server.

    Problem seems similar to https://wpgeodirectory.com/support/topic/max-of-records-per-csv-upload/

    When it stops importing, the rest of the site will be unresponsive for 5-10 min.

    November 23, 2015 at 11:51 pm #61309

    coulterjohnson
    Expired Member
    Post count: 25

    I take that back… After the last import attempt, it has been down for 30 min and counting.

    November 24, 2015 at 12:45 am #61314

    Guust
    Moderator
    Post count: 29970

    Can you post URL, admin details and a copy of the CSV (ZIP it?).
    Then we can have a look.

    November 24, 2015 at 1:41 am #61319

    coulterjohnson
    Expired Member
    Post count: 25
    This reply has been marked as private.
    November 24, 2015 at 1:55 am #61322

    coulterjohnson
    Expired Member
    Post count: 25
    This reply has been marked as private.
    November 24, 2015 at 3:34 pm #61367

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    1) default category should be an ID, not the catgegory name.
    2) post regions names must be full names not abbreviations.

    Once you fix these 2 things it should work correctly.

    Let us know,

    Thanks

    November 24, 2015 at 3:50 pm #61368

    coulterjohnson
    Expired Member
    Post count: 25
    This reply has been marked as private.
    November 24, 2015 at 4:58 pm #61372

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    I’ve double checked and you are correct about the default category. You can leave the names.

    I’m checking the CSV to identify other errors.

    Thanks

    November 24, 2015 at 5:46 pm #61377

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    there are several non utf-8 characters in that file: see image attached.

    They are all spaces, so you should be able to do a search and replace and clean them up.

    To find similar errors, you could use a text editor like http://www.gedit.org/

    Let us know how you went,

    Thanks

    November 24, 2015 at 6:33 pm #61392

    coulterjohnson
    Expired Member
    Post count: 25

    That did it! thanks!

    November 24, 2015 at 6:37 pm #61393

    Paolo
    Site Admin
    Post count: 31206

    You are welcome 🙂

  • Author
    Posts
Viewing 11 posts - 1 through 11 (of 11 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket