Question Status

Suggested Answer
Pallavi Manocha asked a question on 17 Mar 2015 1:57 AM

Hi,

If anyone can help me know How much bad data can a crm system tolerate and what are the insutry standards on the same issue?

Any kind of input i appreciated :)

Thanks,

Pallavi

Reply
Mithilesh Kumar responded on 17 Mar 2015 2:25 AM

Hi Pallavi,

Can you please elaborate on what you mean by Bad Data.

Thanks

Reply
Pallavi Manocha responded on 17 Mar 2015 2:39 AM

Hi Mithilesh,

Thankyou for your response

Wrong data the users may enter in the system.

May be spell errors,invalid data

eg: in gender type Valid options male anfd female

Wrong data may be Femail

Thanks

Pallavi

Reply
Suggested Answer
Mithilesh Kumar responded on 17 Mar 2015 3:21 AM

Hi Pallavi,

You need to design your solution keeping all these thing in mind.

Dynamics CRM have fields which are of specific data types, any value which do not fall into the data type, CRM will throw an error and won't be saved.

For example, for gender field you should create an Option Set having values and Male and Female, this way there won't be any error.

Having said that, the issue is always with Text Field, where the user is free to enter anything under this sky. You cannot always check that, however, you can write certain Business Rules / JScript / Workflow to validate them. Which again cannot be a full proof solution.

Hope that make sense

Thanks

Reply
Suggested Answer
Mithilesh Kumar responded on 17 Mar 2015 3:21 AM

Hi Pallavi,

You need to design your solution keeping all these thing in mind.

Dynamics CRM have fields which are of specific data types, any value which do not fall into the data type, CRM will throw an error and won't be saved.

For example, for gender field you should create an Option Set having values and Male and Female, this way there won't be any error.

Having said that, the issue is always with Text Field, where the user is free to enter anything under this sky. You cannot always check that, however, you can write certain Business Rules / JScript / Workflow to validate them. Which again cannot be a full proof solution.

Hope that make sense

Thanks

Reply