CSV Mapper Component
...
The following screenshots show the sequence from configuring the CsvMapper to the resulting histories in AX.
Example Numeric Trend History Type CSV:
...
Note that the Device Row Index is "1", meaning each history will use the Device name of "Charlotte". Also, each history name is grabbed from the 2nd row and the data starts on row 3.
Timestamp Format
Letter | Date or Time | Presentation | Examples |
| Era designator |
| |
| Year |
| |
| Month in year |
| |
| Week in year |
| |
| Week in month |
| |
| Day in year |
| |
| Day in month |
| |
| Day of week in month |
| |
| Day in week |
| |
| Am/pm marker |
| |
| Hour in day (0-23) |
| |
| Hour in day (1-24) |
| |
| Hour in am/pm (0-11) |
| |
| Hour in am/pm (1-12) |
| |
| Minute in hour |
| |
| Second in minute |
| |
| Millisecond |
| |
| Time zone |
| |
| Time zone |
|
...