How its works Threshold Number in Assets Jira Cloud?

[Emiliano Nicolas Romero]

Hello Community!

I have a very large file and I want to partition it into 3 smaller files so I can import them into assets. These small files can be modified (add or remove information) and I need assets to be updated only by deleting those records that no longer exist in any file. 

The problem is the following, when I import the first file, assets eliminates the records that it does not identify belonging to the other 2 files that remain to be uploaded. How could I use the "Treeshold Number" option so that assets only delete the information belonging to the file I am currently uploading and ignore the other remaining files?

Thanks

[Hakan Bahadir {Pio} · Accepted solution]

Hello,

If you have 3 files, then you can set the threshold to 3 or more. Let's assume that:

- You have 100 records in each file.

- You imported them already and have 300 objects as of now.

- You change the threshold to 3

- Then deleted the first 5 records from the first file.

In theory import works as follows:

Import 1: First file import with 95 records

Assets finds that 205 records are missing for the first time. Status:

1-5 objects -> missing first time

6-100 objects -> found

101-200 objects -> missing first time

201-300 objects -> missing first time

Import 2: Second file import with 100 records

Assets finds that 200 records are missing. Status:

1-5 objects -> missing second time

6-100 objects -> first time

101-200 objects -> found

201-300 objects -> missing second time

Import 3: Third file import with 100 records

Assets finds that 200 records are missing. Status:

1-5 objects -> missing third time

6-100 objects -> missing second time

101-200 objects -> missing first time

201-300 objects -> found

Import 4: First file import with 95 records

Assets finds that 205 records are missing. Status:

1-5 objects -> deleted

6-100 objects -> found

101-200 objects -> missing second time

201-300 objects -> missing first time

For that reason, any threshold number higher than 3 should be good for your scenario. 

Please test this first by using the "Update" option instead of "Delete" option. You can have an attribute to keep the status and update the status attribute as "Deleted" in this way. 

Once you observe that it works as you expected, then it is better to use the "Delete" missing objects option. As you know, there is no recycle bin feature in Assets. You don't want to lose your objects.

Good luck in advance

Hakan Bahadir

Pio

[Emiliano Nicolas Romero]

Thanks for the explanation, it's the answer I needed.

Greetings!