The validation process has found 1 error/s

[Ryan Cannata]

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) ]

[Mirek]

Hi @Ryan Cannata 

Are you seeing any specific characters that might cause it? Would be good to verify which fields are having problem and find a pattern. Seems that 6 fields are incorrectly recognized. Maybe reducing the number of columns and data would give you some clue? 

[Ryan Cannata]

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? 

[Mirek]

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]

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