Is there a row limit for CSV import?

I'm getting a specific error when trying to load a csv file that has thousands of records which include issue id and parent id.  The same format is working fine for smaller files.   The error I'm getting is:

"You have selected too many fields for manual mapping! Please uncheck fields which have more than few thousand unique values."

I have not been able to find any information on what the size limit / row limit for importable CSVs are.  Can someone let me know so that I can tailor the file accordingly?

Much thanks,
Geoff

3 answers

There are no strict limits to the size of CSV file itself, we allow user to upload as big file as attachment settings allow it to be. If you have enough memory assigned to your JIRA, importer should be able to import even 1GB files.

Your error message is connected to "Map field value" checkbox.

 Zaznaczenie_091.png

When you are mapping CSV field to JIRA field, you do not need to check "Map field value" checkbox. You need to check it only if you'd like to manually map values from your CSV file to JIRA values. This is really useful for fields such as Issue Types, Resolutions, Priorities etc, it doesn't make much sense for non-unique fields.

JIRA won't allow you to go to the next step, if you have selected fields that have more than few thousand unique values, because it would result that next page would contain a table with few thousand textboxes.

 

Thank you. This was completely user error. While embarrassed, I am happy to report all imports have worked successfully since then.

Thanks for letting us know, that import worked correctly. If you have any more questions feel free to create a new Atlassian Answers question.

Yes, as of Feb 11 2016, there is a 250 row limit to importing issues via CSV

 

major frowny face

re-reading your comment i see you're probably asking about a column limit.

@Aaron Bauman: 

The limit should not apply when using  External System Import CSV (from System > External System Import).

For details see:

0 vote

The limit should not apply when using  External System Import CSV (from System > External System Import).

For details see:

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

13,571 views 16 15
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you