CSV import/export problems

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

Open Support Ticket

Tagged: CSV, import

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