AbleCommerce Shopping Cart Software

using this method discussed here "Re: Any way to add 100's of users to existing groups" I uploaded my users and their data imcluding passwords, but unless i re-enter the password by hand in the administration interface they can't login in. Its like the password did not get set on the original upload. How can i see or tell whats going on. The users are there when i serach for them in the administration interface but the passwords dont seem to work. Help please.

You can look in the database and it will show something in the field. We have run into trouble in the past where passwords have been imported in bulk from somewhere and have had to trim beginning/ending spaces out of them.

jmestep wrote:You can look in the database and it will show something in the field. We have run into trouble in the past where passwords have been imported in bulk from somewhere and have had to trim beginning/ending spaces out of them.

Judy when i query the ac_UserPasswords table the passwords are not human readable so how do i tell if there is a problem with the content of the password field. for example with something like this Z2UXkMbxR3XkShcVCZ7NHOdlNIC3Fz5V2A== how can I tell.

thanks for you response

Brick

I think I posted the wrong info- I had to put a trim() on the username field because of spaces. You could try that on the password field, but that might not be the problem. The problem could be the encryption method you used on the passwords before you uploaded them-you didn't specify in this post where the data came from.

Judy, these user records and unencrypted passwords came from a csv that I uploaded with the dataport tool. I dont know how they got encrypted. I guess its the default on the field maybe? What do you think the problem is now that you have this additional info.

thanks

Brick

Well, I'm out of ideas.

I think you need to make sure when exporting users in your CSV file then no spaces are added in password fields.

Yea i think that has to be where the problem is/was i'll try and run trim against the db field and see if that helps.

thanks all.

Brick