How to add a relationship properties column in a xlsx file.

somesh pande 1 Reputation point
2021-09-02T11:54:47.797+00:00

I am able to create a digital twin using the sample xlsx file shared on GitHub repository of ADT as shown in below snapshot.
128713-er01.png
In above image the twin properties are added by column 'init data'. But in my case the relationship also have their own properties associated with them.
So how can I include the relationship properties in the xlsx ?
What will be the name of the column for the relationship properties needed to be specified in xlsx ?
It will be helpful if you can share a xlsx having the multiple nodes and relationship where the relationship properties added in them.

Azure Digital Twins
Azure Digital Twins
An Azure platform that is used to create digital representations of real-world things, places, business processes, and people.
220 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Matthijs van der Veer 4,376 Reputation points MVP
    2021-09-07T06:28:32.7+00:00

    Duplicate on StackOverflow

    Currently, the Azure Digital Twins explorer doesn't support uploading relationships with properties through Excel or JSON files. The Excel plugin currently only looks at the columns that are defined in the file. This means that if you absolutely must use an Excel file to import your twin, you would need to build this functionality yourself.

    There is also an open issue that describes relationship properties not being shown in ADT Explorer, so there doesn't seem to be support for it. You could use the API to create these relationships.

    1 person found this answer helpful.
    0 comments