Hi, I am trying to import a file with deals to import from one HubSpot account to another. I created a new pipeline, stages and properties to the new account so the imported deals have a place.
But whenever I try to import, about half of the deals (from specific stages) get imported correctly, but the other half don’t and I get the “Validation failed” error.
When I look at the knowledge base article about it, it tells me to check stage, status, and pipeline name. I did (and carefully checked spelling mistake or typos) but I keep getting the error message.
Does anyone have experience with this and have any solutions or tips?
Hi @OVeenstra,
Could you please share a screenshot of the exact, full error message?
During the mapping step, HubSpot should already flag these values that can’t be mapped. Have you checked during the mapping steps if some mappings have a yellow exclamation mark on them?
Best regards
Hi, thanks for the quick reply!
Yes, I checked for the yellow marks. I remapped to the correct place whenever there was one.
Here is a screenshot of the error message when I tried to import all the remaining deals that were not imported in the first try.
@OVeenstra have you reviewed “View rows with errors”? Which details do you see here?
@OVeenstra I only see an unmapped record ID column and empty columns - is this intentional? Is there more information to the right about the error?
Not all properties are filled in for every deal, that is intentional. There are a lot more columns to the right that are filled in.
When I hover over the “i” sign. I get this message but I don’t know which property they are reffering to.
@OVeenstra can you share which fields you’re mapping in the mapping step? Is there any column that contains a 2?
It doesn’t seem like there is a 2. There is 0.2 but that is between 0 and 1 so that shoudln’t be an issue.
@OVeenstra well, the deal probability field definitely causes the issue. Can you confirm that the original file does not contain any "2"s?
Alternatively, deal pipeline stages have an assigned probability in the deal stage settings anyway. If you can omit the column, it’ll likely save you the troubleshooting overall.
Omitting the column worked, thanks.
Still don’t understand since there were definitely no "2"s but maybe I don’t have to 
Thank you very much!
