[midPoint] Idiot question concerning date/time handling

[Chris Woods]

Hi,
In addition, I think the <target>s are unnecessary in the activation block 
as the target is implicit.

Regards,
Chris

Am 17. April 2020 08:53:32 schrieb Pálos Gustáv <gustav.palos at gmail.com>:
> Hi Kevin,
>
> yes you need to convert it, like this:
> <expression>
>  <script>
>    <code>basic.parseDateTime("yyyy-MM-dd HH:mm:ss", "2020-04-17 07:00:00")</code>
>  </script>
> </expression>
>
>
> Best regards,
>
> Gustav
>
>
>
> pi 17. 4. 2020 o 8:18 Collins, Kevin <K.J.Collins at hw.ac.uk> napísal(a):
>
> Hi everyone,
>
>
>
>
> I hope that everyone is well and coping with the new working patterns that 
> many of us have had to adopt.
>
>
> I have a question that may have been answered previously, but I can't find it.
>
>
> The "source of truth" for user data is in a Postgresql table with 
> start_date and end_date supplied. The columns for start_date and end_date 
> are defined in the table as "timestamp without timezone" and take the form 
> "yyyy-MM-dd HH:mm:ss", (example "2020-04-17 07:00:00").
>
>
> I'm trying to set up activation for any users coming in from this data feed 
> so that Midpoint knows when it's time to create, activate, suspend or 
> archive the user account. I have got the MidPoint database table connector 
> connecting to the database and can import some attributes. However, I can't 
> get the start_date into validFrom and end_date into validTo.
>
>
> =-=-=-=-=-=-=-=
> <activation>
>                    <validFrom>
>                        <inbound>
>                            <authoritative>true</authoritative>
>                            <exclusive>false</exclusive>
>                            <strength>normal</strength>
>                            <source>
>                                <c:path>$account/attributes/start_date</c:path>
>                            </source>
>                            <target>
>                                <c:path>$focus/activation/validFrom</c:path>
>                            </target>
>                        </inbound>
>                    </validFrom>
>                    <validTo>
>                        <inbound>
>                            <authoritative>true</authoritative>
>                            <exclusive>false</exclusive>
>                            <strength>normal</strength>
>                            <source>
>                                <c:path>$account/attributes/end_date</c:path>
>                            </source>
>                            <target>
>                                <c:path>$focus/activation/validTo</c:path>
>                            </target>
>                        </inbound>
>                    </validTo>
>                </activation>
>
>
>
>
> =-=-=-=-=-=-=-=
>
>
> (And I haven't got a clue - yet!! - as to how to determine the 
> administrative status from these dates. I think that it should be 
> "undefined" to allow Midpoint to make the decision).
>
>
> Do I have to convert the dates from Postgresql's timestamp-without-timezone 
> into something else?
>
>
> Help would be appreciated with this PoC.
>
>
> Stay safe, stay well !!
>
>
>
>
> Regards,
>
>
> -Kev_C
>
>
>
> --
> Kevin Collins,
> Edinburgh,
> Scotland, UK
>
>
>
>
> 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:
>
> Heriot-Watt University, a Scottish charity registered under number SC000278
> 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.
>
> 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.
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint
>
>
>
>
> --
>
> s pozdravom
>
> Gustáv Pálos
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200417/42f3bea2/attachment.htm>