RE: [greenstone-users] Examples of use of CSVPlug and/or ExcelPlug

From Michael Silver
DateFri, 1 Sep 2006 09:04:47 -0600
Subject RE: [greenstone-users] Examples of use of CSVPlug and/or ExcelPlug
In-Reply-To (6-2-1-2-0-20060825110245-01e84c38-pop3-paradise-net-nz)
greenstone-users-bounces@list.scms.waikato.ac.nz wrote:
> I created a csv file from an Excel file containing my
> metadata, but discovered that " and ' marks translated to ?,
> and that a maximum of 255 characters were copied for any
> particular cell. I have a data field called abstract which
> sometimes goes over that limit.
> Questions:
> 1. Is there a way around the translation and maximum length
> limitations of conversion from Excel to csv? Should I be
> saving to Excel 95 or 97 format and using ExcelPlug? Does
> that work the same way as CSVPlug?

Hi Ed,

I suspect the issue with the " and ' marks are that Excel or some other
program has turned them into the so-called smart-quotes so they aren't ASCII
characters anymore. I took a quick look in Excel and couldn't find it, but
in Word the setting is in the AutoFormat tab of Tools -> AutoCorrect options
menu as "Replace "straight quotes" with "smart quotes".

I've been exporting my data from Access without a problem, including an
annotation field that goes over 255 characters.

HTH,
Michael

Michael Silver, Network Administrator
Parkland Regional Library
5404 56 Avenue Lacombe, AB T4L 1G1
Phone: 403.782.3850 Fax: 403.782.4650
http://www.prl.ab.ca/