How to rise error during synchronization?

Question

Hello, 
 I have a basic synchronization project to import a bunch of CSV files. The data I would like to import in One Identity Manager looks like this : 
 code1;valueA1;valueB1;valueC1 
 code2; ; ;valueC2 
 code3;valueA3;valueB3; 
 code4;valueA4;valueB4;valueC4 
 Basically I want to make sure there is not empty value in the line before importing it. Otherwise, I would like to skip this line and generate an error in the log of synchronization project (in this example, line 3 and line 2, would be skipped). 
 
 How can I generate an error and then skip the line in one the columns is empty? 
 
 Thank you, 
 Mustapha

Markus Weiss-Ehlers · Accepted Answer

As I have pointed out before, the only feasible way I see is to create your own process chain to trigger the CSV sync. In that process, you trigger the sync as normal but your scope needs to exclude the empty lines. The sync step generates an out-parameter with the UID_DPRJournal of the sync journal that can be used in the next process step. This process step executes a script that parses the CSV files and logs every "empty" line to the sync journal. I would log those skipped lines into DPRJournalMessage .

Markus Weiss-Ehlers · Answer

You could try to create a scope that checks each of your column against an empty value. To avoid to import empty lines. 
 But you cannot throw custom error messages in that case. 
 I think you need to pre-process your CSV file in a custom process prior to importing it.

Endpoint Privilege Management

How to rise error during synchronization?

Top Replies