Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
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'.