CSV

Introduction

With the CSV System Connector you can provision (CRUD) identities to a comma separated values files. The users, their attributes and properties are handled as any other identity within the CoreOne Suite. You simply create a provisioning configuration with the attributes of your choice. Those attributes are then represented as a new column within the configured CSV file.

System Identity Types

The following system identity types are supported:

Identity Type	Description
`CSV User`	A user representing a row in the CSV file.

CSV User

The following user attributes can be manged by default:

Attribute	Description
`Id`	Uniquely identifies the user in the file
`firstName`	The first name of the user
`lastName`	The last name of the user
`birthDate`	The birth date of the user

Note you can add as many new attributes as you like using the Admin User Interface

System Resource Types

The following system resource types are supported:

Identity Type	Description
`CSV Group`	A virtual resource used to initiate the creation of the user.

Target System Parameters

Whenever you connect a SAP system to the CoreOne Suite you will need to specify the following parameters.

Parameter	Mandatory	Example	Description
`Delimeter`	✅	,	The delimeter to be used
`Multi Value Delimeter`	✅	;	The delimter to be used to seperate multiple values for the same attribute
`Storage Location`	✅	\\networkdrive\exports\demoappusers\	Where to store the maintained CSV file
`Filename`	✅	userlist.csv	The filename of the CSV to be maintained
`Encoding`	✅	utf-8	The encoding of file
`Configuration File Name`	✅	config.json	Json file with configuration for Ressource Assignments, needs to be manually added in `Storage Location`

Example config.json file:

[
{
"ResourceTypeId": "16",
"FilePath": "\\\\networkdrive\\Folder\\",
"FileName": "resource_type_16.csv",
"ResourceParametersFileName": "resource_parameters_type_16.csv",
"Delimiter": ";",
"MultiDelimiter": "|",
"Encoding": "utf-8"
},
{
"ResourceTypeId": "17",
"FilePath": "\\\\networkdrive\\Folder\\",
"FileName": "resource_type_17.csv",
"ResourceParametersFileName": "resource_parameters_type_17.csv",
"Delimiter": ";",
"MultiDelimiter": "|",
"Encoding": "utf-8"
},
{
"ResourceTypeId": "18",
"FilePath": "\\\\networkdrive\\Folder\\",
"FileName": "resource_type_17.csv",
"ResourceParametersFileName": "resource_parameters_type_18.csv",
"Delimiter": ";",
"MultiDelimiter": "|",
"Encoding": "utf-8"
}
]

Additional Information:

There will be automatically created file identity_to_resource.json, it’s needed so don’t delete it unless you have problems with generating ressource assignments files and need to remove them and regenrate, then you need to remove that file as well.