Preparing Data for Import
FlexNet Manager Suite ()
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. |
**Parent topic:**Import Procedure