[Plugin: Cimy User Manager] Import fails

I need the csv file and the screenshot of the settings used to know what’s wrong.

You can email guy <at> vguy <dot> co <dot> uk with address I can mail them to, or let me know where I can upload them.

You can email me, my email is everywhere, included the donation link which would be nice to have in mind ??

The problem is you deleted the text delimiter when exporting, but not when importing.

That’s f***ing Excel, then.

Thanks.

Hey, I’m adding what I learned yesterday when importing, because I had the same problem. Also, it’s a good idea to export what users you do have and then clear the contents except for the first row to get a good template for importing.

1: I used a formula to make usernames in excel combining first and last name. The forumla for excel is =CONCATENATE(A2,”.”,B2) but replace your cells with the right names. Mine was C2 and D2. I put a . in the middle because CIMY didn’t like the _ in the username. Hit enter, don’t click anything else or you’ll add a cell or change the cell name.

2. I then clicked on the bottom right corner and dragged my select box downward through the column to create usernames for everyone in my list.

3. I then went back to the top, right clicked or control clicked if you’re on a Mac on the column. I copied it. Then right clicked again to paste. A small paste block appears in the top right corner of the column. I clicked on that and said Values Only. I then saved the file.

4. When I went to import, where it says text delimiter, I deleted the double quotation mark. Then I imported the CSV file. And voila! Takes a while, but it was done!

Oh another thing, if you’re on a Mac, you may need to save the file as a Windows Comma Separated Value file, not just a regular one. I’m on a Mac too.

Nice excel macro to fix excel export issue

https://www.markinns.com/articles/full/export_excel_csvs_with_double_quotes