Working with Date Definitions in the CSV Templates

When preparing the CSV import files there is often a need to specify information pertaining to dates and times.

The Zendesk Migration Utility supports the possibility to capture date and time information in a variety of formats, provided the correct notation has been used in the associated CSV template to specify the format in which this information has been recorded in the corresponding column value.

1. The date format is specified as a suffiz to the heading label using squre brackets "[ ]".
2. The value of the dates in this column must correspond to the specified format if they are to be processed correctly during the import procedure.

• Specifying a suffix of "[EN]" in the heading label to instruct the translator to expect the use of standard english format dates - equivalent to simple date format: dd/MM/yyyy HH:mm.
• Specify a suffix of "[US]" in the heading label for standard United States date formatting - equivalent to simple date format: MM/dd/yyyy HH:mm.

Making use of Simple Date Formats

Alternatively it is possible to make use of any valid simple date formats by specifying the appropriate date pattern within the square brackets, e.g. "[h:mm a]" equates to a date in the format: 12:08 pm.
A full specification and examples of valid date and time patterns can be found at the following address: SimpleDateFormat.

• media_1328792648376.png
• media_1328793985687.png