topic Re: Import Data Error; how do you troubleshoot? in DemandTools

Import Data Error; how do you troubleshoot?

MNajmola2 — Tue, 14 Nov 2023 16:42:05 GMT

I am using the Import: Data Mapping and I am importing a file to update fields. I do this all the time with no issues but when I pick update, map the fields needed and pick the Opportunity ID as key; Always update and allow blanks to override.

When I get to the preview screen it shows that there are a bunch of errors but there is no explanation what the errors are. I assumed it was a rule triggering so I took one record and manually updated the fields and the data saved perfectly so I'm so confused. Any suggestions?

I am uploading percents; not sure if that makes a different.

Re: Import Data Error; how do you troubleshoot?

MNajmola2 — Tue, 14 Nov 2023 18:10:03 GMT

I converted the percentages to numbers and the upload worked.

Re: Import Data Error; how do you troubleshoot?

JonG_Validity — Tue, 14 Nov 2023 18:31:26 GMT

@MNajmola2 I am glad you were able to find a solution for this - you were 100% correct in converting those values since Salesforce percentage fields are stored as decimal numbers. If you do have any issues with this moving forward, please feel free to post again or open a support ticket with this form!