[CWISUsers] Question about database schema and importing data

[Mark Jordan]

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

-- 

Mark Jordan
Acting Coordinator of Library Systems
W.A.C. Bennett Library, Simon Fraser University
Burnaby, British Columbia, V5A 1S6, Canada
Phone (604) 291 5753 / Fax (604) 291 3023                 
mjordan at sfu.ca / http://www.sfu.ca/~mjordan/