[Download-List] Download Excel Format

Wjhonson wjhonson at aol.com
Mon Aug 17 13:23:02 EDT 2015


ftp://ftp.cedarville.edu/download/download800/download_unidata_unix/csv2xlsx.pl


 

 

 

-----Original Message-----
From: Jeff Colvin <jcolvin at mipe.com>
To: Cedarville DOWNLOAD Users <download-list at cedarville.edu>
Sent: Mon, Aug 17, 2015 10:13 am
Subject: Re: [Download-List] Download Excel Format


  
  
I downloaded and installed the new beta version 8.01 for Universe/Unix and performed the same Excel test and got these results...
  
 
  
>SSELECT DLTESTFILE
  
>>DOWNLOAD DLTESTFILE @COUNTER @ID TEXT.FIELD DATE.FIELD.MV MONEY.FIELD.MV NUMERIC.FIELD VFIELD HEADING FIELD.NAMES FORMAT XLSX FILE &HOLD& DOWNLOAD.XLSX OVERWRITING
  
 
  
DOWNLOAD version 8.01
  
Using input file DLTESTFILE
  
Output to file &HOLD& DOWNLOAD.TAB
  
 
  
Executing perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i &HOLD&/DOWNLOAD.TAB -o &HOLD&/DOWNLOAD.XLSX
  
Verb "PERL" is not in your VOC.
  
 
  
7 records processed.
  
 
  
 
  
Any suggestions on resolving this issue are appreciated.
  
 
  
Jeff
  
 
  
   
    
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Jeff Colvin
Sent: Tuesday, July 14, 2015 11:52 AM
To: Cedarville DOWNLOAD Users
Subject: [Download-List] Download Excel Format
   
  
  
 
  
I'm having issues getting DOWNLOAD version 8.00 to work for the Excel (XLSX) format using UniVerse.  I copied the csv2xlsx.pl Perl script from the distribution list over to my /usr/local/bin directory.
  
 
  
I set up VOC DOWNLOAD.CONFIG:
  
001: X
  
002: XLSX.ACTIVE=TRUE
  
003: XLSX.COMMAND=perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i %input -o %output
  
004: XLSX.INPUT.SEPARATOR=TAB
  
005: XLSX.INPUT.SUFFIX=TAB
  
006: XLSX.WORKING.DIRECTORY=&HOLD&
  
007: XLSX.DELETE.WORKING.RECORD=TRUE
  
 
  
>SSELECT DLTESTFILE
  
>>DOWNLOAD DLTESTFILE @COUNTER @ID TEXT.FIELD DATE.FIELD.MV MONEY.FIELD.MV NUMERIC.FIELD VFIELD HEADING FIELD.NAMES FORMAT XLSX FILE &HOLD& DOWNLOAD.XLSX OVERWRITING
  
 
  
DOWNLOAD version 8.00
  
Using input file DLTESTFILE
  
Output to file &HOLD& DOWNLOAD.tab
  
 
  
Executing perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i &HOLD&/DOWNLOAD.TAB -o &HOLD&/DOWNLOAD.XLSX
  
This command is not available on this platform
  
 
  
7 records processed.
  
 
  
 
  
I'm not sure if this is a testing, configuration, or a Perl issue.
  
 
  
 
  
Jeff Colvin
  
Senior Programmer Analyst
  
Mission Petroleum Carriers
  
832-615-0717
  
  
 
 


_______________________________________________
download-list mailing
list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150817/740f81e6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.gif
Type: image/gif
Size: 530 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150817/740f81e6/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 13524 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150817/740f81e6/attachment.png>


More information about the download-list mailing list