S3 Asset Importer for Jira

S3 Asset Importer for Jira can import any csv file stored on Amazone S3 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

  1. Navigate to Find new apps

  2. Search for S3 Asset Importer for Jira

  3. Click install

Creating an import

  1. Click Assets menu

  2. Select the Object Schema you want to import data into

  3. Click Schema Configuration button

  4. Click Roles tab

  5. Add Asset Importer: Amazon S3 file import to the role Object schema managers

  6. Click Import tab

  7. Click Create Import button

  8. Select AWS S3 File Importer

  9. Enter any name regarding the file you want to import, example Cities

  10. Click Save.

Configure the Import

  1. Click the three dots on the import you created

  2. Click Configure app

  3. Enter the S3 Access key and Secret Access key

  4. Click Enable Schedule and set the interval you wish it to run

  5. Click Resources and paste the https url to the S3 file

  6. Click Load

  7. Select the columns, key and label in the generated table

  8. Click Save

Save will try to create the import mapping and the Object Type specified in the configuration.

Screenshot 2024-05-23 at 16.32.00.png
AWS Credentials
Screenshot 2024-05-23 at 16.28.07.png
Enter file, select columns to import

Manual Import

  1. Click Import Data button and the import will start fetching the data

S3 Credentials

To authenticate you need to have S3 Access key and Secret Access key

Make sure the user has a AmazonS3ReadOnlyAccess policy or role.

Two ways of creating access keys are;

From IAM Console

  1. Open the IAM console.

  2. From the navigation menu, click Users.

  3. Select your IAM user name.

  4. Click User Actions, and then click Manage Access Keys.

  5. Click Create Access Key.

  6. Your keys will look something like this:

    • Access key ID example: AKIAIOSFODNN7EXAMPLE

    • Secret access key example: wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY

  7. Click Download Credentials, and store the keys in a secure location.

From the logged in user

  1. Login to the AWS account that has access to S3 bucket

  2. Click on you account in the right corner

  3. Click Security credentials

  4. Click create access keys

 

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.

How to import files using dates in URLs that change each day?

Asset imports can utilize dynamic date placeholders like {{jiraDate}} to automatically insert the current date into the import URL. This allows the import process to dynamically access files that are regularly updated with date-based filenames, ensuring that the most recent data is always imported. For example, using {{jiraDate}} will insert the date in a format like "2024-08-13", making it easier to target files with date-specific naming conventions. This feature enhances flexibility and automation in managing and importing date-sensitive assets.

Format

Thursday, November 1, 1979 6:23:12 AM UTC

Format

Thursday, November 1, 1979 6:23:12 AM UTC

Default (none specified)

1979-11-01T11:23:12.0+0000

jiraDate

1979-11-01

jiraDateTime

1979-11-01T06:23:12.0-0500

jqlDate

1979-11-01

jqlDateTime

1979-11-01 06:23

shortDate

11/1/79

shortTime

6:23 AM

shortDateTime

11/1/79 6:23 AM

mediumDate

Nov 1, 1979

mediumTime

6:23:12 AM

mediumDateTime

Nov 1, 1979 6:23:12 AM

longDate

November 1, 1979

longTime

6:23:12 AM EST

longDateTime

November 1, 1979, 6:23:12 AM UTC

fullDate

Thursday, November 1, 1979

fullTime

6:23:12 AM EST

fullDateTime

Thursday, November 1, 1979, 6:23:12 AM Coordinated Universal Time