[Download-List] Download Excel Format

Tue Aug 18 14:07:26 EDT 2015

My networking team was kind enough to setup a Linux virtual server for me
to use in testing.  Here is what I have found:

In contrast to the Universe Windows "DOS" command, the Universe Unix "SH"
command requires that the referenced item be a shell script rather than an
executable file.  So, my suggestion is to try wrapping your PERL command in
a shell like this:

     #!/bin/bash
     # /usr/local/bin/perlwrap.sh
     # 08/17/2015
     #
     perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i $1 -o $2

Make sure you mark the script as executable via 'chmod'.

Then, modify DOWNLOAD.CONFIG like this:
003: XLSX.COMMAND=sh /usr/local/bin/perlwrap.sh %input %output

Again, my knowledge of Universe is limited...so I welcome comments and
suggestions.

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
voice 937-766-7905
fax 937-766-8819

On Mon, Aug 17, 2015 at 2:22 PM, Jeff Colvin <jcolvin at mipe.com> wrote:

> 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 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 -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 -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
> voice 937-766-7905
> fax 937-766-8819
>
>
>
> On Mon, Aug 17, 2015 at 1:13 PM, Jeff Colvin <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 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
>
> [image: cid:image001.png at 01D09E05.7A345720]
>
>
>
>
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list
>
>
>
> _______________________________________________
> 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/20150818/1c3e0d89/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 530 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150818/1c3e0d89/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 13524 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150818/1c3e0d89/attachment.png>