Customer experience | Sales, Customer Insights,...

Buildings and Venues

Like (1) Share

Report

Posted on 22 Jan 2025 13:28:52 by Guy Boswell

In Dynamics, spaces in which an event can take place are described hierarchically. I think, buildings contain rooms contain layouts.

Dynamics has two tables, "Building", name, "msevtmgt_building", and table, "Venue", name, "msevtmgt_venue"

There is a field on the venue table, "msevtmgt_buildingid", which suggests the venue is a child of a building. But there is also a field on the venue table, "msevtmgt_parentvenueid", which suggests a venue can be a child of another venue.

When you create an event, you can add a location (see attached screenshot). It seems what you are doing is adding a building record to the building table. You can then, if neccessary, add rooms within that building and layouts within those rooms.

Whenever you create a building, a venue record is created on the venue table, with the same details as the building.

Questions:

a) Is my description above correct?

b) Why does Dynamics have both venues and buildings, if the information in both is the same and kept syncronised? If I am correct, and events take place in buildings, where are venues used?

c) Do venues contain buildings or do buildings contain venues? Or neither or both?

d) Where do I find the, "plugin or other back-end Microsoft process that keeps things synchronized"? (See comment from @Tom_G)

e) We want to add some custom fields to the location for our events. Does it matter if I add these to the building or venue or both?

f) Does migration from Outbound marketing to real time journeys change any of this?

Thank you for your help. Guy

Categories:

Microsoft Dynamics CRM

Screenshot.png

All responses (4)

Answers (0)

Guy Boswell 50 on 23 Jan 2025 at 12:47:48

Like (0)

Report

Buildings and Venues

@Tom_G, thank you for your input. As a result, I am editing my original question to clarify.
Suggested answer

Tom_Gioielli 1,108 on 22 Jan 2025 at 21:36:12

Like (0)

Report

Buildings and Venues

From what I have seen, the concept of a Venue can encompass either a building, a room, or even a layout of a room. All of these other tables are considered a type of Venue.

I liken in CRM to the Activity table concept. You have specific tables like Phone Call, Appointment, or Task that exist in the database, but all of them are also considered an "Activity" and are treated in some ways as a single type of record. The Venue management process allows you to define different types of locations based on your needs, but they are all considered a "Venue". This allows you to have a single lookup field on your event table where you pick the Venue, but the split means it can be a room/building/layout. It gives a standardized table no matter the details that the application can work from.

In situations like this, it is typically a plugin or other back-end Microsoft process that keeps things synchronized. I'm not sure if custom fields can be added to each and still become part of the sync process, but others may know if that can be done. If it can be done, you would want to make sure the fields on both tables match (both in field type and schema name) to have a chance.

As to where you should add them, it all depends on what tables you are using in the application. If you are only using buildings and you don't need access to the venue or to the custom fields on the venue, you may be fine without adding it to both.
Guy Boswell 50 on 22 Jan 2025 at 16:53:22

Like (0)

Report

Buildings and Venues

Hi @VaHiX, so if the two tables are kept in synch - why are there two tables? And how are they kept in synch? What process copies the data from one to the other?

Thank you. Guy
Vahid Ghafarpour 8,098 Super User 2025 Season 1 on 22 Jan 2025 at 16:39:17

Like (2)

Report

Buildings and Venues

You can add custom fields to either the Building or Venue table, depending on your requirements. If you add custom fields to the Building table, you might need to ensure that these fields are also populated in the Venue table to maintain consistency.

To ensure consistency and avoid any discrepancies, it's a good practice to add the same custom fields to both the Building and Venue tables. This way, you can maintain a unified view of your event locations.

Community site session details

Buildings and Venues

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Buildings and Venues

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates