Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 18 replies
  • Subscribers 305 subscribers
  • Views 4091 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
  • 0

    Hi,

    I am facing some type of similar issue. I have already tried to clean the data (we work with google spreadsheets). So I wanted to make sure that there are no strange comma's or other punctuation marks in the sheet. 

    However the first 20 records are uploaded without any problems, but the next 21 to 50 records give this exact same error as the example above. The data comes from the exact same excel sheet, so I just thought it is a bit odd. I already checked our date and time format In Sugar. This is the exact same format as in our Sugar environment. We don't work with AM or PM in our Sugar, but I do get this same error message. 

    We are migrating data from one Sugar environment to another. But to be sure, we are first migrating the data to a Sugar sandbox. Below I shared a screenshot of the matter. 

    Thank you in advance for your answer.

    Best regards,

    Maike 

Reply
  • 0

    Hi,

    I am facing some type of similar issue. I have already tried to clean the data (we work with google spreadsheets). So I wanted to make sure that there are no strange comma's or other punctuation marks in the sheet. 

    However the first 20 records are uploaded without any problems, but the next 21 to 50 records give this exact same error as the example above. The data comes from the exact same excel sheet, so I just thought it is a bit odd. I already checked our date and time format In Sugar. This is the exact same format as in our Sugar environment. We don't work with AM or PM in our Sugar, but I do get this same error message. 

    We are migrating data from one Sugar environment to another. But to be sure, we are first migrating the data to a Sugar sandbox. Below I shared a screenshot of the matter. 

    Thank you in advance for your answer.

    Best regards,

    Maike 

Children