CSV Error

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

Open Support Ticket

Tagged: CSV

Author

Posts
February 5, 2019 at 10:55 pm #467318

School Powwow
Expired Member

Post count: 19

Hi,
I am getting this error when importing csv file:

“Sorry, this file type is not permitted for security reasons.)x”

I have attached further file for your perusal.

Can you please help me rectify this problem.

Thanks

February 6, 2019 at 1:39 am #467342

School Powwow
Expired Member

Post count: 19

Please find document attached

February 6, 2019 at 1:42 am #467343

School Powwow
Expired Member

Post count: 19

File not able to upload 🙁

February 6, 2019 at 1:51 am #467347

Alex Rollin
Moderator

Post count: 27815

Hello,

Make sure you save the file with LibreOffice, not Excel.

To share it with us you can zip the file first

Not a valid CSV File error

There is a bug in WordPress that you may run across if you try to upload a CSV file. When you try to upload the file, you may see an error:
“The uploaded file is not a valid csv file. Please try again”.

Some members have reported success with this plugin, a temporary fix until the WordPress issue is resolved:
https://wordpress.org/plugins/disable-real-mime-check/

See more about the WP Issue here: https://core.trac.wordpress.org/ticket/45615

February 6, 2019 at 2:31 am #467348

School Powwow
Expired Member

Post count: 19

zip file attached.

February 6, 2019 at 2:34 am #467349

Alex Rollin
Moderator

Post count: 27815

Did you install the plugin I linked above?
Let us know how it goes

February 6, 2019 at 2:38 am #467350

School Powwow
Expired Member

Post count: 19

trying again

February 6, 2019 at 4:01 am #467355

Alex Rollin
Moderator

Post count: 27815

Are you updating a listing? If so, then post_id is ok, if not it should be cleared.
There are illegal characters when I open with UTF8 encoding. What encoding did you save as?
Did you use LibreOffice?
Did you install the plugin I linked above?
Let us know how it goes

February 6, 2019 at 3:16 pm #467418

School Powwow
Expired Member

Post count: 19

Hi,

I have installed the plugin. However, I am now receiving the following error.

“Total 1 item(s) found.

1 / 1 item(s) could not be added due to blank title/invalid post type/invalid characters used in data.”

February 6, 2019 at 3:29 pm #467420

Paolo
Site Admin

Post count: 31206

There are illegal characters when I open with UTF8 encoding.
What encoding did you save as?
Did you use LibreOffice?

Please answer this question…

Thanks

February 6, 2019 at 6:37 pm #467468

School Powwow
Expired Member

Post count: 19

yes

February 6, 2019 at 6:45 pm #467469

Paolo
Site Admin

Post count: 31206

Errors are still there, you need to correct all bad format characters.

For example in the title of the 1st listing:

Tolimaﾒs Auto Center

See what’s there instead of an apostrophe?

All similar errors must be corrected.

Thanks

February 7, 2019 at 2:24 pm #467590

School Powwow
Expired Member

Post count: 19

I changed it but still showing error, can you fix the error?

February 7, 2019 at 2:25 pm #467593

School Powwow
Expired Member

Post count: 19

I re-attached file sample changes

February 7, 2019 at 8:19 pm #467681

Alex Rollin
Moderator

Post count: 27815

There is a bug in WordPress that you may run across if you try to upload a CSV file. When you try to upload the file, you may see an error:
“The uploaded file is not a valid csv file. Please try again”.

Some members have reported success with this plugin, a temporary fix until the WordPress issue is resolved:
https://wordpress.org/plugins/disable-real-mime-check/

See more about the WP Issue here: https://core.trac.wordpress.org/ticket/45615
Author

Posts