Skip Navigation
Expand
Masking error displayed within Data Import Wizard
Answer ID 12241   |   Last Review Date 05/18/2022

Why does the Data Import Wizard display an error stating a field value "does not conform to the mask for the field"?

Environment:

Data Import Wizard, Custom Input Masking
Oracle B2C Service, All versions

Issue:

I am completing a data import and one of the columns in my CSV file is a field which has an input mask defined.  Even though the data in the CSV matches the mask, the import states the data does not conform to the mask.   

Resolution:

If the input mask for the field contains Fixed, formatted characters the CSV data should not include those characters.  

For example, if the mask for a custom field is defined as F$M#M#F.M#M# in order to store dollar amounts in the format of $12.34, this error will occur if the CSV contains the data '$12.34'.  The error can be avoided by editing the CSV data to contain the value '1234'.