• State Verified Answer
  • +2 person also asked this people also asked this
  • Locked Locked
  • Replies 5 replies
  • Subscribers 96 subscribers
  • Views 8960 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to import IT Operating data into Locality from CSV file

ztze

 Is anyone able to import IT Operating data into Locality from CSV file in v7.1? I believe the table name is TSBITDATA. When I try import from CSV, I am getting error "You are not allowed to assign objects of type 'TSBITData"

  • 0

    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:

     

  • 0
    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.
  • +2

    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

     

  • 0

    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

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