Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Benutzerdaten aus einer CSV-Datei können über die CsvSyncSource gelesen werden.

Hierbei ist es erforderlich, dass die CSV-Datei "Header" besitzt und dass es eine Spalte gibt, welche eindeutige Werte für die Benutzersynchronisation bereitstellt.

Hinweis: Das Mapping wird ebenfalls unterstützt.

...

User data from a CSV file can be read via the CsvSyncSource.

Here it is required that the CSV file has headers and that there exists a column which provides unique values for user synchronization.

Info

Mapping is supported as well.

...

Configuration

Code Block
languagexml
<?xml version="1.0" encoding="utf-8" ?>
<UserSyncConfig>
  	<CsvSyncSource name="Csv" queryKey="OneOffixxIdentifier">
   
    <FilePath>\\Share\Users.csv</FilePath>
   
    <Delimiter>;</Delimiter>
		
		    
    <!-- Column name for user lookup -->
    <KeyColumnName>sid</KeyColumnName>
    
  <KeyColumnName>sid</KeyColumnName> 		 		<!-- Optional: Prevents "stale" data to be synchronized -->
    <TreatFileAsStaleAfterHours>24</TreatFileAsStaleAfterHours>
    
  <TreatFileAsStaleAfterHours>24</TreatFileAsStaleAfterHours> 		 		<!-- Optional: Result Mapping Syntax is supported -->
   
    <ResultMapping>
     
      <Mapping>
      
         <Map Source="email" Target="fromMappingEMail" />
       </Mapping>
    </Mapping>
ResultMapping>
    
  </ResultMapping>		 		 		<!-- Claim Mapping - column names are property names-->
   
    <Claims>
     
      <Claim type="http://schema.oneoffixx.com/ws/2011/01/identity/claims/displayName" ignoreClaimIfEmpty="true" property="displayName" />
			
      <Claim type="http://schema.oneoffixx.com/ws/2011/01/identity/claims/email" ignoreClaimIfEmpty="true" property="fromMappingEMail" />
  
     </Claims>
    
  </CsvSyncSource>
</UserSyncConfig>