<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
Gustav,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
Many thanks for that.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
Wouldn't that mean, though, that the Midpoint IDM would have a shadow object for *every* record in the CSV file? The live ones as well as the stale ones?</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
-Kev</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:10pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> midPoint <midpoint-bounces@lists.evolveum.com> on behalf of Pálos Gustáv <gustav.palos@evolveum.com><br>
<b>Sent:</b> 15 February 2019 04:25<br>
<b>To:</b> midPoint General Discussion<br>
<b>Subject:</b> Re: [midPoint] Filtering out bad or out-of-band data at import</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div>Hi Kevin,</div>
<div><br>
</div>
<div>you can use condition in synchronization to write your needs:</div>
<div><a href="https://wiki.evolveum.com/display/midPoint/Synchronization+Configuration#SynchronizationConfiguration-Conditions">https://wiki.evolveum.com/display/midPoint/Synchronization+Configuration#SynchronizationConfiguration-Conditions</a><br>
</div>
<div><br>
</div>
<div>Best regards</div>
<div><br>
</div>
<div>Gustav</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">št 14. 2. 2019 o 17:00 Collins, Kevin J <<a href="mailto:K.J.Collins@hw.ac.uk">K.J.Collins@hw.ac.uk</a>> napísal(a):<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div style="">Hi everyone,
<div><br>
</div>
<div><br>
</div>
<div>During a data import (from a csv file) is it possible to examine dates in the source record in the csv file to determine whether or not the record should be skipped or imported? For example…</div>
<div><br>
</div>
<div>personID,sn,givenName,personalTitle,description,startDate,endDate</div>
<div>“1234”,”Collins”,”Kevin”,”Mr”,”Specialist”,”10-Jan-2015”,””</div>
<div>“5678”,”Butter”,”Roland”,”Dr”,”System Theologian”,”01-Jul-1996”,”30-Nov-2018”</div>
<div>“9101”,”Calamity”,”Jane”,”Ms”,”Data Packet Wrangler”,”24-Feb-1998”,”31-Mar-2019”</div>
<div><br>
</div>
<div>In the above csv, I’d like to achieve this:</div>
<div><br>
</div>
<div>Collins, Kevin —> imported (no end-date set in HR), and</div>
<div>Calamity, Jane —> imported (end-date is in the future), and</div>
<div>Butter, Roland —> not imported (end-date in the past)</div>
<div><br>
</div>
<div>…but I can’t see how to do this in the examples. I could easily pre-process the csv (Python, Perl, etc) to remove any record with a date in the past, but I’m thinking that it ought to be possible entirely in MidPoint, and that I’m just not seeing it.</div>
<div><br>
</div>
<div><br>
</div>
<div>-Kev_C</div>
<div><br>
</div>
<div>
<div>
<div style="color:rgb(0,0,0); font-family:Helvetica; font-size:12px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none">
- <br>
Kevin Collins,<br>
Senior Specialist,<br>
Information Services,<br>
Rm 23, Allen McTernan Building,<br>
Heriot-Watt University<br>
Edinburgh Campus<br>
EH14 4AS</div>
<div style="color:rgb(0,0,0); font-family:Helvetica; font-size:12px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none">
<br>
</div>
<br class="x_gmail-m_-4214733974034393522Apple-interchange-newline">
</div>
<br>
</div>
<u></u>
<div align="center">
<hr size="2" width="100%" align="center">
</div>
<p style="font-family:Arial,"Helvetica Neue",Helvetica,sans-serif; font-size:8pt; margin:0px">
<b><i>Heriot-Watt University is The Times & The Sunday Times International University of the Year 2018</i></b></p>
<p style="font-family:Arial,"Helvetica Neue",Helvetica,sans-serif; font-size:8pt; margin:0px">
Founded in 1821, Heriot-Watt is a leader in ideas and solutions. With campuses and students across the entire globe we span the world, delivering innovation and educational excellence in business, engineering, design and the physical, social and life sciences.
This email is generated from the Heriot-Watt University Group, which includes:</p>
<ol style="margin:0px">
<li style="font-family:Arial,"Helvetica Neue",Helvetica,sans-serif; font-size:8pt">
Heriot-Watt University, a Scottish charity registered under number SC000278</li><li style="font-family:Arial,"Helvetica Neue",Helvetica,sans-serif; font-size:8pt">
Edinburgh Business School a Charity Registered in Scotland, SC026900. Edinburgh Business School is a company limited by guarantee, registered in Scotland with registered number SC173556 and registered office at Heriot-Watt University Finance Office, Riccarton,
Currie, Midlothian, EH14 4AS</li><li style="font-family:Arial,"Helvetica Neue",Helvetica,sans-serif; font-size:8pt">
Heriot- Watt Services Limited (Oriam), Scotland's national performance centre for sport. Heriot-Watt Services Limited is a private limited company registered is Scotland with registered number SC271030 and registered office at Research & Enterprise Services
Heriot-Watt University, Riccarton, Edinburgh, EH14 4AS.</li></ol>
<p style="font-family:Arial,"Helvetica Neue",Helvetica,sans-serif; font-size:8pt; margin:0px">
The contents (including any attachments) are confidential. If you are not the intended recipient of this e-mail, any disclosure, copying, distribution or use of its contents is strictly prohibited, and you should please notify the sender immediately and then
delete it (including any attachments) from your system.</p>
</div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Gustáv Pálos</div>
<div>Senior Identity Engineer</div>
<a href="http://evolveum.com/" rel="noreferrer" target="_blank" style="color:rgb(17,85,204); font-size:12.8px">evolveum.com</a><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>