Skip to main content
Skip table of contents

Importing User Data

Using Menu "Import"

You can import the following elements and their properties:

  • Users

  • Profiles

  • Roles

  • Permissions

Use menu Import to import data into your PAS user management:

menu_import.png

Menu Import consists of two sections:

menu_import_sections.png

Using the Template

The structure of the import file must correspond to the objects and their properties in the user management. Only correctly structured files can be imported. Therefore, we recommend to use the template provided in section Template. The Excel file is properly formatted and contains all necessary columns. Use button Download Template to save the file to your computer:

Confirm the download in the pop-up window to open or save the template:

Overview of the Template's Content

For every uploadable element you can find a separate tab in the Excel template:

Every tab contains the preconfigured columns needed for the properties of this specific element. Mandatory fields are marked red:

Import of Profiles or Roles

If you want to import profiles or roles, please note that you need to use the profile/role ID. The ID has to be inserted in the import file with double quotes:

CODE
//Valid entry for a profile or role ID
["947c5d80-d969-11e5-839d-d5dcd95d29f0"]

Import of Boolean Values

The fields active and create Sandbox must contain boolean values:

  • In an English Microsoft Excel application enter TRUE or FALSE.

  • In a German Microsoft Excel application enter WAHR or FALSCH.

User Properties

With the help of the template, you can create new users including master data and additional data. Open tab users in the Excel file to insert user data:

The following table shows all user properties that can be specified in the template file:

  • Technical Name: Name of the column in the template

  • User Property: Name of the field in the user data sheet

Technical Name

User Property

Mandatory

Where to be found?

active

User active

(tick)

Menu "Users": Master Data

city

City

(error)

Menu "Users": Additional Data

company

Company

(error)

Menu "Users": Master Data

country

Country

(error)

Menu "Users": Additional Data

create Sandbox

Create Sandbox

(tick)

Menu "Users": Master Data

department

Department

(error)

Menu "Users": Additional Data

email

E-Mail

(tick)

Menu "Users": Master Data

extension

Technical Information

(error)

Menu "Users": Additional Data

fax

Fax

(error)

Menu "Users": Additional Data

firstname

First Name

(tick)

Menu "Users": Master Data

lastname

Last Name

(tick)

Menu "Users": Master Data

loginId

Login

(tick)

Menu "Users": Master Data

mobile

Mobile

(error)

Menu "Users": Additional Data

organisation

Organization

(error)

Menu "Users": Additional Data

password

Password

(tick)

Menu "User": Password

phone

Phone

(error)

Menu "Users": Additional Data

profiles

Profiles

(tick)

Menu "Users": Profiles

roles

Roles

(error)

Menu "Users": Roles

street

Street

(error)

Menu "Users": Additional Data

validFrom

Valid from

(tick)

Menu "Users": Master Data

validTo

Valid until

(tick)

Menu "Users": Master Data

zip

ZIP

(error)

Menu "Users": Additional Data

Profile Properties

Create new or update existing profiles by inserting their properties into the import file. To be able to do so, open tab profiles in the template file:

The following profile properties can be imported:

Technical Name

Profile Property

Mandatory

Where to be found?

active

Profile active

(tick)

Menu "Profiles": Master Data

name

Name

(tick)

Menu "Profiles": Master Data

namespace

Namespace

(error)

Menu "Profiles": Master Data

description

Display Name

(error)

Menu "Profiles": Master Data

permissons

Permissions

(error)

Menu "Profiles": Permissions

Role Properties

The properties of roles can be found in tab roles of the Excel template:

You can insert the following roles properties in the import template:

Technical Name

Role Property

Mandatory

Where to be found?

active

Role active

(tick)

Menu "Roles": Master Data

name

Name

(tick)

Menu "Roles": Master Data

Permission Properties

Open tab permissions in the template to insert the properties of permissions:

The following properties can be imported for permissions:

Technical Name

Permission Property

Mandatory

Where to be found?

active

Permission active

(tick)

Menu "Permissions": Master Data

name

Name

(tick)

Menu "Permissions": Master Data

resource

Permission

(tick)

Menu "Permissions": Permission

Importing Data

Go to section Upload the File when you have inserted all data into the Excel template:

You have two options to upload the import file:

  1. Use drag and drop to place your document to the space marked Drop file here .

  2. Click the Upload File button to select your file.

Please note, that elements such as users, profiles, roles and permissions created by an import cannot be assigned to other new elements created by the same import.
Example:

  • You want to create new users and new profiles by the same import.

  • The new profiles should be assigned to the new users.

  • In that case, you will have to divide the import: The profiles must be imported first, the users by a second import.

As soon as an import file has been uploaded, the content of the file will be analyzed.

In section Result of the Analysis, an overview will appear, showing the following information for all four elements:

  • How many new objects will be created by the import?

  • How many existing objects will be updated by the import?

  • Does the import file contain erroneous data?

If the import file contains objects to update, the existing objects in the user administration portal will be overwritten.

Click Start Import, to import your file. If you want to stop the operation and cancel the import, click Reset.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.