5 use Net::SFTP::Foreign::Compat;
7 use FS::UID qw(adminsuidsetup datasrc);
14 use vars qw( $opt_m $opt_p $opt_r $opt_e $opt_d $opt_v );
15 getopts('m:p:r:e:d:v');
18 #$opt_e = ".$opt_e" unless $opt_e =~ /^\./;
23 my $user = shift or die &usage;
26 # %%%FREESIDE_CACHE%%%
27 my $cachedir = '/usr/local/etc/freeside/cache.'. datasrc. '/cdrs';
28 mkdir $cachedir unless -d $cachedir;
30 my $format = shift or die &usage;
32 use vars qw( $servername );
33 $servername = shift or die &usage;
39 warn "Retrieving directory listing\n" if $opt_v;
41 $opt_m = 'sftp' if !defined($opt_m);
49 $ls = [ grep { /^$opt_p.*\.$opt_e$/i } $ls_ftp->ls ];
51 elsif($opt_m eq 'sftp') {
54 $ls_sftp->setcwd($opt_r) or die "can't chdir to $opt_r\n"
57 $ls = $ls_sftp->ls('.', wanted => qr/^$opt_p.*\.$opt_e$/i,
61 die "Method '$opt_m' not supported; must be ftp or sftp\n";
68 foreach my $filename ( @$ls ) {
70 warn "Downloading $filename\n" if $opt_v;
75 $ftp->get($filename, "$cachedir/$filename")
76 or die "Can't get $filename: ". $ftp->message . "\n";
80 $sftp->get($filename, "$cachedir/$filename")
81 or die "Can't get $filename: ". $sftp->error . "\n";
84 warn "Processing $filename\n" if $opt_v;
86 my $error = FS::cdr::batch_import( {
87 'file' => "$cachedir/$filename",
89 'batch_namevalue' => $filename,
97 $ftp->rename($filename, "$opt_d/$filename")
98 or die "Can't move $filename to $opt_d: ".$ftp->message . "\n";
102 $sftp->rename($filename, "$opt_d/$filename")
103 or die "can't move $filename to $opt_d: ". $sftp->error . "\n";
107 unlink "$cachedir/$filename";
116 "Usage: \n cdr.import user format servername\n";
119 use vars qw( $sftp $ftp );
122 return $ftp if $ftp && $ftp->pwd;
124 my ($hostname, $user) = reverse split('@', $servername);
125 my ($user, $pass) = split(':', $user);
127 my $ftp = Net::FTP->new($hostname) or die "FTP connection to '$hostname' failed.";
128 $ftp->login($user, $pass) or die "FTP login failed: ".$ftp->message;
129 $ftp->cwd($opt_r) or die "can't chdir to $opt_r\n" if $opt_r;
136 return $sftp if $sftp && $sftp->cwd;
138 my %sftp = ( host => $servername );
140 $sftp = Net::SFTP::Foreign->new(%sftp);
141 $sftp->error and die "SFTP connection failed: ". $sftp->error;
148 cdr.sftp_and_import - Download CDR files from a remote server via SFTP
152 cdr.sftp_and_import [ -m method ][ -p prefix ] [ -e extension ] [ -r remotefolder ] [ -d donefolder ] [ -v ] user format [sftpuser@]servername
156 Command line tool to download CDR files from a remote server via SFTP or FTP and then
157 import them into the database.
159 -m: transfer method (sftp or ftp), defaults to sftp
161 -p: file prefix, if specified
163 -e: file extension, defaults to .csv
165 -r: if specified, changes into this remote folder before starting
167 -d: if specified, moves files to the specified folder when done
171 user: freeside username
173 format: CDR format name
175 [sftpuser@]servername: remote server
176 (or ftpuser:ftppass@servername)