The validation process has found 1 error/s

Question

I am getting the following error when trying to import date via CSV file into a Jira  project. Any help is greatly appreciated.  I have roughly 16 columns in the CSV file and some data goes to custom fields and some data goes to out of the box Jira fields.

2024-07-31 21:19:59,907 ERROR - Issue can't be created due to the error/s [ Specify a number for the custom field (below 100,000,000,000,000); Specify a number for the custom field (below 100,000,000,000,000); Specify a number for the custom field (below 100,000,000,000,000); Specify a number for the custom field (below 100,000,000,000,000); Specify a number for the custom field (below 100,000,000,000,000); Specify a number for the custom field (below 100,000,000,000,000) ]

Ryan Cannata · Answer

I can also change it to a number field in the source file. Thank you for you assistance.

Mirek · Answer

If you put this value into a "text" field it might be ok, but if you choose a number field then $ is not something that should be there. Anyway if you are able to try (as a test first somewhere) without any special characters then we would know if this is it.

Ryan Cannata · Answer

Hi Mirek, 
The only thing I can think of is that my file is showing the $ sign before an amount. For example, I have a column that shows $2,961 in a cell. Do you think this is the issue. If it is, any recommendations? Maybe switching the field to a short text vs number?