Hi folks,

I have recently done a user import of approximately 700 users. Though all parts of the import seemed to go as planned, one thing jumped out at me as I went browsing through the new user list.

All my user names seem to have eleven (11) zeros prepended to the username!

A sample section of my CSV file looks like this:

,"09908","FirstNameA","LastNameA","EmailaddressA","Emailaddress2A","Active"
,"09910","FirstNameB","LastNameB","EmailaddressB","Emailaddress2B","Active"
,"09915","FirstNameC","LastNameC","EmailaddressC","Emailaddress2C","Active"
,"09917","FirstNameD","LastNameD","EmailaddressD","Emailaddress2D","Active"
,"10200","FirstNameE","LastNameE","EmailaddressE","Emailaddress2E","Active"
,"10208","FirstNameF","LastNameF","EmailaddressF","Emailaddress2F","Active"
,"10209","FirstNameG","LastNameG","EmailaddressG","Emailaddress2G","Active"

with the number (used in a different registration system) being used as the username. Unfortunately the user name gets imported as:

0000000000009908
0000000000009910
0000000000009915
0000000000009917
0000000000010200
0000000000010208
0000000000010209

So a couple questions... was this a setting I missed in the module? Also, since this is now in my Drupal DB like this and all the account-creation e-mail messages have been sent out to the users, what would be the most sane way of trimming all these zeros and letting the users know that they've been changed?

Thanks in advance!

Comments

robert castelo’s picture

robert castelo commented

jeffnik- why are you using User Import 5.x-1.3?

User Import 5.x.2.7 fixes many bugs, such as this one, and has been out for weeks.

robert castelo’s picture

robert castelo commented
Status: Active » Fixed
jeffnik’s picture

jeffnik commented

Unfortunately I noticed the new version after I had done the user import. I got caught up between the bureaucracy that ensued between the time I set-up the import and when I was given the go ahead, and didn't do my due diligence.

So now I'm trying to figure out the best (and hopefully programmatic) way of changing all 650 of the user names and issuing notices to the users when it's done!

robert castelo’s picture

robert castelo commented

Is it OK to delete the users and import them again?

jeffnik’s picture

jeffnik commented

At this point I'm sort've loathe to, but I believe that I won't cause any damage by doing a TRIM of the username directly in mySQL and then I'll do a mass e-mail about updated names.

Thanks for your help!

I do like this module a lot, and it is my fault for not checking on updates (or doing a test run beyond the "test" button)... so all things are good.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.