General Information


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 of 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

Access

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-ServiceDesk specifying an IP address.

Parameter IKZ

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. 

XML Schema


Below you will find a description of the XML schema used for the exports.

 XML Schema
Elements Complex types Simple types 
 oulist  ouType gguidType 
      ikzType 
      ouNameType 
       telephoneNumberType  
      urlType 
 element oulist

diagram
childrenou
annotation
documentation 
Liste mit Organisationseinheiten
source
 element oulist/ou

diagram
typerestriction of ouType
attributes
Name  Type  Use  Default  Fixed  Annotation
ikz  ikzType  required       
abbreviation  xs:string         
name  ouNameType  required       
organisation  xs:string         
street  xs:string         
postalCode  xs:string         
town  xs:string         
telephoneNumber  telephoneNumberType         
facsimilePhoneNumber  telephoneNumberType         
email  xs:string         
categoryLevel1  ouNameType         
categroyLevel2  ouNameType         
url  xs:string         
campusUrl  urlType         
gguid  gguidType         
source
 complexType ouType

diagram
used by
element oulist/ou
attributes
Name  Type  Use  Default  Fixed  Annotation
ikz  ikzType  required       
abbreviation  xs:string         
name  ouNameType  required       
organisation  xs:string         
street  xs:string         
postalCode  xs:string         
town  xs:string         
telephoneNumber  telephoneNumberType         
facsimilePhoneNumber  telephoneNumberType         
email  xs:string         
categoryLevel1  ouNameType         
categroyLevel2  ouNameType         
url  xs:string         
campusUrl  urlType         
gguid  gguidType         
source
 simpleType gguidType

typerestriction of xs:string
used by
attribute ouType/@gguid
facets
length 32
pattern (\d|[A-F])*
annotation
documentation 
128Bit genesisworld global unique identifier
source
 simpleType ikzType

typerestriction of xs:string
used by
attribute ouType/@ikz
facets
maxLength 10
whiteSpace collapse
annotation
documentation 
Institutskenziffer (IKZ)
source
  simpleType ouNameType

typerestriction of xs:string
used by
facets
maxLength 140
whiteSpace preserve
pattern \p{IsBasicLatin}*
annotation
documentation 
Offizielle Bezeichnung für Organisationseinheiten
source
 simpleType telephoneNumberType

typerestriction of xs:string
used by
facets
maxLength 30
whiteSpace collapse
pattern \+\d{1,2}( \d+)*
annotation
documentation 
Int. Telefonnummer nach ITU
source
  simpleType urlType

typerestriction of xs:anyURI
used by
facets
pattern http:
annotation
documentation 
URL
source

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.

Export as xml

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.

Export as csv

Alternatively, the above export also allows for the replacement of german umlauts (ä,ü,ö,ß) by (ae,ue,oe,ss):

Export as csv with umlauts in subsitute representation .

3. Export in the Format HTML

The export as HTML exports the data as HTML tables.

Export as HTML

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.

Example_for_CAMPUS-organization directory_in_Excel.xls