Preparing Data for Import

IT Asset Management (Cloud)

Standard-format spreadsheets or CSV files can be imported. Here are details of the supported format.

To enable FlexNet Manager for SAP Applications to optimize non-SAP systems (apply rules and consolidate users of non-SAP systems with users of SAP systems), you need to import information from the linked remote systems into the non-SAP system. This information usually includes user accounts, roles, and consumption data.

You can import the data using a comma-separated file (.csv) or Microsoft Excel workbook (.xls). You need to manually create a template, populate it with data and import it.

A .csv template can specify only one type of data (user, roles, or consumption). If you want to import all three types of data, you need to perform three separate import procedures.

A template in .xls or .xlsx format can contain three spreadsheets—one for each data type. This enables you to import all three data types in one step.

The following tables help you prepare the templates in Microsoft Excel or comma-separated format for importing user data, roles, or consumption data. They specify which information should be provided in the individual columns.

Columns for importing user data from remote systems

Column Name

Description

System ID

The name of the remote server from which the data is imported.

User Name

The user ID of the user on the remote system.

First Name

The first name of the user on the remote system.

Last Name

The last name of the user on the remote system.

License Type The license type that is currently assigned to the user on the remote system.
Valid From

The start date of the user's validity period on the remote system.

Valid To

The end date of the user's validity period on the remote system.

Role

The role that has been assigned to the user on the remote system.

Role Valid From

The role's start date on the remote system.

Role Valid To

The role's end date on the remote system.

Email Address

The email address of the user on the remote system.

Accounting Number

The user's accounting number.

Phone Number

The user's phone number.

Phone Number Extension

The user's phone number extension.

User Group The group that the user belongs to on the remote system.
Is Developer

Indicates whether the user currently has a developer license.

  • TRUE indicates that the user has a developer key.
  • FALSE indicates that the user does not have a developer key.
Cost Center

The user's cost center.

Company Name 1

The company name 1 of the user.

Company Name 2

The company name 2 of the user.

Department

The department to which the user belongs.

User Function

The function of the user within your organization.

Columns for importing roles from remote systems

Column Name

Description

System ID

The name of the remote server from which the data is imported.

Role Name

The name of the role that is used on the remote system.

Authorized Object

The name of the authorized object on the remote system.

Columns for importing consumption data from remote systems

Column Name

Description

System ID

The name of the remote server from which the data is imported.

User Name

The user ID of the user on the remote system whose consumption data is imported.

Consumption Date (YYYY-MM)

The month in which the consumption occurred on the remote system. Enter the month in the format YYYY-MM for each row.

Object

The name of the object that the user accessed.

CPU Time (s)

The CPU time that the user consumed on the remote system (in seconds). CPU times with up to three decimal points are supported.

Access Count

The number of times that the user accessed the object.

IT Asset Management (Cloud)

Current