CSV import/export problems

This topic contains 15 replies, has 5 voices, and was last updated by  Guust 7 years, 4 months ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • January 12, 2017 at 11:50 am #341370

    James Veale
    Expired Member
    Post count: 54

    When trying to import listings i get the following message:

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

    I’ll try to upload the csv… but it might not allow me to upload it

    site: http://thomasw5.sg-host.com/

    January 12, 2017 at 11:51 am #341373

    James Veale
    Expired Member
    Post count: 54

    🙁

    January 12, 2017 at 11:53 am #341376

    Kor
    Moderator
    Post count: 16516

    Testing CSV file upload

    January 12, 2017 at 12:02 pm #341380

    Guust
    Moderator
    Post count: 29970

    We’ll get Kiran to have a look for you, please provide WP admin details in a private reply. Thanks.

    January 12, 2017 at 12:04 pm #341383

    James Veale
    Expired Member
    Post count: 54
    This reply has been marked as private.
    January 12, 2017 at 1:16 pm #341403

    Kiran
    Moderator
    Post count: 7069

    Hi James,

    There is new defect(bug) in WordPRess 4.7.1, that causes problem in uploading csv file.

    Please check here – https://core.trac.wordpress.org/ticket/39550

    Thanks,
    Kiran

    January 12, 2017 at 1:22 pm #341408

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Adding this line to your wp-config.php file will allow you to upload any file but this is a security issue and you should only do it when needed and remove immediately after. (until they release WP 4.7.2)

    define('ALLOW_UNFILTERED_UPLOADS', true);

    Stiofan

    January 12, 2017 at 10:34 pm #341746

    James Veale
    Expired Member
    Post count: 54

    The code works like a charm. I’m using the snippets plugin so I can just activate and deactivate from there….

    However… I’m still getting an error message about the csv not being valid. This is simply exporting the csv, then a minute later trying to reimport it without even opening it.

    January 13, 2017 at 2:55 am #341894

    Guust
    Moderator
    Post count: 29970

    That code should be put in your config file,it is not a code that will work in Code Snippets or functions.php

    January 13, 2017 at 3:00 am #341895

    James Veale
    Expired Member
    Post count: 54

    Possibly its working due to a plugin I installed called ‘Disable Real MIME Check’

    although, I’m still getting other errors for no apparent reason. Screen shot attached. I’ll attach screenshot of settings im using in open office too.

    Maybe it’s just still to do with my config file?

    January 13, 2017 at 8:38 am #341964

    Guust
    Moderator
    Post count: 29970

    We will need to see the CSV file.
    You can upload it with FTP somewhere to your site and give us the link if you like.

    January 13, 2017 at 8:39 am #341965

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    January 13, 2017 at 10:04 am #341985

    James Veale
    Expired Member
    Post count: 54

    just emailed it

    January 13, 2017 at 10:19 am #341987

    Guust
    Moderator
    Post count: 29970

    The file is semi-colon delimited, not comma delimited.
    https://wpgeodirectory.com/docs/csv-tips-and-tricks/

    I am guessing you are trying to update listings, not add new.
    I cannot see anything else wrong, assuming that the categories and users exist as added.

    I also note that some of the regions are abbreviated.

    January 13, 2017 at 11:41 am #342003

    James Veale
    Expired Member
    Post count: 54

    That must have been it! I just saved as per the documentation and it worked!

    Many thanks!

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

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

Open Support Ticket