MIM codeless Provisioning Convert String to Date

Question

Hello All,

I am using an HR management agent (demlimited text file management agent) which is getting a string value for the date. It comes into the connector space as a string. Once it is imported and synced into MIM connectorspace, I would like to export using the FIM management agent, using Synchronization rules. Is there a way to convert a string value to DateTime? Currently, I receive an error attempting this.

I investigated the function DateTimeFormat in the FIM portal (sync rules inbound flow), but upon an export to FIM I receive the error, DateTimeFormat Error. I am thinking that FIM already wants this value to already be a DateTime attribute, and all the DateTimeFormat does is just convert it to a particular format, but I need to convert data types.

Is there a codeless provisioning way of doing this?

-Thanks

Answer 1

Try MIMWAL with a function/workflow to populate a new attribute.

https://github.com/microsoft/MIMWAL/wiki/DateTimeFromString-Function

Answer 2

Hi,

One way is to use MIMWAL. However, this could lead to lower performance than using the Sync engine. There's also a risk of glitches.

If it isn't possible to modify the date format in the input file, I'd use a Rules Extension to convert the input to a valid datetime.

Br,
Leo

Answer 3

This article shows how to do it:
http://blog.goverco.com/2010/03/exporting-employeestartdate-to-fim-2010.html

But it depends on, how you are getting the date from the HR agent. What is the format you are recieving?

/Søren