This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
contact-file-preparation-dates [2019/03/11 14:34] benc [Comma Separated Values (CSV) File] |
contact-file-preparation-dates [2019/03/11 14:47] (current) benc [Microsoft Excel] |
||
---|---|---|---|
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 18: | Line 18: | ||
- | ===== Microsoft Excel ===== | + | ===== Microsoft Excel Spreadsheets ===== |
While your data may //appear// to be in the required **DD/MM/YYYY** format when you open an Excel spreadsheet file, it may not actually be //stored// in the correct way for Sentori to access it. | While your data may //appear// to be in the required **DD/MM/YYYY** format when you open an Excel spreadsheet file, it may not actually be //stored// in the correct way for Sentori to access it. | ||
- | To ensure it is, the simplest option is to use Excel's "Text to Columns" feature. | + | To ensure it is, the simplest option is to use Excel's **Text to Columns** feature. |
Here's how: | Here's how: | ||
Line 42: | Line 42: | ||
Email,DateValue | Email,DateValue | ||
"me@example.com",15/01/2018 | "me@example.com",15/01/2018 | ||
+ | "other@example.com",24/06/2018 | ||
</code> | </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. |