[Download-List] Version 8.0 of Cedarvile DOWNLOAD released

[Rotman, David]

Version 8.00 of Cedarville DOWNLOAD is now available on our ftp site (
ftp.cedarville.edu).

This version has one small change and one major change compared to
version 7.41:
*   Bug fix (CSV format with multiple MV.ORIENTATION VERTICAL fields
*        did not align fields properly)
*   Add support for invoking a "csv to xlsx" routine


Creation of XLSX (Excel) files is accomplished by calling a routine at the
operating system level
to convert a tab- or comma-delimited file to XLSX format.  An example of
doing this with a free Perl library
on RedHat Linux is shown in the DOWNLOAD documentation and an appropriate
Perl script is included
in the distribution files.  The Perl library will also work on Windows
installations (I've had success with
the ActivePerl collection).

Sample command:
  GET.LIST MY.LIST
  DOWNLOAD CUSTOMERS CUST.NAME CUST.ANNUAL SALES \
     FILE REPORT.DIR CUSTOMER.XLSX OVERWRITING \
     FORMAT XLSX

What happens:
   Based on entries in VOC DOWNLOAD.CONFIG, a temporary file named
CUSTOMER.TAB
   is created.  This file is then converted to XLSX format by invoking the
appropriate system-level
   script and (as specified in the config entry) the temporary file is
deleted.

Sample DOWNLOAD.CONFIG:
001: X
002: COMPILE.EVAL=TRUE
003: LOG.SUBROUTINE=DOWNLOAD.LOG.SUBR
004: LOG.COUNTER=384
005: XLSX.ACTIVE=True
006: XLSX.COMMAND=perl /usr/local/bin/csv2xlsx.pl -s tab -e undef -q undef
-i %input -o %output
007: XLSX.INPUT.SEPARATOR=TAB
008: XLSX.INPUT.SUFFIX=TAB
009: XLSX.WORKING.DIRECTORY=_HOLD_
010: XLSX.DELETE.WORKING.RECORD=TRUE


I'm open to suggestions for improving on this approach.



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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20140122/f7a7fcec/attachment.html>