Hi. I'm trying to import a CSV file into Insight. Some of the records import correctly, but a good number (more than half) fail.
I tried to
Here's a link to the import file: https://drive.google.com/open?id=0BxSjaSuq_9wgRy1ZTVNkYnRKWTg
With this file, values in the first column (which is not the label field) of 1, 2, 3, 4, 5, 6, 7, 8, 9 and 1160 were imported, but the rest of the records were not.
Using version 5.0.6 I managed to set it up without any problem. I've attached a screenshot of my settings for the import. I simply downloaded the file you provided and uploaded it as a file for the import. I got 19 Imported objects without any errors.
did you run the import directly from google spreadsheet ? So when it becomes to import choosing URL and your spreadsheet-link or could you only manage it via export as CSV and then import it ?
really looking in a way using direct google spreadsheet import to jira (in order to avoid former export from google) like:
For a recurring import where the sheet is continually updated, try using this format for the URL: https://docs.google.com/spreadsheets/d/'+spreadsheetID+'/gviz/tq?tqx=out:csv&sheet='+sheetID+'
Since our last roundup in April, Atlassian's Marketplace Partners have added over 100 new cloud apps to the Atlassian Marketplace to help your teams work more efficiently. Let’s take a quick look a...
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