Customizable CSV file (CSV Connector type)

Introduction

Description

The CSV connector type allows users to load a collection of data stored into a plain CSV file.

In the following page, the process to complete the CSV connector setup will be explained.

To begin with,  address to the quick start section. 

Quick start

The core of Customizable CSV file connector is located under the 'Attribute Mapping'  tab.

There are two important sections:

Property

File information related configuration.

Property
Description
file Mandatory: Path where the file is placed in the directory system
key Mandatory: The field to be used as key 

 System attribute

Mapping between CSV fields and Soffid objects.

CSV Connector - customizable CSV file.png

Taking a look to the configuration used, we can see that:

  • System objects is the entity to load (user, account, group, role).
  • System attributes fields match the columns defined into the 'file.csv'.

To demonstrate Soffid flexibility in terms of agent customization, notice that:

USERNAME, NAME, LASTNAME fields, correspond to default fields from User object.

NDI is a custom field defined into the User object.

"I" is a 'char' literal that indicates the UserType.

  • Soffid attributes match Soffid specification model object.

Example

Type
File
data (file used in this configuration guide)

file.csv

attribute-mapping (file used in this configuration guide)

csv-agent-config.xml

Useful information

System objects
User
Account
Group
Role