I need to import start and end times for SLA Headers via assyst ETM (database table sla - SLA Header Details, fields mon_start, mon_end, tue_start, tue_end and so on). My channel is defined with source = Directory and message format = CSV.
What is the JavaScript expression to parse my input data? Please consider date/time format as “dd/mm/yyyy hh:mi:ss”, where dd = day (two digits), mm = month, yyyy = year (four digits), hh = hour (zero to 23, not AM/PM), mi = minutes and ss = seconds.
We have some common JavaScript functions available to Datamapper authors as linked from the wiki above. The key one for this would be common.parseDate(dateString, dateFormat). It takes the date value from your input, along with the target format (As described in Java SimpleDateFormat) to return a Date value.
In use, if we have a CSV file like:
mon_start
mon_end
...
01/01/2022 09:00:00
01/01/2022 17:30:00
...
Our Datamapper could have a field mapping to the “Mon Start” field for an SLA, with the following JavaScript expression:
We have some common JavaScript functions available to Datamapper authors as linked from the wiki above. The key one for this would be common.parseDate(dateString, dateFormat). It takes the date value from your input, along with the target format (As described in Java SimpleDateFormat) to return a Date value.
In use, if we have a CSV file like:
mon_start
mon_end
...
01/01/2022 09:00:00
01/01/2022 17:30:00
...
Our Datamapper could have a field mapping to the “Mon Start” field for an SLA, with the following JavaScript expression:
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
