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
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:
run some tests like CSV imports - but got stock
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
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+'
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