IPA to use syscmd node for executing importdb

Legacy Contributor

Hi,

 

I am trying to upload data to GLTRANSREL file using input CSV file. I used IPA SYSCMD node and executed importdb option.  the output returns -1 with no error explantion. Anyone please help on this

Execution mode - runshell

command : importdb -fa <!Productline> GLTRANSREL <!GLInputFile>

Legacy Contributor

I store the Perl script below in %GENDIR%/bin and then in the syscmd node I execute it like this perl /lawprod/gen/bin/epicgl_load.pl



($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time) ;

$year=$year+1900 ;

$mon=$mon+1 ;

if ($mon<10) {$mon="0".$mon;}

if ($mday<10) {$mday="0".$mday;}

if ($hour<10) {$hour="0".$hour;}

if ($min<10) {$min="0".$min;}

if ($sec<10) {$sec="0".$sec;}

$filedate="$mon$mday$year$hour$min$sec" ;

if ((-e "D:/epicftp/pbgl.csv") and (-e "D:/epicftp/LawsonGLExtract.csv")){

system("importdb -af prod gltransrel /epicftp/pbgl.csv") ;

system("importdb -af prod gltransrel /epicftp/LawsonGLExtract.csv") ;

system("D:/lawprod/gen/bin/epicgl_email.bat") ;

system("mv /epicftp/pbgl.csv /epicftp/epicgl_bkp/pbgl_$filedate.csv") ;

system("mv /epicftp/LawsonGLExtract.csv /epicftp/epicgl_bkp/LawsonGLExtract_$filedate.csv") ;

}

else

{system("D:/lawprod/gen/bin/epicglno_email.bat") ;}