PDA

View Full Version : Csv


LFCII
10-10-2007, 11:36 AM
Hi,

Is it possible to export client info to a third party billing system using CSV or another way?

Kind Regards,

Les

Domains_Aamir
10-13-2007, 10:26 AM
Hello,

Most likely yes, but I don't know of a particular way.

Forum browsers: Can you assist?

Thanks,

Aamir A.
Reseller Services

yurtesen
10-13-2007, 01:57 PM
Do you mean like when you click on '# Financial Statements ' There is a Download As CSV File option in RWI?

Alex
10-13-2007, 10:13 PM
Hi,

Is it possible to export client info to a third party billing system using CSV or another way?

Kind Regards,

Les
The Search Domains page can export results to a CSV file, but it's indexed by domain, not by client. If you want the whole list of all domains in your reseller account, just click "Results to file" without specifying any search options.

It doesn't list the username for each domain either, but keep in mind that usernames in the Tucows system are not necessarily unique. That's why the management system requires you to provide a domain in addition to user/pass when logging in.

The CSV output looks like this:
Date Registered,Expiry Date,Domain Name,Initial Cost,Total Cost,Lock State,WHOIS Privacy,Parked Pages

Nov 23 2005,Dec 18 2010,domain1.com,$6.50,$25.97,0,Disabled,Disabled
Nov 25 2005,Jan 10 2010,domain2.com,$6.50,$19.48,0,Disabled,Disabled
Nov 29 2005,Mar 30 2010,domain3.com,$6.50,$19.48,0,Disabled,Disabled
Dec 15 2005,May 19 2008,domain4.com,$6.49,$12.98,0,Disabled,Disabled
...

LFCII
10-14-2007, 01:00 PM
Hi Alex,

Thanks for the reply and info. I have used that function before. I was looking for a way to import all my clients into a 3rd party inventory / billing script. A lot of these scripts allow importing from a CSV file.

Kind Regards,

Les