OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
bin
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/03/2023 08:25:32 AM
rwxr-xr-x
📄
auditreport.sh
1.15 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
clripcs
44.5 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
comparedb.sh
487 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
convertToexcel.pl
3.69 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
convertToexcel_my.rd.pl
3.06 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
crlf.sh
67 bytes
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
cron.sh
173 bytes
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubadmserv
1.94 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubalert
1.3 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubetlserv
1.97 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubgphserv
2.55 MB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
cubmenuserv
2.51 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubnotify
2.79 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubot.properties
1.93 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
cubregenxy
947.66 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubregenxy.gz
341.15 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubrouter
378.71 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubrxgate
440.74 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
cubrxlogin
529.18 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubsearch
1.58 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubsearchrouter
520.15 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
doZip.sh
669 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
esalesforce
57 bytes
02/03/2023 07:34:09 AM
rwxr-xr-x
📁
etl
-
02/03/2023 07:34:08 AM
rwxr-xr-x
📁
etl_odbc
-
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
finyr.so
25.82 KB
02/03/2023 07:34:11 AM
rwxr-xr-x
📄
finyr.so_16May
26.11 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
fmtxml2ooffice.sh
1013 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
forecast.R
3.13 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
gep_days.so
10.03 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
html2csv.sh
2.97 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
html2ps
129.14 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
httpd
565.41 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
httpd_2.2
2.9 MB
02/03/2023 07:34:15 AM
rwxr-xr-x
📁
jars
-
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
jgraphserver.sh
841 bytes
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
libAdaptikTokenServiceProvider.so
631.87 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libTokenServiceProvider.so
146.98 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libcrypto.so.0.9.8
38.29 KB
05/03/2022 10:19:39 AM
rw-r--r--
📄
libcubotsvc.so
112.92 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
libdbdriver.so
113.32 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libldap-2.3.so.0
319.36 KB
05/12/2022 01:52:38 PM
rw-r--r--
📄
libmysqlclient.so
1.52 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libmysqlclient.so.15
3.78 MB
04/23/2023 02:08:47 PM
rw-r--r--
📄
libmysqlclient.so.16
3.78 MB
04/23/2023 02:08:47 PM
rw-r--r--
📄
libodbc.so.1
421.49 KB
03/26/2018 02:37:19 PM
rw-r--r--
📄
libpcre.so.1
449.93 KB
05/17/2022 07:42:45 AM
rw-r--r--
📄
librxauth.so
98.6 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxetl.so
29.8 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxfusionchart.so
60.25 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
librxgphserv.so
125.78 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxmetadata.so
227.2 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
librxmysql.so
80.75 KB
02/03/2023 07:34:10 AM
rwxr-xr-x
📄
librxolap.so
823.31 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
libssl.so.0.9.8
563.78 KB
05/24/2023 05:14:51 PM
rw-r--r--
📄
libtdsodbc.so
929.6 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
makeXtab2NormalExcel.pl
5.33 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
mod_axis2.so
226.12 KB
02/03/2023 08:01:00 AM
rwxr-xr-x
📄
mod_jk.so
384.77 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
mod_rx.so
50.69 KB
02/03/2023 08:01:00 AM
rw-r--r--
📄
multiSheet.pl
5.74 KB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
preCheck.js
1.03 KB
02/03/2023 07:34:13 AM
rw-r--r--
📄
priority_regen.sh
4.41 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
procscript.sh
321 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxdummydb.so
108.43 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxmssql.so
112.95 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxmysql.so
108.4 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
rxodbc.so
113.24 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxolite.so
108.45 KB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
rxora.so
113.03 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
rxsalesforce.so
108 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxsybase.so
123.61 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
services.xml
6.64 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
setvars.sh
556 bytes
02/03/2023 07:34:15 AM
rwxr-xr-x
📁
utils
-
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
ws.core.js
40.18 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
wsAll.js
142.94 KB
02/03/2023 07:34:09 AM
rw-r--r--
Editing: makeXtab2NormalExcel.pl
Close
#/usr/bin/perl ########################################################################################################################### # DESC: SCRIPT TO MODIFY CROSSTAB EXCEL REPORT TO NORMAL EXCEL REPORT. # # # # Ussage: makeXtab2NormalExcel.pl file_name_with_path fixed_column ignore_rows sheet_name merge # # # # Author: Arun Kumar Swain # # # # Company: Robust Designs (India) Pvt. Ltd # # # # Last Updated:Tue Sep 29 11:05:57 IST 2009 # # # ########################################################################################################################### my $infile=$ARGV[0]; my $fixedcol=$ARGV[1]; my $ignrrows=$ARGV[2]; my $SheetName=$ARGV[3]; my $merge=$ARGV[4]; #Newly added on 29-sep-09. we are merging all sheets if set 1 $DateCol=$ARGV[5]; #print "I got infile=$infile fixedcol=$fixedcol ignrrows=$ignrrows SheetName=$SheetName merge=$merge \n"; if($merge eq 1){ #If merge option is set then process all sheets. To process all sheets I am making sheet Name as blank. $SheetName=""; } else{ $merge=0; } if($DateCol == ""){ $DateCol=-1; } my $xlsxf=index($infile,".xlsx"); my $Workbook; use Spreadsheet::ParseExcel::Utility qw(ExcelFmt); if($xlsxf > 0){ use Spreadsheet::XLSX; $Workbook =Spreadsheet::XLSX ->new($infile); } else{ use Spreadsheet::ParseExcel; my $XLS = new Spreadsheet::ParseExcel; $Workbook = $XLS->Parse($infile) or print "Parse Failllllllllllllllllllllllled\n"; } my($WorkSheet, $Cell, $CellRow, $CellCol); my $flag=0; my $allsh = 0, $PrintHeading=1, $tmpfname=""; if( "$SheetName" ne ""){ #Process one sheet for(my $Sheet=0; $Sheet < $Workbook->{SheetCount} ; $Sheet++){ $WorkSheet = $Workbook->{Worksheet}[$Sheet]; if( "$SheetName" eq "$WorkSheet->{Name}" ){ $tmpfname=">/tmp/$WorkSheet->{Name}".".csv"; MakeXtab2Normal($tmpfname, $ignrrows, $fixedcol, $WorkSheet, $PrintHeading); } } } else #Process All sheet. Case: Sheets are identical { for(my $Sheet=0; $Sheet < $Workbook->{SheetCount} ; $Sheet++){ $WorkSheet = $Workbook->{Worksheet}[$Sheet]; if(($merge eq 1) && ($Sheet eq 0)){ $tmpfname=">/tmp/$WorkSheet->{Name}".".csv"; $PrintHeading=1; } elsif(($merge eq 1) && ($Sheet ne 0)){ $tmpfname=">".$tmpfname if $Sheet eq 1; $PrintHeading=0; } else { $tmpfname=">/tmp/$WorkSheet->{Name}".".csv"; $PrintHeading=1; } print "\n **********$tmpfname****No of Records=".$WorkSheet->{MaxRow} if defined $WorkSheet->{MaxRow}."***\n"; MakeXtab2Normal($tmpfname, $ignrrows, $fixedcol, $WorkSheet, $PrintHeading); } } undef $XLS; sub MakeXtab2Normal{ my $tmpfname = shift; my $ignrrows = shift; my $fixedcol = shift; my $WorkSheet = shift; my $PrintHeading = shift; my $FILEH; my @HEADING=(); my $NXTROW, $CellRow, $CellCol,$MAXHEADCOL; open($FILEH, $tmpfname) or die "File Creation failed Error:$!"."[".$tmpfname."]\n"; print "\nCurrent SHEET:", $WorkSheet->{Name}, "\n"; for( $CellRow= $WorkSheet->{MinRow}; defined $WorkSheet->{MaxRow} && $CellRow<= $WorkSheet->{MaxRow}; $CellRow++){ #Ignore rows specified if($ignrrows ne "" && $CellRow<$ignrrows){ next; } # Prepare Headings for( $CellCol= $WorkSheet->{MinCol} ; defined $WorkSheet->{MaxCol} && $CellCol<= $WorkSheet->{MaxCol}; $CellCol++){ $Cell = $WorkSheet->{Cells}[$CellRow][$CellCol]; if($Cell){ push(@HEADING, $Cell->{_Value}); } else{ push(@HEADING, "NA"); } } last; } $NXTROW=++$CellRow; $MAXHEADCOL=$CellCol; # Print Heading print "\n***************************$PrintHeading**************************************\n"; if($PrintHeading eq 1){ $fixedcol = 1 if $fixedcol eq "" ; for(my $i=0; $i < $fixedcol; $i++){ print $FILEH $HEADING[$i]."|"; } print $FILEH "XTAB|Count \n"; } for(my $HEADCNT= $fixedcol ; $HEADCNT < $MAXHEADCOL; $HEADCNT++) { # Dont consider the total columns next if $HEADING[$HEADCNT] =~/[Tt]otal/; for($CellRow=$NXTROW; defined $WorkSheet->{MaxRow} && $CellRow<= $WorkSheet->{MaxRow}; $CellRow++){ my @csvdata = (); # Dont print row if first column is blank next if $WorkSheet->{Cells}[$CellRow][$WorkSheet->{MinCol}]->{_Value} eq "" ; # Dont print row if value is zero next if $WorkSheet->{Cells}[$CellRow][$HEADCNT]->{Val} <= 0; # Dont print row if value is blank #next if $WorkSheet->{Cells}[$CellRow][$HEADCNT]->{_Value} eq ""; for( $CellCol= $WorkSheet->{MinCol} ; $CellCol< $fixedcol; $CellCol++){ $Cell = $WorkSheet->{Cells}[$CellRow][$CellCol]; if($Cell && ($CellCol == $DateCol-1)){ my $val=ExcelFmt('yyyy-mm-dd',$Cell->{Val}); push(@csvdata, $val); } elsif($Cell){ $Cell->{_Value} =~ s/[\x00-\x09\x0B\x0C\x0E-\x1F\x7F-\xFF]//g; $Cell->{_Value} =~ s/&/&/g; $Cell->{_Value} =~ s/'/'/g; push(@csvdata, $Cell->{_Value}); } else{ push(@csvdata, ""); } } push(@csvdata, $HEADING[$HEADCNT]); #Xtab Name push(@csvdata, $WorkSheet->{Cells}[$CellRow][$HEADCNT]->{Val}); #Xtab Value @csvdata=join("|", @csvdata); print $FILEH @csvdata, "\n"; } } close($FILEH); } 1;