sqliimport

Thursday 26 May 2011 9:59:25 am

I've installed sqliimport because I need to import 150 users into ezpublish.

I've looked at the documentation but I don't understand what I have to do to import the users.

Would anyone be kind enough to give me a 'step by step' explaination of what I need to do please?

Thanks,

Andy

Friday 27 May 2011 2:41:18 am

Hi Andy

Lars Eirik explained it very well actually :).

The only thing you need to keep in mind is that a user is no more than a content object with an eZUser attribute. Thus, it can be processed just like other regular content objects.

SQLIImport uses fromString() methods from datatypes (see the fromString doc appendix to learn about the format for several datatypes). For ezuser, here it is :

ezuser
======
'|' separated string with user login, email, password hash, and password hash type

The following code could be taken as an example, in your import handler :

$userOptions = new SQLIContentOptions( array(
 'class_identifier' => "user",
 'remote_id' => "importeduser-$userIDInOldSystem"
) );
$content = SQLIContent::create( $userOptions );
$content->fields->first_name = $firstName;
$content->fields->last_name = $lastName;

// Build the password hash
// md5_user is a concatenation of login and password with a \n, md5 hashed
$passwordHash = md5( "$userLogin\n$userPassword" );

// Format for ezuser is userLogin|userEmail|passwordHash|hashType|isActivated
$content->fields->user_account = "$userLogin|$userEmail|$passwordHash|md5_user|1";

$userPlacementID = eZINI::instance( "UserSettings", "DefaultUserPlacement", "site.ini" );
$content->addLocation( SQLILocation::fromNodeID( $userPlacementID ) );

$publisher = SQLIContentPublisher::getInstance();
$publisher->publish( $content );

I hope it will help you :)

Friday 27 May 2011 11:36:44 am

Hi Jérôme,

Thank you for your post.

I am a developer - I've been coding with PHP for 10 years.

All I need is a heads up on the process to create an import handle, ie. which files to add your code to and the various other changes to I need to make.

I would like to import the following from a csv file:

 - first name
 - surname
 - email address
 - username
 - password

Thanks,

Andy