Standard timestamp in log files.

I am using Appian 18.4 on prem. I am using the Log Reader plugin to read data from log files and write the data into database tables. I want for the timestamp columns to be of type Date and Time. For example, the log file site_usage.csv contains the timestamp in the format 11 Jun 2019 05:30:40 GMT. I am in need to convert that to Date and Time. I could easily create expression rule to do that. However, what happens if:

1. In the future we move to the cloud or other environment and that other environment have different date format in the logs.

2. What if Appian changes the format of the column in the future?

3. Etc.

Having said all that, what do others recommend I should do in terms of the logic to convert the text timestamp of any log file to Date and Time and bullet proof for any future changes?

Parents
  • So, bullet proof is a hard goal to achieve :-)

    However, if you just always store the date/time in a char field in the DB, you can create DB functions or Appian expression rules to apply formatting based on what text comes back. Doesn't make it bullet proof, but makes it more 'adaptable' to storing any value and then formatting to display as desired. Just a thought....

Reply
  • So, bullet proof is a hard goal to achieve :-)

    However, if you just always store the date/time in a char field in the DB, you can create DB functions or Appian expression rules to apply formatting based on what text comes back. Doesn't make it bullet proof, but makes it more 'adaptable' to storing any value and then formatting to display as desired. Just a thought....

Children

 Discussion posts and replies are publicly visible