Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
contact-file-preparation-dates [2019/03/11 13:40]
benc
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 13: Line 13:
 Some examples of this: Some examples of this:
  
-|**Value**|**Date it Represents**|+^Value^Represented ​Date^
 |25/​12/​2010|25th December 2010| |25/​12/​2010|25th December 2010|
 |01/​03/​1980|1st March 1980| |01/​03/​1980|1st March 1980|
  
  
-===== 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.
  
-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 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.