Export

Annotations and comments can be exported to two different formats:

  • CSV: Comma Separated Values
  • XLS: Microsoft Excel

The data is exported in the form of a table whereas the rows contain items (text annotations, structured annotations and comments) and the columns contain the following information:

Column Name Value Description
Id Number Unique identification number of item
Creation Date Date Date when the item was created
Last Updated Date Latest modification date
Author String Name of the creator of the item
E-mail String E-mail address of the author
Track String Track this item belongs to
Start Number Start time of item in seconds
End Number End time of item in seconds
Duration Number Duration of item
Type 'S', 'T' or 'C'

Type of item

  • Structured annotation
  • Text annotation
  • Comment
Value String or Number For text annotations and comments, this is the actual annoation text respectively comment text. For Structured annotations, this field contains the scale values as defined by the scale or, in case that no scale is used, the field is empty
Category String Name of the category of structured annotations. Not applicable for text annotations and comments
Label String Name of the label of structured annotations. Not applicable for text annotations and comments
Refers To Number For comments, this field contains the identification number of the annotation the comment refers to. Not applicable for annotations.

 

The table will contain all annotations and comments that are visible to the signed-in user, i.e. all annotations and comments that are public or have been created by this user.