This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
contact-file-preparation-dates [2019/03/11 13:36] benc created |
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. | ||
- | Dates being imported must be in the format DD/MM/YYYY. | + | **Dates being imported must be in the format DD/MM/YYYY** |
Some examples of this: | Some examples of this: | ||
- | 25/12/2010 for 25th December 2010 | + | ^Value^Represented Date^ |
- | 01/03/1980 for 1st March 1980. | + | |25/12/2010|25th December 2010| |
+ | |01/03/1980|1st March 1980| | ||
- | Microsoft Excel | + | ===== Microsoft Excel ===== |
- | 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. | ||
- | To do this, open your spreadsheet and select the column that contains your date values then go to the "Data" tab on the Excel "ribbon" and click Text to Columns. A popup window will open for the Convert Text to Columns Wizard. | + | Here's how: |
+ | * open your spreadsheet in Excel | ||
+ | * select the whole column that contains your date values | ||
+ | * go to the **Data** tab on the Excel "ribbon" and click **Text to Columns** | ||
+ | * a popup window will open for the **Convert Text to Columns Wizard** | ||
+ | * Use these options: | ||
+ | * **Step 1 of 3** \\ Choose "Delimited". \\ Click Next. \\ | ||
+ | * **Step 2 of 3** \\ Leave all the default settings. \\ Click Next. \\ | ||
+ | * **Step 3 of 3** \\ Select "Date" and "DMY". \\ Click Finish. \\ | ||
- | Use these options: | ||
- | Step 1 of 3 | ||
- | Choose "Delimited". | ||
- | Click Next. | ||
- | Step 2 of 3 | + | ===== Comma Separated Values (CSV) File ===== |
- | Leave all the default settings. | + | |
- | Click Next. | + | |
- | Step 3 of 3 | + | 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: |
- | Select "Date" and "DMY". | + | |
- | Click Finish. | + | <code> |
+ | Email,DateValue | ||
+ | "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. |