Support » Plugin: Import Users from CSV » Once setup, it works well.

  • Nice little plugin, does exactly what it says, quickly with data integrity.

    However, I ran into a problem at the begginning, which took a while to troubleshoot.

    The plugin was not working at all with my .csv, and the error log was not showing anything. It would fail every time. However, the example csv would work as advertised.

    After a lot of playing around I found that when I was saving the .csv out in excel, it was not putting quotes around the entries, and also, must have been putting in some headers in the file or something the plugin didn’t like, as if I opened the example file in excel, closed it and tried to import it, it woudlnt work.

    If anyone is having issues like this, try these steps;

    Open your csv in excel, and format it to make it look like the example csv. Then format all boxes to be text, or add quotes around them manually (I used = “‘”&a2&”‘”).

    Save this out as a csv, and open in your text editor of choice.

    Open the example in your text editor (I used sublime2), and remove all the dummy entries. Copy and paste your entries into the example file.

    Save this and then try and import it. Good luck!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Ulrich Sossou

    (@sorich87)

    So you gave the plugin three stars because of a shortcoming of Excel… 😉

    As you noticed, Excel formats the CSV files weirdly and there’s not much I can do.
    A quick way to deal with CSV is to use http://www.libreoffice.org/ or http://www.openoffice.org/ or any other spreadsheet program.

    Thanks for the review anyway and for your patience trying the plugin.

    I gave the plugin a 3 star rating because;

    – it is not compatible with one of the most widely used csv editing applications.
    – this shortcoming is not documented (at least not anywhere I was able to find while troubleshooting)
    – the error log did not display anything when nothing was imported. Granted I realise that there were no “errors” as the script found nothing to import, but really, that should raise a flag if nothing is imported, and should probably log something to the effect of ‘data in acceptable format not found’.
    – no time stamps on the error log.

    Perhaps I could help and contribute by trying to get the script to accept excel formatted csvs?

    Cheers.

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    – it is not compatible with one of the most widely used CSV editing applications.
    – this shortcoming is not documented (at least not anywhere I was able to find while troubleshooting)

    Fair enough. I couldn’t find any copy of Office for Mac to buy here and test. 🙁 I thought the example CSV was sufficient for users to compare. Some users reported that it works when they save as “windows comma separated (.csv)” (http://wordpress.org/support/topic/plugin-import-users-from-csv-test-csv-fails-to-import-and-log-is-blank?replies=4).

    – no time stamps on the error log.

    The plugin writes the date in the format Y-m-d H:i:s before putting any error message in the file.

    Perhaps I could help and contribute by trying to get the script to accept excel formatted csvs?

    https://github.com/sorich87/import-users-from-csv. Pull requests are quickly accepted and I’m willing to give commit rights to anyone who wants to make significant contributions. I’m barely doing any WordPress development these days. Just keeping my plugins up to help folks. So any help from you would be greatly appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Once setup, it works well.’ is closed to new replies.