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
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
Thanks for the explanation, it's the answer I needed.
Greetings!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.