Guest Posted December 7, 2006 Posted December 7, 2006 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.
TechieTW Posted December 11, 2006 Posted December 11, 2006 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...!
Jack_mcs Posted December 11, 2006 Posted December 11, 2006 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
Guest Posted December 11, 2006 Posted December 11, 2006 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?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.