Before you start:s

•The imported data must be saved in a CSV file stored in a folder defined in the IntegrationExecutorService.exe.config file.

•The file does not need to include corresponding columns for all Clausion FPM fields, and it can also include additional columns (missing columns will receive a NULL value and additional columns will be ignored).

•The default delimiter in the CSV file is |, but it can be changed in the IntegrationExecutorService.exe.config file.

The data upload settings include a number of predefined steps. These standard data upload options can be used as such or as a template for defining custom steps.

Note! We do not recommend that you change the standard data upload options on your own. If you want to make changes, contact your Clausion consultant.

To add new data upload settings:

1.Click Open to open the options.

2.Click Add, add an ID for the data upload, select a data type, and save. The new data upload is added to the Data upload drop-down list.

3.Under Basic settings, add a name for the data upload in the languages used in your system.

4.Under Conversion tables, select the conversion tables to be used in transferring data if needed.

5.Under Steps, define the actions to be performed and their order. The standard data upload options are included by default. If you want to make changes to them, contact your Clausion consultant.

Note! You can upload multiple files at the same time by adding several file reading steps to an upload run (after de-selecting the standard upload checkbox). In the database content of each source file is saved to separate raw data tables. Note that the standard interface steps process forward until the report data tables only data of the file imported in the first file reading step. Admin user or interface specialist must add steps for processing the other raw data tables.

6.Under Schedule, you can define one or several schedules for running the data upload:

•In the Schedule column, add the time of the run in cronstring format. For examples, see Schedule time setting examples.

•From the Period and Year drop-down lists, select the period and year of the data to be imported.

•In the RunUdid2 column, you can add a value for delimiting the run, for example, an organization code.

•In the User column, add valid user login information.

7.Map source fields to Clausion FPM columns. Click Mapping to open the mapping settings dialogue box and add the following:

•Position: The position of the column in the CSV file. The position must be a numerical value.

•Source: The source column name. The source cannot include Scandinavian and other special characters.

•Type: The type of the column (for example, float, varchar(xx)).

•Destination: The corresponding Clausion FPM column, if any.

The values of the source fields are copied as such to target columns based on the mapping.

8.Save the data upload settings.

Note! Between each numerical value and character in the time setting there must be a space.

Table 34: Schedule time setting examples

Tasks for running data uploads manually can be added to the user interface with user interface task parameters. For the parameter settings, refer to Clausion Financial Performance Management User Interface Task Parameters.

To run data upload:

1.Select the Period and Year for which you want to transfer data. The period and year can be defined for the task in the user interface task parameter settings.

2.You can add a RunUdid2 value for delimiting the run, for example, an organization code.

3.Click Start.

You can monitor the status of the imported data and flow logs of the executed data upload runs using the Data Upload Status custom template. Also error reports of runs that have failed or completed with errors are displayed.

To execute data upload run:

The data upload status report opens without any entries in the Flow Log column and with no data on the Run Flow Log and Run Error Report sheets.

•Enter 'X' in the Flow Log column on the row of the run (one row at a time) and save.

When saving, the Run Flow Log and Run Error Report sheets are populated with the data according to the results.