Installation

1. Navigate to Find new apps

2. Search for Asset Importer : Google file importer

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: Google file import to the role Object schema managers

6. Click Import tab

7. Click Create Import button

8. Select Google 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. Setup credentials by copy paste the Google Cloud Storage service account json file content in the box in the Credentials tab.

4. Select the scope of the application

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

6. Click Resources and paste the https url to the Google file

7. Click Load

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

9. Click Save

Credentials

Setup scheduled trigger

Select file to import

Manual Import

1. 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

1. Goto Google Console

2. Create a project

3. Goto API & Services

4. Click Credentials

5. Click Create Credentials

6. Create a Service Account

7. Click on the Service User

8. Click Keys, create new

9. Download the Private Key as JSON

   

10. Enable the API that you want to access. example Google Sheets

11. 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.

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.

How to move an Object Type into a parent?

To create a parent-child relationship between Object Types, simply drag and drop one onto another. Note that asset importers always add new types to the root level. However, you can easily reorganize these types by moving them around within the tree.

Can I create the Object Type before the app creates it?

Yes, there is no problem that the Object type exists before the app modifies the type. However it needs to be empty so that the app can create the attributes.

Can the app remove assets that are no longer in the source data?

Yes, the app uses the default settings for Assets when it comes to retaining information. You can modify that by clicking the Edit mapping button and then the three dots and select the Edit object type mapping option.

This will open the standard mapping dialog.

Under Missing Objects select what to do with the object if it is no longer present in the source data. For example Remove and a threshold how many import cycles it needs to be gone before removing the object.

• 1 How to map a attribute to a Object Type in CSV import?
• 2 How to move an Object Type into a parent?
• 3 Can I create the Object Type before the app creates it?
• 4 Can the app remove assets that are no longer in the source data?