Thread

We imported several thousand EE member accounts using the member import utility. All of the users passwords were imported as plain text and were 8 digit numbers starting with “00” like “00510731”. For some weird reason the passwords that wound up getting imported did not have these leading zeros. So 00510731 became 510731. This is presenting me with a big problem because these users are expecting their passwords to have these leading zeros. I don’t think this issue was introduced by EE or the member import utility because I have done some tests to try and see if I can replicate the issue but I cannot. So I think the issue is more likely to have been created when we exported the data from Excel into a CSV file but I’m not sure.

My question: Can anyone suggest a way to insert two zeros in front of each password in the member DB using SQL? i’m not sure how to begin since the passwords are stored in an encrypted format.

If someone can help me sort this out I will be forever grateful!

mindshare,

What version and build of EE are you using?

My question: Can anyone suggest a way to insert two zeros in front of each password in the member DB using SQL? i’m not sure how to begin since the passwords are stored in an encrypted format.

Yes there is no way you are goignt o be able to update those encryted passwords

Is there any way you can delete those members and try the import again?

When you used the Member Import Utility to convert your delimited csv to an XML file, did you examine that for the correct password format before proceeding? Can you take a look at it now?

Thanks John,

That’s exactly what I wound up having to do. Also, I isolated the issue - it was the stupid auto-formatting that MS Excel applies that screwed up the import (it saw the column with the numerical passwords and decided for us that the leading zeros weren’t needed). The XML file/import utility wasn’t the issue. You can close this thread.

Thank you.

Glad you were able to figure out what the problem was. Don’t hesitate to post again as needed.