40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Failing Imports

This topic contains 6 replies, has 2 voices, and was last updated by  Andrew Deere 4 years, 9 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • July 11, 2019 at 3:45 pm #497132

    Andrew Deere
    Expired Member
    Post count: 13

    Hello GD Support.

    I have attached a CSV to this message, where 14 out of 19 rows are failing to import. I only get told directly why 4 of them fail (Lines 2, 3, 4, 5), leaving me having to guess what’s wrong with the remaining locations.

    Please could you advise why this is failing to import the majority of the data please?

    Thank you.

    July 11, 2019 at 6:35 pm #497174

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    try zipping the file first. (*.zip)

    Try out our recommended import process, it might give you some clues about what is happening

    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    July 12, 2019 at 8:20 am #497324

    Andrew Deere
    Expired Member
    Post count: 13

    Hello Alex. I feel you may have misinterpreted my question – I’m talking about the CSV imports, not uploading the plugin.

    See attached screenshot, thanks!

    July 12, 2019 at 9:30 am #497333

    Alex Rollin
    Moderator
    Post count: 27815

    I feel you may have misunderstood my post.

    I was talking about zipping the files you are trying to upload. As you can see in your post above they were not attached.

    If you open the file in Open or LibreOffice do you see any diamond/question mark characters? Those are ‘illegal’ and will be the cause of the failure.

    July 12, 2019 at 9:35 am #497338

    Andrew Deere
    Expired Member
    Post count: 13

    Aha, yes okay, I see what you mean – CSV attached as a zip now. Thanks.

    I currently don’t have either of those applications installed, will have to go through IT to get one of them installed, however I did check in a text editor (sublime text 2) for anything potentially suspicious and couldn’t locate anything.

    Thanks for your help, hopefully we can get this solved.

    July 12, 2019 at 9:52 am #497343

    Alex Rollin
    Moderator
    Post count: 27815

    I do not see any issues with sheet formatting but the sheet is missing columns.

    Do follow the recommend process:
    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    (I linked incorrectly, edited)

    July 12, 2019 at 9:56 am #497345

    Andrew Deere
    Expired Member
    Post count: 13

    Unfortunately I can’t seem to obtain better information to be able to populate those cells in the few cases we’re missing information, such as the post code on row 2. When googling the address it seems to appear on the map just fine though – I had hoped the lat/long would be enough information for it to place the pin correctly.

    I did just find out that adding them manually one at a time through the WP interface does work; it’ll take much longer, but I may just have to go through that method instead.

    Thanks for looking into this, I appreciate it.

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

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

Open Support Ticket