About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
Common Errors and Resolutions when importing Candidate Form Field Options via Workbench.
Answer
|
ERROR | CAUSE/RESOLUTION |
| 'Properties$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. | CAUSE: The Properties tab is missing. RESOLUTION: Add the Properties tab to the spreadsheet. Properties tab formatting can be viewed in the Preparing the Spreadsheet section. |
| 'Options$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. | CAUSE: The Options tab is missing. RESOLUTION: Add the Options tab to the spreadsheet. Options tab formatting can be viewed in the Preparing the Spreadsheet section. |
| Value for property 'client' must be provided on 'Properties' tab | CAUSE: The spreadsheet does not have a “Client” name defined on the Properties tab. RESOLUTION: Add your Client name to the Properties tab. |
| Value for property 'form' must be provided on 'Properties' tab | CAUSE: The spreadsheet does not have a “Form” name defined on the Properties tab. RESOLUTION: Add the name of the Form that you would like to import the option list for to the Properties tab. |
| Value for property 'field' must be provided on 'Properties' tab | CAUSE: The spreadsheet does not have a “Field” name defined on the Properties tab. RESOLUTION: Add the database name of the Field that you would like to import the option list for to the Properties tab. |
| Sort Order is a required field. This error may cause additional error messages. | CAUSE: The option’s row is missing a ‘Sort Order’. RESOLUTION: Ensure that the spreadsheet has a Sort Order column along with the numeric value. If the field option list is marked as “Designated Order” the sort order entered DOES matter and options will show in the order entered. If the field option list is marked as “Alphabetical” the sort order entered DOES NOT matter and options will show in an alphabetical order. |
| Sort Order cannot be more than 5 characters long. Sort Order must be a positive whole number. | CAUSE: The Sort Order row does not have a valid Sort Order. RESOLUTION: Update the Sort Order row to include positive whole numbers. |
| Invalid value for Code ( ; " * ! ` ~ @ # = + ? \ , > < ' ' % | [ { } ] are not allowed). | CAUSE: The option’s code has an invalid character. RESOLUTION: Update the option’s code by removing the invalid special character ( ; " * ! ` ~ @ # = + ? \ , > < ' ' % | [ { } ] |
| Status is a required field. This error may cause additional error messages. | CAUSE: The option’s row is missing a ‘Status’ RESOLUTION: Ensure that the spreadsheet has a Status column along with the value of ‘Active’ or ‘Inactive’ depending on if you want the option to selectable (active) or not selectable (inactive) to the end user. |
| Description (English (US)) cannot be more than 255 characters long. | CAUSE: The option’s Description is greater than 255 characters. RESOLUTION: Update the option’s Description so it is less than 255 characters. |
| Valid values for Status are 'Active' or 'Inactive'. | CAUSE: The option’s Status is something other than Active or Inactive. RESOLUTION: Update the Status to be Active (selectable to the end user) or Inactive (not selectable to the end user). |
| Code cannot be more than 255 characters long. | CAUSE: The option’s Code is greater than 255 characters. RESOLUTION: Update the option’s Code so it is less than 255 characters. |
| Object reference not set to an instance of an object. | CAUSE: Typically, this error results from system issues, not related to your import/export. RESOLUTION: We recommend waiting 5-15 minutes and trying the import/export again. |
Jump to:
| TOPIC | LINK |
| Table of Contents | Click Here |
| Preparing the Candidate Form Field Option List Spreadsheet for Import into Workbench | Click Here |
| Performing the Candidate Form Field Option List Import (Power User Access) | Click Here |
| Performing the Candidate Form Field Option List Import (Tier 5 User Access) | Click Here |
| Reading the Candidate Form Field Option List Results File | Click Here |
[{"Product":{"code":"SSEUFV","label":"IBM Kenexa BrassRing on Cloud"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB27","label":"Talent Management Solutions"}}]
Was this topic helpful?
Document Information
More support for:
IBM Kenexa BrassRing on Cloud
Software version:
Version Independent
Document number:
551043
Modified date:
17 June 2018
UID
swg21989969
Manage My Notification Subscriptions
