You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am currently trying to figure out if it is possible to setup the CSV import in such a way that it does not replace already existing references instead of replacing them.
For example in Insight I have an object A which has a reference to object B. In my import file I now have a row which says that A has a reference to object C. The current behavior is that after the import A has a reference only to C.
How can it be achieved that A has a reference to B AND C after the import?
Thanks a lot.
You can tell the import to ignore custom fields that are empty in the import, but you can't tell them to just add to existing fields.
How would you ever tell the system that something needs to be removed?
An import updates the objects, as in, overwrites everything that is filled in in the import.
So I'm sad to say you just can't. You should keep both / all values in the CSV if they all need to stay linked.
If you really need this kind of updates to the objects, I suggest diving into the API's and see if you can do what you need from there.
We have the same requirement, when importing 'contacts' who have a reference to 'Contact Roles', we want the contact roles that already are present on the contact to be kept and additional roles added if not present.
I understand that this is not possible using the csv import, does anyone have another solution (script, ...) to add additional attribute values to an object?
Actually just a way to "add" data.
For each attribute that should be "merged" I am adding an "interal_add_<Att-Name>"
as example Person hast Roles there is an "hidden" attribute "internal_add_Roles"
The Import is importing to the internal_add attribute and then I have a groovy that is running very then minutes IQL for the "possible" objects with that special fields.
And then it is merging the data.
Yeah quite complicate to explain as it is an freaky complicated and not nice at all (as just stuff will be added)
I found the same 'workaround' using an additional attribute that is filled when doing the import and than an automation to merge both.
But the code shown to merge is not working....
Can you give me the groovy script that merges the attributes so that I can build on that?
at first the mentioned workaround was not clean working for me
and I try to prevent "on update" automations as I am importing to many data
and the automation engine is "blocked" for days and other projects can't work.
So I am using a merge script that is triggered every 10minutes and updating 120 objects
(I loved to have an IQL TOP/MAX or something)
So the script is also using a custom Insight Manager Library to wrap tons of functions and loads etc.
I will add a "trimmed" version of my script and mentioned the original InsightManagerForScriptrunner library which you will find in the net (it is from RIADA)
So the script will not work out of the box!
but this scenario is quite common if you are using multiple import configurations and actually makes the data „inconsistent“ and „incorrect“
you have an object application
with an multiple reference to systems.
one import source contains systems (a,b,c)
that have that application installed
and the other import source fetched systems (x,y,z) that have the same application installed.
and of course at the end you want to see that this application is installed on system a,b,c,x,y,z
the remove „threahold“ logic is different
as we can configure it to remove them after x days or syncs
and for the devs this is where you need to store from which import configuration the information was comming from
this actually is a major blocker for us