[CWISUsers] Question about database schema and importing data

[Barry Wiegan]

Hi Mark,

There is no need to put quotes (single or double) around text,
paragraph, or controlled names in your input file. They will
import correctly without them.

A single quote within a controlled name should also import
correctly (without a backslash). However, I believe you have
uncovered a bug which we will fix in a future release.
Escaping it in the interim should work for you.

Regards,
Barry

Mark Jordan wrote:
> Hi Ed,
> 
> Actually, now that I've read the docs a bit more closly and written some test data, I've been able to parse some MARC records into the
> CWIS input format and import them (and I'd be happy to share my sample script, but I probably should clean it up a bit first). Writing a
> line for each resource, for each classification, worked like a charm once I figured out what I had to escape. Is is safe to assume that
> the importer uses a single quotation mark around text (Text, Paragraph, Controlled Name) fields, so if I \' single quotes in every field
> there should be no problem? The first time I tried to import I got back an SQL error caused by a single quote within an Author field.
> When I escaped the single quotation marks, it worked great.
> 
> I have to say that CWIS is the most flexible content management system I've seen so far, particularly with regard to how it handles
> metadata. I'll be using it for a demo CMS in a class I'm teaching at the University of British Columbia's School of Library, Archival,
> and Information Studies in July and August, and very likely for my own library's ethesis collection.
> 
> I have one remaining question: how easy would it be to add additional OAI metadata schemas?
> 
> Mark
> 
> On Wed, May 26, 2004 at 01:25:11AM -0500, Edward Almasy wrote:
> 
>>On Tue, May 25, at 03:30:11PM, Mark Jordan wrote:
>>
>>>Is there more information available on importing data into cwis?
>>>MetadataTool/SPT--ImportData.php describes the process at a
>>>high level, but I'm interested in seeing more detail. My motivation
>>>for this is that I am considering using cwis as our electronic theses
>>>and dissertations database, and I will be dumping a few thousand MARC
>>>records from out library catalogue and importing them into cwis.
>>
>>   Mark, I take it the import function in CWIS won't do what you need it
>>   to to do?  Can you give more information about what you need to import
>>   and/or what hurdles you've encountered?  The built-in import facilities
>>   are pretty flexible.
>>
>>   Ed
>>
>>
>>-- 
>>   Edward Almasy                                     ealmasy at scout.wisc.edu
>>   Co-Director                                         1308 W Dayton Street
>>   Internet Scout Project                                  Madison WI 53706
>>   Computer Sciences Department                        608-262-6606 (voice)
>>   University of Wisconsin - Madison                     608-265-9296 (fax)
>>_______________________________________________
>>CWISUsers mailing list
>>CWISUsers at scout.wisc.edu
>>http://scout.wisc.edu/mailman/listinfo/cwisusers
> 
> 

-- 
Barry Wiegan
Sr. Software Engineer
Internet Scout Project
Madison, WI
bwiegan at scout.wisc.edu