Skip to Content
avatar image
Former Member

Empty records

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 30, 2008 at 06:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Jun 30, 2008 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded