Facility Mangaement using Exchange Resource Mailbox, Conflicts properties

Status
Not open for further replies.

htd01

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I don't know how or when a conflicts count is adjusted for an appointment\meeting item. If you use a resource scheduler function, the conflicts properties are a great way to check for errors in booking, but there's no documentation on when this property is actually instantiated.

You can update the standard form to listen for ACTIONS. Unfortunately, not knowing when the Conflicts list is checked. The Autoresolved winner is one that, obviously, must be sent first and checked afterward. But the Conflicts list has 2 functions. In offline mode, it always returns conflicts for all items. In online mode it returns true for those that aren't updated, or for those that show a Conflict in the Date\time fields.

Any clues here?
 

htd01

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Re: Facility Management using Exchange Resource Mailbox, Conflicts properties

I've found that most properties like this one are actually passed after a .save\send operation. This property has two purposes, so it cannot be use properly anyway. However, by running a test on the free\busy info you parse, you can check the rooms with relative quickness. The caveat or pitfall is that you will get a "Busy" signal if the Booking is the current appointment you're working with.

I've been trying to find a property that can be used to identify the appointment as unique, one that cannot be masked or replaced, and is the same across all of them. I've been looking and I believe I've found a way to get that property. Most information points to the ENTRYID and\or STOREID. However, what they don't address is the fact that the entry id for the item in the room mailbox will be different. One possible solution is using the meetingItem as a front door, and and walking the hallway all the way back to the associated appointmentItem. The function will have to be created for both of them, and will have to work for both of them, but that is not as difficult as it may seem. Even if only an appointmentItem (if the meetingItem has been corrupted for whatever reason), a new meetingitem can be built to represent the current item that's open, and the tunnel back to the appointment item can still be built. Here's the Caveat, and it's a big one: If the room builds it's own appointmentItem in it's calendar, and doesn't link back to the original calendar that built the booking, it's not possible to check if the two items are actually the same. However, the payoff in the opposite is big. Not only can you tell that two items are actually the same, but you can grant permissions to make changes so long as the person\user has the ability to make changes to the calendar that built the appointment. This means that you can offer a Group Access Level to the rooms that allow them to make the changes by recreating an event instead of updating it, but that alters the functionality of sending it to people. So, if you want to keep all that intact, you might try setting the organizer to a distribution group rather than a single person, or as an equipment mailbox (a virtual cork board for the department) that you grant access to by group. Then you build on the form and have it allow them to make updates.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: Facility Management using Exchange Resource Mailbox, Conflicts properties

Your information is correct on the EntryID - that is the unique GUID that identifies the item, and yes, it will be different in each mailbox. (Copies get their own id too.)
 

htd01

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Re: Facility Management using Exchange Resource Mailbox, Conflicts properties

What I need to know now is whether the GetAssociatedAppointmentItem will return an appointmentItem in the current folder (when it's a meeting that was requested by somebody else) or if it will actually grab the original appointmentItem in the folder where it was initially created. If the Former, then I'm up a creek. If the latter, Then there's a way to compare entries of different folders after all (other than the StoreID or entryID). If it will grab an appointmentItem where it was originally created with an entryID that's unique, then I can compare that with the item that's currently open to tell if they are the same or not. If they are the same, I can skip a few lengthy tests, and the logic of testing subject or other items (that may end up being similar for one reason or another) all becomes moot. The actual uniqe id will be the only necessary test. If the GUID were the same for the meeting item that somebody accepts that gets placed, I wouldn't have to attempt to grab the initial item. If this action throws back an error, I can surmise that the access level is different (meaning it's on a different calendar the user has no access to), and I can continue with the execution I'm interested in. All that means is that using an if test, I can:

> ...some code here....

Dim myItemCheck As Outlook.AppointmentItem

Dim item As Object

On Error Resume Next

myItemCheck = item.GetAssociatedAppointmentItem

If Not myItemCheck.entryID = CurrentItem.EntryID Then
Do Stuff

Elseif
Do other stuff

> ..

I've been working on parsing Free\Busy info (mainly the design) in a custom version of the default form. Unfortunately, my VBScript is worse than my VBA (which is akin in many ways to an english speaking 7 year old trying to order some chef boyardee in ancient greece).
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Re: Facility Management using Exchange Resource Mailbox, Conflicts properties

GetAssociatedAppointment gets the associated appt in the calendar of the mailbox running the code. It's possible to check other calendars using code, but they need to be in the profile and the appointment won't be "associated".
 

htd01

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Re: Facility Management using Exchange Resource Mailbox, Conflicts properties

When I send a meeting to a moderated resource calendar, and it is accepted, and I've got reviewer access to the room calendar, is it possible to then grab the meeting on the room calendar and track it back to the original on my calendar so I can compare the original with something else? That's what I'm trying to find out.

Logic:

Say I'm parsing some free\busy info in my code, and I've already sent this meeting to the room, and it has been accepted. If I grab the free\busy time again, it will show busy for that time. If I haven't saved or sent yet, and the room is busy from another meeting I scheduled for a different set of people in the same group (say I'm setting up multiple start times across multiple venues for different sets of people or different exhibits are opening\closing and people will be free to move about), and I've used the same subject etc for most of the work because it's faster to read and to book. What I need from my custom form is a way to follow the free\busy info all the way back to the original and compare it's entry id (if saved) with the one that's currently open. The form will then create a list of any conflicts that are not the currently open item. Maybe I'm deciding how many exhibits to open, and I'm only putting in a shell item currently. If I've made any changes to the item, it won't match any longer, accept for the entry id of the original appointment item. The GUID or entry id... ...It is different for every store\folder\calendar, because there is an entry made as soon as you send\save anything or accept\decline. But is there a way to trace the meeting currently on that secondary calendar (I have reviewer access), to the item it came from on the original calendar? Or do I have to append something to every meetingitem that in some way identifies it's original? I could use the actual numbers for the entryID, StoreID and store it in a string appended to every body statement, but that get's a little messy and provides the same to outsiders who receive the request.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
H Mailing List account needed with remote smtp auth facility Exchange Server Administration 3
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
pcunite Outlook 2019/O365 Build 13127.20408 errors when using MAPI calls Using Outlook 1
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
X Using Outlook 2013 and Outlook 365 Using Outlook 1
A Going to folder using shortcuts Using Outlook 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 5
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
K Using Outlook 2016 to draw Using Outlook 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
A Using or not using apostrophes in search terms has this changed? Using Outlook 0
O Office 365 using POP3 on both laptop and desktop Using Outlook 0
M Using field names to capture a data element Using Outlook 0
B Vba to monitor time to respond to emails using a shared mailbox Outlook VBA and Custom Forms 5
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
O Using .OST and .PST mail thru different providers Using Outlook 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
E Using the Like operator properly Outlook VBA and Custom Forms 1
R Using "check for duplicates" for existing contacts Using Outlook 2
S Find a cell value in excel using outlook vba Using Outlook 1
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
C Sync Calendars using WiFI Using Outlook 3
A Capturing Send Variables without using Application_ItemSend in ThisOutlookSession Outlook VBA and Custom Forms 8
L Using alpha numeric in email address Using Outlook 5
Sabastian Samuel HOW DO I FORWARD AN EMAIL WITH MACRO using an email that in the body of another email Outlook VBA and Custom Forms 3
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
D Print Attachments only in selected emails using a macro Outlook VBA and Custom Forms 3
B query outlook using vba Outlook VBA and Custom Forms 13
M Using conditional formatting on a shared calendar with categories Using Outlook 6
e_a_g_l_e_p_i A question about installing office 2013 Pro and using my .pst from office 2010 Using Outlook 12
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
O How to paste website content using a specific font and removing URLs Using Outlook 2
P Replying to calendar item using VBA Outlook VBA and Custom Forms 4
N Export details to a excel spreadsheet using macros Using Outlook 0
R Toggle the Reading Pane using Keyboard Shortcut Using Outlook 0
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
H Change Default Email Account Using VBA Outlook VBA and Custom Forms 5

Similar threads

Top