Transform Map error when trying to import string to string

[Glenn H]

I created a transform map to create new incidents in our system.  We use data policies to enforce mandatory fields.  One of these mandatory fields is Call Back Number.  Call back number is a string field.  When importing a number into this field, the transform mapping finishes with no errors.  Records are created and filled in properly. 

When importing with text in this field, such as NA, I am receiving this error: Data Policy Exception: The following fields are mandatory: Call back number.  When I disable the data policy, the values do not get imported and instead we are getting a blank field.

This is an excel import to the incident table.  I've tried changing the column types in excel to see if that does anything but it is no help.  I've verified call back number is listed as a string field.

Any thoughts on what I can do to troubleshoot this better?

[Richard P]

Do you have anything set on the dictionary for that field, any attributes?

[Glenn H]

No attributes.  Only one ACL which is set to make sure that you can edit the field when the state is not closed.

[Dhananjay Pawar]

Hi,

Try with another text and check still it is giving same error or not.

Thanks,

Dhananjay.

[Glenn H]

Unfortunately, any text kicks out an error while integers works fine.