Fusion 23.2.0 Analyze Help Center

# Data list

Once you have refined the data list using the filter panel, the advanced search builder, or a combination of the two, you can take a closer look at your results.

For each data item, information icons display inline within the list to indicate if the data has been stored, has been analyzed, has had grammar values extracted, has been protected, has attachments, and is on hold. If associated with a weighted label, a colored circle also displays inline.

Information icons in the data list

TIP: Information icons may not apply to all data types.

Icon | Description
--- | ---
| (circles in varying colors, solid) Is associated with a weighted label, but content has not been analyzed. The color reflects the color assigned to the weighted label in Connect. If more than one weighted label is associated with the data, the color for the label with the highest weight displays.
| (circles in varying colors with checkmark) Is associated with a weighted label and content has been analyzed. The color reflects the color assigned to the weighted label in Connect. If more than one weighted label is associated with the data, the color for the label with the highest weight displays.
| Only metadata has been processed; not indexed, content not analyzed, stored, or collected. Not associated with a weighted label. You cannot see the content of the data or any document attachments or images. When you select a data item for which only the metadata has been processed, the content view panel does not display.
| Has been analyzed (metadata indexed, tag values identified) but not associated with a weighted label. If the content has not been stored or collected, you cannot see the content of the data or any document attachments or images and the content view panel does not display.
| Content has been stored; metadata and content has been indexed. If a document and not also collected, you will see the content of the file in the content view panel in a simplified text-only view but cannot view any attachments or images.
| Has been collected (unstructured data only). You can see the content of the file in the content view panel in a near-native view with basic formatting. You can view images, attachments, and attachment contents. If an email, you can view the message sender and recipients.
| Has had grammar values extracted. Documents include identified words, phrases, or blocks of information managed by grammars defined in Connect. From the data analysis tab () of the detail panel, you can select a specific grammar to highlight the identified information in the content of an unstructured data document. For more information, see Data detail.
| Has been sent to a target. To view the destination and target sent to, open the document detail panel for the item and then click the metadata tab ().
| Includes an attachment. If the file has been collected, you can click the attachment name from within the document view panel to view the contents of the attachment.
| Is on hold. Holds are managed in Manage.
| Is protected. Protected documents have had security rules applied, such as encryption.

For container files such as ZIP or archive files, a down arrow (˅) displays to let you view the contents of the container. Similarly, files within a container file display a down arrow to let you view the container file.

To view documents within a container file or the parent container file of a document

1. In the data list, click the down arrow (˅) for the desired document.

2. In the menu that opens, click the desired link.

   - If the selected document is a container file, click View contents of this file.

   - If the selected document is a child of a container file, click View container of this file.

   - If the selected document is a container file, and also a child of another container file (such as a ZIP within an archive file), both links display in the menu. Click the desired option.

   The data list refreshes. The VIEWING CONTENT OF box at the top of the filter panel displays the name of the container you selected to see the contents of (view contents of this file) or of the container that included the document you selected (view container of this file).

When viewing the data list in the detail view, the list includes the subject/title, record date, file size and information icons. When viewing the data list in the grid view, the list includes the information icons, subject/title, record date, file size, dataset from which the data originated, and the file path to the dataset. The content view panel is not available in the grid view.

You can sort the current data list, change the grouping view, save all or selected unstructured documents in the list to a new workspace, and even export the data list and metadata to a CSV file to review offline.

## Sort the data list

Sorting the data list does not change the contents of the list, just the order in which the data is displayed. By default, the list is sorted by record date, with the most recent first. You can combine the sort order and the grouping as desired.

To sort the data list

With the desired list in view, do one of the following:

- If viewing the detail view, click Sort by in the action ribbon above the data list and select the desired sort order.

  - Record Date (latest) sorts the list in descending order by date, latest (most recent) first. Similar to the Modify Date, the record date is the last modified date for the item itself. The difference is that the record date for email items is the sent date.

    - For file items and structured data items, this would be the last modified (saved) date.

    - For email items, this would be the sent date.

  - Record Date (earliest) sorts the list in ascending order by date, earliest (oldest) first. Similar to the Modify Date, the record date is the last modified date for the item itself. The difference is that the record date for email items is the sent date.

  - Last Processed Date (latest) sorts the list in descending order by date, latest (most recent) processing date first. Processing date is the date the items is processed by Fusion.

  - Last Processed Date (earliest) sorts the list in ascending order by date, earliest (oldest) processing date first. Processing date is the date the item is processed by Fusion.

  - Subject/Title (ascending) sorts the list alphabetically, A-Z, by the subject of an email item or the title of a document.

  - Subject/Title (descending) sorts the list alphabetically, Z-A, by the subject of an email item or the title of a document.

  - From (ascending) sorts the list alphabetically, A-Z, by the sender. If the document list contains email messages and documents not derived from email, the email messages display first followed by the documents ordered by date. If the document list does not contain any email messages, the documents display ordered by date.

  - From (descending) sorts the list alphabetically, Z-A, by the sender. If the document list contains email messages and documents not derived from email, the email messages display first followed by the documents ordered by date. If the document list does not contain any email messages, the documents display ordered by date.

  - File size (ascending) sorts the list by file size, smallest first.

  - File size (descending) sorts the list by file size, largest first.

- If viewing the grid view, click the Title, Record Date, or Dataset column headers to sort by the specific column information in either ascending () or descending () order.

## Change the data grouping

By default, the data list shows Documents/Tables that match your search. You can choose to view the individual items, or even the entire conversation related to your search. You can combine the grouping and the sort order as desired. If the selected grouping does not apply to all of the data in the list, the data that fits the grouping is displayed first, followed by the remainder of the data.

To change the data grouping displayed in the data list

1. With the desired data list in view, click Group by in the action ribbon above the document list.

2. Select the desired grouping.

   - None shows individual data items that match the filter and search criteria with no grouping.

   - Documents/Tables shows the originally processed source data that match the filter and search criteria. If the matched data is an attachment to an email or another file, the email or file to which the item is attached shows in the list. You can access the matched file from the data view panel.

   - Conversations, similar to Documents/Tables in concept, shows the originally processed source files that match the filter and search criteria, but also shows additional emails in the conversation thread (original message and responses). The email conversations display in the list with a visual bracket for easy identification. While conversations apply to email messages, documents and data items that match the filter and search criteria still display in the list.

## Save documents to a workspace

NOTE: Applies only to unstructured data.

You can save the documents in the current data list to a new or existing workspace for further review in Manage. You have the option to create the workspace from all or only selected data items. The documents are associated with a designated dataset in the workspace. If unstructured data is included in your selection, this data is not added to the workspace.

TIP: To see these options, you muse have permission to create workspaces in Manage.

To create a new workspace from documents in the current data list

1. With the desired data list in view, do one of the following.

   - To create a workspace from all documents in the list, click > Create Workspace from all in the action ribbon above the document list.

   - To create a workspace from selected documents in the list, select the desired documents and then click > Create Workspace from selected in the action ribbon above the data list.

     TIP: To select multiple documents, use shift+click to select consecutive documents or ctrl+click to select non-consectuive documents.

   If structured data items are included in your selection, a message displays stating that this data is not added to the workspace. Click Continue.

   The New Workspace dialog opens to the General page.

2. Complete the General options for the new workspace.

   Option | Description
   --- | ---
   Name | Type a unique, meaningful name for the workspace. Limits: Maximum 50 characters.
   Template | Select whether to base this workspace on a defined template. To define the workspace from scratch, select None. To define the workspace from a template, select the desired template from the list. The values defined for options in the template are pre-populated in this dialog. You can edit these values if desired. TIP: Before using the Data Cleanup template, ensure the desired datasets are associated with the template. If no datasets are defined in the template, the included workbooks will be empty. NOTE: This option defaults to the selection you made the last time you created a workspace. Make sure the desired option is selected.
   Workspace ID | (Optional) Type an ID for your workspace. For example, you can enter a code representing the workspace in another application, or some other useful identifier.
   Description | (Optional) Type a meaningful description for the new workspace. Limits: Maximum 250 characters.
   Workspace open date | Select the date to designate as the open date for this workspace. Defaults to the current date.
   Workspace due date | (Optional) Select the date to designate as the date all work for the workspace is due to be completed.
   Enforce Policy Review | Select whether to enforce a review of delete and send to target actions taken against documents in workbooks within this workspace. If selected, all requests within this workspace to delete documents from a workbook or send documents within a workbook to a target will require a designated reviewer to either approve or reject the action. If not selected (check box cleared), requests within this workspace to delete documents from a workbook or send documents within a workbook to a target will be processed without further review.

   Click NEXT.

3. Define the security options for the new workspace.

   Option | Description
   --- | ---
   Workspace owner | Type the user name of the user to be the owner of the new workspace. Defaults to the user you are logged in as. NOTE: There can only be one user assigned to a workspace as its workspace owner. If you select a user other than the account you are currently logged in as, the user you are logged in as will not be able to access this workspace unless you add the user you are logged in as to the list of users and groups for this workspace (next step).
   List of Users/Groups | Define the users and groups to have permissions for this workspace. IMPORTANT: To create workbooks and add data to the workbooks you must assign at least one user with the permissions to perform these tasks. The workspace owner does not automatically have these permissions. In the Enter name or email address box, begin typing a group name or a name or email address of a user. As you enter a string in the field, the interface displays names or email addresses matching the string. Select a role to assign to the user or group from the Select Role list. The default workspace roles are as follows: Document Review Full control Manage Policy Review Search only NOTE: Your Fusion environment may have additional roles available. These roles are managed in the Administration UI. TIP: If will enable custom actions for this workspace, ensure you define a user who has permission to perform the custom action. To enable a custom action for a user Assign the custom action permission to a role at the application level (Manage) in Administration. Assign the corresponding custom action workspace security level permission to a role at the Workspace Security level in Administration. Assign the Manage and Workspace Security roles with the custom action to the user in Administration. When creating or editing a workspace in Manage, select the user on the Security page of the wizard and select a functional workspace role. Click Add to add the selected user or group to the workspace. Once you add users or groups to the list, you can change their role by selecting the role from the Role column. To remove a user or group from the workspace, hover over the name in the User/Group column and then click the corresponding remove icon ().

4. Click FINISH.

   The new workspace is created and you are redirected to the CONTENT page of the new workbook in Manage. The documents are added to the new workspace as part of the Research dataset.

To add documents in the current data list to an existing workspace

1. With the desired document list in view, do one of the following.

   - To create a workspace from all documents in the list, click > Add all to Workspace in the action ribbon above the document list.

   - To create a workspace from selected documents in the list, select the desired documents and then click > Add selected to Workspace in the action ribbon above the document list.

     TIP: To select multiple documents, use shift+click to select consecutive documents or ctrl+click to select non-consecturive documents.

   If structured data items are included in your selection, a message displays stating that this data is not added to the workspace. Click Continue.

   The Add Selected to Workspace dialog opens.

2. Complete the details for the workspace.

   Option | Description
   --- | ---
   Select a Workspace | Select the workspace to add the documents to.
   Dataset Name | Type a unique and meaningful name for a dataset.
   Dataset Description | Type a meaningful description for the dataset.

3. Click ADD.

   The documents are added to the selected workspace. The defined dataset is created within the selected workspace.

## Export to a CSV file

You can export information about data in a current list to a CSV file for review offline.

Many metadata fields are available for inclusion in the CSV, however a limited number of fields are included by default. You have the option to include or exclude any available field. If an included field does not apply to a selected data item, the field in the resulting CSV is blank.

Available fields for inclusion in the CSV

Field | Included by default | Description
--- | --- | ---
Accounts | no | Defines the accounts associated with the item.
Analyzed/Collection Status | no | Defines the current processing/collection status of the item. A status of Metadata means only the metadata has been indexed. item content has not been indexed, stored, or collected. A status of Analyzed means the item content has been analyzed to identify tag values, but the content has not been stored. The item itself has not been collected. A status of Collected means that the item content has been indexed and the item has been collected.
Archive Date | no | Defines the date that the item was collected by Fusion.
BCC | no | Defines the blind carbon copied (Bcc) recipients of the email item. NOTE: Depending on how the items were processed, this information may not be present. For example, in PST files, Bcc information is available for outgoing messages, but not for incoming messages. Applies to email items.
Categories | no | Defines categories associated with the item.
CC | no | Defines carbon copied (Cc) recipients of the email item. Applies to email items.
CM Classifications | no | Defines the Content Manager classification.
CM Expanded Number | no | Defines the Content Manager expanded number.
CM Notes | no | Defines the Content Manager notes.
CM Record Number | no | Defines the Content Manager record number.
CM Record Type | no | Defines the Content Manager record type.
CM Unique Identifier | no | Defines the unique identifier for Content Manager documents.
Column Count | no | Defines the number of columns in the table.
Columns | no | Defines the column headers in the table.
Content Stored Status | no | Specifies whether the item's content has been stored.
Create Date | no | Defines the original creation date of the item.
Datasets | yes | Defines the name of the dataset associated with the item.
Errors | no | Defines any errors associated with the item.
Export Locations | no | Defines any export locations associated with the item.
Extraction Type | no | Defines the type of extraction performed on the item.
Family BCC | no | Defines the blind carbon copied (Bcc) recipients of the email parent document if the item is an attachment to an email. Applies to email items.
Family CC | no | Defines the carbon copied (Cc) recipients of the email parent document if the item is an attachment to an email. Applies to email items.
Family From | no | Defines the author of the email parent document if this item is an attachment to an email. Applies to email items.
Family Reply To | no | Defines the "reply to" email address for the parent document if the item is an attachment to an email. Applies to email items.
Family Sender | no | Defines the distributor of the email parent document if the item is an attachment to an email. This can differ from the Family From value if, for example, an application distributed the parent email instead of an individual. Applies to email items.
Family To | no | Defines the primary recipients for the email parent document if the item is an attachment to an email. Applies to email items.
File Extension | no | Defines the file extension of the document (such as .pdf, .msg, .docx)
File Name | no | Defines the full name of the table or the file including the file extension.
File Size | yes | Defines the size, in bytes, of the data item, including attachments.
File Type | yes | Defines the file type of the data item. For example, PDF, email message, Word document, or ocet-stream (binary data).
First Analyzed Date | no | Defines the date that the data item was initially analyzed (content processed for tag values) by Fusion.
First Processed Date | no | Defines the date that the data item was initially processed by Fusion. This date may differ from the Archive Date (collection date) if the item was not collected during initial processing.
From | yes | Defines the author of the email item. This can differ from the Sender if, for example, the Sender is an application that distributed the item. Applies to email items.
Grammar Rules | no | Defines any grammar rules associated with the item.
Grammars Extract Status | no | Specifies whether the item was processed for grammar extraction.
Has Attachments | yes | Specifies whether the document has attachments.
Hash | no | Defines the hash value of the item.
Holds | no | Defines any holds associated with the item.
ID | no | Defines the unique Fusion internal ID of the document.
Last Analyzed Date | no | Defines the date that the document was last analyzed (content processed for tag values) by Fusion. This date may differ from the First Analyzed Date if the document has been reprocessed.
Last Processed Date | no | Defines the date that the document was last processed by Fusion. This date may differ from the First Processed Date or Archive Date if the document has been reprocessed in any way.
Modify Date | no | Defines the last modified date for the item.
Path | yes | Defines the original path of the item. This is the location from where the document was processed. Applies to non-email items.
Protection Status | no | Defines whether the document has been protected.
Record Date | yes | Similar to the Modify Date in that this defines the last modified date for the item itself, but also applies to email items. For file items and structured data items, this would be the last modified (saved) date. For email items, this would be the sent date.
Reply To | no | Defines the "reply to" email address for the item. Applies to email items.
Row Count | no | Defines the number of rows in the table.
Reporting Groups | no | Defines any tag reporting groups associated with the item.
Sender | no | Defines the distributor of the email item. This can differ from the From value if, for example, an application distributed the item instead of an individual. Applies to email items.
Sent to Targets | no | Defines the destination and targets the document was sent to, in the format `destination (target)`. For any documents that have not been sent to a target, the cell in the CSV file will be blank.
Source | no | Defines the name of the source associated with the item.
Source Type | no | Defines the type of source in Fusion from which the item was initially processed.
Tags | no | Defines any tags associated with the item.
Thread ID | no | Defines the unique Fusion internal ID of email threads. All items in the thread have the same Thread ID. Applies to email items.
Title | yes | Defines the subject of an email, the title of a document, or the database table name.
To | yes | Defines the primary recipients for the email item. Applies to email items.
Warnings | no | Defines any warnings associated with the item.
Weighted Labels | no | Defines any weighted labels associated with the item.
Workbooks | no | Defines any workbooks associated with the item.
Workspace | no | Defines any workspaces associated with the item.

TIP: Dates are presented in GMT (Greenwich Mean Time).

To export data to a CSV file

1. With the desired data list in view, do one of the following.

   - To export all data in the list to a CSV, click > Export all to CSV in the action ribbon above the data list.

   - To export selected data in the list to a CSV, select the desired data and then click > Export selected to CSV in the action ribbon above the datalist.

     TIP: To select multiple data items, use shift+click to select consecutive data items or ctrl+click to select non-consecutive data items.

   The Export Results to CSV dialog box opens.

2. Select and set the order of the fields you want included in the CSV.

   Several fields are selected by default and display in the SELECTED FIELDS section.

   To set the order that the fields will be presented in the CSV:

   1. Hover over the desired field in the SELECTED FIELD section and then do one of the following:

      - Click either the up or down arrow in the corresponding change icon ().

      - Click and drag the field to the desired placement in the list of fields.

   2. Repeat as necessary to set the desired field order.

   To add a field to the results that will be included in the CSV:

   1. In the AVAILABLE FIELD section, hover over the field you want to add and then click the add icon ().

      The field is added to the end of the SELECTED FIELDS section.

   2. Set the order for the newly added field.

   To remove a field from the results that will be included in the CSV:

   1. Hover over the desired field in the SELECTED FIELDS section.

   2. Click the corresponding remove icon ().

3. Click EXPORT.

   The CSV is generated and displays as a download as appropriate for the browser you are using.

   Open the downloaded file to view the exported information.

Copyright 2019-2023 OpenText
Version 23.2.0 | Last updated May 2023
Connect
Marketplace
Learn
Support portal
Documentation
Contact
Submit or view service request