Configuring and Executing a Data Import

Documentation

Getting Started

Global Functions

Lucanet Lume

Administration

Data Hub

Consolidation & Financial Planning

Lease Accounting

Extended Planning & Analysis (xP&A)

ESG Reporting

Disclosure Management

The Lucanet Disclosure Management User Interface

All Steps at a Glance

Basic Configuration

Dashboard

Configuring a Document

Cockpit

Creating and Editing Chapters

Creating and Editing Periods

Importing Data

Defining Connection to a Data Source

Defining a Data Source

Configuring and Executing a Data Import

Working with MS Office Files

Creating and Editing Validations

Using the Data View

Using the XBRL Tagger

Creating Result Document

Rolling Forward or Copying a Document

Editing Documents in the XBRL Tagger

XBRL Tagger

Tax Compliance & Reporting

Banking & Cash Management

Data Collection

Glossary

When you have defined the data source(s) and the connections to these data sources as the basis for the import in the Import Management area of Disclosure Management, you can configure and execute the data import. Both are carried out in the Import data workspace at individual document level.

The Import data workspace is only activated for users who have been assigned the Document Administrator or Document Data Importer role at document level in Disclosure Management role management. (For additional information about user roles in Disclosure Management, see Assigning Document Roles for Disclosure Management.)

To configure and execute a data import in Disclosure Management:

In the overview of a document, click Import data to open the workspace.

Select the data source to be used for the import (see section Selecting a Data Source).

Choose the parameters for the data import at document level (see section Parameterizing Data).

If necessary, display a preview of the import and check the data (see section Displaying a Preview and Checking Data).

Start the data import (see section Starting the Data Import).

When you open the Import data workspace at document level in Disclosure Management, the Data sources area is displayed by default:

Shows the 'Data sources' step of the 'Import data' workspace in Disclosure Management for the document 'Report 2024' with four data sources and the columns 'NAME', 'CONNECTION TYPE', 'DESCRIPTION' and 'LAST EXECUTION'. One data source is selected, and the 'Go to parameterization' button is displayed. Highlighted in red are 'Document', 'Report 2024', 'Import data' and the step 'Data sources'. — ‘Data sources' area

This area contains all the data sources you defined in Import Management (see section Defining a Data Source). You can sort the data sources by name, connection type, description or last execution date.

Select the data source(s) to be imported by activating the corresponding check box(es) and click Go to parameterization.

In the Parameterization area of Disclosure Management, select the parameters for importing the selected data source(s) at document level. The area is displayed as follows, for example:

Shows the 'Parameterization' step of the 'Import data' workspace in Disclosure Management with the buttons 'Open preview' and 'Start data import'. Highlighted in red with annotations are the connection 'My new Lucanet Connection', the data source 'Lucanet Balance Sheet 2024', its parameters 'Organization Elements', 'First Month', 'Data Level', 'Ledger' and 'Adjustment Level', the mapping 'new Mapping', the field 'TargetPeriod', the connection 'XLS Import of Balance Sheet' and the field 'FileName'. — ‘Parameterization' area

The following table describes the elements of the Parameterization area in Disclosure Management:

Option	Description
Connection to the data source	Displays the connection of the selected data source and serves as the top root folder for parameterizing the data source. The element can be expanded and collapsed using the arrow icon. A separate root folder for parameterization is displayed for each data source selected in the Data sources area.
Data source	Displays the selected data source. The element can be expanded and collapsed using the arrow icon so that further parameters can be assigned for this data source, if necessary.
Mapping	Displays the mapping that has been defined within a data source. The element can be expanded and collapsed using the arrow icon. For each mapping defined within a data source, a separate folder is displayed that can be expanded and collapsed. For additional information on defining mappings see section Defining a Data Source.

When you have selected all parameters for all displayed data sources, you have the following options:

You can use the

Open preview

button to display a preview of the imported data in order to check the data again before the actual import. For additional information on this, see chapter

Displaying a Preview and Checking Data

You can use the

Start data import

button to import the data immediately without a preview. For additional information on this, see section

Starting the Data Import

You can navigate back to the

Data sources

area to make any necessary adjustments to the selection of data sources.

When you have configured all parameters for all selected data sources in the Import data workspace of Disclosure Management, you can use the Open preview button to display a preview of the imported data in order to check the data again before the actual import.

The preview is displayed as follows, for example:

Shows the 'Optional: Preview' step of the 'Import data' workspace in Disclosure Management with the data source 'Datasource - Ranorex - ImportFlat A' and a table with the columns 'PROGRAMMING', 'NAME', 'NEW VALUE', 'OLD VALUE' and 'DIFFERENCE', and the 'Start data import' button. Highlighted in red is the step 'Optional: Preview'. — ‘Preview' area

The following elements are displayed in the top section of the preview in Disclosure Management:

Option	Description
Name	Name of the data source(s) to be imported
Connection type	Connection type of the data source: Client FlatFile Import (client-side import of an Excel or CSV file); Server FlatFile Import (server-side import of an Excel or CSV file); Lucanet Rest API Import (import from a Lucanet database); S3 ESG Import (import from Lucanet ESG Reporting)
Description	Description stored in the definition of the connection to the data source
Last execution	Date of the last execution of an import of this data source

The following elements are displayed in the table of the preview in Disclosure Management:

Element	Description
Programming	Content of the column that was defined as a programming column in the imported data source
Name	Content of the column that was defined as a name column in the imported data source
New value	New value after the current import
Old value	Old value before the import
Difference	Difference between new and old value

When you have checked the import in the preview, you have the following options:

You can import the data using the

Start data import

button. For additional information on this, see section

Starting the Data Import

You can make changes to the configuration of the import and reopen the preview. Changes are possible in the following areas:

In the previous steps

Data sources

Parameterization

In the

Import Management

in the connection to the data source or the data source itself.

To start a data import in Disclosure Management, click Start data import either in the Parameterization area or in the Preview area.

The task of executing the data import is then transferred to the job monitor and you can display the status of the task by clicking on the bell icon at the top right-hand corner. Successful execution of an import is displayed as follows, for example: