Bulk member import

[edevys]

Hi,
I have a problem with the bulk import functionnality. When I want to import my file, I have an error message with :
One of the required columns not found in CSV: user_name

But in fact the user_name is my first column and all the fields are filled with a user name.

I cannot import my file. Can you help ?

Thank you

Emmanuel

[mbrsolution]

Hi, did you follow these instructions?
https://simple-membership-plugin.com/simple-membership-bulk-import-member-data-csv-file/

Thank you

[edevys]

Yes I did but I still have an error when importing the file. It says that the first column is missing but it is not missing !

[mbrsolution]

Hi,

For testing purposes, what happens when you import the sample data in the csv template file?

Thank you

[edevys]

Hi thank you for your reply.

I download the data CSV sample data file and put my data in it with the same column organization but when I try to import it on my website, I get a popup message : One of the required columns not found in CSV: user_name

For testing purpose I tried also with your sample data sheet without modifying them and I get the same message.

Emmanuel

[mbrsolution]

Hi,

When you are creating a CSV file using Microsoft Excel for example; if the following CSV (Comma Delimited) format does not work, try CSV (MS-DOS) format.

Let me know if the above helps.

Thank you

[edevys]

Hello, Sorry but Even with this format I get the same answer and alert.

Please find hereby a screenshot

https://www.abeilles-international.net/images/simple-membership-import.png

It looks like the first column is not recognized.

Emmanuel

[edevys]

HI, Could you help ? I am still running a problem !
Thank you.

[South_Coaster]

@edevys – I had the same problem.

My version of Excel has three output options for CSV export, only one works:

CSV UTF 8 (Comma Delimited) = NO
CSV (Comma Delimited) = NO
CSV (MS DOS) = YES

[Marco]

I had the same issue. All three type, that @South_Coaster mentioned, didn’t work. So I opened the CSV file from Excel (MS-DOS) in TextEdit and replaced all semicolons with commas. After that, it worked but not with all files.

Is there already a solution for that issue that works in all cases?

[Author]

Posts