CSV Import 255 Summary Limit

Greetings,

I am trying to upload a csv file with 28 columns. On the first row, each column is a category (ID, Milestone, etc.) Once in Map Field, all the column headers are converted in a single field which is then transformed into Summary; none of these columns are over the 255 character limit by themselves, but together they are, thus breaking the character limit for Summary.

I have managed to get the importation to work, but only by removing 18 columns out of the original 28. Is there any way to bypass that 255 character restriction other than cutting each field's real name to a non-descriptive name?

Thank you very much for your time.

1 answer

0 vote

There is no "restriction" on this really.  You're just trying to wedge too much into the wrong field.  The field is limited to 255 characters, deliberately, as it's supposed to be a summary (meaning short description of what it is).

If you want to amass overlong strings into a field, that's fine, but they're not a summary.  Try mapping them into a free-text field.

First, thank you for your answer. However, the mapping options do not offer me another choice that works: all other options lead to the 'next' button greyed out. Summary is the only one working. Is the modification to a free-text field to be done directly in Excel somehow? I am not seeing any options for that in the previous choices of the importer tool.

 

Mapping Selection.PNG

 

Of note is that even with the headers edited to abbreviations (not shown in previous pic), I am still getting the same error, despite the resulting string being less than 255 characters (149 characters according to Word with mapped values and the string in Summary copypasted in Word.)

 

Thank you very much for your time.

You still need to give the system something to put in the summary - it's the only completely mandatory field in the system.

Your data needs to go into a free-text custom field, the description or environment, as they're the only three types of field (without add-ons) that can accommodate your data.

I suspect the reason the shorter version is failing to go into summary is because it contains garbage too - the black diamond question mark characters are not valid.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Hipchat

Moving from Hipchat to Stride? Here’s what you’ll love

Heya, Hipchat friends! We’re so happy you’re checking out   Stride. Whether you know it or not, you have been instrumental in making Stride come to life. Every feature, design, and functionality...

83 views 3 6
Read article

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