Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Cannot connect to CSV file when importing to Insight

When we attempt to upload a CSV file into Insight, we are not able to proceed past the Create Import Configuration screen due to an error message that states "Failed to connect to the CSV file specified." 

We can see that the file is present in the "Files" tab for the object schema being used.

Does anyone know of possible causes for this error?DTNS.PNG

4 answers

I'm having the same issue, some of my files just refuse to import, others are successfully imported without any issue.. It would be good to get some information about this from the devs.

I had this problem and it was caused by a blank value in the CSV's header row. eg

title,summary,,description

I changed it to

title,summary,something,description

and I was able to continue. A more descriptive error wouldn't go wrong...

I found out something else in this issue. I was having the same problem and I found out I was saving my csv file as csv delimited with "," but not in UTF-8 format

I just found out that quotes around the headers / values are also a reason for this error to popup... (is valid CSV, but not supported apparently)

I'm having this issue as well. I have saved the file with UTF-8 encoding, and it is delimited with "," but keeps giving the same error.

If i change the delimiter in the import settings to ";" instead, it accepts the configuration, but then it is read incorrectly (all columns in 1 column, not delimited).

Please help!

EDIT:

I found out what the problem was. There was a random zero in the file under an empty unnamed header. So two criteria to take away for csv import to work:

  1. unique column headers (file will not be read if two columns are the same or have the same title)
  2. no empty column headers, and all cells under empty column headers are empty (file will not be read if a column header is empty, but there is 1 or more cells with data in them)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

685 views 7 23
Read article

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