Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How its works Threshold Number in Assets Jira Cloud?

Emiliano Nicolas Romero February 21, 2024

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

1 answer

1 accepted

1 vote
Answer accepted
Hakan Bahadir _Pio_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 22, 2024

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 February 22, 2024

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

Greetings!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events