How does Sugar Import recognise is a date is dd/mm/yyyy or mm/dd/yyyy ?

While starting to use the Contracts module , I've uploaded the about 3300 contracts which were managed so far via Excel.

After the upload , I saw that Sugar Import interpreted my dates as MM/DD/YYYY instaed of DD/MM/YYYY. 

The csv file was created out of an Excel using the semicolon as field separator and the coma as item separator (used within the Teams field).

When investigating this further (I discovered the import file properties section only a couple of days later :-) ) together with our IT department, they were able to create csv files that were imported correctly whatever the format (MM/DD/YYYY or DD/MM/YYYY) they used.

Only difference was , they used the comma as field separator and had only 1 team in the Teams field (so no item separator used).

I know I can solve my issue by manually setting the date format correctly in the Import Files Properties section. 

But I still like to understand what made the IT support file dates work fine while mine were interpreted incorrectly ?
Somehow , somewhere the Sugar Import tries to determine what my date format is...

Bye now

Hugo

Parents Reply Children
No Data