Exports with OpenCIS
The export interface provides access to the CAMPUS Organization Directory of the RWTH Aachen or parts of it in four different common formats. The exports can be processed with conventional standard applications, text tools or via an automated system. Alternatively, the IT Center also offers specialized exports.
The organization directory contains more than 650 organization units of the RWTH Aachen and the University Hospital in a hierarchical organization structure. Most information is updated by the organization unit itself. The following information is provided in the organization direcotry per organization unit (formal schema according to XML-schema-standard W3C):
- ikz: Institute index number (Institutskennziffer)
- abbreviation: Abbreviation of the institute
- name: Official name of the institute
- organisation: "RWTH Aachen" or "University Hospital"
- street: Institute address
- postalCode: Postal code of the institute address
- town: Place of the institute address
- telephoneNumber: Phone number of the institute
- facsimilePhoneNumber: Fax number of the institute
- email: Official e-mail address of the institute
- categoryLevel1: 1st level of the organization structure (corresponds to faculty in the case of chairs)
- categoryLevel2: 2nd level of the organization structure (section/department/..)
- url: Web address of the institue
- campusUrl: Web address of the institute on CAMPUS
- gguid: Clear identification of the organization unit on CAMPUS
- parentIkz: Institute index number of the superordinate organization unit
Exports are provided via an IP-filtered or personalized SSL-encrypted access. Access is already activated for the IT Center and individual users. If you require access, please contact the IT service desk specifying an IP address.
The export allows the indication of an institute index number (IKZ) as a paramter. If you only need parts of the organization directory, you can indicate an institute index number. The export then contains only the indicated institute and all its (transitively) subordinate organization units. For example: When you enter the IKZ 150000, which is the institute index number of the section chemistry, the organization unit section chemistry and all its subordinate organization units will be displayed.
The IKZ has to be manually entered at the end of the URL.
Regular Automated Export
The export generated here can automatically be read into and used again in individual data bases by means of tools like wget. The export for the organization directory is updated once a day. For automated usage, the data should be accessed once a day.
Below you will find a description of the XML schema used for the exports.
Various Export Formats
1. Export in the XML Format
The export consists of a text file in a general UTF-8 coding. XML is our preferred format for data exchange. You must, however, dispose of appropriate tools for XML processing. There is an XML Schema for this, that formally describes the structure of the XML file according to W3C-Standard and a documentation for the schema.
2. Export in the Format CSV
A CSV export ("Comma Separated Values") consists of a simply structured text file. The individual datasets are exported as lines in which the individual fields are separated by the tab character. The first line contains the name of the exported fields. The character set used is ISO-8859-1 (ASCll incl. Western European Special Characters).
This format is widespread and can be easily processed with standard tools for text files. Many standard applications, such as Excel and Access, can directly import this format.
Alternatively, the above export also allows for the replacement of german umlauts (ä,ü,ö,ß) by (ae,ue,oe,ss):
3. Export in the Format HTML
The export as HTML exports the data as HTML tables.
4. Sample Export in the Format XLS
The following Excel spreadsheet is a simple example for the usage of the export in Excel, which you can adapt for your own purposes. It is based on a "web query" in Excel which accesses the complete index in the format CSV (see above) and represents it as a spreadsheet. The web query is automatically updated upon opening the spreadsheet. The settings for the web query can be adapted in Excel.