Exporting Activities from AM is done from the Activity List or Activity Series table. This feature can be used if you need to use the Activity data for tasks outside of Time Edit, or for extended investigation of the data.

When exporting Activities, all activities in the current form will be included in the export, i.e. using a filter will not affect which data is exported.

All columns will be added to the export, so even if some columns are hidden in the UI, they will still be included in the export.

Even if the export is performed from the Activity Series table, the export will contain one row for each Activity. It will not be grouped by Activity Series

‍

In the Activity list or Activity Series list, click the "Export Activities" button. This will initiate an export and notify the user in a popup. When the export finishes, an email will be sent to the user who initiates the export with a link to the export file. 

Please note that an export can take several minutes to complete, before the email is sent.

‍

Clicking the link will open the file in your default browser. For some browsers (like Chrome) the file will be immediately downloaded, but some browsers (like Safari) will open the file in a tab in the browser. This is not very useful, so the file can be saved by selection File -> Save As.. and saving the file. Make sure the filename ends with ".csv".

The downloaded file is a CSV file that contains all Activity data. This could be opened with any spreadsheet tool. Make sure to use comma as a delimiter when opening the file.

‍

There are a number of standard columns included in the file:

Activity Id

This is unique activity of an Activity. It is not visible in the UI, but could be useful when comparing different exports.

Activity Series Id

This is the Id of the Activity Series that the activity belongs to. All Activities within an Activity Series will share this Id. 

Track number

This is the Track number of the Activity within the Activity Series

No of tracks

This is the total number of Tracks in the Activity Series that the Activity belongs to.

Week number

This is the (ISO) week number of the Activity. This is based on the Start time and End time values

Start time

This is the start time of the Activity. For Activities without an exact time and date, this is the start of the week where this Activity should be scheduled. The date/time is displayed in the timezone specified in the Timezone column.

End time

This is the end time of the Activity. For Activities without an exact time and date, this is the end of the week where this Activity should be scheduled. The date/time is displayed in the timezone specified in the Timezone column.

Weekday

If a weekday has been assigned to the Activity, it will be shown here.

Exact time

If an exact time has been assigned to the Activity, it will be shown here.

Timezone

The timezone of the Activity is displayed here. The Start time and End time will be displayed in this Timezone.

Duration

This is the duration of the Activity, in minutes.

Status

This is the Status of the Activity. It can be one of these: NOT_SCHEDULED, SCHEDULED, FAILED

Tags

This will include all tags applied to the Activity

Primary object

This is the ext-id of the Primary Object for the Activity

Activity type

This is the ext-id of the Activity Type object for the Activity

After these standard columns, all Objects are included. These columns will share the header "Objects". The second header row will display the ext-id of the Object Type in that column. All values are displayed as object ext-ids.

After the Objects all Object Filter values will be included. These columns will share the header "Object filters". The second header row will display the ext-id of the Object Type that the filter value belongs to as well as the ext-id of the Field. These will be concatenated with a period, like so: "object_ext_id.field_ext_id"

If multiple values are set for a particular Object filter, they will be separated using a "|" character. If an object needs to match all values in the filter, they will be shown like "value_1 | value_2", but if the object needs to match only one, or any of the values, they will be shown like (value_1 | value_2).

After the Object Filters, all Fields are included. These columns will share the header "Fields". The second header row will display the ext-id of the field.

After the Fields, all Information fields are included. These columns will share the header "Information fields". The second header row will show the name of the information field. There is no ext-id for this column, as information fields are not part of the data model.

‍