---
title: "Importing Data Automatically"
description: "Automatic data imports allow you to import contracts, lessors and contract components automatically. This both simplifies the import process and saves you time."
source_url: https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/automatic-data-import
language: en
last_updated: 2023-08-16
---
# Importing Data Automatically

## Overview

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

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

The 'Automatic data import' workspace

## Importing Data Automatically

To import data, proceed as follows:

{% stepper %}
{% stepper-step %}
Open the **Automatic data import** workspace:

Importing data automatically

{% /stepper-step %}
{% stepper-step %}
Select the **data to be imported**. The following data types can be imported:

 - **Lessors**
 - **Contracts**
 - **Contract components**
{% /stepper-step %}
{% stepper-step %}
Use **drag and drop** to attach the **Excel** or **CSV file** you want to import, or add it via the **Browse** function.
{% /stepper-step %}
{% stepper-step %}
Click **Start import**.

{% /stepper-step %}
{% /stepper %}
{% idea-box %}
**{% u %}Excel and CSV Import Templates{% /u %}**

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](https://lnag.sharepoint.com/:x:/s/hubkm/IQCnJUMt8TaHQJhdewJgo_TsAb8JuUOBXODBT6OOEM2_BNY?e=EI71U5)
- [Excel Template for Contract Imports](https://lnag.sharepoint.com/:x:/s/hubkm/IQApJ5XhiV6pTaHr1SIvRo56ATOX5wTphtJfsPsjSIb94JM?e=gDmxMk)
- [Excel Template for Contract Component Imports](https://lnag.sharepoint.com/:x:/s/hubkm/IQBHNlo_-CUNTZB_V4fS2xX8AYKjSpJCCaV9FrQRkCjkm18?e=ZWog7a)

**CSV Templates:**

- [CSV Template for Lessor Imports](https://lnag.sharepoint.com/:x:/s/hubkm/EW5Dq-ZgJa9ItacvIJe8LWgB-kEQVJs-vIoN65A3YiOHJw?e=eVzXt1)
- [CSV Template for Contract Imports](https://lnag.sharepoint.com/:x:/s/hubkm/EfIU3mB0GSxCrZIUbohuG-IBgdNaejtTwKjbgTV6v6wirA?e=OuhTOB)
- [CSV Template for Contract Component Imports](https://lnag.sharepoint.com/:x:/s/hubkm/IQAApa9b5yOHQb6ZNbHXtMILAVA8o5568v-C39ro_efqYhA?e=zXA91A)
{% /idea-box %}

## Data Import Details

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

Overview table in the 'Automatic Data Import' workspace

The table provides the following information:

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

{% info-box %}
- You can view the details of the **individual messages** in the [Import History](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/show-import-history.md).
- To jump straight to the history of a specific import, click the icon in the column.
{% /info-box %}

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

{% info-box %}
- To view the **notes** for imports that were **not executed successfully**, visit the [Import History](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/show-import-history.md).
- To jump straight to the history of a specific import, click the icon in the column.
{% /info-box %}

#### 

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