Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Importing Customers and passwords....


Guest

Recommended Posts

I'm having a problem importing customers and their passwords. I have all the information in a CSV file and imported it into my database.

In the CSV file each customer's password is in plaintext (not encrypted). When those plaintext passwords are imported into the database, osC doesn't recognize the password (I realize this isn't the smartest way to store passwords either.)

I have about 1200 customers I need to import.

 

Does anyone have a script to run the customers through the osC add user process?

Or does anyone have any other ideas of what I should do? I'd rather not reassign all the users random passwords and let them change it if possible....

 

Thanks.

Link to comment
Share on other sites

I'm having a problem importing customers and their passwords. I have all the information in a CSV file and imported it into my database.

In the CSV file each customer's password is in plaintext (not encrypted). When those plaintext passwords are imported into the database, osC doesn't recognize the password (I realize this isn't the smartest way to store passwords either.)

I have about 1200 customers I need to import.

 

Does anyone have a script to run the customers through the osC add user process?

Or does anyone have any other ideas of what I should do? I'd rather not reassign all the users random passwords and let them change it if possible....

 

Thanks.

 

You can use an external SQL program to manually access your database and add to the records.

Don't give up. I see light ahead...!

Link to comment
Share on other sites

I'm having a problem importing customers and their passwords. I have all the information in a CSV file and imported it into my database.

In the CSV file each customer's password is in plaintext (not encrypted). When those plaintext passwords are imported into the database, osC doesn't recognize the password (I realize this isn't the smartest way to store passwords either.)

I have about 1200 customers I need to import.

 

Does anyone have a script to run the customers through the osC add user process?

Or does anyone have any other ideas of what I should do? I'd rather not reassign all the users random passwords and let them change it if possible....

 

Thanks.

As far as I know, there is no way to do that. If you have the tables from the old database and don't need the ones from the new one, you can replace them. But you need to replace all of the tables having to do with customers (all of the ones starting with customers and the address book).

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Thanks for the replies. I have replaced the values of the old table into the new table.

Problem is, when the passwords are imported, they show as plain text, not the encrypted password like they do if you manually add a user.

 

Is there a way to run just the passwords through an encrypter and then upload those?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...