- User's Guide
- Working with Exports
- Creating Exports
- Merge Log Export
Merge Log Export
Merge Log exports output a record for each item in the merge log meeting the filter criteria. You can output this information to a file.
Note:
This export is applicable only if the Merge feature is used.
To create a merge log export:
- On the Home page, select Export.
- Click
.
- Select Merge Log as the export type.
- Optional: To create substitution parameters for the export:
- Click
.
- Click Add and add Key-Value pairs.
Note:
Key-Value pairs cannot use "<%" or "%>" sequentially or an equal sign.
- Click OK.
- Click
- On the Source tab, select a version or version variable.
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.
- On the Filter tab, select from these options:
-
Begin/End Dates — Set the beginning and ending date for the export
-
Deleted Node — Enter the name of a deleted node.
-
Merge Node — Click
to specify a merge node
-
User — Select a user
-
Status — Select a status
-
- On the Columns tab, select the columns for the export.
Tip:
Use the Category list to select a property category to ease navigation. Use the up and down 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.
- On the Target tab, from the Device list, select the location to which you want to export the results: Client File or Server File.
- 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 each column value. Any existing quotation marks within the column value are doubled.
For example,
=IF("ABC","XYZ",)
changes to
"=IF(""ABC"",""XYZ"",)"
-
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 — Select one of the encoding options.
-
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
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 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 each column value. Any existing quotation marks within the column value are doubled.
For example,
=IF("ABC","XYZ",)
changes to
"=IF(""ABC"",""XYZ"",)"
-
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 — Select one of the encoding options.
-
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
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
-
-
- Do any of the following:
-
To save the export, click
.
You are prompted to define a name, description, and an object access group for the export. Select a custom group or one of the following:
-
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.
-
-
To run the export, click
.
If you selected Client File, you have a download option where you can download the file locally.
Note:
If you selected to run batch validations for exports in the book, these validations are run first.
-