[CWISUsers] Question about database schema and importing data

[Mark Jordan]

Hi,

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. Looking at the structure of the MySQL Classifications table and content, for example, makes me
realize that I need to know be certain about the function of SegmentName, LinkString, etc.:


mysql> describe Classifications;
+--------------------+---------+------+-----+---------+----------------+
| Field              | Type    | Null | Key | Default | Extra          |
+--------------------+---------+------+-----+---------+----------------+
| ClassificationId   | int(11) |      | MUL | NULL    | auto_increment |
| FieldId            | int(11) | YES  |     | NULL    |                |
| ClassificationName | text    | YES  |     | NULL    |                |
| Depth              | int(11) | YES  |     | NULL    |                |
| ParentId           | int(11) | YES  |     | NULL    |                |
| SegmentName        | text    | YES  |     | NULL    |                |
| ResourceCount      | int(11) | YES  |     | NULL    |                |
| LinkString         | text    | YES  |     | NULL    |                |
| QualifierId        | int(11) | YES  |     | NULL    |                |
+--------------------+---------+------+-----+---------+----------------+
9 rows in set (0.00 sec)


[Accompanying record:]


ClassificationId: 179
           FieldId: 27
ClassificationName: Pollutants -- Reporting -- United States.
             Depth: 2
          ParentId: 178
       SegmentName: United States.
     ResourceCount: 1
        LinkString: NULL
       QualifierId: 1


Is there any developer-oriented documentation on the MySQL schema that I could have access to? If I do write this MARC import 
script, I'd be happy to share it with the world.

Mark


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/