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:

Import ID

Date of the import run

Name of the user who executed the import

OID of the reporting entity (lessee) for whom the import run was executed

Name of the imported file

Size of the imported file in KB

The imported file type. This is always CSV.

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 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

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 lessors imported successfully during the import run

Number of contracts imported successfully during the import run

Number of contract components imported successfully during the import run

Number of issues and warnings output during an import that was not executed successfully

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.

To jump straight to the history of a specific import, click the icon.

Last updated on Aug 24, 2023

Importing Data Automatically

Overview

The ‘Automatic Data Import’ Workspace

Importing Data Automatically

Data Import Details

Overview

The ‘Automatic Data Import’ Workspace

Importing Data Automatically

Data Import Details

ID

Date

User name

Reporting entity OID

File name

File size

Import mode

Import type

Status

Number of imported lessors

Number of imported contracts

Number of imported components

Number of issues

Table of Contents

Company

Legal Notice

Table of Contents

Related Articles

Company

Legal Notice