Thread

Hi,

can someone help me import members into EE please. It’s very unclear how to do that. I’ve read the threads, and it looks like it is not really useable.

So I have the csv file with screen name, email, password and username. I try to convert to XML, but I always get: “You must have at least 3 fields: username, screen_name, and email address”

So that’s my firts question. WHy does it say that? I have four fields, no headings.

All help appreciated,
Michel

Hi Michael,

Which version of ExpressionEngine are you using?

I’ve used the XML Conversion and Member Import Utility in EE 2.4 just this week we no trouble. Here is an example from my CSV:
Headers:

"Last Name","First Name","Screen Name","Email","User Name","Password"

Data:

"Roberts","Bob","Bob Roberts","[email protected]","bob_roberts","bobspass"
"Robers","Jane","Jane Roberts","[email protected]","jane_roberts","janespass"

I set the Utility to use “,” as the delimiter and double quote marks as the data enclosure.

You should then be able to map the data to ExpressionEngine Member Management fields.

Can you show me an example of your CSV? Be sure to use dummy data, as long as it matches the pattern in your file.

Cheers,

Hi Dan,

I’m on 2.4. U’ve managed to create an XML file, although the xml is not added by the converter. I added that myself. Now I get the error: “The required type attribute is missing in the password element for user: some_user. Please consult the documentation for the correct import format.”

My xml looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<members>
 <member>
  <screen_name>My Name</screen_name>
  <email>[email protected]</email>
  <username>MyName</username>
  passwordofuser</password>
 </member>
</members>

Thx for helping,
Michel

Almost there. It looks like I need to add type=“md5” to every password line. But I only have the string type password. Can I upload it like that too, and have EE make it md5?

Michel

Hi Michel,

Almost there. It looks like I need to add type=“md5” to every password line. But I only have the string type password. Can I upload it like that too, and have EE make it md5?

Indeed, set the type=“text” and ExpressionEngine will encrypt them for you when they are imported.

Cheers,