CSV

Introduction

HCL Notes is a proprietary collaborative software platform for Unix, Windows, Linux and macOS, sold by HCLTech. The client application is called Notes while the server component is branded HCL Domino.

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.