Asset Importer for Microsoft files and Excel, Sharepoint
Asset Importer: Microsoft file import can import any csv, excel file stored on Microsoft cloud services such as OneDrive or Sharepoint ie. into Assets in Jira.
100% Running on Atlassians infrastructure called Forge, which 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 : Microsoft 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: Microsoft file import to the role Object schema managers
Click Import tab
Click Create Import button
Select Microsoft File Importer
Enter any name regarding the file you want to import, example Cities
Click “Create Import”.
Configure the Import
Click the three dots on the import you created
Click Configure app
Set up authentication for Microsoft.
Microsoft uses OAuth2 as the authentication method. To set this up, you need to create a Microsoft OAuth2 application. Note down the “Redirect URL” on the “Authentication” tab. This is your Microsoft app callback URI for this specific importer.
Read more on how to set up the OAuth2 app here: Asset Importer for Microsoft files and Excel, Sharepoint | Microsoft Credentials
Set up credentials by entering the Microsoft App Client ID and the Microsoft App Client Secret into the respective textboxes.
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 Microsoft 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.
Enter Client Id + Client Secret and click Authorize
Click continue and login with your Microsoft credentials.
Click “Refresh status” on the “Authentication” tab to reaload authentication status.
Setup scheduled trigger
Select file to import
Manual Import
Click Import Data button and the import will start fetching the data
Microsoft Credentials
To authenticate you need to create a Microsoft App
This can be done in this ways;
Create and setup your Microsoft app
Log into your company’s (or school) Azure portal https://portal.azure.com/#home
Click “App registration”
Select your account type (option 1 or 2) (note, personal accounts does not support the redirect url provided by the importer app. Hence; personal accounts are not supported)
This is your App client Id
Now click “Manage” and “API permissions”
Add Files.Read (or) Files.Read.All + offline_access to allow offline access (refresh tokens)
Now click “Certificates & Secrets” to generate a secret for this app.
Copy your secret value. This is your client secret.
Now click “Authentication” and select edit platform configuration. Select “Web”
Enter the “Redirect url” from the Jira Asset Importer Authentication tab. Paste this into the redirect uri configuration of this app.
Now you're set!
Head over to the Asset Importer app in Jira to complete the login process.
The Asset Importer will now have access to the files that the logged-in user has permission to view.
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.
Troubleshooting
I receive errors when Authorizing my app
Missing parameter “code”
This indicates that there is something wrong on your setup on Microsoft side. Check app settings, if possible select account type bullet #2 Accounts in any organizational directory as in the guide above.
FAQ
Excel
To import an Excel file sheet → Choose type CSV in the Resources settings page.
Known limitations: Only the first sheet is imported