Community Support Forums

Re: Can't Import from a CSV file - Keep getting this message

2010-10-27T06:39:48-05:00

Jason - thanks again,

I'll give that a try. Sounds like that will do the trick. I sort of thought I was doing something wrong.

Thanks again for your help and the follow up!

Statistics: Posted by mooredb — October 27th, 2010, 6:39 am

Re: Can't Import from a CSV file - Keep getting this message

2010-10-26T03:26:20-05:00

Thanks for the follow-up.
I just received your email.

After performing some importation tests with:

Code:: "","Username","Password","First Name","Last Name","Display Name","email@example.com"

I found that the importation process is working as expected with s2Member. I noticed in your email that you said, "I'm pasting it into an Excel file". Try pasting it directly into a text editor and then just save it as a CSV file. I've attached a sample CSV file for you.

import-file.csv
Related articles on CSV files:
http://creativyst.com/Doc/Articles/CSV/CSV01.htm
http://en.wikipedia.org/wiki/Comma-separated_values

If all else fails, just paste your data directly into the Import field that is provided by s2Member. In other words, instead of uploading a file, just upload the data itself by pasting it in.

Statistics: Posted by Jason Caldwell — October 26th, 2010, 3:26 am

Re: Can't Import from a CSV file - Keep getting this message

2010-10-24T00:12:12-05:00

Thanks for reporting this important issue.

This part of the error message that you're receiving... Line #1. User ID# ""
indicates to me that your import file is becoming corrupted, as the double-quotes are being read in as the User ID instead of the empty string they contain. This can happen when slashes are added to your file, for the purposing of escaping special characters.

Please paste this line into the Import field and run a test to see if it succeeds with "1" imported User.

Code:: "","Username","Password","First Name","Last Name","Display Name","email@example.com"

If this test fails, please email me a Dashboard login so I can diagnose the issue for you.

Statistics: Posted by Jason Caldwell — October 24th, 2010, 12:12 am

Can't Import from a CSV file - Keep getting this message

2010-10-23T17:21:26-05:00

I am working on creating a test file to import records from a CSV file and I keep getting this error message.

The following errors were encountered during importation:
•Line #1. User ID# "" does NOT belong to an existing User.

I've even tried to copy this format into a test file and I still get the same error message.

"","johnsmith22","","John","Smith","John Smith","john.smith@example.com","","s2member_level2","","","","12/31/2021"

I've even exported the current user accounts and keep the same structure but changed the information and get the same error message.

Can someone email me an example file of what the structure should be?

Thanks.

Statistics: Posted by mooredb — October 23rd, 2010, 5:21 pm