Export XML Finance

About the Finance XML Export browser

What the Export XML Finance screen shows

Using the XML Finance browser

About the Finance XML Export browser

Use the XML Export Finance tool to select a list of valid AccountingIntegrator Enabler Enabler objects and start the export operation. You can set user preferences to indicate how object selection is handled and what content is to be exported. Before you start, ensure that the following rights are activated: Finance-XML Export Wizard.

Select Finance > Export XML Finance from the Tools menu in the Integration-Services workbench.

What the Export XML Finance screen shows

The XML Export screen is organized into two parts:

How you use the icon bar

Icon Use

To expand selected node

To collapse selected node

To expand all nodes

To collapse all nodes

To refresh tree

To select all nodes

To unselect all nodes

To launch selected objects XML data export

To open the Preferences of XML data export

To launch the Wizard to select a group of objects

How you use the repository tree structure

The repository tree structure displays the following AccountingIntegrator Enabler Enabler objects in the active root folder:

  • Input-Events (1000 maximum)
  • Transformation-Rules (50 maximum)
  • Tables (1000 maximum)
  • Accounting Processing-Context-Out objects (1000 maximum)

All objects are displayed for each of the four types even those that have not yet been checked (status ToBeChecked).

When you:

  • Select an object, AccountingIntegrator Enabler selects automatically all objects that are used by this object.
  • Unselect an object, AccountingIntegrator Enabler unselects automatically all objects that use this object.

You can however disable this automatic object selection/deselection option in the Export XML Finance Preferences.

Example 1 - Select

You select a Transformation-Rule.

If you have selected the Include weak links when selecting depending child objects option in the Preferences, all the dependent Table and Processing-Context-Out objects are selected.

If you have not selected the Include weak links when selecting depending child objects option, only the dependent Table objects are selected.

Example 2 - Unselect

Input-Event EVT uses Transformation-Rules R1 and R2. You have selected the Include weak links when unselecting referencing parent objects option in the Preferences.

If you unselect R1 but R2 is:

  • selected: the Input-Event EVT is not unselected
  • not selected: the Input-Event EVT is unselected

Using the XML Finance browser

To use the XML Finance browser, you must have access rights to the folders and follow this procedure:

  1. Set XML data export preferences
  2. Select objects
  3. Start export operation

Step 1: Setting XML data export preferences

To set the preferences, click .

When you modify these attributes, AccountingIntegrator Enabler does not change the current tree selection and the new settings are only applied to the next selection operation.

Set the following attributes:

When you have completed this window, click OK to validate the preferences and display the general screen.

XML export contents

To optimize data volume, check one or all of these options to define the level of detail of the XML export:

Check... If you want to...

Include Output-Event and Pre-calculation mapping expressions

Export:

  • output segments mapping expressions produced by AccountingIntegrator Enabler
  • pre-calculations mapping expressions linked to these segments

    By default, this box is checked

Include Table access or extraction descriptions

Export the table contents description and the table extraction description

By default, this box is checked

Export table contents

To optimize data volume, check one of the following options to define the level of detail of the table export:

  • Never export table contents
    None of the
    cells of the selected tables are exported.
    By default, this box is checked.
  • Always export table contents
    All the cells of all the selected tables are exported.
    By default, this box is not checked.
  • Use setting "Send table contents to server" for each table
    This option is set in the Table General tab and indicates if you can add, modify or delete Table entries in Tables sent to Production.
    By default, this box is not checked.

Automatic object selection

Check... If you want to automatically...

Include weak links when selecting depending child objects

Select all referenced objects including weak links. By default, this box is checked.

Example: for each Input-Event that you select, AccountingIntegrator Enabler selects automatically all Transformation-Rules used by this Input-Event.

Include weak links when unselecting referencing parent objects

Unselect all objects that reference this object and include weak links. However, a parent object is only automatically unselected if there is no other referenced object selected. By default, this box is not checked.

Example: for each Transformation-Rule that you unselect, AccountingIntegrator Enabler unselects automatically all Input-Events that use this Transformation-Rule.

Step 2: Selecting objects

You can:

  • select or unselect objects manually for the export
  • select a large number of objects simultaneously either manually or via the Wizard.
    Manual selections and Wizard selections complement one another.

Selecting/Unselecting objects manually

To select/unselect objects manually, use one of the following:

Using the icon bar

Click... To... The system...

select all categories

Selects automatically:

  • All categories
  • All objects in the categories

unselect all categories

Unselects automatically:

  • All categories
  • All objects in the categories

Using the tree structure

Click... To... The system...

a node

select one category

Selects automatically:

  • All objects in the category
  • All referenced objects in other categories

one or more objects in a node

select objects in a category

Selects automatically:

  • The object(s) in the category
  • All referenced objects in other categories

If you select all the objects in a category, the system checks automatically the category node.

a node

unselect one category

Unselects automatically:

  • All objects in the current category
  • All referenced objects in other categories depending on the Automatic object selection parameter set in the Preferences

one or more objects in a node

unselect objects in a category

Only unselects the object(s) in this category; referenced objects remain selected.

If you unselect one object in a category, the system unchecks the category node.

Using the popup menu

Click... To... The system...

refresh the display

Refreshes the display but does not unselect previously selected objects

display the properties of a selected object

Displays the properties that you can modify if you have the corresponding rights

select one or more objects in a category

Selects the object(s) and also selects automatically all referenced objects in other categories

If you select all the objects in a category, the system checks automatically the category node

unselect one or more objects in a category

Only unselects the object(s) in this category ; referenced objects remain selected

If you unselect one object in a category, the system unchecks the category node

Selecting objects via the Wizard

About the Wizard

The Wizard enables you to automatically select a group of objects and their related objects according to detailed settings.

To use the Wizard, follow these steps:

  1. Select import mode
  2. Provide detailed settings for the import mode

To start the Wizard, click in the icon bar.

Screen 1: Select import mode

Select... To...

Select all objects modified since a given date

Select objects automatically according to a date

The system identifies all Input-Events, Transformation-Rules, Tables and accounting Processing-Context-Out objects that have been modified since that date

This option is selected by default.
 

Select all Processing-Context-Out objects modified since a given date

Select Processing Context-Out objects automatically according to a date

The system:

  • Identifies all Processing-Context-Out objects that have been modified since that date
  • Computes all Transformation-Rules that are linked to them as well as all Input-Events that are associated with the Transformation-Rules

Select Processing-Context-Out objects individually

 

Select objects automatically according to one or more selected Processing Context-Out objects

The system computes all Transformation-Rules that are linked to the selected Processing-Context-Out object(s)

Click Next to continue.

Screen 2: Specify detailed settings

If you selected... Then...

All modified objects by date

or

All modified Processing Context-Out by date

Screen 2 displays a calendar with, by default, the date of the last XML data export performed by the current user (month, year).

Enter the day, month and year.

Click Finish.

Manually select Context-Outs

Screen 2 displays:

  • a  list of all available Processing-Context-Out objects  in the Available column
  • an empty Selected column

Use the Add, Add all, Remove and Remove all buttons to move the objects from one column to the other.

Select Selection of Input-Events in cascade if you want to include all Input-Events that use any of the Transformation-Rules linked to the selected Processing-Context-Outs.

Click Finish.

Step 3: Starting export operation

Click to start the export operation.

The export operation creates a transaction that locks all selected objects and checks the objects status. If objects have not been checked (status ToBeChecked) or errors occur during that first step, errors (object and cause of the problem) are listed in the log pane and the operation is cancelled.

Summary screen

This screen displays the number of objects that can be exported for each category: Input-Events, Transformation-Rules, Tables, Processing Context-Outs. This enables you to estimate the processing time.

At this point, if you choose to cancel the whole operation, click the corresponding button.

Otherwise:

  1. Enter the XML output file name or click Browse to open up the search window to locate the required file.
  2. Click Finish.
    A progress bar is displayed until the operation is complete.

Summary report

This report is displayed at the end of the export operation. It gives the name of the XML output file, lists the exported objects and details about the execution.

Click:

  • Save to save this report in a txt format file
  • Close to return to the Finance XML Export screen

Note: You can also copy and paste the contents of this report to a standard text editor (such as WordPad).

Back to top

Related Links