Google file Asset Importer for Jira
Google file Asset Importer for Jira can import any csv file stored on Google Drive into Assets in Jira.
100% Running on Atlassians infrastructure called Forge, this means that no data is stored or transfered to Rixter AB. All is kept within your Jira instance and Atlassian agreement,
Â
Installation
Navigate to Find new apps
Search for Asset Importer : Google file importer
Click install
Creating an import
Click Assets menu
Select the Object Schema you want to import data into
Click Schema Configuration button
Click Roles tab
Add Asset Importer: Google file import to the role Object schema managers
Click Import tab
Click Create Import button
Select Google File Importer
Enter any name regarding the file you want to import, example Cities
Click Save.
Configure the Import
Click the three dots on the import you created
Click Configure app
Setup credentials by copy paste the Google Cloud Storage service account json file content in the box in the Credentials tab.
Select the scope of the application
Click Enable Schedule and set the interval you wish it to run
Click Resources and paste the https url to the Google file
Click Load
Select the columns, key and label in the generated table
Click Save
Save will try to create the import mapping and the Object Type specified in the configuration.
Credentials
Setup scheduled trigger
Â
Select file to import
Â
Manual Import
Click Import Data button and the import will start fetching the data
Google Credentials
To authenticate you need to have a Google Cloud storage Service account json file
This can be done in this ways;
Google Service Account
Service account is used to have system to system communication and is recommended for Google services using iHub.
There is two sides of the setup, one in iHub Cloud and one in Google Console
Google Console
Reference create a service account https://cloud.google.com/iam/docs/service-accounts-create
Goto Google Console
Create a project
Goto API & Services
Click Credentials
Click Create Credentials
Create a Service Account
Click on the Service User
Click Keys, create new
Download the Private Key as JSON
Enable the API that you want to access. example Google Sheets
For Google Docs, Sheets, Presentation etc share the resource with the service account to grant access
Credentials storage
The app uses Atlassian forge secret store to store the credentials encrypted.
The current version displays the credentials for the Asset Schema Admin, that has the permission o create imports.