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

Open

AWS Credentials

Open

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.