Forum Moderators: buckworks
We have a number of subscribers handled by IBill. IBill allows you to download a CSV through their Web interface listing active subscribers who have cancelled. We used to do a daily midnight cron job that ran a perl script to download this document and parse it to determine who had cancelled - updating our own database accordingly. This script stopped working some time ago, forcing the process to be completed manually - That is, I log in daily to get the cancellation requests..
My suspicion is that IBill changed something about their authentication scheme, which blocks the Perl user agent I was using. The URL and params appear to be valid.
Anyone dealt with this or something similar? Suggestions for getting into IBill's management interface automatically?
An outline of the script and what it returns follow.
Thanks very much.
THE SCRIPT is structured like this:
use HTTP::Request::Common qw(POST);
use LWP::UserAgent;
my $ua = new LWP::UserAgent;
$ua->timeout(300);
my $req = POST '[content management interface url]',
[ [params]...
];
my $res = $ua->request($req)->as_string;
(@list) = split(/\r\n/, $res);
/* Foreach line, update member information */
The DOCUMENT RETURNED BY IBILL is this:
HTTP/1.1 302 (Found) Object moved
Cache-Control: private
Connection: KEEP-ALIVE
Connection: Keep-Alive
Date: Wed, 19 Nov 2003 21:31:04 GMT
Location: login.asp
Server: Microsoft-IIS/5.0
Content-Length: 121
Content-Type: text/html
Client-Date: Wed, 19 Nov 2003 21:12:58 GMT
Client-Peer: 208.62.228.74:443
Client-SSL-Cert-Issuer: /C=US/O=RSA Data Security, Inc./OU=Secure Server Certification Authority
Client-SSL-Cert-Subject: /C=US/ST=Florida/L=Fort Lauderdale/O=Internet Billing Company LLC./OU=ibill/CN=cmi.ibill.com
Client-SSL-Cipher: DES-CBC3-SHA
Client-SSL-Warning: Peer certificate not verified
Set-Cookie: ASPSESSIONIDCQCCTAQC=JMDFIINBAGLIKNMDKIIKPMOA; path=/
Title: Object moved
<head><title>Object moved</title></head>
<body><h1>Object Moved</h1>This object may be found <a HREF="">here</a>.</body>
This indicates that iBill have changed the URL of the CSV file. I can only suggest that you contact their technical support department directly and raise the issue with them
