<font color='black' size='2' face='arial'>ftp://ftp.cedarville.edu/download/download800/download_unidata_unix/csv2xlsx.pl<br>
<br>
<div> <br>
</div>
<div> <br>
</div>
<div> <br>
</div>
<div style="font-family:arial,helvetica;font-size:10pt;color:black">-----Original Message-----<br>
From: Jeff Colvin <jcolvin@mipe.com><br>
To: Cedarville DOWNLOAD Users <download-list@cedarville.edu><br>
Sent: Mon, Aug 17, 2015 10:13 am<br>
Subject: Re: [Download-List] Download Excel Format<br>
<br>
<div id="AOLMsgPart_1.1.2_dc682eb1-de29-43b3-9ebd-3f099123e5f0">
<style scoped="">#AOLMsgPart_1.1.2_dc682eb1-de29-43b3-9ebd-3f099123e5f0 td{color: black;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:"Trebuchet MS"; panose-1:2 11 6 3 2 2 2 2 2 4;} .aolReplacedBody p.MsoNormal,.aolReplacedBody li.MsoNormal,.aolReplacedBody div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Calibri","sans-serif"; color:black;} .aolReplacedBody h1 {mso-style-priority:9; mso-style-link:"Heading 1 Char"; margin-top:24.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; font-size:16.0pt; font-family:"Calibri","sans-serif"; color:black;} .aolReplacedBody h2 {mso-style-priority:9; mso-style-link:"Heading 2 Char"; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; font-size:14.0pt; font-family:"Calibri","sans-serif"; color:black; font-weight:normal;} .aolReplacedBody h3 {mso-style-priority:9; mso-style-link:"Heading 3 Char"; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; font-size:13.0pt; font-family:"Calibri","sans-serif"; color:black; font-weight:normal;} .aolReplacedBody h4 {mso-style-priority:9; mso-style-link:"Heading 4 Char"; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; font-size:14.0pt; font-family:"Calibri","sans-serif"; color:black; font-weight:normal;} .aolReplacedBody h5 {mso-style-priority:9; mso-style-link:"Heading 5 Char"; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; font-size:13.0pt; font-family:"Calibri","sans-serif"; color:black; font-weight:normal;} .aolReplacedBody h6 {mso-style-priority:9; mso-style-link:"Heading 6 Char"; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; page-break-after:avoid; font-size:11.0pt; font-family:"Calibri","sans-serif"; color:black; font-weight:normal;} .aolReplacedBody a:link,.aolReplacedBody span.MsoHyperlink {mso-style-priority:99; color:#993300; text-decoration:underline;} .aolReplacedBody a:visited,.aolReplacedBody span.MsoHyperlinkFollowed {mso-style-priority:99; color:blue; text-decoration:underline;} .aolReplacedBody p.MsoAcetate,.aolReplacedBody li.MsoAcetate,.aolReplacedBody div.MsoAcetate {mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0in; margin-bottom:.0001pt; font-size:8.0pt; font-family:"Calibri","sans-serif"; color:black;} .aolReplacedBody p.MsoNoSpacing,.aolReplacedBody li.MsoNoSpacing,.aolReplacedBody div.MsoNoSpacing {mso-style-priority:1; margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif";} .aolReplacedBody span.Heading1Char {mso-style-name:"Heading 1 Char"; mso-style-priority:9; mso-style-link:"Heading 1"; font-family:"Trebuchet MS","sans-serif"; color:black; font-weight:bold;} .aolReplacedBody span.Heading2Char {mso-style-name:"Heading 2 Char"; mso-style-priority:9; mso-style-link:"Heading 2"; font-family:"Trebuchet MS","sans-serif"; color:black;} .aolReplacedBody span.Heading3Char {mso-style-name:"Heading 3 Char"; mso-style-priority:9; mso-style-link:"Heading 3"; font-family:"Trebuchet MS","sans-serif"; color:black;} .aolReplacedBody span.Heading4Char {mso-style-name:"Heading 4 Char"; mso-style-priority:9; mso-style-link:"Heading 4"; font-family:"Trebuchet MS","sans-serif"; color:black;} .aolReplacedBody span.Heading5Char {mso-style-name:"Heading 5 Char"; mso-style-priority:9; mso-style-link:"Heading 5"; font-family:"Trebuchet MS","sans-serif"; color:black;} .aolReplacedBody span.Heading6Char {mso-style-name:"Heading 6 Char"; mso-style-priority:9; mso-style-link:"Heading 6"; font-family:"Trebuchet MS","sans-serif"; color:black;} .aolReplacedBody span.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Tahoma","sans-serif"; color:black;} .aolReplacedBody span.EmailStyle25 {mso-style-type:personal; color:black;} .aolReplacedBody span.EmailStyle26 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:#1F497D;} .aolReplacedBody span.EmailStyle27 {mso-style-type:personal; color:black;} .aolReplacedBody span.EmailStyle28 {mso-style-type:personal-reply; color:black;} .aolReplacedBody .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} .aolReplacedBody div.WordSection1 {page:WordSection1;}</style>
<div bgcolor="white" background="cid:image003.gif@01D0D8E4.62F23D10" class="aolReplacedBody" lang="EN-US">
<img class="shape" style="display:none;width:0;height:0" src="cid:image003.gif@01D0D8E4.62F23D10" height="0" width="0">
<div class="WordSection1">
<div class="MsoNormal">I downloaded and installed the new beta version 8.01 for Universe/Unix and performed the same Excel test and got these results...</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">>SSELECT DLTESTFILE</div>
<div class="MsoNormal">>>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</div>
<div class="MsoNormal"> </div>
<div class="MsoNoSpacing">DOWNLOAD version 8.01</div>
<div class="MsoNoSpacing">Using input file DLTESTFILE</div>
<div class="MsoNoSpacing">Output to file &HOLD& DOWNLOAD.TAB</div>
<div class="MsoNoSpacing"> </div>
<div class="MsoNoSpacing">Executing perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i &HOLD&/DOWNLOAD.TAB -o &HOLD&/DOWNLOAD.XLSX</div>
<div class="MsoNoSpacing">Verb "PERL" is not in your VOC.</div>
<div class="MsoNoSpacing"> </div>
<div class="MsoNoSpacing">7 records processed.</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">Any suggestions on resolving this issue are appreciated.</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">Jeff</div>
<div class="MsoNormal"> </div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<div class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> <a href="mailto:download-list-bounces@cedarville.edu">download-list-bounces@cedarville.edu</a> [<a href="mailto:download-list-bounces@cedarville.edu?">mailto:download-list-bounces@cedarville.edu</a>] <b>On Behalf Of </b>Jeff Colvin<br>
<b>Sent:</b> Tuesday, July 14, 2015 11:52 AM<br>
<b>To:</b> Cedarville DOWNLOAD Users<br>
<b>Subject:</b> [Download-List] Download Excel Format</span></div>
</div>
</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">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.</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">I set up VOC DOWNLOAD.CONFIG:</div>
<div class="MsoNormal">001: X</div>
<div class="MsoNormal">002: XLSX.ACTIVE=TRUE</div>
<div class="MsoNormal">003: XLSX.COMMAND=perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i %input -o %output</div>
<div class="MsoNormal">004: XLSX.INPUT.SEPARATOR=TAB</div>
<div class="MsoNormal">005: XLSX.INPUT.SUFFIX=TAB</div>
<div class="MsoNormal">006: XLSX.WORKING.DIRECTORY=&HOLD&</div>
<div class="MsoNormal">007: XLSX.DELETE.WORKING.RECORD=TRUE</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">>SSELECT DLTESTFILE</div>
<div class="MsoNormal">>>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</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">DOWNLOAD version 8.00</div>
<div class="MsoNormal">Using input file DLTESTFILE</div>
<div class="MsoNormal">Output to file &HOLD& DOWNLOAD.tab</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">Executing perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef -i &HOLD&/DOWNLOAD.TAB -o &HOLD&/DOWNLOAD.XLSX<span style="background:yellow;mso-highlight:yellow"></span></div>
<div class="MsoNormal"><span style="background:yellow;mso-highlight:yellow">This command is not available on this platform</span></div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">7 records processed.</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal"> </div>
<div class="MsoNormal">I'm not sure if this is a testing, configuration, or a Perl issue.</div>
<div class="MsoNormal"> </div>
<div class="MsoNormal"> </div>
<div class="MsoNormal"><b><span style="color:#1F497D">Jeff Colvin</span></b></div>
<div class="MsoNormal"><i><span style="font-size:11.0pt;color:#1F497D">Senior Programmer Analyst</span></i></div>
<div class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Mission Petroleum Carriers</span></div>
<div class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">832-615-0717</span></div>
<div class="MsoNormal"><span style="color:#1F497D"><img id="Picture_x0020_1" alt="cid:image001.png@01D09E05.7A345720" src="cid:image004.png@01D0D8E4.62F23D10" height="68" width="120"></span><span style="font-size:11.0pt"></span></div>
<div class="MsoNormal"> </div>
</div>
</div>
</div>
<div id="AOLMsgPart_2_4b4a9002-3e7a-460b-bdac-97bc083120be" style="margin: 0px;font-family: Tahoma, Verdana, Arial, Sans-Serif;font-size: 12px;color: #000;background-color: #fff;">
<pre style="font-size: 9pt;"><tt>_______________________________________________
download-list mailing
list
<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
</tt></pre>
</div>
<!-- end of AOLMsgPart_2_4b4a9002-3e7a-460b-bdac-97bc083120be -->
</div>
</font>