Insight: How NOT TO create new Objects with an Import

Thomas Scheibelhofer
Contributor
January 25, 2018

Hello,

i've been trying to find a solution for this but so far it's rather fruitless.

I have different sources of data linked with different imports.

In my case i would like an import to ONLY update existing objects, without creating new ones.

Is there any way to e.g. use an IQL saying "Object exists" or something like that during the import?

Thank you and best regards

 

4 answers

1 vote
Martin Zelenohorský March 30, 2022

Its hard to believe, that support still not resolved this basic functionality..!?

I have the same problem, from on source CSV I need update 3 containers, without creating any new objects. 

1 vote
Alan Fitzpatrick February 25, 2021

I also very much need this. Would be great to push it forward.

0 votes
Kuherrn Nagayaindran February 16, 2023

This is going to be rather "hackish" but since the importer will create new Objects based on the identifier selected you can use the IQL below to find which objects were recently imported and then bulk delete them.

"Created" > now(-1h) 

// Or whichever time frame suits your needs, e.g. (-10m)
0 votes
Alexander Sundström
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2018

Hi Thomas,

It's not possible to configure the import to only update and not create. If an object is not found in Insight matching the identifier set, it will be created.

I would like to recommend you to visit https://jira.riada.se which is our open ticket system for feature requests and verified bugs. You can view, watch, vote etc for issues reported by anyone.

If you can't find an already opened feature request for this, feel free to create a new one.

If you have any issues or questions regarding this, please let us know.

Best Regards
Alexander

Thomas Scheibelhofer
Contributor
February 1, 2018

Thank you, Alexander.

I've created a feature request.

https://jira.riada.se/browse/ICS-632

Best regards
Thomas

Like SB likes this
Sanja Vukovic February 8, 2018

Thank you, Thomas, for creating this request. This is very basic functionality to choose betwen append new rows or only update existing. and  I'm surpristed, too, that it doesn't exist. We are in phase of evaluating Insight.

Thomas Scheibelhofer
Contributor
February 9, 2018

Here you can find the request for this feature:

https://jira.riada.se/browse/ICS-632

Best regards

SB
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 14, 2020

I see there is no response to it even 2 and a half years later. too bad, would have needed that feature, too...

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events