Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 18 replies
  • Subscribers 313 subscribers
  • Views 4515 views
  • Users 0 members are here
Related content from around SugarClub

Importing Tasks errors with time values in Description field

Lyle Hookom

I am migrating Salesforce data into Sugar for one our company divisions located in Germany.

Sugar is at version 8.0.2

When importing Tasks I will get errors.

Troubleshooting has shown me that if the first record has a Description field value such as "This is a description at 9:57 AM today", I will get an invalid datetime field error and no records import successfully.  If I remove the "AM" from the description I can then successfully import 100's of records successfully . The other records can all contain similar time values with AM or PM within the Description. In fact since this data comes from emails and tasks entered there may be 10 or more AM or PM in a single Description value.

At some point the problem starts over again, for example at record 710 I had  to remove the "AM" and "PM" values from the description and then I could import a 1000 records.

I do not know why the Wizard is messing up on the 1st and 710 records and probably others. I am trying to import 16000 or more records.

Thanks

Lyle

_TaskFailureRecord_AM.txt.zip

Parents Reply Children
  • 0 in reply to Patrick McQueen

    I have attached two files to my original request. One is a screenshot of the Invalid Date error and the other is the actual import file for one record that caused the error. As I note in the screenshot, if 10:30 AM is in the description field of the first record it will fail, however if I make this record the 2nd or later record in the file it will load fine, as long as the first record does not contain the 10:30 AM or PM value.

    Lyle