CSV import error message

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

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

Open Support Ticket
  • Author
    Posts
  • February 12, 2019 at 3:42 pm #468526

    lampshade
    Expired Member
    Post count: 129

    Experiencing an issue importing event file. Following instructions, I have converted the Excel file into an Open Office CSV file, saved it and attempted to import it into Geodirectory using the Import/Export tool. I am receiving this error message reproduced in its entirety, here and an the image of the page I am on.

    Array( [error] => Sorry, this file type is not permitted for security reasons.)x

    Any suggestions?
    Thank you

    February 12, 2019 at 4:51 pm #468556

    Alex Rollin
    Moderator
    Post count: 27815

    Please install the plugin mentioned here: https://wpgeodirectory.com/docs-v2/faq/troubleshooting/#not-a-valid-csv-file

    February 12, 2019 at 7:37 pm #468573

    lampshade
    Expired Member
    Post count: 129

    Alex:
    Thanks for the quick reply. That solved one issue. However, I have this issue remaining and please see images below.

    As noted, I have the address, city state and zip code in place. Unless there is something wrong with the file not saving as a CSV accurately. I used Tim Clark’s steps as noted on his website when he was providing support here and it worked for several years.

    I’m using WP 5.0.3 and GD v1
    I noted that Open Office is being migrated to Libreoffice,should we use that instead of Open Office to create a csv file?
    Thanks

    February 12, 2019 at 11:38 pm #468601

    Alex Rollin
    Moderator
    Post count: 27815

    Have you tried following our recommended procedure here?

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

    Try that and let us know where you get stuck. It seems like you might benefit from the part of the process of adding a test listing first to make sure your data matches the format returned by the Maps API of your choice.

    February 15, 2019 at 7:15 pm #469256

    lampshade
    Expired Member
    Post count: 129

    Alex:
    Seriously?
    You want me to run through 10 pages of instructions and tests to solve a problem that has worked for the past 5 years?

    Most of the instructions seem to be related to GDv2, I am running GDv1 as noted previously.

    And yes, I am only uploading 5 lines of test data. The previously provided images illustrate that I have included the city, state, postal code and country. Yet the error message says:
    Total 5 item(s) found.
    5 / 5 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).

    Thanks

    February 15, 2019 at 7:56 pm #469277

    Alex Rollin
    Moderator
    Post count: 27815

    The instructions are ‘verbose’ but should cover only the steps you need to take for a successful import batch.

    That said, we ask you to make sure you are using an exported CSV for actual data.

    Did you?

    February 18, 2019 at 6:57 pm #469794

    lampshade
    Expired Member
    Post count: 129

    Alex:
    I revisited the steps to create a CSV file and learned that I had saved the file correctly. I also downloaded LibreOffice, installed it, ran updates, using the original Excel file imported it into LibreOffice then saved it as a CSV.

    Attempted to import back into GD and received the identical error message.
    Any further suggestions?
    Thanks

    February 18, 2019 at 6:59 pm #469795

    Kor
    Moderator
    Post count: 16516

    Hi lampshade,

    Thanks for your reply. Could you share your CSV in a zip file and also your WP admin access here n private reply so that we could try to replicate it on your Website?

    Thanks!

    February 19, 2019 at 11:39 pm #470102

    lampshade
    Expired Member
    Post count: 129
    This reply has been marked as private.
    February 20, 2019 at 4:04 am #470127

    Alex Rollin
    Moderator
    Post count: 27815

    Please attach the csv after it has been zipped. Thanks

    February 20, 2019 at 4:08 am #470128

    Alex Rollin
    Moderator
    Post count: 27815

    The data is missing several required fields including post author.

    Please see: https://wpgeodirectory.com/docs/core-export/#import

    February 21, 2019 at 11:06 pm #470485

    lampshade
    Expired Member
    Post count: 129

    Alex:
    Thanks for the suggestion and link. I will have a look at it and try again.

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

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount