I need to export tasks from 2005 and 2006. I'm using the field "CreatedDate" but I get an error everytime I run the dataloader.
Here is the information for the correct Date Format for the Dataloader. But if you are trying to insert a value into a System Date field like Created or Last Modified you'll need to contact SFDC Support and allow you to override the System Date. Also, you can only do this for a limited time, it is not open-ended.
Knowledge Article Number: 344999
When admin/user import date or date time field using Data Loader, admin/user always notice the Data uploaded from CSV files doesn't match with what are displaying from Salesforce records when admin/user check those imported records after login to admin/user SF account using web browser.
Knowledge Article Number: 344999
Description
When admin/user import date or date time field using Data Loader, admin/user always notice the Data uploaded from CSV files doesn't match with what are displaying from Salesforce records when admin/user check those imported records after login to admin/user SF account using web browser.
Resolution
To insert record into Date or Date Time field using Data Loader:
1) "Date" type field accept either one of below format:
yyyy-mm-dd
yyyy-mm-dd hh:mm:ss
yyyy-mm-ddThh:mm:ssZ
yyyy-mm-ddThh:mm:ss.sssZ
2) "Date Time" type field accept either one of below format:
yyyy-mm-dd hh:mm:ss
yyyy-mm-ddThh:mm:ssZ
yyyy-mm-ddThh:mm:ss.sssZ
Example given below is based on user/admin set their SF timezone to "China/Taiwan timezone GMT+8" (admin/user set his or her time zone in SF under Setup | Personal Setup | My Personal Information | Personal Information | Timezone Setting )
If your field Data Type is "Date" type and Data Loader Timezone setting: "GMT+0" or "GMT" or blank, your example data in your import spreadsheet can be either one of below:
2011-01-10
2011-01-10 00:00:00
2011-01-10T00:00:00Z
2011-01-10T00:00:00.000Z
If your field Data Type is "Date" type and Data Loader Timezone setting: "GMT+8", your example data in your import spreadsheet must only be either one of below (if you set the hh:mm:ss to 00:00:00, the import date data in SF will display previous day '2011-01-09' instead of '2011-01-10'):
2011-01-10 08:00:00
2011-01-10T08:00:00Z
2011-01-10T08:00:00.000Z
If your field Data Type is "Date Time" type and Data Loader Timezone setting: "GMT+0" or "GMT" or blank, your data display in SF will be 8 hours ahead of your time XX:XX:XX (Basically it messes up all your date time data)
2011-01-10 XX:XX:XX+08:00 (This No Longer supported in Data Loader 20)
2011-01-10TXX:XX:XX+08:00 (This No Longer supported in Data Loader 20) 2011-01-10TXX:XX:XX.XXX+08:00 (This No Longer supported in Data Loader 20)
If your field Data Type is "Date Time" type and Data Loader Timezone setting: "GMT+8", your example data in your import spreadsheet must be either one of below in order to have the Date Time displaying from SF exactly what you imported in spreadsheet:
2011-01-10 XX:XX:XX
2011-01-10TXX:XX:XXZ
2011-01-10TXX:XX:XX.XXXZ
Note:
1) XX:XX:XX or XX:XX:XX.XXX symbol stands for the variable time you key in.
2) Above information is only applicable for SF latest Data Loader (is Data Loader version 20)
1) "Date" type field accept either one of below format:
yyyy-mm-dd
yyyy-mm-dd hh:mm:ss
yyyy-mm-ddThh:mm:ssZ
yyyy-mm-ddThh:mm:ss.sssZ
2) "Date Time" type field accept either one of below format:
yyyy-mm-dd hh:mm:ss
yyyy-mm-ddThh:mm:ssZ
yyyy-mm-ddThh:mm:ss.sssZ
Example given below is based on user/admin set their SF timezone to "China/Taiwan timezone GMT+8" (admin/user set his or her time zone in SF under Setup | Personal Setup | My Personal Information | Personal Information | Timezone Setting )
If your field Data Type is "Date" type and Data Loader Timezone setting: "GMT+0" or "GMT" or blank, your example data in your import spreadsheet can be either one of below:
2011-01-10
2011-01-10 00:00:00
2011-01-10T00:00:00Z
2011-01-10T00:00:00.000Z
If your field Data Type is "Date" type and Data Loader Timezone setting: "GMT+8", your example data in your import spreadsheet must only be either one of below (if you set the hh:mm:ss to 00:00:00, the import date data in SF will display previous day '2011-01-09' instead of '2011-01-10'):
2011-01-10 08:00:00
2011-01-10T08:00:00Z
2011-01-10T08:00:00.000Z
If your field Data Type is "Date Time" type and Data Loader Timezone setting: "GMT+0" or "GMT" or blank, your data display in SF will be 8 hours ahead of your time XX:XX:XX (Basically it messes up all your date time data)
2011-01-10 XX:XX:XX+08:00 (This No Longer supported in Data Loader 20)
2011-01-10TXX:XX:XX+08:00 (This No Longer supported in Data Loader 20) 2011-01-10TXX:XX:XX.XXX+08:00 (This No Longer supported in Data Loader 20)
If your field Data Type is "Date Time" type and Data Loader Timezone setting: "GMT+8", your example data in your import spreadsheet must be either one of below in order to have the Date Time displaying from SF exactly what you imported in spreadsheet:
2011-01-10 XX:XX:XX
2011-01-10TXX:XX:XXZ
2011-01-10TXX:XX:XX.XXXZ
Note:
1) XX:XX:XX or XX:XX:XX.XXX symbol stands for the variable time you key in.
2) Above information is only applicable for SF latest Data Loader (is Data Loader version 20)
No comments:
Post a Comment