Issue import fails - Specify a number for the custom field

Deleted user January 11, 2024

I am trying to import some issues to Jira Product Discovery from another system. I have created the import file, mapped the value types, but getting this error for every issue:

 

Issue can't be created due to the error/s [ Specify a number for the custom field (below 100,000,000,000,000)

 The error does not specify which field is causing it. I suspect it should be related to a number field, but I am not aware importing any number type of data.

 

My field mapping looks like this - no number fields there.

jira_import_mapping.png

 

What is wrong here?

2 answers

1 vote
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 11, 2024

Welcome to the Atlassian Community!

Try creating an issue manually in the project you are trying to import into, leaving all the fields blank other than the summary.  It looks like it has a validator on it that checks a custom field that you are not giving it in your CSV, so the create process would give you the same message.

The screenshot of the error you give us seems to be cut off though, it shows a scroll bar and is missing a closing ] which suggests there is more of the error, and I would expect the bit to the right that has been cropped off to name the custom field.

Andrew
Contributor
April 19, 2024

Running into the same error message here. 

I tried creating a new issue from the create screen and create a new discovery idea with only the summary. 

 

Like Leah Elzinga likes this
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 20, 2024

Is it the same type of issue you are trying to create, in the same project?

Andrew
Contributor
April 22, 2024

Yes, I am trying to create in the same project with just an idea issue type. I have a custom fields that is checkmark field i type in my project that i was trying to add in the bulk-upload, that's the only thing i can think of. 

Wendy McCurdy
Contributor
June 12, 2024

I'm getting the same thing here, actually its listed twice and I've opened a case with Atlassian and am getting no where, came here hoping someone else had solved it.

Like Leah Elzinga likes this
0 votes
Cate Page August 16, 2024

Hi,

I'm getting it too: 

  • 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) . I cannot work out which field it is talking about ...
Wendy McCurdy
Contributor
August 16, 2024

I was able to figure this out. You need to look at each of the fields you have setup in JPD and what type of fields they are: are they a rating, checkbox, etc. As these type of fields require specific types of data. I believe in my case I ended up having a checkbox that required a 0 or 1 and ratings which were 1 to 5 - the (below 100,000,000,000,000) value was a bit of a misnomer. Go back and check your fields against what you are trying to import and I'm sure you will find what is a mismatch.

Like # people like this
Ignacio Bassino
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 18, 2025

Quick note from my experience:
I had two columns generating the "Specify a number for the custom field (below 100,000,000,000,000);" error.
1. I was trying to import a status column to the "Delivery Status" field in JPD and I was getting. The Delivery Status is a system calculated field, so it was throwing the error.
2. I was trying to import a Issue Key to Linked issues. I was supposed to use Issue Id. Super unclear error. 

Dear Atlassian teams, it would be nice if you work on the error messages, it took a good deal of time to find it. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events