[Download-List] Download Excel Format
Jeff Colvin
jcolvin at mipe.com
Mon Aug 17 14:22:11 EDT 2015
I changed VOC DOWNLOAD.CONFIG as follows:
001: X
002: XLSX.ACTIVE=TRUE
003: XLSX.COMMAND=sh /c 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<http://DATE.FIELD.MV> MONEY.FIELD.MV<http://MONEY.FIELD.MV> NUMERIC.FIELD VFIELD HEADING FIELD.NAMES FORMAT XLSX FILE &HOLD& DOWNLOAD.XLSX OVERWRITING
7 record(s) selected to SELECT list #0.
DOWNLOAD version 8.01
Using input file DLTESTFILE
Output to file &HOLD& DOWNLOAD.TAB
Executing sh /c perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i &HOLD&/DOWNLOAD.TAB -o &HOLD&/DOWNLOAD.XLSX
SH: /c: No such file or directory
7 records processed.
Jeff
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Rotman, David
Sent: Monday, August 17, 2015 12:39 PM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Download Excel Format
It looks like you need to modify the DOWNLOAD.CONFIG entry in the voc to include 'sh /c ' in the command:
sh /c perl /usr/local/bin/csv2xlsx.pl<http://csv2xlsx.pl/> -s tab -e undef -q undef -i %input -o %output
I don't have access to Universe under Linux, so I can't verify this precisely. I do know that the Universe/Windows variant works:
DOS /C perl /usr/local/bin/csv2xlsx.pl<http://csv2xlsx.pl/> -s tab -e undef -q undef -i %input -o %output
David Rotman, Ph.D.
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu<mailto:rotmand at cedarville.edu>
voice 937-766-7905
fax 937-766-8819
[http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg]
On Mon, Aug 17, 2015 at 1:13 PM, Jeff Colvin <jcolvin at mipe.com<mailto:jcolvin at mipe.com>> wrote:
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<http://DATE.FIELD.MV> MONEY.FIELD.MV<http://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<http://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> [mailto: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<http://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<http://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<http://DATE.FIELD.MV> MONEY.FIELD.MV<http://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<http://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<tel:832-615-0717>
[cid:image002.png at 01D0D8EE.6DCD6DE0]
_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto: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/729306c0/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 530 bytes
Desc: image001.gif
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150817/729306c0/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 13524 bytes
Desc: image002.png
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150817/729306c0/attachment.png>
More information about the download-list
mailing list