How to import IT Operating data into Locality from CSV file

Without more detailed information it's hard to tell you anything besides, the explanation that you import user seems not to have enough permissions to create the entries in TSBITData.

What you could check in addition for the entries you are trying to create:

• Does the value UID_DialogColumnTarget point to a Column using the script template TSB_ITDataFromOrg in their template . See http://documents.software.dell.com/identity-manager/7.0/business-roles-administration-guide/managing-business-roles/setting-up-it-operating-data for more details.
• Does ObjectKeyAppliesTo point to either a valid TSBAccountDef or a valid reference to the target system root like ADSDomain, UNSRootB,...

 

Markus,
Thanks for the response. Below is what we are trying to do
1. Create a location from Manager
2. Assign IT operating data such that #1 maps to an OU in AD

We have about 600+ such locations. We have loaded all of them into the locality table. Now we are trying to build an XML to load IToperating data to map each of 600+ locations to an AD OU which we have listed in a CSV.

Any ideas on how to move forward with the XML such that there is a link between locality(in #1) and ITOperating data? In 6.1.3 we didn't have any issues sine we could use UID_ADSContainer as a FK in locality. Please advise.

I do not know what XML you are referring to but here is what you have to put in the properties of the entry in TSBITData.

 

• ObjectKeyAppliesTo = XObjectKey of the ADSDomain (or TSBAccountDef) this mapping should be valid for
• ObjectKeyValue = XObjectKey of the ADSContainer you are referring to
• UID_DialogColumnTarget = UID of the DialogColumn that should use this value. In your case, the column ADSAccount.UID_ADSContainer.
• UID_Org = UID of your location

 

Markus,
Thanks for the prompt response. Our locations have only been loaded into the locality table. So there is no UID_Org reference to our locations. I am trying to understand your statement below
•UID_Org = UID of your location
Am I missing something? Does it get autogenerated? The reason for my question is that, when I tried this through Manager, it generated an entry in TSBITData with a UID_Org value for which I cannot find corresponding entry in ORG table.

Please advise

Markus,
Please ignore my earlier question. I got it. Thanks for all your help