I'm using the Import Issues button to test using a CSV file to upload bulk tickets to Jira. I have it working except for when one of the required files includes a special character like an apostrophe.
For example, the field Division is required and is a single-select dropdown menu. If I specify the value Men's Apparel in the CSV I get this error when I validate it:
- The value [ {null=Men's Apparel} ] can't be added to the Custom Field [ Division ]. The value [ {null=Men's Apparel} ] can't be found or is in the incorrect format
I've tried adding this as "Men's Apparel" to force the exact field selection, as suggested in Jira documents, but that still results in the same error. I do not get this error if the value in the field does not contain any special characters, the CSV validates without errors.
Any ideas what I can do to solve this?
