• State Verified Answer
  • +2 person also asked this people also asked this
  • Locked Locked
  • Replies 5 replies
  • Subscribers 96 subscribers
  • Views 8998 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"

Parents
  • +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

     

Reply
  • +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

     

Children
No Data