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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,734
Community Members
 
Community Events
176
Community Groups

Import Insight Assets from google Spreadsheet

Hey,

is there a way using google spreadsheet as source for directly importing assets in insight ?

I am trying to automate creating insight assests - especially when it comes to bulk imports.


Importing CSV files works

However as we are an international company google spreadsheet is a very helpful "database"

Importing CSVs to Insight requires an existing CSV - which needs manually to be exported from google.
( disadvantage with automatic export scripts:  this needs to be setup for a special account and a server to store it.  What happens if employee is leaving, furthermore Locale storage will be outdated as in the near future everything will be cloud based )

 

Google spreadsheets csv export can easily be used like this:

https://docs.google.com/spreadsheets/d/'+spreadsheetId+'/export?format=xlsx

 

run some tests like CSV imports - but got stock

  1. choosing URL as source
  2. using adapted link like above
  3. import objects

but it fails  / no objects are imported

=> got only 1652 object without labels - even if there are only 2 items within the list

 

hopefully you have ideas what I am doing wrong

2 answers

Hi, 

It is a very good idea to be able to import google docs. As you have found out it is nothing you can do now out of the box. 

The link to export a spreadsheet is actually a "page" that triggers the download of the exported file and not the file itself. That is why the imported data is quite strange compared to what you would expect. 

Since this is nice feature it is a good idea to add it to the feature list https://jira.riada.se. 

Another possibility is to create the import module for the Google Docs integration https://documentation.riada.se/insight/latest/insight-advanced-usage-guide/insight-for-developers/insight-app-development/create-your-own-import-type-module

It is a more advanced option to create that but it is an alternative. In this way you are able to integrate with any kind of data source. 

But again I think it is a good feature to have so please add it as a feature request

 

Cheers

Ola

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events