Talk:Customers Export

From DevWiki

Password returns the SHA256 encoded password, not the raw password that is seen in the Volusion Admin.

The SELECT_Columns and WHERE_Columns do not need a "c." in front of the values. For example, SELECT_Columns=CustomerID,EmailAddress,FirstName,Password.

Exporting multiple customers will not export the password, but will just ignore the that field as being requested.

Exporting passwords

I needed to export the customer passwords from Volusion, so I wrote the following script to do it:

javascript:void(q=function(custcount){var http=new XMLHttpRequest();var pref="https://"+window.location.hostname+"/admin/AdminDetails_Generic.asp?table=Customers&ID=";var regex = /<input type="hidden" name="password" value="([^"]*)">/i;var table = {};for(var n=1;n<=custcount;n++){http.open("GET",pref+n,false);http.send(null);regex.test(http.responseText);table[n] = RegExp.lastParen;}for(var o=1;o<=custcount;o++){document.write(o+" "+table[o]+"
");}});void(q(prompt("What's your largest customer ID?")));

Paste it into the address bar while logged into an account with access to view customer passwords. Be sure to look up your largest customer ID before using it (it will ask you for that value). Tested only in Firefox - IE7 should run it fine, IE6 will need a slight modification.

Run time: about 1 second per customer (3600 customers will take about an hour) The result data will need some cleanup, which Excel can handle just fine.--Brilliand 16:30, 9 December 2008 (CST)