Community Support Forums

I have spent days (30 hours at least) on this and cannot get data in.
Example below.
first line is data from file I downloaded from s2memberafter creating fields etc so I new where fields were to move my data round to match.
second two are is the data I am trying to load and will not be accepted.

"4", "username1", "", "first1", "last1", "username1", "email@.com", "http://web1", "s2member_level1", "", "07/27/2010", "", "07/27/2011", "", "subid1", "special_name", "special1", "street_address", "street1", "city", "city1", "state", "state1", "zip", "zip1", "country", "country1"


"", "gergussss", "2345", "Jergus", "zzpherson", "zzzgus", "", "", "s2member_level1", "", "01/01/1996", "", "", "", "", "special_name", "MIRAGE", "street_address", "P.O. Box xxxxxyz", "city", "Lockockfurn", "state", "zictorrrrrria", "zip", "33533", "country", "Arrrrustralia"

"", "diasssnne", "6789", "Dianne", "zzzzewski", "zzznne", "", "", "s2member_level1", "", "01/01/1996", "", "", "", "", "special_name", "WENDYz", "street_address", "1xxxcx Conard St", "city", "Framringham", "state", "Massachusetts", "zip", "01555", "country", "United States"

do you see anything I am doing wrong?
i have changed some of the 'spelling to protect data and even up the second two lines.

I have used this data for our 1400 members in a plain comma deliminated format and put into an older database we use online. (only trying several names at a time at this stage)

Thanks

This thread might be helpful to you:
http://www.primothemes.com/forums/viewtopic.php?f=4&t=123&p=1158&hilit=import#p1158

Hi there. Thanks for reporting the issue.

I've noticed that in all three of your examples, the email address is invalid. In order for the Import routine to function properly, you must have a valid email address in the proper import field. Try this one:

Code: Select all

"", "johnsmith22", "234jsisdf53K", "John", "Smith", "John Smith", "john.smith@example.com", "http://www.example.com/", "2", "music,videos", "12/31/2000", "12/31/2020", "12/31/2021", "www.example.com|123.357.125.654", "I-2342934SSER243", "Interests", "fishing", "T-Shirt Size", "xx-large"

Helpful tips!

I have users that I need to import, who don't have email address.
I think that I can use spreadsheet functions to create fake ones from their first and last names.

My question is, where in the WP tables does s2Member store this information? I'd like to be able to go to MySQL and edit to remove these fake emails later.

The answer to my above question is: They are stored in the 'usermeta' table. In that table, they are stored as part of a JSON encoded array inside a field called 'meta_value' or something very similar to that. Going by memory here, but it is close enough for you to find it if you need to.