User creates a new drop down value for an object field. User is able to modify objects and select the new drop down field value. When the object is exported to EXCEL, running a FASTMAP import will throw an error saying that the drop down value does not exist.
Running FastMap Import on an object that was exported will raise an error saying that the drop down field is not valid or does not exist. No edits were performed on the .XLS that was exported.
User had created the drop down value with a trailing space character by accident.
Diagnosing the problem
When the new drop down field label was exported to EXCEL, the trailing space is implicitly removed, so that's why the FASTMAP import was complaining about not finding the value. (FastMap was comparing string with the trailing space vs. string without the trailing space)
Resolving the problem
The following steps resolved the issue:
- Open a supported browser.
- Go to the OpenPages URL.
- Login with an administrator id.
- Using the navigation menubar, go to: Administration -> Object Text.
- Click on the object type that is being used.
- Find the field group and field being used.
- Modify the label by removing the trailing space.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.