Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

CSV Import Character Limit of 255 Error

Brad Rutledge
Contributor
July 14, 2023

I am trying to import Issues from another source via the CSV import functionality (project version not Administrator version). I am getting errors as some of the text cells have > 255 characters. Is there any way around this without manually moving the text to the Issue after the import. Thanks

1 answer

1 vote
Bill Sheboy
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.
July 14, 2023

Hi @Brad Rutledge -- Welcome to the Atlassian Community!

I suspect that if you review the error message, you will find it is for the Summary field, which does have a character limit.  My understanding is there is no work-around for that field.

The Summary is intended to be a summary name/title of an issue.  For more details the Description and other fields are used.  One work-around for your scenario would be to split your source information at the 255 limit so only that goes into Summary and add the full value into another field.

Kind regards,
Bill

Brad Rutledge
Contributor
July 17, 2023

Thanks for the response. I went back and looked at the source data for the summary field and did a count using the LEN function which showed that none of these exceeded the 255 characters (largest was 158). When I encountered this problem I identified all of the fields that were being imported and edited those that had greater than 255 characters and reduced these so they were all less than 255. The fields in my source that exceeded the limit when I received the errors. These were being mapped to the Description field which based on your response should not of generated this error but they did. Not sure why this is happening. Any thoughts?

Bill Sheboy
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.
July 17, 2023

Nope, as I have imported more than 255 for the description before.  I even did a test after your question.

Perhaps work with your site admin to contact the Atlassian Support team and see what they say: https://support.atlassian.com/contact/#/  Once you hear back from them, please post what you learn to benefit the community.

Brad Rutledge
Contributor
July 18, 2023

Thanks for your help. I have since did a single issue import test with more than 255 characters and it worked. I am still working with our admin around some fields I want to import but cannot do with my CSV import permissions. This is in relation to the Created date and the Status.

Suggest an answer

Log in or Sign up to answer