Column names in the CSV file
Learn more about the column names in the CSV file exported from Fotoware.
14. October 2026
Activity Exports are provided as CSV files. The columns available in an export depend on your Activity Export configuration, including the events and metadata fields configured for logging.
The table below describes the fields that can be included in the CSV file. The field names correspond to the CSV column headers and can also be used when analyzing or visualizing the data in tools such as Microsoft Excel or Power BI.
The exact set of fields depends on the Activity Export configuration. For example, the metadata fields exported are configurable.
The table below describes the fields in the CSV files and the categories of information they belong to.
| Field category |
Field name (as in the column header of the CSV file) |
Description |
| General | EventId |
Unique string ID of the activity event. |
EventTime |
Time of the activity event (UTC timezone). | |
ActivityType |
The type of activity event, for example, Metadata edit. Note: Only activity types that are configured for Activity Export are logged and included in the CSV file. |
|
| User info | UserInfo.UserId |
The ID of the user performing the activity. Note: The User info fields are only logged if Activity Export is configured to log user information. |
UserInfo.UserName |
The user name of the user performing the activity. | |
| Asset info | AssetInfo.ArchiveId |
The ID of the archive of the asset involved in the activity. Note: The Asset info fields contain values only if an asset is involved in the activity event. Examples of such events are Metadata edit, Upload, and Download. |
AssetInfo.ArchiveName |
The name of the archive of the asset. | |
AssetInfo.FileName |
The file name of the asset, for example, "image.jpg" | |
AssetInfo.PathToAsset |
The path of the asset relative to the archive, for example, "folder 1/image.jpg" | |
AssetInfo.AssetHref |
The relative URL path to the Fotoware site, for example, "/fotoweb/archives/5001-Photo-Archive/Folder%201/image.jpg.info |
|
AssetInfo.ChangedMetadataFields |
A list of metadata fields whose values have changed as a result of the activity, for example, "XMP005:Title;XMP025:Keywords" | |
| Workflow info | WorkflowInfo.WorkflowId |
The string identifier of the workflow performed in the activity. The workflow may represent either an action or a marker. Note: The Workflow info fields only have values if a workflow item (action or marker) was involved in the activity performed. |
WorkflowInfo.WorkflowName |
The name of the action or marker (workflow item). | |
WorkflowInfo.WorkflowType |
The type of workflow, i.e., either the string "Action" or "Marker". | |
WorkflowInfo.DestinationType |
The destination type when an action has a destination, for example, "Archive". | |
WorkflowInfo.DestinationUri |
The destination URI of the asset for an action with a destination. | |
WorkflowInfo.DestinationArchiveId |
In case of an action with a destination of type archive, this field is the ID of the destination archive. | |
WorkflowInfo.DestinationArchiveName |
In case of an action with a destination of type archive, this field is the name of the destination archive. | |
| Search info | SearchInfo.ArchiveId |
The ID of the archive in which a search took place. Note: The Search Info fields have values only if the performed activity is of type Search. |
SearchInfo.ArchiveName |
The name of the archive in which a search took place. | |
SearchInfo.PathToSearchFolder |
If specified, the path to the folder being searched within the archive. This can be a regular folder or a smart folder.
|
|
SearchInfo.UserDtSearchString |
The user search string for the archive, as applied in the search. | |
SearchInfo.AutoDtSearchString |
The auto search string for the archive, as applied in the search. Note: The user and the auto search strings together build up the complete search string as sent to the underlying search engine (Fotoware Index Manager or Fotoware Veloz). |
|
SearchInfo.NumberOfHits |
The number of search results in the archive being searched. | |
SearchInfo.ProcessingTimeMs |
The milliseconds it took to perform the search. | |
| Asset metadata (current) | XMP005[Current]:Title |
Metadata field 5, named Title, with the current value after the activity was logged. "Current" metadata values are logged when an asset is involved in the activity. Note: Only metadata fields that are configured for Activity Export are logged and included in the CSV file. Each metadata field enabled for logging will appear as two separate columns, one for the current value and one for the previous value (see Asset metadata (previous) below). |
XMP025[Current]:Keywords |
Same as above, but a different metadata field. Note: Some types of metadata fields can contain multiple values (bag fields). For such fields, values will be separated according to the CSV file standard (RFC 4180). |
|
XMP120[Current]:Description |
Same as above, but a different metadata field. | |
XMP200[Current]:Custom Field 1 |
Same as above, but a different metadata field. | |
XMP201[Current]:Custom Field 2 |
Same as above, but a different metadata field. | |
| Asset metadata (previous) | XMP005[Previous]:Title |
Metadata field 5, named Title, with the value prior to the activity. Note: "Previous" metadata values are only logged when there is a change in the metadata value induced by the activity being logged. |
XMP025[Previous]:Keywords |
Same as above, but a different metadata field. | |
XMP120[Previoust]:Description |
Same as above, but a different metadata field. | |
XMP200[Previous]:Custom Field 1 |
Same as above, but a different metadata field. | |
XMP201[Previous]:Custom Field 2 |
Same as above, but a different metadata field. |