User Import - Port to Drupal 7

still no takers, huh...i'd love to, but don't code :( subscribing.

I would also like to see this ported, also not a programmer but again, can test.

Subscribe

A very very useful module. Subscribe.

Glad people find User Import module useful.

I've maintained it for over 5 years, across 3 versions of Drupal, and will definitely be upgrading it to Drupal 7.

If no one steps up with a budget then I'll need to do it on my own time, happy to do that, but would appreciate people's patience in the meantime.

Great to hear Robert, i am still finding my feet with D7 or i would offer to help, i am certainly interested in testing should you require testers.

+1

sub

subscribe

Following.

Subscribe

Will be glad to see it ported to D7

I have an interest in helping as I have found this module useful.

+1

+1

Okay, so let's get started. I ran the code through the D7 upgrade tool suggested by the folks working on the Coder module. I've attached the results for everyone to take a look at. Would this be a good starting point for a Drupal 7 dev branch?

I am currently porting this module to drupal 7.
So far, it's working quite well. Only need to work on extra fields imports.
I will keep you guys posted (it's nearly the end).

Cool. Share your code, please! Maybe we can help.

+1 Is there a bounty system for module development? I'd be happy to kick in a few bucks.

@starmate - Are you working on a straight port to 7 or integrating any new entity field functionality / api into the module? I was looking into doing the latter, but I will wait for any code that crops up in this issue. ALso to switch to using Queue API.

I'd like to get the ability to import Node Reference fields into the user's content profile based on matching the value in the field with an existing Node Title and also the case where the a column has a 1 in it and have the Node Title in their header to match with an existing Node Title. This should work for cases where there are single and multiple values for a node reference field.

I've arranged for this to happen using this patch for the D6 version of User Import
http://drupal.org/node/633358
If you can roll this in to the D7 upgrade that'd be great. I'm happy to help integrating this in to D7 version of User Import, I've got some new ideas for it as well.

I'm working on a similar effort for Node Import right now, it'd be nice to coordinate the two.
http://drupal.org/node/1089632
and
http://drupal.org/node/1089644

Ability to import users as vcf (vcard) instead of csv would be great :)

Would love to see this as well - building my first drupal site and have 85 "users" to import for this project. If I can help test something, that would be great, but this is my first week with drupal and also first post here. Hopefully this "subscribes" me to future comments!

Subscribing, many thanks for your effort!

I'm interested, too. I anticipate having to batch import new users on a regular basis. Thanks!--Tim

+1

+1

Add me to the list!!! Thanks for all your efforts!

Hi everyone!
As promise, this is the the work that I've done on drupal 7 user_import port.
You can import user profile picture. You just need to put the files in sites/default/files/pictures folder and only use the filename in your csv file.

The module still need to be tested and need improvements.

Best regards,

Jon

In testing out the module update in #31, I got a the following error when importing a test user:
"Warning: implode() [function.implode]: Invalid arguments passed in DefaultMailSystem->format() (line 24 of /modules/system/system.mail.inc)."
It sent the email to the test address I gave it, but without anything in the body.

Other than that, this module is functional in D7. The forms all worked as expected. I suggest that this be committed as D7-dev. Can I get someone else to second me on this?

Here is a new version.
Few bugs have been corrected like:
- permission issues
- file type (csv and txt) that can be uploaded

The menu entry has been moved as well, under configuration > people > user import.

Ftp and user roles hasn't been tested and the features are not ported.

Regards,

Jon

UI only recognises email address as the username. The D6 version recognised first name, last name or email address.

How about ability to mass import using vcard format? AS I use a Mac address book I have to convert the vcards to csv using this: http://labs.brotherli.ch/vcfconvert/

A little confused, the documentation says we need to use http://drupal.org/project/content_profile which isn't D7. Which profile can be used the default D7 or Profile 2 or another?

thanks

subscribing

I've tried importing the sample and my own csv, keep getting this error:

Notice: Undefined index: email in _user_import_process() (line 1867 of .../sites/all/modules/user_import/user_import.module).

I am assigning the email field to the appropriate source, not sure what is wrong.

Sxs551

I think the issue is either the email isnt unique or there are spaces after of before the email address in the csv file.

subscribing

subscribing

Tested the D7 module #33
User import is working but when the option of send email is selected the error comes :
Warning: implode() [function.implode]: Invalid arguments passed in DefaultMailSystem->format() (line 24 of /var/www/html/is/isocenter.org/modules/system/system.mail.inc).

the email does get sent but there is nothing in the text.

Further to the last error #43 it can be solved by installing the mail system and the HTML mail modules. then the process works fine..

Another issue that popped up when I was importing users was the fact that the time zone was not being set. I circumvented by removing the ability of the users to set their own time zones and setting up a default site wide timezone for all users. This is the same issue as #34.

Hi Santam,

I installed mail system and HTML mail yet the welcome mail doesn't get sent to imported users. Did you set any special configuration for this to work? (all I get is empty emails).

Thanks!

Hi my module configuration is as follow:
HTML Mail 7.x-2.43 Enables HTML in system emails.
Mail MIME 7.x-2.13 Provides a class for creating MIME messages.
Mail System 7.x-2.10

In mail system the site wide and html mail module classes are set to HTMLmailsystem
In HTML mail i have set up a special email filter to allow all tags and called it for HTMLmail filter. Send out a test mail from the test email place and see if modifying the html file helps.
The actual email that user import sends will be configurable in the user import setting that appears after u have uploaed a csv file.
Do tell me if that works. I successfully imported 140 users using this brilliant module. The killer feature for me was the ability to set a password for them.

Thank you very much! I hadn't installed Mail MIME properly + hadn't set up Mail System.

It's working properly now.

Greetings

Hi guys,

This is a new version (from #33) which solves the bug 'Notice: date_default_timezone_set() [function.date-default-timezone-set]: Timezone ID '-18000' is invalid in drupal_session_regenerate()'.

You can now map the 'Timezone' field to any column in your .txt or .csv file. If it's not mapped, 'UTC' is assigned by default.

HTH

bmunlsow #48 - that would have been great a few weeks ago, but I already ran my first import!
So, santam #44 - how does one remove the timezone setting ability for the users? That would work fine for my very local drupal site but I can't seem to find it in the configuration for User module anywhere. Is it elsewhere?

Alternatively I've been looking for some kind of "bulk profile" updater module which would allow me to set everybody's timezone.

Thanks so much for everyone's work on this module porting to 7; clearly I didn't know what I was doing when I started using drupal! .

@ dbarsh you can find it under configuration > date and time (under regional and language section). There I could turn off the ability of my users to set their own time zones. It doesnot matter much to me anyways. You may look at views bulk operator module for the bulk operations thing though I am not certain how you can do it but considering the power of views i am pretty certain some drupal guru will be able to do it.

Sub, let's get this into a Git branch so we can dev a bit more effectively!

Hello,
just wanted to let you know I came around a conflict pb between drupal 7's core Trigger module and user import.
I want to add a redirection to home page after a user updates his profile, but if I do that user import stops sending the welcome message to the users it imports.
Anyone knows a workaround?

I am having an issue with the version in #48. Upon import I can only ever import 1 user even though I have a whole list of them in my CSV file. The import throws this error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cope.profile_fields' doesn't exist: SELECT * FROM {profile_fields}; Array ( ) in profile_get_fields() (line 164 of /.../sites/all/modules/user_import/supported/profile.inc).

This may have something to do with the fact that I use email addresses as usernames. I am not mapping any other fields nor am I updating any existing fields or data.

subscribe

Once the users are imported how do you make the passwords work?

Thanks, Steve.

Steve, I assume you're talking about doing a user export from Drupal 6 to a Drupal 7 import. Drupal 7 uses a much more secure hash for protecting passwords, whereas Drupal 6 uses only MD5. MD5 is no longer considered secure since passwords can now be hacked using rainbow tables. I don't know that there is a good way to convert Drupal 6 passwords to Drupal 7, although it would be cool if someone would take one of the MD5 hacking tools that uses rainbow tables and convert them to Drupal 7 passwords. That said, the best plan is to let the users know they will need to reset their passwords via a password reset request that provides a link to do this. Perhaps there is a module available to send out this link for all of the users preemptively.

Thanks Darrell,

I am migrating from Joomla 1.5.x to Drupal 7. I managed to get my userbase over but could not log in once migrated. Your suggestion may do the tricks. I will carry out some testing now.

sub +1

Subscribe. An issue with a life of it's own. Am also trying to use #33. To bad it's not in the normal D7 versioning process.

subscribe

sub

+1

Can we get this on the project page as a beta or even dev?

++1

After attempting this, I've received the following. No one else can now log in:
Warning: Cannot modify header information - headers already sent by (output started at /home/maximoto/public_html/includes/common.inc:2565) in drupal_send_headers() (line 1039 of /home/maximoto/public_html/includes/bootstrap.inc).
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'maximoto_drpl2.field_data_field_company' doesn't exist: SELECT field_data_field_company0.entity_type AS entity_type, field_data_field_company0.entity_id AS entity_id, field_data_field_company0.revision_id AS revision_id, field_data_field_company0.bundle AS bundle FROM {field_data_field_company} field_data_field_company0 WHERE (field_data_field_company0.deleted = :db_condition_placeholder_0) AND (field_data_field_company0.bundle = :db_condition_placeholder_1) LIMIT 10 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => user ) in field_sql_storage_field_storage_query() (line 568 of /home/maximoto/public_html/modules/field/modules/field_sql_storage/field_sql_storage.module).

No Need to make a port.

Feeds does the job perfectly. =-)

philosurfer - Can you tell me how to import Profile2 fields and associate them with a user, then? I have been banging my head on my desk for weeks trying to figure it out! Thanks.

+1 subscribing..

Subscribe

I'm using #33 version and getting the following log messages

Notice: Undefined index: setting in user_import_cron() (line 204 of /public_html/sites/all/modules/user_import/user_import.module).

Any ideas?

Thanks
Sharon

Here is also a solution with the migration module: http://drupal.org/node/1285276

+1

+1

I have the same error as sxs above "Undefined index: email in _user_import_process() (line 1863 of ./modules/user_import/user_import.module)."

I have verified that there are no spaces before and after the email address. The user actually imports fine, there is simply no mail sent. I am using the email address as the userna,e, and reviewing the user account after import both the username and email address are set to the email address -- which is as I intend. I am going to dig a little in the code to see what gives -- but if anyone has any advice, I would love to hear it.

r.b.

I've downloaded #48 but can't install it. I've tried to install it in the normal way I install every module. Is there another way I have to install #48?

I 've copied the module directory to site/all/modules, but it doesn't appear in the modules list.

USE FEEDS!!!

It works... i swear.

What do you exactly mean?

What @philosurfer means, without the module evangelicism, is that the feeds module supports importing different entity types such as nodes, users, etc... in ways other than just RSS (csv, xml, etc...). He is suggesting you use that instead.

Personally, I wrote my own csv import because I had very specific requirements that needed to be met (and allow for a simpler interface that several non-admins could use).

Right, but if you build an importer in feeds, using csv, it is quite simple for any user to import anything. Including users via CSV.

quit wasting your time here unless you are in D6.

Will it allow the addition of data for the Roles Expire module??

Thanks,
Eric

@philosurfer: It would be nice if you cut down on your community-unfriendly tone. Also, I have met people who dislike feeds and have had trouble getting it to work (not me personally) so don't assume that one thing is better than another or a waste of time.

Well, I have tried with Feeds but don't work for me, since I need to map a CSV value to Alternate Login field. I don't know if User import can do it, but at least I want to try.

But I still haven't installed the module, because I copy user_import directory from #48 in sites/all/modules but it doesn't appear in the modules list.

Any help?

New to Drupal. Would love to be able to use this module with 7.x What's the current status?

subscribe

@paulthed,
Stop subscribing and start following. (Use the follow button at the top of the page) :)

I have previously used this module with much success, but now I too am having a blank message body sent to users, and am getting the error:

Warning: implode() [function.implode]: Invalid arguments passed in DefaultMailSystem->format() (line 23 of /home/robertwb/public_html/modules/system/system.mail.inc).

My drupal system is 7.10 and I have
mailmime-7.x-2.15
mailsystem-7.x-2.30.tar.gz

I'm a bit confused!

Thanks,
r.b.

The entire purpose of modules in Drupal is to make something either possible, or easier. There are any number of modules that allow for one very specific function to be performed in a straight forward and user friendly manner, that could be done with a combination of a number of other modules in a complex fashion, or happens to exist as a single component of a very large otherwise unneccessary module.

All due respect:

Suggesting Feeds as an alternative is perfectly valid. Telling people that they're wasting their time by looking for something that does exactly what they want without a bunch of other stuff they don't need/care about is, perhaps, wasting your time.

Quick note that I've been updating the tests for User Import in preparation for updating the module to D7.

Note, I have no timeframe for when the D7 version will be ready.

I tried it and it kind of worked - what's not working is non-US-ascii common in Europe.
The import stops with an Unexpected error (no error codes)
Looking forward for an fixed version.

Did you see this module: http://drupal.org/project/uif/ ?

I've seen it but until I have a method for handling integration with the Role Expire module, I can't use it..

Eric

+1. I would love this to get updated to D7. Looking forward to anything that gets posted.

I've got the plain text emails working but the html implementation seems totally broken - I don't have time to fix that at the moment but here is a link that might help:

http://drupal.org/node/900794

meanwhile changing the code in /supported/user_import.inc at line 81 to the below will fix the plain text versions.

 $message['body'][] = (empty($params['!body'])) ? _user_mail_text('register_admin_created_body', NULL, $params) : strtr($params['!body'], $params);

it's just adding an extra "[]" to $message['body'] as that should be an array

Not sure where things stands in terms of the D7 port but you may want to look at User Import Framework (http://drupal.org/project/uif) and its companion UIF Plus (http://drupal.org/project/uif_plus) which are built over a strong architecture, support most core and entity fields out of the box, have hooks for developer extensions, and are actively maintained.

Full disclosure - I am the lead maintainer on UIF. Robert - kudos on your great past work on this module.

The problem with UIF and UIF Plus is you can't import users' roles.

Just added an initial Drupal 7 upgrade of User Import module.

Doesn't yet support entity or Profile 2 fields, aiming to get that finished next week.

Please test thoroughly before using on production.

Thanks to Francewhoa, bmunslow, starmate, rositis, and everyone else who contributed on this thread!

Wow, thank you very much! Installing right away! Can't wait to see Profiles 2 support next week... it's just what I need to start the private beta of my site...

UPDATE: It doesn't show all my Drupal fields but the email, password & role!

See above "doesn't yet support entity".

Working on it....

I think you are not getting what I mean... I know you are working already on Profile2 support (even if you said you will have it for the past week) but it's not even working properly with the normal Drupal fields because it's displaying only email, password and roles.

I have my Profile2 fields connected to the original User fields so I don't really need Profile2 or entity support but full support to default fields.

Thanks in advance my friend.

"Doesn't yet support entity or Profile 2 fields"

Entity fields are what you call 'normal Drupal fields'.

As I said, being worked on, please stop re-opening this issue. If you do find an issue with the Drupal 7 version of User Import create a new issue for it.

Like #15, I'm having almost the same problem with latest 7 stable version! I will open a new tread to stop spamming this one!

Here is it #1840246: profile_fields doesn't exist error

Note: as I said in my bug report I'm not sure about the roles name format or if emails and passwords can be duplicated, I guess no so I just added a number (Ej. myemail0@server.com) but more important I have no idea of how the username will be applied if entities are not supported yet, so this users won't be able to login?

Please stop re-opening this issue - there is a D7 release of the module, if you find a bug with it just open a new issue specifically for the bug. Grrrrh!