Skip Navigation
Expand
  • Advanced SearchOpens new dialog
    Enter plus (+) or minus (-) signs in search terms to make a word required or excluded
    Search Tips
    Filter by product
    Filter by category
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'.