Excel Import / Export GUI relations mapping bad logic
Dear all,
I would like to raise issue with latest GUI for Import / Export in Collibra.
Main problem is that GUI is not exporting relations with Head included in column header… It exports and import only relationRole -Tail name.
So if we have relations like: Report - sources/targets - Table and FIle - sources /targets- Table, in export file we will have two columns with same header “sources > [Table]”. Funny thing is that because of this Collibra is not able to Import its own Export file because is not able to automaticaly find and map relations due to this bad export naming.
Second great thing about this Import mapping logic of partial relation names is, that if we have (due to different UC) two relations which differ by direction: Code Value - is part of/contains - Code Set and Code Set - contains/is part of - Code Value, Collibra allow to create this relations BUT it considers them as same one, so in Import mapping is not able to map them even we have in import file only one column header “contains > [Code Value]”. We have to map it manually and give 50:50 try as dropdown in mapping will offer two same options “Code Set contains Code Value”, even direction is different so it is NOT true.
All of this issues could be easely solved just with adding “HEAD” asset into export (column headers) / import (mapping dropboxes right direction)
