<div dir="ltr">Basically, you would end up having 2 different schema extensions, 1 to pull in and store it as a string value yyyymmdd and then you use the other to take the string value and store it as date by using objectTemplate mapping.<div><br></div><div><div><mapping></div><div><span style="white-space:pre-wrap"> </span><strength>strong</strength></div><div><span style="white-space:pre-wrap"> </span><source></div><div><span style="white-space:pre-wrap"> </span><path>extension/yourStringValu<wbr>e</path></div><div><span style="white-space:pre-wrap"> </span></source></div><div><span style="white-space:pre-wrap"> </span><expression></div><div><span style="white-space:pre-wrap"> </span><script></div><div><span style="white-space:pre-wrap"> </span><code></div><div><span style="white-space:pre-wrap"> </span>import com.evolveum.midpoint.prism.xm<wbr>l.XmlTypeConverter</div><div><span style="white-space:pre-wrap"> </span>Date dt = Date.parse('yyyyMMdd',
<span style="font-size:small;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">yourStringValue</span>)</div><div><span style="white-space:pre-wrap"> </span>XmlTypeConverter.createXMLGreg<wbr>orianCalendar(dt)</div><div><span style="white-space:pre-wrap"> </span></code></div><div><span style="white-space:pre-wrap"> </span></script></div><div><span style="white-space:pre-wrap"> </span></expression></div><div><span style="white-space:pre-wrap"> </span><target></div><div><span style="white-space:pre-wrap"> </span><path>extension/yourDateTimeVa<wbr>lue</path></div><div><span style="white-space:pre-wrap"> </span></target></div><div></mapping></div></div><div class="gmail_extra"><br clear="all"><div><div class="m_7652260472931619365m_-2860546152687520283gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">JASON</div></div></div>
<br><div class="gmail_quote">On Tue, Aug 14, 2018 at 12:20 PM, Frigerio, Joshua <span dir="ltr"><<a href="mailto:joshua@uic.edu" target="_blank">joshua@uic.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Ah, Ok. I guess I was assuming that Midpoint would have to import it as a<br>
date in order to use the value as a date? (ie, so that rules can be made<br>
that depend on date values).<br>
Is that not the case? Can I import them as strings and Midpoint will<br>
still be able to use them as dates?<br>
<span class="m_7652260472931619365m_-2860546152687520283im m_7652260472931619365m_-2860546152687520283HOEnZb"><br>
<br>
-----Original Message-----<br>
From: midPoint <<a href="mailto:midpoint-bounces@lists.evolveum.com" target="_blank">midpoint-bounces@lists.evolve<wbr>um.com</a>> on behalf of<br>
</span><span class="m_7652260472931619365m_-2860546152687520283im m_7652260472931619365m_-2860546152687520283HOEnZb">František Dvořák <<a href="mailto:valtri@civ.zcu.cz" target="_blank">valtri@civ.zcu.cz</a>><br>
Reply-To: midPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
</span><span class="m_7652260472931619365m_-2860546152687520283im m_7652260472931619365m_-2860546152687520283HOEnZb">Date: Tuesday, August 14, 2018 at 11:49 AM<br>
To: midPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
Subject: Re: [midPoint] scriptedsql example<br>
<br>
</span><div class="m_7652260472931619365m_-2860546152687520283HOEnZb"><div class="m_7652260472931619365m_-2860546152687520283h5">>Hello,<br>
><br>
>Frigerio, Joshua píše v Út 14. 08. 2018 v 14:23 +0000:<br>
>> Hey, can anyone throw me a rope. How do I get a scriptedsql resource<br>
>> to<br>
>> read the “datetime” type as a date into Midpoint?<br>
>> I tried setting “All native” to true. No help.<br>
>> I keep getting the same error:<br>
>> <br>
>> "Attribute 'birth' type 'class java.sql.Timestamp' is not<br>
>> supported.’"<br>
>> <br>
><br>
>As I understand, ConnId framework doesn't support date types. It needs<br>
>to be converted to Long or String inside the SQL groovy script.<br>
><br>
>But there are exciting plans in midPoint 3.9 about newer ConnId and<br>
>native date types support:<br>
><br>
><a href="https://wiki.evolveum.com/display/midPoint/Release+3.9+-+PLANNED#Release3" rel="noreferrer" target="_blank">https://wiki.evolveum.com/dis<wbr>play/midPoint/Release+3.9+-+PL<wbr>ANNED#Release3</a>.<br>
>9-PLANNED-Changeswithrespectt<wbr>oversion3.8<br>
><br>
> Frantisek<br>
><br>
>> Thanks.<br>
>> <br>
>> <br>
>> -----Original Message-----<br>
>> From: midPoint <<a href="mailto:midpoint-bounces@lists.evolveum.com" target="_blank">midpoint-bounces@lists.evolve<wbr>um.com</a>> on behalf of joe<br>
>> schmoe <<a href="mailto:joshua@uic.edu" target="_blank">joshua@uic.edu</a>><br>
>> Reply-To: midPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
>> Date: Friday, August 3, 2018 at 8:21 PM<br>
>> To: midPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
>> Subject: Re: [midPoint] scriptedsql example<br>
>> <br>
>> > > <br>
>> > > If you don't want to handle this date as a real date, just<br>
>> > > convert it to<br>
>> > > string using mysql cast function:<br>
>> > <br>
>> > I want it to remain a date.<br>
>> > I figured in the SchemaScript.groovy, I’d change it to tell<br>
>> > Midpoint it’s<br>
>> > a date, using this line:<br>
>> > <br>
>> > account.addAttributeInfo(Attri<wbr>buteInfoBuilder.build("birthda<wbr>te",<br>
>> > String.class));<br>
>> > <br>
>> > But nothing I change it to matters, same error every time:<br>
>> > "Attribute<br>
>> > 'birthdate' type 'class java.sql.Timestamp' is not supported.”. :-<br>
>> > (<br>
>> > <br>
>> > Or am I going about it wrong? How do I get it to see that datetime<br>
>> > field<br>
>> > as a datetime field?<br>
>> > <br>
>> > <br>
>> > <br>
>> > > <br>
>> > > select cast(timestamp as char) as timestamp<br>
>> > > <br>
>> > > <br>
>> > > W dniu 03.08.2018 o 21:27, Frigerio, Joshua pisze:<br>
>> > > > > You have:<br>
>> > > > > sql.eachRow("SELECT name,timestamp,id,notes,birthd<wbr>ate,netid<br>
>> > > > > FROM<br>
>> > > > > person "<br>
>> > > > > + where, {result.add([__UID__:<a href="http://it.id" rel="noreferrer" target="_blank">it.id</a>, __NAME__:it.netid, ])}<br>
>> > > > > );<br>
>> > > > > <br>
>> > > > > Should be:<br>
>> > > > > sql.eachRow("SELECT name,timestamp,id,notes,birthd<wbr>ate,netid<br>
>> > > > > FROM<br>
>> > > > > person "<br>
>> > > > > + where, {result.add([__UID__:<a href="http://it.id" rel="noreferrer" target="_blank">it.id</a>, __NAME__:it.netid,<br>
>> > > > > notes:it.notes,<br>
>> > > > > birthdate:it.birthdate])} );<br>
>> > > > <br>
>> > > > Ug, that was right there in the example too, somehow I missed<br>
>> > > > thatŠ.<br>
>> > > > Thanks!<br>
>> > > > <br>
>> > > > Although it doesn¹t work for date fields (datetime or timestamp<br>
>> > > > mysql<br>
>> > > > types). If I try to add the ³timestamp² field or the<br>
>> > > > ³birthdate" field,<br>
>> > > > it<br>
>> > > > says, ³Got unexpected exception:<br>
>> > > > java.lang.IllegalArgumentExcep<wbr>tion:<br>
>> > > > Attribute 'birthdate' type 'class java.sql.Timestamp' is not<br>
>> > > > supported."<br>
>> > > > In the schema groovy script, I told it to treat it as a<br>
>> > > > String.class,<br>
>> > > > but<br>
>> > > > it doesn¹t work anyway. :-(<br>
>> > > > <br>
>> > > > ______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
>> > > <br>
>> > > -- <br>
>> > > Wojciech Staszewski<br>
>> > > Administrator Systemów Sieciowych<br>
>> > > tel. kom: 663 680 236<br>
>> > > <a href="http://www.diagnostyka.pl" rel="noreferrer" target="_blank">www.diagnostyka.pl</a><br>
>> > > Diagnostyka Sp. z o. o.<br>
>> > > ul. Prof. M. Życzkowskiego 16, 31-864 Kraków<br>
>> > > Numer KRS: 0000381559 (Sąd Rejonowy dla Krakowa-Śródmieścia w<br>
>> > > Krakowie,<br>
>> > > XI Wydział Gospodarczy KRS)<br>
>> > > NIP: 675-12-65-009; REGON: 356366975<br>
>> > > Kapitał zakładowy: 33 756 500 zł.<br>
>> > > <br>
>> > > Pomyśl o środowisku zanim wydrukujesz ten e-mail.<br>
>> > > <br>
>> > > ______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
>> > <br>
>> > ______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
>> <br>
>> ______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
>_____________________________<wbr>__________________<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/mai<wbr>lman/listinfo/midpoint</a><br>
<br>
______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
</div></div></blockquote></div><br></div></div>