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

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 map a attribute to a Object Type in CSV import?

• Enter the URL of the resource and click "Load." This will display the attributes and their corresponding types.

• To map an attribute to an Object Type, select "Type" as "Reference Object" and fill in the two additional fields:

  • Ref. Obj. Type: Enter the name of the object type you want to reference. Ensure it is spelled correctly.

  • AQL Field: Provide the query for mapping the data. Use the format "Attribute Name" = ${Number} "Name" = ${6}, where "Name" is the attribute in the referenced type, and ${6} is the corresponding value. You can use more advanced queries as well if needed.

• 1 How to map a attribute to a Object Type in CSV import?