# 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.

<div id="bkmrk-property-description"><table class="wrapped confluenceTable tablesorter tablesorter-default" role="grid"><colgroup><col></col><col></col></colgroup><thead><tr class="tablesorter-headerRow" role="row"><th aria-disabled="false" aria-label="Property: No sort applied, activate to apply an ascending sort" aria-sort="none" class="confluenceTh tablesorter-header sortableHeader tablesorter-headerUnSorted" data-column="0" role="columnheader" scope="col" tabindex="0"><div>Property</div></th><th aria-disabled="false" aria-label="Description: No sort applied, activate to apply an ascending sort" aria-sort="none" class="confluenceTh tablesorter-header sortableHeader tablesorter-headerUnSorted" data-column="1" role="columnheader" scope="col" tabindex="0"><div>Description</div></th></tr></thead><tbody aria-live="polite" aria-relevant="all"><tr role="row"><td class="confluenceTd">file</td><td class="confluenceTd"><u>Mandatory</u>: Path where the file is placed in the directory system</td></tr><tr role="row"><td class="confluenceTd" colspan="1">key</td><td class="confluenceTd" colspan="1"><u>Mandatory</u>: The field to be used as key </td></tr></tbody></table>

</div>####  System attribute

Mapping between CSV fields and Soffid objects.

[![CSV Connector - customizable CSV file.png](https://bookstack.soffid.com/uploads/images/gallery/2021-04/scaled-1680-/csv-connector-customizable-csv-file.png)](https://bookstack.soffid.com/uploads/images/gallery/2021-04/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.

<u>Example  
</u>

<div id="bkmrk-type-file-data-%28file"><table class="wrapped confluenceTable tablesorter tablesorter-default" role="grid"><colgroup><col></col><col></col></colgroup><thead><tr class="tablesorter-headerRow" role="row"><th aria-disabled="false" aria-label="Type: No sort applied, activate to apply an ascending sort" aria-sort="none" class="confluenceTh tablesorter-header sortableHeader tablesorter-headerUnSorted" data-column="0" role="columnheader" scope="col" tabindex="0"><div>**Type**</div></th><th aria-disabled="false" aria-label="File: No sort applied, activate to apply an ascending sort" aria-sort="none" class="confluenceTh tablesorter-header sortableHeader tablesorter-headerUnSorted" data-column="1" role="columnheader" scope="col" tabindex="0"><div>**File**</div></th></tr></thead><tbody aria-live="polite" aria-relevant="all"><tr role="row"><td class="confluenceTd">data (file used in this configuration guide)</td><td class="confluenceTd">[file.csv](https://bookstack.soffid.com/attachments/5)

</td></tr><tr role="row"><td class="confluenceTd" colspan="1">attribute-mapping (file used in this configuration guide)</td><td class="confluenceTd" colspan="1">[csv-agent-config.xml](https://bookstack.soffid.com/attachments/6)

</td></tr></tbody></table>

</div>### Useful information

<table class="wrapped confluenceTable tablesorter tablesorter-default" id="bkmrk-system-objects-user-" role="grid"><colgroup><col></col></colgroup><thead><tr class="tablesorter-headerRow" role="row"><th aria-disabled="false" aria-label="System objects: No sort applied, activate to apply an ascending sort" aria-sort="none" class="confluenceTh tablesorter-header sortableHeader tablesorter-headerUnSorted" data-column="0" role="columnheader" scope="col" style="width: 200px;" tabindex="0"><div>**System objects**</div></th></tr></thead><tbody aria-live="polite" aria-relevant="all"><tr role="row"><td class="confluenceTd" colspan="1" style="width: 200px;">[User](http://www.soffid.org/doc/console/2.5.0/iam-common/apidocs/com/soffid/iam/api/User.html)</td></tr><tr role="row"><td class="confluenceTd" colspan="1" style="width: 200px;">[Account](http://www.soffid.org/doc/console/2.5.0/iam-common/apidocs/com/soffid/iam/api/Account.html)</td></tr><tr role="row"><td class="confluenceTd" style="width: 200px;">[Group](http://www.soffid.org/doc/console/2.5.0/iam-common/apidocs/com/soffid/iam/api/Group.html)</td></tr><tr role="row"><td class="confluenceTd" colspan="1" style="width: 200px;">[Role](http://www.soffid.org/doc/console/2.5.0/iam-common/apidocs/com/soffid/iam/api/Role.html)</td></tr></tbody></table>