<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’m using the following expression for importing date from DATABASE to MIDPOINT, and it works:<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"><script xmlns:org="http://midpoint.evolveum.com/xml/ns/public/common/org-3"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> <code><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> import java.text.SimpleDateFormat;<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> import java.text.DateFormat;<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> <o:p>
</o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> DateFormat dtf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> <o:p>
</o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> if (input!=null) {<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> Date dt = dtf.parse(input);<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> log.info("convertedValidFrom = " + dt);<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> return com.evolveum.midpoint.util.MiscUtil.asXMLGregorianCalendar(dt);<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> } else {<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> return null;<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> }<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"> </code><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="color:#1F497D"></script><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Using the same expression for outbound throws the following error:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="color:#1F497D">No such property: input for class: expression_in_mapping_in_inbound_expression_for_DATA _in_resource_67952a4d-218b-4b1d-952d-7e1fe1a9d58b(HR) in expression in mapping in outbound mapping
for {.../resource/instance-3}DATA in resource:28d3861d-df87-494b-8c65-597ca787ba08(Users)(null (focus, user)=user:1056841c-1dc9-489b-bead-3054bfa1882a(); configuration=systemConfiguration:00000000-0000-0000-0000-000000000001(SystemConfiguration); resource=resource:28d3861d-df87-494b-8c65-597ca787ba08(Users);
iterationToken=; actor=user:00000000-0000-0000-0000-000000000002(administrator); DATA =PPV(XMLGregorianCalendarImpl:1979-11-10T12:00:00.000+01:00); legal=true; iteration=0; assigned=true; projection (shadow, account)=null; operation=add; ) in expression in
mapping in outbound mapping for {.../resource/instance-3}DATA in resource:28d3861d-df87-494b-8c65-597ca787ba08(Users)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Can anyone advise?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thank you.</span><b><span style="font-size:8.0pt;color:black">
</span></b><span lang="EN-GB" style="font-size:8.0pt;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>