Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
tutorial:adm:how_to_identity_sync [2020/11/23 17:55] apeterova key in columns |
tutorial:adm:how_to_identity_sync [2021/03/03 12:45] soval [Systems - CSV: Source of identities] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Systems - CSV: Source of identities ====== | ====== Systems - CSV: Source of identities ====== | ||
+ | |||
+ | <note important> | ||
===== Introduction ===== | ===== Introduction ===== | ||
Line 8: | Line 10: | ||
<code csv> | <code csv> | ||
- | login,firstname,lastname | + | LOGIN,FIRSTNAME,LASTNAME |
edwardw, | edwardw, | ||
adaml, | adaml, | ||
Line 16: | Line 18: | ||
Set permissions so that the CzechIdM server will be able to read this file. **Also, CzechIdM must be able to write into the folder where the file is located because the connector needs to create temporary files when processing csv into its location.** (chmod 750 for folder permissions) | Set permissions so that the CzechIdM server will be able to read this file. **Also, CzechIdM must be able to write into the folder where the file is located because the connector needs to create temporary files when processing csv into its location.** (chmod 750 for folder permissions) | ||
+ | We recommend using the column names as upper-case, because the connector is case-sensitive and also it transforms the names of the columns to uppercase automatically. If you don't use upper case, you would have to change the attributes in the Scheme manually (see later). | ||
===== Basic information ===== | ===== Basic information ===== | ||
Line 30: | Line 33: | ||
* **Header included**: does the file have a header (it usually does, as in our example; if not, it can be set in the " | * **Header included**: does the file have a header (it usually does, as in our example; if not, it can be set in the " | ||
* **Source path**: path to the csv | * **Source path**: path to the csv | ||
- | * **Identifier**: | + | * **Identifier**: |
* the rest is optional and should not be set in this case | * the rest is optional and should not be set in this case | ||
Click Save. | Click Save. | ||
Line 40: | Line 43: | ||
{{ : | {{ : | ||
+ | |||
+ | If your CSV file contains the header names in lower case and the scheme attributes weren' | ||
===== Mapping ===== | ===== Mapping ===== | ||
Line 76: | Line 81: | ||
* Permission of the folder with CSV files should be set to reading, writing and execution | * Permission of the folder with CSV files should be set to reading, writing and execution | ||
* Owner of the CSV files and folder, including these files, has to be tomcat: | * Owner of the CSV files and folder, including these files, has to be tomcat: | ||
+ | * '' | ||
+ | * Check if the columns are lower or upper case - they should be upper case in the Scheme attributes, otherwise their values are not correctly loaded into IdM. | ||
**Your CSV is not valid:** | **Your CSV is not valid:** | ||
Line 83: | Line 90: | ||
* No empty columns in the header definition | * No empty columns in the header definition | ||
* The CSV file has UTF-8 encoding and starts with BOM character (< | * The CSV file has UTF-8 encoding and starts with BOM character (< | ||
- | * '' | + | |