Imports and Exports

Import Formats

CSV Formats

See list on the right-hand site.

Markdown

In most imports, there is a description field using Markdown. For more
information about the Markdown markup language, see:
Daring Fireball.

Conventions

  • Some fields in the CSV exports are not part of the import.
    Those fields start with view_ variables and datasets.
  • Columns with the internal_ prefix are indended for internal use only and
    will not be imported (e.g. internal_comment).
  • Language codes, for all translation purposes: ISO 639-1

XML Formats

  • Endnote: Publications in Endnote‚Äôs XML export.
  • r2ddi: DDI-Codebook-based XML, generated by r2ddi.
  • QeDML: QeDML-XML from QLIB.

Other Formats

  • EndnoteKeys are a special import of two columns (accession number and
    keywords) in addition to the normal XML import. Endnote exports everything
    but the keywords to XML what makes this import neccessary.

Import Structure

Top Level

import/
|  system/       # -> system-wide imports
|  study-first/  # \
|  study-second/ #  }-> one folder per study
|  study-third/  # /

All Levels

import/
|  system/
|  |  endnote.xml
|  |  endnote-keys.txt
|  |  ddiOnRails.png
|  study-first/
|  |  studies.csv
|  |  variables.csv
|  |  ...all other csv files...
|  |  files/
|  |  |  ...all files for public folder...
|  |  qedml/
|  |  |  ...questionnaires in QeDML-XML-format...
|  |  r2ddi/
|  |  |  version/
|  |  |  |  ...dataset descriptions in DDI-C-XML...
|  study-second/
|  |  ...like study-first...

Attention: the import procedure is about to change in version 1.0 of DDI on Rails.