ISCAN allows users to import timeseries data in a range of formats. The minimum requirements of an import are to have a timestamp, a reference name and a value.
Timestamps. There are a number of formats supported. Below is the current list of supported formats
Date YYYY-MM-DD
Format for a date only as YYYY-MM-DD
Date YYYY/MM/DD
Format for a date only as YYYY/MM/DD
Date DD/MM/YY
Format for a date only as DD/MM/YY
Date DD/MM/YYYY
Format for a date only as DD/MM/YYYY
Date MM/DD/YY
Format for a date only as MM/DD/YY
Date MM/DD/YYYY
Format for a date only as MM/DD/YYYY
Date DD/MM-YYYY
Format for a date only as DD/MM-YYYY
Date DD.MM.YYYY
Format for a date only as DD.MM.YYYY
Date MM.DD.YYYY
Format for a date only as MM.DD.YYYY
Date/Time ISO
Format for a date and time as ISO Zulu time or with offset
Date/Time YYYY-MM-DD
Format for a date and time as YYYY-MM-DD HH:MM(:SS)
Date/Time YYYY/MM/DD
Format for a date and time as YYYY/MM/DD HH:MM(:SS)
Date/Time DD/MM/YY
Format for a date and time as DD/MM/YY HH:MM(:SS)
Date/Time DD/MM/YYYY
Format for a date and time as DD/MM/YYYY HH:MM(:SS)
Date/Time MM/DD/YY
Format for a date and time as MM/DD/YY HH:MM(:SS)
Date/Time MM/DD/YY hh:mm AM
Format for a date and time as MM?/DD?/YYYY HH:MM(:SS) (AM|PM)
Date/Time MM/DD/YYYY
Format for a date and time as MM/DD/YYYY HH:MM(:SS)
Date/Time DD/MM-YYYY
Format for a date and time as DD/MM-YYYY HH:MM(:SS)
Date/Time DD.MM.YYYY
Format for a date and time as DD.MM.YYYY HH:MM(:SS)
Date/Time MM.DD.YYYY
Format for a date and time as MM.DD.YYYY HH:MM(:SS)
Date/Time Microsoft Date
Format for a date and time as Microsoft Date format
Date/Time Ticks
Format for a date and time as Microsoft Ticks format
Date/Time Unix Seconds
Format for a date and time as seconds since unix date epoch
Date/Time File Time
Format for a date and time as seconds since MS file epoch
Date/Time MS Seconds
Format for a date and time as seconds since MS date epoch
Date Short Month
Format for a date only as Short Month format '15 Dec 2013'
Date/Time Short Month
Format for a date and time as Short Month format '15 Dec 2013 18:30:00'
Date/Time Short Month AM/PM BST/GMT
Format for a date and time as Short Month AM/PM format '21-Feb-15 11:10:00 AM GMT'
Date Long Month
Format for a date only as Long Month format '15 December 2013'
Date/Time Long Month
Format for a date and time as Long Month format '15 December 2013 18:30:00'
