Column names in the CSV file

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Learn more about the column names in the CSV file exported from Fotoware.

The column names are the names of the columns in the CSV file exported from Fotoware. These are also the names that users are presented with when using, for example, PowerBI to create visual reports. In such tools, users must select from the list of columns to determine which data they want to include in their visualization.

The exact set of fields depends on the Activity Export configuration. For example, the metadata fields exported are configurable.

The table below describes the different fields in the CSV files and the categories of information to which they belong.

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 only have values 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 only of the asset, for example, "image.jpg"
	`AssetInfo.PathToAsset`	The path of the asset relative the 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 only have values if the activity performed 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. Examples: "animals/frogs/" "+/animal videos/" (+ means 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 SaaS Core).
	`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 logged. "Current" metadata values are logged when there is an asset 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). Example: "nature:animals;night photos"
	`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[Current]: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[Current]:Keywords`	Same as above but a different metadata field.
	`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.