• State Not Answered
  • Replies 2 replies
  • Subscribers 33 subscribers
  • Views 1515 views
  • Users 0 members are here

Element ID vs Mstn ID vs Instance ID

Min Song
Offline

Software used: AECOsim Building Designer V8i

OS: Windows 10

Question 1:

I am using i-model ODBC to see the different tables (e.g., pipe, door, etc.) in Excel. In the tables, I see three different IDs: Element ID, Mstn ID, Instance ID. I understand what Element ID is - it's the ID I can see when I select an object and click on Element Information, but I've never seen Mstn ID and Instance ID before. How are these three IDs different?

Question 2:

When I use i-model ODBC and see different tables (e.g., pipe, door, etc.) in Excel, some tables have an Element ID column and some tables don't. Is there a way to change some setting so I can see an Element ID column in all of the tables? 

Thank you everyone!

 

Min

Parents
  • 0 Offline

    Hi Min,

    it's recommended to ask questions separately to don't create confusing threads with merged topics.

    My guess about different IDs:

    • ElementID is unique ID in design file context. In fact it's a counter, that assign a number to every newly created element. It's ensure every number is used once only. This is DGN V8 format feature.
    • MStn_ID is i-model feature and I guess it's unique ID in i-model context with format <file name><reference slot number><model name><Element ID> ... at least it's what I see in some i-model I opened using ODBC driver. In my opinion the format is not very important, it's just something like GUID, so unique string.
    • I don't know what InstanceID is, I don't see it in my i-model. I guess it can be some AECOsim Building Designer internal ID.

    Element IDs are displayed only in tables relevant to MicroStation elements. Other tables contains business data not relevant directly to particular element, so in such case there is no Element ID. How tables are created and in what structure depends on an application used for i-model creation, so export from MicroStation will be quite simple (and probably Element IDs will be everywhere), but from AECOsim BD or Plant products will be more complex.

    With regards,

      Jan

    Bentley Accredited Developer: iTwin Platform - Associate
    Labyrinth Technology  |  dev.notes()  |  cad.point

Reply
  • 0 Offline

    Hi Min,

    it's recommended to ask questions separately to don't create confusing threads with merged topics.

    My guess about different IDs:

    • ElementID is unique ID in design file context. In fact it's a counter, that assign a number to every newly created element. It's ensure every number is used once only. This is DGN V8 format feature.
    • MStn_ID is i-model feature and I guess it's unique ID in i-model context with format <file name><reference slot number><model name><Element ID> ... at least it's what I see in some i-model I opened using ODBC driver. In my opinion the format is not very important, it's just something like GUID, so unique string.
    • I don't know what InstanceID is, I don't see it in my i-model. I guess it can be some AECOsim Building Designer internal ID.

    Element IDs are displayed only in tables relevant to MicroStation elements. Other tables contains business data not relevant directly to particular element, so in such case there is no Element ID. How tables are created and in what structure depends on an application used for i-model creation, so export from MicroStation will be quite simple (and probably Element IDs will be everywhere), but from AECOsim BD or Plant products will be more complex.

    With regards,

      Jan

    Bentley Accredited Developer: iTwin Platform - Associate
    Labyrinth Technology  |  dev.notes()  |  cad.point

Children
No Data
Communities
Support and Services
Training and Learning
Social Media