(SOLVED) Generate MD5 Encrypted Passwords for Clients using OpenOffice

[iberinternet]

I'm going to publish this easy way for novel users:

 

I've read in many posts here about the problems of importing clients from other shops or older prestashop versions.

 

The solution is really easy and there are many ways to do it, but I'm going to show you another an easy way for users without mysql/php programming knowlege.

 

I suppose you have imported all your clients from another installation to the new prestashop installation and your client's passwords are not encrypted or they don't have a valid encryptation.

 

In this case, your clients can't login to your shop or if they do it, they can't make and order and pay it, because the verification process fails.

 

The passwords (field "passwd") imported are in this format: Ex: 666666

And you want to have them encrypted (MD5): 4a2a8440dd66917967d1cd2c87598166

You also have to put the same encrypted passwords in the "secure_key" field.

 

Attached you can find a zip file containing:

1) An extension to install for openoffice (cryptographic.oxt). You can also download it from here:

http://extensions.openoffice.org/en/project/cryptographic-hash-functions-uno-component-openofficeorg

2) A massive md5 generator for openoffice (prestashop-texthash-md5-generator.ods) using the function TEXTHASH.

 

INSTRUCTIONS:

==============

- Install the attached extension in openoffice

- Open the attached ods file

- Find the COOKIE_KEY of your prestashop installation (/config/settings.inc.php). Copy and paste it in the first column.

- Copy and paste all client's passwords (not encripted) in the second column.

- The last column will give you the md5 encrypted passwords.

- Apply same function to all passwords

- Copy and paste the result in the "passwd" and "secure_key" fields of table "ps_customer"

I recommend to use Navicat or directly phpmysql

prestashop-texthash-generator.zip