Need help importing customers database from csv file into mySQL

[jeffmic]

OK Dr, this is getting quite deep and I am getting a bit lost on this.

If there an application that will just convert about 25000 passwords to MD5+salt?

thanks so much,

Jeff

[DrByte]

How's this?

Unzip to your /admin folder.
Then log into your admin
Then change the URL to call the filename.
Best to only run once.

It will convert all passwords less than 30 characters to MD5+salt using Zen Cart's built-in functions.

[Attachment removed]

[jeffmic]

I got all the stuff working, but I can't convert even the first password.
It's happening at the Salt part (it looks like)
Here's the error message:

Converting all plain-text passwords less than 30 characters long to Zen Cart MD5+SALT format.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':63 WHERE customers_id = 5094' at line 1
in:
[update customers set customers_password = 5265eddec1d5b0e4fbadca636c3c6a6f:63 WHERE customers_id = 5094]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I'll keep trying to find a way around it until I hear something back from you.

thanks so much for your help

Jeff

[DrByte]

Oops. Worked fine on smaller dataset for me. Missed some quotes. Update attached.

[jeffmic]

WA HOOOO!!!


You's the DOCTOR alright!

This has saved me soooo much time, I can't begin to tell you.
I hope others can benefit from this little tool also.

Almost 23,000 imports and it worked perfectly.

(Hey, is there a tool that will decode one address too if someone calls in on the phone and needs help?)


I'M SENDING SOME COFFEE RIGHT NOW! You have really made my day...week..year etc.


thanks again,
Jeff Michaels
pres of Musical Creations Ltd.

[DrByte]

There's no decode option for the encrypted passwords.

However, there is a "master password" contribution that can be used to allow you to log in to the customer's account using your admin password ... see the "Encrypted Master Password" contribution for a very easy install.

[jeffmic]

I'll give it a try.
Thanks....

There was another Paypal contribution by me today. http://www.zen-cart.com/donate

[DrByte]

There was another Paypal contribution by me today.

Greatly appreciated !

[urasakik]

I also appreciate this support information and the tool.
This is great help to me.
Thank you.