Web Hosting Talk : Web Hosting Main Forums : Hosting Software and Control Panels : Adding name and address to plesk clients

[wmguk]

Hey,

I have 80 clients in plesk at the moment, however NONE of them have addresses and correct contact details, they were just created quickly to get the accounts online.

I have a csv exported from my accounts package, is there a simple way to import my csv to update the client accoutns deails?

The other way I think is via phpMyadmin - I could simply download the clients table as a csv, edit it in excel and then reupload the csv - however would this work, is there any danger here? as I am simply adding a few fields to the existing csv?

[Helix development]

You can manage clients table using phpMyadmin, but 'psa' database should be dumped before such changes:

# mysqldump -uadmin -p`</etc/psa/.psa.shadow` psa >/root/psa.dump.sql

It's easy to write a script to apply such changes.

For example, you have clients contact details in CSV file client_data.csv containing login, company name, person name, phone, email:

johns,NewSoft Inc.,John Smith,1234567890,john@example.com
billg,MS,Bill Gates,0987654321,billg@eample.com

Bash script:

#!/bin/bash
while read -d, C_LOGIN C_CNAME C_PNAME C_PHONE C_EMAIL JUNK; do
   /usr/local/psa/bin/client -u "$C_LOGIN" -company "$C_CNAME" -name "$C_PNAME" -phone "$C_PHONE" -email "$C_EMAIL"
done <client_data.csv

Best regards.

Eduard