Skip to main content
Solved

Importing relations as "Leave empty"

  • December 13, 2023
  • 7 replies
  • 270 views
T

Hi Everyone,

I have a question and ofcourse I could create a support ticket for that. As the topic is not too urgent and I wanted to start a topic in community therefore, I thought about posting it here.


The topic is the following: for relations we have the possibility to deliberately select, “Leave Empty” and this contributes to the overall completion score of a factsheet (if applicable).

Is there a possibility to import relations via excel on multilple factsheets (say application) as “Leave Empty” instead of manually maintaining it? 

 

I hope I can get some positive answers. 

Thank you in advance. 

 

Best regards.

Best answer by Thomas Schreiner

Hi @Tahir_Waheed, Unfortunately this is not possible at the moment. Technically, the “intentionally left blank” relations are not values of the relation itself, but a list of intentionally left blank relation names in another data structure called “naFields” (“not applicable fields”).

If you want to set this via a mass update, you would have to write your own custom script, for example in Python using our LeanIX partner product:

application.update_field(naFields=["relApplicationToUserGroup"])

7 replies

Thomas Schreiner
Forum|alt.badge.img+3
  • Thomas Schreiner
  • Everlasting Love
  • 384 replies
  • Answer
  • December 15, 2023

Hi @Tahir_Waheed, Unfortunately this is not possible at the moment. Technically, the “intentionally left blank” relations are not values of the relation itself, but a list of intentionally left blank relation names in another data structure called “naFields” (“not applicable fields”).

If you want to set this via a mass update, you would have to write your own custom script, for example in Python using our LeanIX partner product:

application.update_field(naFields=["relApplicationToUserGroup"])
T
  • Tahir_Waheed
  • Author
  • Rookie
  • 4 replies
  • December 15, 2023

Hi @Thomas Schreiner  thanks a lot for your answer. I will definately have a look on the product and get back to you in case of any questions. 

Tahir.

Thomas Schreiner
Forum|alt.badge.img+3
  • Thomas Schreiner
  • Everlasting Love
  • 384 replies
  • December 15, 2023

@Tahir_Waheed No problem, anytime :-) If you want to try it out in your browser, you can use this simplified demo environment: https://demo.aronis.de/

T
  • Tahir_Waheed
  • Author
  • Rookie
  • 4 replies
  • December 15, 2023

Great! Thanks a lot once again.

Thomas Schreiner
Forum|alt.badge.img+3
  • Thomas Schreiner
  • Everlasting Love
  • 384 replies
  • December 15, 2023

You are welcome! If you want to make it easier for other community participants to find the right answers, feel free to mark my first reply as “Best answer”.

Justin Swift
Forum|alt.badge.img+1
  • Justin Swift
  • Veteran
  • 186 replies
  • December 18, 2023

@Tahir_Waheed I submitted this as an additional use case a while back in the roadmap item https://roadmap.leanix.net/c/188-eam-onboarding-excel-import-improve-excel-import?utm_medium=social&utm_source=portal_share while voting on it.

Perhaps you could do the same with your own justification on why you think it is important/critical to be able to import relations as intentionally empty.

Power to the people!

T
  • Tahir_Waheed
  • Author
  • Rookie
  • 4 replies
  • December 20, 2023

Hi @Justin Swift thank you for your comment as well! I just upvoted the idea with this functionality to be included in the excel importer :).


Terms & ConditionsCookie settingsAccessibility statement