Hello, moving back to Dynamics after 3 years of using ConnectWise. I am trying to import my contact and opportunity data. I am unable to download a template, keeps telling me that a duplicate column heading exists, but I cannot find a duplicate in any field. I also keep getting a “number of fields differs from number of column headings” error which I cannot find. Any help?
It is possible you have a hidden column or it is trying to import an empty one. You might try to delete 10 empty columns to the right of your last column and check for hidden columns
This may be due to currency columns. For example, Balance Due and Balance Due (Base) have the same display name, but Balance Due combines currency conversion.
Thank you, I am going to check both of these ideas.
Hi @Anyse_Spang - did you get this issue sorted? We’ve seen it with standard imports where there are field names (the display names not the schema names) are the same. Let me know if you’re still having an issue, I’d be happy to spend a half hour with you on a call if it would help.
Hi Alex, yes I am definitely still having issues. More “cannot create or update due to a duplicate found” errors. I would love any help. Are you available Tuesday June 10th any time between 10:00 AM and 3:00 PM?
Sorry, didn’t see this reply! Book a teams call with me Book time with Alex Brown: 30 minutes meeting