It's normal account data plus a custom date field (a membership joining date). All other details are imported with no problem.
I tried several formats in excell before exporting to CSV:
YYY/MM/DD
*DD/MM/YYYY
and a custom format of YYYY/DD/MMThh:mm:ss.000Z (one recommended by someone for the data loader)
The dates are valid and show in my CSV file in exactly the format as I would expect. I then convert to UTF-8 (we have non Latin cahracters in some TEXT fields) and run the import wizard.
I even tried this using only the account name and this date field to eliminate the possablity that another field is causing a problem but every time salesforce imports nothing (or tells me when I try to make an update of existing records tha the data has already beein imported).
And before you ask, I am 100% certain I'm choosing the right fields in the wizzard :-)
In the account view the field is always empty (I can manually enter the date, but I have 2000 records so thats not really an option...)
HELP!
6 respuestas
GENIUS Steve, so simple! Yes it was the date fromat for the locale that was the problem. Thankyou so much!
It seems SF is very sensitive to the locale setting when importing this typeof data. I just had my first entirely sucessful import.
Many thanks, head ache number one down!
Next to fix those pesky contracts...
Matt
