It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Errors in CSV import

Miranda pasam Dec 06, 2011

I'm trying to import Projects using CSV import, The process fails giving the following error

The first header row of the CSV import file contains following errors for the field name 'PK!q9+p��[Content_Types].xml ��(�̔MN�0��H�!�%n��j�?K��ؓƪc[���g��' on position 1: 'brackets mismatch', 'plus sign'

I've removed all the content in the file and tried uploading a basic csv with simple test data

<colgroup><col style="width: 49pt;" span="2" width="65"/> </colgroup>
Summary
test

Not sure what the reason is. Any help is really appreciated.

thank you

Miranda

2 answers

1 accepted

2 votes
Answer accepted
Nic Brough [Adaptavist] Community Leader Dec 06, 2011

I really don't think your file is CSV, there's a lot of control characters there.

Try opening it in a plain text editor (vi, gedit, nano, emacs, etc, or notepad if you're stuck with a Windows operating system) and checking what they show the first line as. Even Excel gets "save as .csv" right most of the time, but I do know of people trying to save as csv and not quite getting it right because all they change is the filename, and not the actual format.

Wojciech Seliga Dec 06, 2011

Indeed, it looks like a zipped spreadsheet XML. Only plain CSV files are supported by JIRA Importers Plugin.

Miranda pasam Dec 06, 2011

Thank you for the responses. It worked fine after the saved the file as a CSV.

AKASH BHARDWAJ Sep 02, 2015

@Nic Brough [Adaptavist] : Nic, you are just great!! I ran into this issue and found your post. In a minute i am On track now. Thanks, Akash

0 votes

Configuration format has changed in version 2.6.0. If you're using an older format you need to restart the wizard from scratch. I get this error while doing csv import. Please help

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Off-topic

Disney Live Action Reboots: Are you for or against?

Happy Friday Everyone! Today marks the international release of Disney's live action version of the animated classic Aladdin. I know that this movie was met with some controversy of over cast...

204 views 22 10
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you