/
CSV
CSV
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.
Mapping is supported as well.
Configuration
<?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>
<!-- Optional: Prevents "stale" data to be synchronized -->
<TreatFileAsStaleAfterHours>24</TreatFileAsStaleAfterHours>
<!-- Optional: Result Mapping Syntax is supported -->
<ResultMapping>
<Mapping>
<Map Source="email" Target="fromMappingEMail" />
</Mapping>
</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>
, multiple selections available,
Related content
CSV
More like this
User synchronization
User synchronization
More like this
SQL
More like this
Microsoft Graph
Microsoft Graph
More like this
CsvDataProvider
CsvDataProvider
More like this
PeoplePicker
PeoplePicker
More like this
PrimeSoft AG, Bahnhofstrasse 4, 8360 Eschlikon, Switzerland