Separator character

Character used to separate your data entries. Default value is ‘;’, a typical CSV entry woould look like username;password;phone;email

List separator character

Character used to separate entries in lists. This is used if one of the im- or exported fields contains a collection as value. Default value is ‘|’, a typical list entry would look like [1|2|3], where the braces indicate the value as list.

Charset

Charset of your data. Note: MS Excel in a western country will use Windows-1252

Date format

SimpleDateFormat used to import and export date values; e.g. "EEE, d MMM yyyy HH:mm:ss Z"

Export

• cURL

You may also filter classes to export using the ‘classesToExport’ query parameter and a comma separated list of classes which you want to be exported:

• cURL

If you have multiple modules with classes that have the same name, you can prepend the classnames with the module name and a dollar sign after the module name:

• cURL

You can also filter the data that you want to be exported by using a query:

• cURL

Or limit the resultset:

• cURL

Usually, images are exported as URLs in the CSV. If you want them to be contained as files directly in the CSV, simply add the ‘exportResources’ parameter like follows:

• cURL

Import

Assuming import.zip containing all classes as csv data, the import command would look like:

• cURL

Each exported dataset of your own classes contains an ID field, which is the ID from ApiOmat database. Do NOT change this field if you want to update the dataset. If you create new entries, leave this field empty. Self-created IDs will lead to import errors. If you want to give your new data entries an ID, you can use an arbitrary (but unique) value in the foreignId field. You can even use this foreignId if you want to set references from other classes.