Error occurring when attempting to import a CSV

This topic contains 11 replies, has 3 voices, and was last updated by  Andrew Deere 5 years, 5 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • #489972

    Andrew Deere
    Expired Member
    Post count: 13

    When I try to import a CSV to add a few new places, I get the following error:

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

    I thought it may be WordFence preventing this so I disabled it, but that hasn’t remedied the situation.

    Any advice?

    Thank you.

    #490021

    Kor
    Moderator
    Post count: 16516

    Hi Andrew,

    Thanks for your post. Kindly refer to this section of the documentation https://wpgeodirectory.com/docs-v2/faq/troubleshooting/#not-a-valid-csv-file

    #490024

    Andrew Deere
    Expired Member
    Post count: 13

    Thank you Kor for your response. It now lets me upload the CSV, however, the information in the CSV seems to get ignored – I receive the message below when I import:

    Total 2 item(s) found.
    1 / 2 item(s) updated.
    1 / 2 item(s) added.

    However, the imported data is nowhere to be seen.

    I’ve attached the CSV so that you’re able to check it, in case I’m doing something wrong with the data.

    Thanks again for your help.

    #490025

    Kor
    Moderator
    Post count: 16516

    Hi Andrew Deere,

    Thanks for your reply. Please zip the csv file and reattached it here. If possible, share your Website WP admin access here in private reply and we’ll check this out for you.

    #490027

    Andrew Deere
    Expired Member
    Post count: 13

    Sorry, apparently not allowed to upload CSV files here due to security issues. Plain text of the CSV below:

    ID,post_title,post_content,post_status,post_author,post_type,post_date,post_tags,post_category,default_category,featured,street,city,region,country,zip,latitude,longitude,phone,email,website,twitter,facebook,video,special_offers,business_hours,neighbourhood,post_images
    2879,Applus RTD,"<h2>Website:</h2>
    https://www.applus.com/en/
    <h2>Address:</h2>
    Units 2C & 3D,
    West Mains Industrial Estate,
    Falkirk,
    Grangemouth,
    Scotland
    FK3 8YE",publish,1,gd_place,21/05/2019 14:10,,",113,",113,0,"Units 2C & 3D, West Mains Industrial Estate",Grangemouth,Falkirk,United Kingdom,FK3 8YE,55.9192651,-3.7934972,,,https://www.applus.com/,,,,,,,http://corrodere.com/wp-content/uploads/2019/05/applus-1.png|14||
    ,Weir Valves and Controls UK Ltd,"<h2>Website:</h2>
    https://www.global.weir/
    <h2>Address:</h2>
    Britannia House,
    Huddersfield Road,
    Elland,
    Calderdale,
    United Kingdom,
    HX5 9JR",publish,1,gd_place,21/05/2019 14:10,,",113,",113,0,"Britannia House, Huddersfield Road",Elland,Calderdale,United Kingdom,HX5 9JR,53.6781033,-1.8298574,,,https://www.global.weir/,,,,,,,
    #490028

    Kor
    Moderator
    Post count: 16516

    Hi Andrew Deere,

    Please read my previous reply. Thanks!

    #490032

    Andrew Deere
    Expired Member
    Post count: 13
    This reply has been marked as private.
    #490033

    Andrew Deere
    Expired Member
    Post count: 13

    Zip Attached. Thanks!

    #490110

    Alex Rollin
    Moderator
    Post count: 27815

    I do not see any specific issues with the CSV.
    Make sure you are using the option to update for rows that have a post id in the import.

    I tried to login but get a ‘bad gateway’ 502 error.

    We have a recommended process for imports here:
    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    #490148

    Andrew Deere
    Expired Member
    Post count: 13

    Hello Alex.

    Please try to log in again via https://corrodere.com/wp-admin/

    I’ve viewed the link you supplied, the only thing to note was that I didn’t use the application suggested to make the CSV, but you’ve observed that there shouldn’t be anything wrong with the supplied CSV.

    I’ve also tried the different options when importing, including the option to update rows based on the post id, but nothing seems to stick.

    #490282

    Alex Rollin
    Moderator
    Post count: 27815

    I exported and imported and it worked fine.
    Try working with the file that is exported as outlined in the doc above.

    #490559

    Andrew Deere
    Expired Member
    Post count: 13

    Hi Alex.

    That’s where I went wrong. I used the Export tool, rather than the sample listing tool. Perhaps the export tool should be exporting the data in the same format it expects it to be imported in?

    Regardless, thank you for helping me get to the bottom of this.

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