Upland OL User community

Datamapper does'nt return date correctly in workflow metadata

HI,

I do a simple process of extract meta data with datamapper and I would like read date but unfortunately datamapper return a wrong date in metadata.

Follow the what I do :

PDF document contain the date :

2021-08-30%2010_48_06-s21-0101%20-%20Connexion%20Bureau%20%C3%A0%20distance

Extract the date by extraction step

The result in the data model sound like good :

2021-08-30%2010_48_31-s21-0101%20-%20Connexion%20Bureau%20%C3%A0%20distance

Send the datamapper configuration and execute it .

2021-08-30%2010_50_33-s21-0101%20-%20Connexion%20Bureau%20%C3%A0%20distance

2021-08-30%2010_56_56-s21-0101%20-%20Connexion%20Bureau%20%C3%A0%20distance

And then read the result into the workflow metadata file :

2021-08-30%2010_50_49-s21-0101%20-%20Connexion%20Bureau%20%C3%A0%20distance

What’s happen ? The date is not the same.

I don’t unerstand.

Could 'you help me please.

Herve

After some tests, the date stay correct inside the connect process. she’s modified only if we ask to datamapper to output her to metadata.

Herve

My guess is that since you have converted your text date to a date object in Connect, when you output it ot your metadada, it converts it based on your TimeZone, hence a day before at 22:00 (10 pm).
I do not think this is hte proper behaviour so if it happens again, please open a ticket to our support so they can reproduce it and ask R&D to check into it.

Thank’s for your ansmer, I try to change the timezone of my server to GMT and have the the same result.

Herve

I receive an answer from suppport.
Dates are store in UTC timezone into the Datamapper storage, when he export them to metadata file they stay in UTC.

I’ll try to wrote a JScript funtion to do the conversion and publish here in case of success.

Herve

Convert UTC metadata to locale date:

var UTCToLocale=function(e){var a=Date.parse(e),t=new Date;return new Date(a-1e3*t.getTimezoneOffset())};

Herve