You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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+'