Export ACL tables to ACL AI Studio

As an Owner or Editor in ACL AI Studio, you can export an ACL table from ACL for Windows to ACL AI Studio. During export, you select the destination organization and dataset, and then create a new table or export to an existing table by appending or overwriting data.

Note

If you have the Reviewer role, you cannot export ACL tables to ACL AI Studio. For information about the roles in ACL AI Studio, see Dataset-level collaboration roles.

Prerequisites

Before you export data to ACL AI Studio, make sure that you meet the following requirements:

  • If you are exporting data manually, you know the organization and dataset that you want to use as the export destination.

  • If you are exporting data by script, you know the organization ID and dataset ID of the export destination.

  • If you plan to run the export as a robot, you have a valid Diligent One Platform API token.

Export options

Note

Before you export data with a UTC offset to ACL AI Studio, turn on Display times with UTC offset as UTC in Tools > Options > Date and Time. Otherwise, the upload fails.

Use one of the following options to export data to ACL AI Studio:

  • Create a table

  • Append records to an existing table

    Note

    Append is the default behavior for writing to an existing table when Overwrite is not specified.

  • Overwrite an existing table

Export a table

  1. Open the ACL table that you want to export.

  2. Select Data > Export.

  3. On the Main tab, from the Export As dropdown menu, select AI Studio.

  4. Optional - If you want to overwrite an existing table, select the Overwrite checkbox.

  5. Based on what you want to export, select one of the following radio buttons

    :

    • Fields Select this option if you want to export specific fields.

      From the Export Fields list, select the fields that you want to export.

      The fields are exported using the physical field names in the table layout.

    • View Select this option if you want to export all the fields in the current view.

      Note

      The Title column (display name) is not exported.

  6. Select the To button.

  7. In the pop-up window that appears, select the destination organization.

  8. Select the destination dataset.

    Note

    An empty list of datasets indicates that either ACL AI Studio is not enabled in the selected organization or no datasets have been created in the organization yet.

  9. Do one of the following:
    • From the list of available tables, select the table to which you want to add data.

    • In the New AI Studio Table field, enter a unique table name, and then select Create.

      Note

      The table name must begin with a letter.

      However, if you enter an existing table name, the behavior is as follows:

      • If you selected the Overwrite checkbox (Step 4), the table gets overwritten.

      • If the Overwrite checkbox is not selected, the selected fields are appended to the existing table.

        Append works only when the schema of the exported data is compatible with the schema of the destination table.

        • New fields that are not present in the original table are populated with empty strings for existing records.

        • Missing fields in newly appended records are populated with null values.

        • Field order is maintained based on the original field names.

  10. Select OK.
  11. In the Export window, select OK.

    The table is uploaded to ACL AI Studio only after the export in ACL for Windows completes.

    Note

    If the upload to ACL AI Studio fails, you receive a notification email.