<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Hi everyone,
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">personID,sn,givenName,personalTitle,description,startDate,endDate</div>
<div class="">“1234”,”Collins”,”Kevin”,”Mr”,”Specialist”,”10-Jan-2015”,””</div>
<div class="">“5678”,”Butter”,”Roland”,”Dr”,”System Theologian”,”01-Jul-1996”,”30-Nov-2018”</div>
<div class="">“9101”,”Calamity”,”Jane”,”Ms”,”Data Packet Wrangler”,”24-Feb-1998”,”31-Mar-2019”</div>
<div class=""><br class="">
</div>
<div class="">In the above csv, I’d like to achieve this:</div>
<div class=""><br class="">
</div>
<div class="">Collins, Kevin —> imported (no end-date set in HR), and</div>
<div class="">Calamity, Jane —> imported (end-date is in the future), and</div>
<div class="">Butter, Roland —> not imported (end-date in the past)</div>
<div class=""><br class="">
</div>
<div class="">…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 class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">-Kev_C</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;">
- <br class="">
Kevin Collins,<br class="">
Senior Specialist,<br class="">
Information Services,<br class="">
Rm 23, Allen McTernan Building,<br class="">
Heriot-Watt University<br class="">
Edinburgh Campus<br class="">
EH14 4AS</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<br class="">
</div>
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<title>Untitled Document</title>
<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:0;">
<b><i>Heriot-Watt University is The Times & The Sunday Times International University of the Year 2018</b></i></p>
<p style="font-family: Arial, Helvetica Neue, Helvetica, sans-serif; font-size: 8pt;margin:0;">
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:0;">
<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:0;">
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>
</body>
</html>