Dynamics Community Forum Thread Details

null value in combobox for data import

I am trying to import data (transaction import) from a csv file into the Vendor Maintenance screen. We added a user defined combobox and created our values list. I then created a new control macro for the import and made sure that the CSV file matches the macro. Some of the records in the data file will have a null value for this combobox field and some won't. How do I configure the values list in the ComboBox propertis so that the import will not fail? The error from the import log file is below, the record that this failed on has a null (a blank value really) value for this field.

'System Message 8020: Invalid possible value for a ComboBox. Control: xuser1 Value:

'System Message 8016: Possible values for the control xuser1 are ;,LGBUS;Large Business,SMBUS;Small Business,SD_BA;SDB - Black
'                    American,SD_HA;SDB - Hispanic American,SD_AP;SDB - Asian Pacific American,SD_FA;SDB - Filipino
'                    American,SD_NA;SDB - Native American,SD_AI;SDB - Asian Indian American,SD_PA;SDB - Polynesian
'                    American,SD_ME;SDB - Multi-Ethnic,WOBUS;Women's Business Enterprise,DVBUS;Disabled Veteran Owned Business
'                    Enterprise

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)