<div dir="ltr"><div><br></div><div><div style="font-family:Arial;font-size:16px">Version 8.00 of Cedarville DOWNLOAD is now available on our ftp site (<a href="ftp://ftp.cedarville.edu/" target="_blank">ftp.cedarville.edu</a>).</div>
<div style="font-family:Arial;font-size:16px"> </div><div style="font-family:Arial;font-size:16px">This version has one small change and one major change compared to version 7.41:</div><div style="font-family:Arial;font-size:16px">
<div><span style="font-family:Courier"><div>* Bug fix (CSV format with multiple MV.ORIENTATION VERTICAL fields<br></div><div>* did not align fields properly)</div><div>* Add support for invoking a "csv to xlsx" routine</div>
<div><br></div></span></div><div><br></div></div><div style="font-family:Arial;font-size:16px"><font face="Courier"></font>Creation of XLSX (Excel) files is accomplished by calling a routine at the operating system level</div>
<div style="font-family:Arial;font-size:16px">to convert a tab- or comma-delimited file to XLSX format. An example of doing this with a free Perl library</div><div style="font-family:Arial;font-size:16px">on RedHat Linux is shown in the DOWNLOAD documentation and an appropriate Perl script is included</div>
<div style="font-family:Arial;font-size:16px">in the distribution files. The Perl library will also work on Windows installations (I've had success with</div><div style="font-family:Arial;font-size:16px">the ActivePerl collection).</div>
<div style="font-family:Arial;font-size:16px"><br></div><div style="font-family:Arial;font-size:16px">Sample command:</div><div style="font-family:Arial;font-size:16px"> GET.LIST MY.LIST</div><div style="font-family:Arial;font-size:16px">
DOWNLOAD CUSTOMERS <a href="http://CUST.NAME">CUST.NAME</a> CUST.ANNUAL SALES \</div><div style="font-family:Arial;font-size:16px"> FILE REPORT.DIR CUSTOMER.XLSX OVERWRITING \</div><div style="font-family:Arial;font-size:16px">
FORMAT XLSX</div><div style="font-family:Arial;font-size:16px"><br></div><div style="font-family:Arial;font-size:16px">What happens:</div><div style="font-family:Arial;font-size:16px"> Based on entries in VOC DOWNLOAD.CONFIG, a temporary file named CUSTOMER.TAB</div>
<div style="font-family:Arial;font-size:16px"> is created. This file is then converted to XLSX format by invoking the appropriate system-level</div><div style="font-family:Arial;font-size:16px"> script and (as specified in the config entry) the temporary file is deleted.</div>
<div style="font-family:Arial;font-size:16px"><br></div><div style="font-family:Arial;font-size:16px">Sample DOWNLOAD.CONFIG:</div><div><div><font face="Arial" size="3">001: X</font></div><div><font face="Arial" size="3">002: COMPILE.EVAL=TRUE</font></div>
<div><font face="Arial" size="3">003: LOG.SUBROUTINE=DOWNLOAD.LOG.SUBR</font></div><div><font face="Arial" size="3">004: LOG.COUNTER=384</font></div><div><font face="Arial" size="3">005: XLSX.ACTIVE=True</font></div><div>
<font face="Arial" size="3">006: XLSX.COMMAND=perl /usr/local/bin/<a href="http://csv2xlsx.pl">csv2xlsx.pl</a> -s tab -e undef -q undef -i %input -o %output</font></div><div><font face="Arial" size="3">007: XLSX.INPUT.SEPARATOR=TAB</font></div>
<div><font face="Arial" size="3">008: XLSX.INPUT.SUFFIX=TAB</font></div><div><font face="Arial" size="3">009: XLSX.WORKING.DIRECTORY=_HOLD_</font></div><div><font face="Arial" size="3">010: XLSX.DELETE.WORKING.RECORD=TRUE</font></div>
<div style="font-family:Arial;font-size:16px"><br></div></div><div style="font-family:Arial;font-size:16px"><br></div><div style="font-family:Arial;font-size:16px">I'm open to suggestions for improving on this approach.</div>
<div style="font-family:Arial;font-size:16px"> </div></div><div><br></div><br clear="all"><div>David Rotman, Ph.D.<br>Associate Vice President for Technology<br>Chief Information Officer<br>Cedarville University<br>251 N. Main Street<br>
Cedarville, OH 45314<br><a href="mailto:rotmand@cedarville.edu" target="_blank" onclick="window.open('https://mail.google.com/mail/?view=cm&tf=1&to=rotmand@cedarville.edu&cc=&bcc=&su=&body=','_blank');return false;">rotmand@cedarville.edu</a><br>
voice 937-766-7905<br>fax 937-766-8819<div><img src="http://www.cedarville.edu/~/media/Images/Information-Technology/IT-logo-for-signature.jpg"><br></div></div>
</div>