Importing Data Automatically

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

General Functions in Lease Accounting

User Roles in Lease Accounting

All Steps at a Glance

Basic Configuration for Lease Accounting

Selecting a Lessee

Collecting Data

Creating and Configuring Lessors

Creating and Configuring Contracts

Creating and Configuring Contract Components

Importing Data Automatically

Viewing Import History

Reversing Components

Categorizing Components

Calculating Data

Creating Postings

Reversing Postings

Exporting Reports and Postings

Importing Postings into Consolidation & Financial Planning

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Automatic data imports allow you to import contracts, lessors and contract components automatically. This both simplifies the import process and saves you time.

The Automatic data import workspace displays all the data import runs that have been executed to date, regardless of which reporting entity is selected:

Displays the 'Automatic data import' workspace — The 'Automatic data import' workspace

To import data, proceed as follows:

Open the Automatic data import workspace:

Select the data to be imported. The following data types can be imported:

Lessors

Contracts

Contract components

Use drag and drop to attach the Excel or CSV file you want to import, or add it via the Browse function.

Click Start import.

Excel and CSV Import Templates

To make automatic imports easier for you, we provide templates for both Excel and CSV files. The structure of these templates matches that required for the import.

The templates include instructions on how to add the data.

Use the following links to download the templates:

Excel Templates:

Excel Template for Lessor Imports

Excel Template for Contract Imports

Excel Template for Contract Component Imports

: this template uses conditional formatting to help you keep your entries within the allowed length. If you enter more than 250 characters in a cell, that cell turns red. Reduce the number of characters before you start the import.

CSV Templates:

CSV Template for Lessor Imports

CSV Template for Contract Imports

CSV Template for Contract Component Imports

The following details are displayed in the overview table for each data import:

The 'Automatic data import' workspace is displayed. The overview table is outlined in red. — Overview table in the 'Automatic Data Import' workspace

The table provides the following information:

Column	Description
ID	Import ID
Date	Date of the import run
User name	Name of the user who executed the import
Reporting entity OID	OID of the reporting entity (lessee) for whom the import run was executed
File name	Name of the imported file
File size	Size of the imported file in KB
Import mode	The imported file type. This is always CSV.
Import type	The data type that was imported. The following options are displayed: • StandardExternalParter for importing lessors • LucanetContract for importing contracts • LucanetComponent for importing contract components
Status	Status of the import. The following options are displayed: • Success if the import was completed successfully • Error if an error occurred during the import run • Warning if a warning was issued during the import run • Info if the message is only a notice on the import’s execution status • TBD if the import run is still ongoing and it is not yet possible to display a status for it Note: • You can view the details of the individual messages in the Import History. • To jump straight to the history of a specific import, click the icon in the column.
Number of imported lessors	Number of lessors imported successfully during the import run
Number of imported contracts	Number of contracts imported successfully during the import run
Number of imported components	Number of contract components imported successfully during the import run
Number of issues	Number of issues and warnings output during an import that was not executed successfully Note: • To view the notes for imports that were not executed successfully, visit the Import History. • To jump straight to the history of a specific import, click the icon in the column.
Configuration column	To jump straight to the history of a specific import, click the icon.