Creating Transaction Log Exports

When you create or open an export, it is displayed on a named tab.

The export wizard is used to define the parameters and criteria for the export. The wizard content is organized across Source, Filters, Columns, and Target tabs to guide input. Although the wizard tabs are ordered to gather input in a sequence, you can navigate between any tabs.

  To create a transaction log export:

  1. From the Data Relationship Management navigation bar, select Export.

  2. Click New compare toolbar button.

  3. Select Transaction Log as the export type.

  4. Select the Source tab and choose a version.

    You can select Normal, Baseline, or As-Of versions. The Version list defaults to the Normal versions. To select a Baseline or As-Of version, click Normal under the Version list.

    Note:

    You can also select the Run Export for All Versions option.

  5. To select hierarchies and nodes for the export, click Ellipsis button.

  6. Select the Filter tab and choose options:

    • Levels — Click Ellipsis button to specify levels to filter:

      • Core –– Includes actions that indicate a change to version data (not metadata objects).

      • Logged –– Includes actions that indicate system activity occurred but did not result in additions, changes, or updates to data.

      • Loss –– Includes transaction history records that store data that has been lost due to a core action, such as deleting a node.

      • Result –– Includes actions that are associated with, and are a result of, a Core action.

      • Admin –– Includes actions that affect metadata objects (not version related data).

    • Actions — Click Ellipsis button to specify transaction log action types to filter.

    • Properties — Click Ellipsis button to specify a list of properties to filter.

    • Users — Click Ellipsis button to specify users to filter.

    • Include Child Nodes — Select to include child nodes.

    • Include Shared Nodes — Select to include shared nodes.

    • From Date — Select and enter a start date.

    • To Date –– Select and enter an end date.

    • From Transaction — Select and enter a start transaction ID.

    • To Transaction –– Select and enter an end transaction ID.

    • Filter to Current Session — Filter transactions to those performed during the current session.

  7. On the Columns tab, select the columns for the export.

    Tip:

    Use the arrows to position the column in the Selected list. The first item in the list is the first column, the second item in the list is the second column, and so on.

  8. On the Target tab, from the Device list, select the location to which you want to export the results: Client File Database Table, or Server File.

  9. Perform an action:

    • If you selected to export to a Client File, choose options:

      • Column Headings — Includes column headings in the export

      • Quoted Strings — Puts quotation marks around strings

      • Fixed Width — Allows you to specify field widths, left or right justification for the column, and number of pad characters. You can enter column information in the Fixed Width Option section.

      • Character Encoding — To export the results as UTF8, ANSI, ASCII, UTF16BE, UTF16LE

      • Replace options — Select up to three characters from the lists to be replaced. For example, commas can be replaced by tabs

      • Header/Footer — Add a line between the header/footer and the body or enter text to be printed on the header and footer of the export results. Enter lines of text into the text box or click Ellipsis button to open a text editor.

        Note:

        You can insert customization tags to further enhance the readability of the export results. For more information, see Customization Tags.

      • Delimiter options — To select a field delimiter character and a record delimiter character

    • If you selected to export to a Database Table, you must set your connection and select the database table. You must have already created a valid external connection to a database for it to show up in the drop-down list. You can also select from these options:

      • Clear table options

        • Do Not Clear Table — Appends to existing data in the specified table.

        • Clear Based on Version ID(s) — deletes data in the table where the specified key field equals the current version ID of the data being exported. If this option is selected, a Key field must be specified in the Database Column Options section. When the export is run, all data in the table is first deleted where the Key field equals the current version ID of the data being exported. For the other Clear Table options, the Key field is ignored.

        • Clear All Rows — Deletes data from the table before writing the export output.

      • Use Transactions — The export is performed within a database transaction and allows the entire operation to be rolled back if an export error occurs.

      • Use Fast Appends — Performs a bulk insert operation into the target database table for improved export performance. Only available with a database-specific connection.

      • Use Fast Deletes –– Performs a bulk delete operation on the target database table for improved performance. Only available with a database-specific connection.

      • Database Column Options — Each column being exported must be mapped to a field in the external database table. Under Field Name, select the name of a field. If you selected Clear Based on Version ID(s), specify a Key field.

        Note:

        The column must be the same data type as the database field to which it is mapped. For example, if a string property is mapped to a numeric database field, an error occurs.

    • If you selected to export to a Server File, you must set your connection and enter a file name. You must have already set up a valid external connection to a UNC or FTP file. You can also select from these options:

      • Column Headings — Includes column headings

      • Quoted Strings — Puts quotation marks around strings

      • Fixed Width — Allows you to specify field widths, left or right justification for the column, and number of pad characters. You can enter column information in the Fixed Width Option section.

      • Character Encoding — To export the results as UTF8, ANSI, ASCII, UTF16BE, UTF16LE

      • Replace options — Select up to three characters from the lists to be replaced. For example, commas can be replaced by tabs

      • Header/Footer — Add a line between the header/footer and the body or enter text to be printed on the header and footer of the export results. Enter lines of text into the text box or click Ellipsis button to open a text editor.

        Note:

        You can insert customization tags to further enhance the readability of the export results. For more information, see Customization Tags.

      • Delimiter options — To select a field delimiter character and a record delimiter character

  10. Do either or both of the following:

    • Click Save button to save the export.

      You are prompted to define a name, description, and object access for the export:

      • User – Personal objects that are only available to an individual user to view and run.

      • Standard – Public objects that are available to all users to view and run. Only Data Manager users can create and modify standard exports.

      • System – Restricted objects that are only available to Application Administrator role users to view and run.

    • Click Run button to run the export.

      If you selected Client File, you have a download option where you can download the file locally.