Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
tutorial:adm:how_to_identity_sync [2019/08/14 12:44]
doischert 		tutorial:adm:how_to_identity_sync [2021/03/03 12:52] (current)
soval [Systems - CSV: Source of identities]
Line 1: Line 1:
 ====== Systems - CSV: Source of identities ====== ====== Systems - CSV: Source of identities ======
 +
 +<note important>OBSOLETE from IdM version 10.6.0. [[tutorial:adm:how_to_identity_sync_via_wizard|]]</note>
  
 ===== Introduction ===== ===== Introduction =====
Line 8: Line 10:
  
 <code csv> <code csv>
-login,firstname,lastname+LOGIN,FIRSTNAME,LASTNAME
 edwardw,Edward,Williams edwardw,Edward,Williams
 adaml,Adam,Lewis adaml,Adam,Lewis
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 (multi)" field)   * **Header included**: does the file have a header (it usually does, as in our example; if not, it can be set in the "Header (multi)" field)
   * **Source path**: path to the csv   * **Source path**: path to the csv
-  * **Identifier**: the name of the column containing unique identifiers of the identities (login in our example)+  * **Identifier**: the name of the column containing unique identifiers of the identities (LOGIN in our example)
   * 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:
  
 {{ :tutorial:adm:csv_conf_4.png?direct&600 |}} {{ :tutorial:adm:csv_conf_4.png?direct&600 |}}
 +
 +If your CSV file contains the header names in lower case and the scheme attributes weren't generated in upper case, go to each generated attribute and change its name to upper case.
  
 ===== 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:tomcat   * Owner of the CSV files and folder, including these files, has to be tomcat:tomcat
 +  * ''org.hsqldb.HsqlException: user lacks privilege or object not found: USER_EX65024'' - The key column is not written in the configuration property **Column names (multi)** (there must be all columns)
 +  * 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 82: Line 89:
   * No missing unique identifiers   * No missing unique identifiers
   * 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 (<U+FEFF>). It Shouldn't start with BOM character.
 +
  
  
  
  • by doischert