Revision: 4653
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at January 14, 2008 17:38 by eszpee
Initial Code
#!/usr/bin/perl
use strict;
use LWP::UserAgent;
my $silent = 0; # set to 1 for no output on stdout
my $logindata = {
'j_username' => 'fill in your username (email)',
'j_password' => 'fill in your password',
'j_remember' => 'on',
};
my $loginurl = 'http://crm.zoho.com/crm/zohologin';
my $backupurl = 'http://crm.zoho.com/crm/ExportEntity.do';
my @backuptables = qw{Users Leads Accounts Contacts Potentials Campaigns Tasks Events Notes Competitors Products PriceBooks Cases Solutions Forecasts Vendors Quotes SalesOrders PurchaseOrders Invoices};
my $ua = LWP::UserAgent->new;
$ua->cookie_jar({ file => "cookies.txt" });
print qq{get cookie from frontpage...} unless $silent;
my $devnull = $ua->get('http://crm.zoho.com/crm/login.sas'); #get cookie
print qq{done.\n} unless $silent;
print qq{login as $$logindata{'j_username'}...} unless $silent;
my $loginresponse = $ua->post($loginurl, $logindata);
print qq{done.\n} unless $silent;
foreach my $whichtable (@backuptables) {
print qq{exporting $whichtable.csv...} unless $silent;
my $backupdata = {
'module' => $whichtable,
};
my $backuptable = $ua->post($backupurl, $backupdata);
open (KI, ">$whichtable.csv");
print KI $backuptable->content;
close (KI);
print qq{done.\n} unless $silent;
}
Initial URL
Initial Description
fill your username and password
Initial Title
Backup all your tables from ZOHO CRM in CSV format
Initial Tags
script, backup, csv
Initial Language
Perl