Documentation/Project K/Import procedure

Virtual research environment for collaborative analysis of classroom photographies. The initial metadata have been collected in Citavi system, which prones to errors and many cycles of data correction and validation. Metadata collected in Citavi was exported first to an Excel file and after to xml format.

Prerequisites

In order to have a meaningfull data, the following steps are necessary:

• Cleaning up the data. Please verify that MSWord text formatting characters are not into Citavi file. If yes, please remove them.
• Export Citavi file to Excel
• Build up a schema for Excel file. This will be used to export excel file to XML format. XML format will be transformed using an .XSLT transformation script.

An example of the schema file is the following:

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="ItemsTable">
        <xs:complexType>
            <xs:sequence>
                <xs:element ref="ItemRow" minOccurs="0" maxOccurs="unbounded"/>
            </xs:sequence>
        </xs:complexType>
    </xs:element>
    <xs:element name="ItemRow">
        <xs:complexType>
            <xs:sequence>
				<xs:element name="Jahrermittelt" type="xs:string"/>             
                <xs:element name="Titel" type="xs:string"/>
				<xs:element name="Dateiname_Artikel" type="xs:string"/>
				<xs:element name="Ort" type="xs:string"/>
				<xs:element name="Verlag" type="xs:string"/>
				<xs:element name="Zeitschrift_Zeitung" type="xs:string"/>
				<xs:element name="Nummer" type="xs:string"/>
				<xs:element name="Seiten_von_bis" type="xs:string"/>
				<xs:element name="Artikeltitel" type="xs:string"/>
				<xs:element name="Artikelseiten" type="xs:string"/>
				<xs:element name="Artikelautor" type="xs:string"/>
				<xs:element name="Fotoredaktion_Gestaltung" type="xs:string"/>
				<xs:element name="Fotountertitel" type="xs:string"/>
				<xs:element name="Jahrgang" type="xs:string"/>
				<xs:element name="Notiz" type="xs:string"/>
				<xs:element name="Rubrik" type="xs:string"/>
				<xs:element name="Redaktion" type="xs:string"/>
				<xs:element name="Autor" type="xs:string"/>
				<xs:element name="Fotoagentur" type="xs:string"/>
				<xs:element name="Kategorien" type="xs:string"/>
            </xs:sequence>
        </xs:complexType>
    </xs:element>
</xs:schema>

Use the transformation procedure as it is described in: