+ Start a Discussion
Pritam ShekhawatPritam Shekhawat 

Import Leads through import Wizard

Hello ,
         I am Using import wizard for importing my leads from production to developer account. I export all leads from production, i have total 3500 leads. When i tried to import then its display like this:
Result:
Total records processed: 3,555
Leads created: 1,974
Leads not updated: 1,581
Leads updated: 0
Invalid or no-access lead ids: 0
Deleted lead ids: 0
Locked leads: 0
Converted lead ids: 0
Ignored leads because a converted status was specified: 1,581
Duplicates: 0
Violated uniqueness constraints: 0

How to solveout this issue??
Thanks,

 
Best Answer chosen by Pritam Shekhawat
goabhigogoabhigo
Aahh.. Instead of creating new column, can you check if its already there? Actually you need not specify this column at all. So check the csv file, and if this column is present, remove it!

--
Abhi

If my answer helps to solve the issue/problem/doubt, please mark it as Best Answer; so that people who are stuck in the similar issue get benefitted. 

All Answers

goabhigogoabhigo
Looks like 1581 leads were converted in Production. So ensure while importing, you make "Converted" or "IsConverted" column to 0. 0 means false, so you are importing leads which are not converted.

Does this help? Let me know if you have further queries.

--
Abhi
Pritam ShekhawatPritam Shekhawat
hello goabhigo,
                     according to you am create a new column "Converted" in Excel Sheet and make value false then import again right??
goabhigogoabhigo
Yes. But ensure you have deleted the old ones OR else ensure that there is no duplicate (match it with Name or whatever is unique).
Pritam ShekhawatPritam Shekhawat
ok let me try it if i found issue then i let you about it.
Thanks
 
Pritam ShekhawatPritam Shekhawat
Again same error
Result:
Total records processed: 3,550
Leads created: 1,969

Leads not updated: 1,581
Leads updated: 0
Invalid or no-access lead ids: 0
Deleted lead ids: 0
Locked leads: 0
Converted lead ids: 0
Ignored leads because a converted status was specified: 1,581
Duplicates: 0
Violated uniqueness constraints: 0

am create a new column in Sheet and give value false in all .But Same issue .
goabhigogoabhigo
Aahh.. Instead of creating new column, can you check if its already there? Actually you need not specify this column at all. So check the csv file, and if this column is present, remove it!

--
Abhi

If my answer helps to solve the issue/problem/doubt, please mark it as Best Answer; so that people who are stuck in the similar issue get benefitted. 
This was selected as the best answer
goabhigogoabhigo
Do you need further help on this? Was this solved?

--
Abhi

If my answer helps to solve the issue/problem/doubt, please mark it as Best Answer; so that people who are stuck in the similar issue get benefitted. 
 
Pritam ShekhawatPritam Shekhawat
Thanks abhi i solved out this issue.
goabhigogoabhigo
Glad that you were able to solve :)