We were trying to upload to an object.Most of the dates uploaded exactly as defined in the CSV file, however others were one day out e.g 2-Jul uploaded as 1-Jul.
While using DataLoader it turns out that the Time Zone setting within data loader has a big impact.
Solution #1:
we changed it to "GMT" all the dates loaded without issue.
We also check the "Use European date format (dd/mm/yyyy)" within Data Loader.
Another option we worked out is specifying these setting in process-conf.xml file.
Solution #2 (for Automating Data Loader)
process-conf.xml
....
....
specified the dates in CSV file as dd/mm/yyyy
Hope it Helps
No comments:
Post a Comment