Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 10-14-2011 10:21:04

jensme
Member
Registered: 04-29-2010
Posts: 392

Can you export usernames and passwords?

If you want to switch to another PHP based software (or any other host/software combo), is there a way to export your customers?

Offline

 

#2 10-14-2011 10:48:24

JDLS88
Member
From: Maryland, USA
Registered: 07-06-2011
Posts: 102
Website

Re: Can you export usernames and passwords?

To what extent are you looking to export users? Just their usernames/passwords/addresses or all that plus their order history?

If the first you should be able to export the ecom_users table via phpmyadmin or the Raw Database Admin as a csv or exce file. Then you just need to copy/paste the needed columns into the new system's database (which you would also need to export as csv/excel file).


Jeremy D.

Offline

 

#3 10-14-2011 10:55:56

jensme
Member
Registered: 04-29-2010
Posts: 392

Re: Can you export usernames and passwords?

Yes and yes!  Aren't the passwords private, though?  If so, how does the system translate that?

Offline

 

#4 10-14-2011 11:21:31

JDLS88
Member
From: Maryland, USA
Registered: 07-06-2011
Posts: 102
Website

Re: Can you export usernames and passwords?

I'm not 100% sure on this, but I think I have the gist of it right. CCP hashes the passwords so you dont have the raw password text anywhere on the server. When you log in it hashes your typed password and ti checks it against the saved one. I assume whatever system you're switching to would do the same, but I'm not sure if it would hash the same way?

Trying it out would be the quickest way to find out though.


Jeremy D.

Offline

 

#5 10-14-2011 11:24:20

JGB
Member
From: Holyoke, Massachusetts
Registered: 01-16-2004
Posts: 298

Re: Can you export usernames and passwords?

Those are in MD5 hash. I don't think you have to translate them, just copy that column with the other info you need (user name, etc. )and move it to a spreadsheet by way of a .csv file and paste in the same column for "passwords" in the new spreadsheet from the new software. You might have to create one account so you can see how the new table field is laid out.

I believe this would work, maybe someone else can chime in.

Offline

 

#6 10-14-2011 11:30:20

jensme
Member
Registered: 04-29-2010
Posts: 392

Re: Can you export usernames and passwords?

Thanks!

Offline

 

Board footer