AnsweredAssumed Answered

lead import GIGO

Question asked by Francesca Shiekh on Aug 18, 2016

Does Lead Import do any FK constraint checking?
I found records that were imported with a created_by that was the user's full name instead of their ID. Similarly for Campaign, the name went in the database instead of the campaign_id.

 

I had no choice but to make corrections from the back end which I don't like to do.

 

Is there additional data-validation I can put in place to avoid these user errors?

 

Thanks,

FrancescaS

SugarCRM Pro 7.6.2.1

Outcomes