Flex For TimeStamps

[bhleee]

Hello.

I wanna share my flexconnector timestamp parse test document. when it comes to time to make flexconnector, various timestamp format was one of the difficulty to overcome.

I gather this tip and idea from many of posting on  Protect724 and manual etc.

thank you

[Lar]

Thanks for posting this Brad

[skrc851]

Thanks ​ for the document!

[skrc851]

Hi ​, I've got something to ask on a flex parser I've been working today

My Timestamp: 2016-09-06T17:25:57 ----- I need to map this to endTime

Attempt 1:

token[0].name=ET ,     token[0].type=TimeStamp ,     token[0].format=yyyyMMddTHH\:mm\:ss 
event.endTime=ET---------------- Unsuccessful

Attempt 2:

token[0].name=ED , token[0].type=String , 

token[1].name=ET ,  token[1].type=String
All the below were not returning any values – I mean the fields are just empty-no values seen and no errors seen as well - ---------------- Unsuccessful

a. event.deviceReceiptTime=__createOptionalTimeStampFromString(__concatenate(ED," ",ET),"yyyyMMdd HH\:mm\:ss")

b. event.deviceCustomDate1=__createOptionalTimeStampFromString(__concatenate(ED," ",ET),"yyyyMMdd HH\:mm\:ss")

c. event.deviceCustomDate2=__safeToDate(event.deviceCustomString1,"yyyyMMdd HH\:mm\:ss")

Attempt 3: - - ----- Partially OK but unsuccessful while converting to Timestamp

Now, I want to make sure the tokens are converted to string first, so

event.deviceCustomString1=__concatenate(ED," ",ET) – Successfully mapped as "2016-09-06 17:25:57"

However the below doesn’t work again,

event.endTime=__createOptionalTimeStampFromString(event.deviceCustomString1,"yyyyMMdd HH\:mm\:ss")

Please let me know, what am I missing here..

[bhleee]

can you please try this one on page 25?

"1.17 Multiple Time Stamp"

event.deviceReceiptTime=__parseMultipleTimeStamp(datetime,"yyyy-MM-dd'T'HH\:mm\:ss.SSSZ","yyyy-MMdd'T'HH\:mm\:ssZ","yyyy-MM-dd'T'HH\:mm\:ss.SSS","yyyy-MM-dd'T'HH\:mm\:ss")

thank you

[ekirca1]

Nice share, thank you Brad

[klr01]

Thank you so much, Brad! This doc is very helpful!

[sahinok]

This is a very helpful document. Thanks.