This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
contact-file-preparation-dates [2019/03/11 14:32] benc [Importing Dates into Sentori] |
contact-file-preparation-dates [2019/03/11 14:44] benc [Importing Dates into Sentori] |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| Examples of this might be: | Examples of this might be: | ||
| - | - Sentori preventing you from mapping the column by displaying an error when you try. | + | * Sentori preventing you from mapping the column by displaying an error when you try. |
| - | - day and month parts of your values are swapped, giving you either a different date date or an invalid one, e.g. if your data was intended to represent 1st February 2000 it might be incorrectly interpreted as 2nd January 2000. | + | * day and month parts of your values are swapped, giving you either a different date date or an invalid one, e.g. if your data was intended to represent 1st February 2000 it might be incorrectly interpreted as 2nd January 2000. |
| This article describes how to ensure your date values are correctly imported into Sentori. | This article describes how to ensure your date values are correctly imported into Sentori. | ||
| Line 39: | Line 39: | ||
| Different applications create CSV files in different ways, but the key result is for the date values to appear as follows when the CSV file is opened in a simple text editor: | Different applications create CSV files in different ways, but the key result is for the date values to appear as follows when the CSV file is opened in a simple text editor: | ||
| - | Email,DateValue\\ | + | <code> |
| + | Email,DateValue | ||
| "me@example.com",15/01/2018 | "me@example.com",15/01/2018 | ||
| + | "other@example.com",24/06/2018 | ||
| + | </code> | ||
| If it's surrounded by any type of quotes, then Sentori probably won't be able to read it as a date. | If it's surrounded by any type of quotes, then Sentori probably won't be able to read it as a date. | ||