Empty records

[Former Member]

Hi SDNers,

I am facing a problem while importing records.I am using MDM 5.5 SP05. While importing records if any record is empty mdm is importing data and each time creating a new record the number of time we send the empty record. We are using only one field while importing the records and also this field is mentioned as required in Console. It should throw exception but it is not throwing any exception.

Any suggestions.

Thanks & Regards

Dilmit Chadha

[Former Member · Accepted solution]

Hi,

If you are setting the Required property of any field still you can save the record without entering any value to that required field. You need to write the Validation with Execution=Automatic and expression as REQUIRED_FIELDS thats it and you need to write this expression manually.

First try this in Data Manager and then check the behavior in Import Manager.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Hi Jitesh,

Thanks for your reply.

I am importing records using MDIS. I have written the validation expression but its not stopping it from importing those record. Is there something that I am missing in this.

Thanks & Regards

Dilmit Chadha

[Former Member · Accepted solution]

Hi Dilmit,

Please try it by changing "Automatic Execution" property of validation to "Error". Please let me know if it is working fine.

Regards,

Dheeraj.

[Former Member · Accepted solution]

Hi Dheeraj,

I have already set that to error but it is still not working. Can you tell me what expression do I have to write for validation expression.

I have used this expression: IS NOT NULL(required_field). This expression is working fine when I am using it manually. It shows the error fields.

Any other suggestions

Thanks & Regards

Dilmit Chadha

[Former Member]

Hi,

Required field in MDM does not make sure that the field is required(Not null).

You need to write the validation expression in data manager to check null values.

Refer below blog:

/people/savitri.sharma/blog/2005/09/22/tips-and-hints-for-new-mdm-users

Thanks

Narendra