Skip to main content

Data external systems

Access through: Administration > Data > External systems

The External systems folder has all functions to import and manage data from connected external data sources.

CSV file import

CSV file import​

Access through: Administration > Data > External systems > Import CSV file

The Import CSV file report allows you to import data from external system data sources into Snow Optimizer for SAP® Software.

Description​

This report imports user data of external systems from a CSV file.

A CSV field mapping definition can control the mapping of the columns of the CSV file to the fields of the user master data. Without field mapping, a simple 1:1 mapping is used according to the order of the fields.

note

You can create CSV field mappings in Manage CSV field mappings.

Selection criteria​

In addition to the standard selections, the selection screen of the report has the following selections:

Options for file selection

You can select whether the report loads the CSV file from the application server or from the front-end. In both cases, you must enter the file path.

Options for import

You can select a CSV mapping and change the CSV delimiter and file encoding if necessary. You can select to add users.

You can execute this report in the background.

Result​

The report result shows information about the imported data.

Data administration external systems

Data administration external systems​

Access through: Administration > Data > External systems > Data administration external systems

The Data administration external systems feature allows you to manage imported data from connected external data sources.

Description​

A table shows icons for the user master data status for each connected external data source. When you select an icon, a pop-up shows the data source and category, and when and by whom the data was last imported. There is an option for deleting data. If you select an empty field, a pop-up only shows the data source, category, and option for loading data. You can define warning thresholds that specify the time when the data becomes outdated.

Data status​

IconDescription
Loaded_complete.pngThe data is loaded completely.
Outdated.pngThe data is outdated based on the warning threshold.
Not available.pngThe data is not available due to the system type or version.
NoneNo data is loaded.

Manage warning thresholds​

You can specify the number of days from which the user master data is outdated.

  1. Select Settings.png.

  2. Enter the number for the warning threshold.

    note

    If you enter no number, the default value of 31 days is used.

  3. Save.