[Plugin: CSV Importer] Imported 0 posts–directory/file/database/server permissions?

The usual suspect is PHP’s safe mode. Check your PHP settings and verify that scripts are allowed to write to the system’s temporary directory (usually /tmp on *nix servers).

https://www.ads-software.com/extend/plugins/csv-importer/faq/

I am running version 0.3.3, have checked my CSV against the sample, and have made sure safe mode is off. I still get the 0 Posts in 0 seconds fail. Any ideas?

Never mind… I tried OpenOffice instead of Excel, and it worked like a champ. Thanks for the killer plugin.

I have the same problem as you are descibing. Gonna try out that open office. And cheers for this addon m8.

Greetings hieronymus

You tried open office creativepickle, can you please tell me what settings you used. Cause i am using this importer from an affiliate website and for some reason when i press import the i get a blank screen. No message at all.

This is an example feed

title;”link”;”daisycon_unique_id”;”description”;”img_small”;”minimum_price”;”category”;”internal_id”;”priority”;”ean_code”;”brand”;”shipping_costs”;”stock”

AC Ryan Mediaplayer PlayOn DVR HD 1,5TB;”https://ds1.nl/c/?wi=92486&si=733&li=51264&dl=media-streamer%2Fac-ryan-media-streamer%2Fac-ryan-mediaplayer-playon-dvr-hd-15tb-art-161587.htm%3Fnetwerk%3Ddaisycon&ws=”;”Db5e029f0497eb6f59931b46a60b17e3f”;”Full HD DVR1 5TBOnline media collectie”;”https://www.plasma-discounter.nl/getImage.aspx?imageid=e5c6c3b2-c85e-4c70-be3e-c4c934e0417b”;”319.00″;”Media streamer”;”61587″;””;”8717931013178″;”AC Ryan”;”0.00″;”5″

When i export this with the open office cal i pick the Unicode utf-8 as mentioned on the FAQ. Using a comma.

Thank you for your help in advance

I used UTF-8 with the comma separator and double-quote text delimiter. But just to be clear, my problem was never a blank screen- the issue I had was that I kept getting “0 posts imported” when I ran the script.

Also, make sure you read the documentation closely and use the correct header row syntax. I missed that the first time, which I think was part of the problem.

Hope that helps!

I had the same issue using Excel 2011 on OSX 10.6.6. Saving a normal csv file produced an “imported 0 posts” dialogue.

SOLUTION: I saved the file using “Windows Comma Separated (.csv)” format (it’s located under Specialty Formats).

For OS X/Excel users: adispezio hit on the right solution to use Windows CSV (from the list of specialty formats) instead of Excel’s native CSV format.