Format example for importing user data

Overview

For importing user data, you require an import format that is configured with the database table Import User.

The example below compares the data content of a file from a spreadsheet software (here, e.g., an Excel file prior to its conversion to a CSV or TXT file) with the import format for user data:

Explanatory Notes to the Example

Column A of the Excel spreadsheet (Search Key) is in the first place, ergo the corresponding format field is given the Start No. 1. Consequently, the format field for Column B receives the Start No. 2 etc.
The order (SeqNo) of the format fields is therefore irrelevant.

Note: metasfresh does not expect any column names in the import file. Simply the position of the column must correspond to the start number.
The Name of the format field may be chosen freely and does not have to coincide with the column name in the import file.
The Column of the format field specifies where metasfresh shall transfer the content of the column from the import file.
The Data Type specifies whether the type of the import data is, e.g., a String or a Number.

Some useful notes

The mandatory fields are essential for a successful data import!

Mandatory Field	Field Name	Example	Note
X	Search Key	DC_102019	Search key of the business partner linked to the user (unique alphanumeric string)
X	First Name	Arthur	User’s first name
X	Last Name	Fleck	User’s last name
	Email	arthur.fleck@dc.com	User’s email address
	Login	Joker	User’s login
	System User	• Y / true = Yes • N / false = No	Indicates whether it is a system user with access permissions.
	Role	WebUI	The user role defines user permissions to access functions and data.

Next Steps

Import user data.

View source file on GitHub.com