|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Extracting attendee status from calendar entriesI'm desperately trying to extract the list of attendees with
Accepted/Declined/Tentative/No answer status from a calendar meeting object. I've started from the code at: http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 in order to avoid starting from scratch. I cannot get code that would use "urn:schemas:calendar:attendeestatus" (in the query) / "d:attendeestatus" (in the processing of the response) to work... Any clue? TIA Hello,
the attendee status is kept in the recipient table of the message which is unfortunately not available via WebDAV. Kind regards, Henning Show quote "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... > I'm desperately trying to extract the list of attendees with > Accepted/Declined/Tentative/No answer status from a calendar meeting > object. > > I've started from the code at: > > http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 > > in order to avoid starting from scratch. > > I cannot get code that would use "urn:schemas:calendar:attendeestatus" (in > the query) / "d:attendeestatus" (in the processing of the response) to > work... > > Any clue? > > > TIA > > > So? What else than WebDAV would I have to use? CDOEX.DLL? Where can I find
info / doc / sample code on how to extract the attendee info? TIA Henning Krause [MVP - Exchange] wrote: Show quote > Hello, > > the attendee status is kept in the recipient table of the message > which is unfortunately not available via WebDAV. > > Kind regards, > Henning > > "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message > news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... >> I'm desperately trying to extract the list of attendees with >> Accepted/Declined/Tentative/No answer status from a calendar meeting >> object. >> >> I've started from the code at: >> >> http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 >> >> in order to avoid starting from scratch. >> >> I cannot get code that would use >> "urn:schemas:calendar:attendeestatus" (in the query) / >> "d:attendeestatus" (in the processing of the response) to work... >> >> Any clue? >> >> >> TIA Extended MAPI or/and CDO 1.2.1 and/or OOM
See MSDN for RecipientType and GetMeetingResponseStatus Maybe you like to build something as our "Attendees Print" http://www.imibo.com/imidev/Exchange/imiap.htm :) Regards, info_at_imibo_dot_com Show quote "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message news:OdoXJRG9HHA.3716@TK2MSFTNGP03.phx.gbl... > So? What else than WebDAV would I have to use? CDOEX.DLL? Where can I find > info / doc / sample code on how to extract the attendee info? > > TIA > > Henning Krause [MVP - Exchange] wrote: >> Hello, >> >> the attendee status is kept in the recipient table of the message >> which is unfortunately not available via WebDAV. >> >> Kind regards, >> Henning >> >> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message >> news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... >>> I'm desperately trying to extract the list of attendees with >>> Accepted/Declined/Tentative/No answer status from a calendar meeting >>> object. >>> >>> I've started from the code at: >>> >>> http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 >>> >>> in order to avoid starting from scratch. >>> >>> I cannot get code that would use >>> "urn:schemas:calendar:attendeestatus" (in the query) / >>> "d:attendeestatus" (in the processing of the response) to work... >>> >>> Any clue? >>> >>> >>> TIA > > info_at_imibo_dot_com wrote:
> Extended MAPI or/and CDO 1.2.1 and/or OOM More or less, but we'd also like to publish *some* information about meeting > See MSDN for RecipientType and GetMeetingResponseStatus > Maybe you like to build something as our "Attendees Print" > http://www.imibo.com/imidev/Exchange/imiap.htm :) rooms (that are marked "private" so that normal users don't have the title / participants of managers' meetings). Eric's code seemed a nice starting point. And I'm "definitely unsure" I can convince whomever has to be convinced to shell out the money for 200 licenses of your app... (I've eval'd your app, works like a charm, just would have a few comments, like: why the inserted empty columns in the Excel export, but that's another story altogether... if you want to discuss this further I suggest direct email, you can probably guess my real email address from the mangled one) Show quote > > Regards, > info_at_imibo_dot_com > > > "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message > news:OdoXJRG9HHA.3716@TK2MSFTNGP03.phx.gbl... >> So? What else than WebDAV would I have to use? CDOEX.DLL? Where can >> I find info / doc / sample code on how to extract the attendee info? >> >> TIA >> >> Henning Krause [MVP - Exchange] wrote: >>> Hello, >>> >>> the attendee status is kept in the recipient table of the message >>> which is unfortunately not available via WebDAV. >>> >>> Kind regards, >>> Henning >>> >>> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in >>> message news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... >>>> I'm desperately trying to extract the list of attendees with >>>> Accepted/Declined/Tentative/No answer status from a calendar >>>> meeting object. >>>> >>>> I've started from the code at: >>>> >>>> http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 >>>> >>>> in order to avoid starting from scratch. >>>> >>>> I cannot get code that would use >>>> "urn:schemas:calendar:attendeestatus" (in the query) / >>>> "d:attendeestatus" (in the processing of the response) to work... >>>> >>>> Any clue? >>>> >>>> >>>> TIA You can always wrote your comments and suggestions to info_at_imibo_dot_com
Any remarks are welcome :) Show quote "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message news:O6Qw6LJ9HHA.1168@TK2MSFTNGP02.phx.gbl... > info_at_imibo_dot_com wrote: >> Extended MAPI or/and CDO 1.2.1 and/or OOM >> See MSDN for RecipientType and GetMeetingResponseStatus >> Maybe you like to build something as our "Attendees Print" >> http://www.imibo.com/imidev/Exchange/imiap.htm :) > > More or less, but we'd also like to publish *some* information about > meeting rooms (that are marked "private" so that normal users don't have > the title / participants of managers' meetings). Eric's code seemed a > nice starting point. > > And I'm "definitely unsure" I can convince whomever has to be convinced to > shell out the money for 200 licenses of your app... > > (I've eval'd your app, works like a charm, just would have a few comments, > like: why the inserted empty columns in the Excel export, but that's > another story altogether... if you want to discuss this further I suggest > direct email, you can probably guess my real email address from the > mangled one) > >> >> Regards, >> info_at_imibo_dot_com >> >> >> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message >> news:OdoXJRG9HHA.3716@TK2MSFTNGP03.phx.gbl... >>> So? What else than WebDAV would I have to use? CDOEX.DLL? Where can >>> I find info / doc / sample code on how to extract the attendee info? >>> >>> TIA >>> >>> Henning Krause [MVP - Exchange] wrote: >>>> Hello, >>>> >>>> the attendee status is kept in the recipient table of the message >>>> which is unfortunately not available via WebDAV. >>>> >>>> Kind regards, >>>> Henning >>>> >>>> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in >>>> message news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... >>>>> I'm desperately trying to extract the list of attendees with >>>>> Accepted/Declined/Tentative/No answer status from a calendar >>>>> meeting object. >>>>> >>>>> I've started from the code at: >>>>> >>>>> http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 >>>>> >>>>> in order to avoid starting from scratch. >>>>> >>>>> I cannot get code that would use >>>>> "urn:schemas:calendar:attendeestatus" (in the query) / >>>>> "d:attendeestatus" (in the processing of the response) to work... >>>>> >>>>> Any clue? >>>>> >>>>> >>>>> TIA > > One option you could consider trying with WebDAV is the attendee status is
usually held in the vcalendar body part of the appointment. So it you do a Get on the appointment stream its possible to parse out the status from that bodypart. It not the same as accessing the recipients collection but maybe a workaround you can test. eg set Req = createobject("Microsoft.XMLHTTP") Req.open "GET", "http://server/exchange/mailbox/Calendar/appoinment.EML", false Req.setRequestHeader "Translate","f" Req.send attendeearry = split(req.responsetext,"ATTENDEE;",-1,1) for i = 1 to ubound(attendeearry) string1 = vbcrlf & " " stparse = replace(attendeearry(i),string1,"") attaddress = mid(stparse,(instr(stparse,"MAILTO:")+7),instr(stparse,chr(13))) attaddress = mid(attaddress,1,instr(attaddress,vbcrlf)) attrole = mid(stparse,(instr(stparse,"ROLE=")+5),instr((instr(stparse,"ROLE=")+5),stparse,";")-(instr(stparse,"ROLE=")+5)) attstatus = mid(stparse,(instr(stparse,"PARTSTAT=")+9),instr((instr(stparse,"PARTSTAT=")+9),stparse,";")-(instr(stparse,"PARTSTAT=")+9)) wscript.echo attaddress wscript.echo attrole wscript.echo attstatus next Cheers Glen Show quote "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message news:OdoXJRG9HHA.3716@TK2MSFTNGP03.phx.gbl... > So? What else than WebDAV would I have to use? CDOEX.DLL? Where can I find > info / doc / sample code on how to extract the attendee info? > > TIA > > Henning Krause [MVP - Exchange] wrote: >> Hello, >> >> the attendee status is kept in the recipient table of the message >> which is unfortunately not available via WebDAV. >> >> Kind regards, >> Henning >> >> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message >> news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... >>> I'm desperately trying to extract the list of attendees with >>> Accepted/Declined/Tentative/No answer status from a calendar meeting >>> object. >>> >>> I've started from the code at: >>> >>> http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 >>> >>> in order to avoid starting from scratch. >>> >>> I cannot get code that would use >>> "urn:schemas:calendar:attendeestatus" (in the query) / >>> "d:attendeestatus" (in the processing of the response) to work... >>> >>> Any clue? >>> >>> >>> TIA > > Glen Scales [MVP] wrote:
> One option you could consider trying with WebDAV is the attendee I assume the URL above is a "dummy" one, it should contain "something" that > status is usually held in the vcalendar body part of the appointment. > So it you do a Get on the appointment stream its possible to parse > out the status from that bodypart. It not the same as accessing the > recipients collection but maybe a workaround you can test. eg > > set Req = createobject("Microsoft.XMLHTTP") > Req.open "GET", > "http://server/exchange/mailbox/Calendar/appoinment.EML", false specifies the meeting you want to read. In any case, a GET of http://TheRealServerName/exchange/MyMailboxName/Calendar/appoinment.EML gets me nothing but a 404... (a GET of http://TheRealServerName/exchange/MyMailboxName/Calendar DOES get me something) Do I miss something? Show quote > Req.setRequestHeader "Translate","f" > Req.send > attendeearry = split(req.responsetext,"ATTENDEE;",-1,1) > for i = 1 to ubound(attendeearry) > string1 = vbcrlf & " " > stparse = replace(attendeearry(i),string1,"") > attaddress = > mid(stparse,(instr(stparse,"MAILTO:")+7),instr(stparse,chr(13))) > attaddress = mid(attaddress,1,instr(attaddress,vbcrlf)) > attrole = > mid(stparse,(instr(stparse,"ROLE=")+5),instr((instr(stparse,"ROLE=")+5),stparse,";")-(instr(stparse,"ROLE=")+5)) > attstatus = > mid(stparse,(instr(stparse,"PARTSTAT=")+9),instr((instr(stparse,"PARTSTAT=")+9),stparse,";")-(instr(stparse,"PARTSTAT=")+9)) > wscript.echo attaddress > wscript.echo attrole > wscript.echo attstatus > next > > Cheers > Glen > > "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message > news:OdoXJRG9HHA.3716@TK2MSFTNGP03.phx.gbl... >> So? What else than WebDAV would I have to use? CDOEX.DLL? Where can >> I find info / doc / sample code on how to extract the attendee info? >> >> TIA >> >> Henning Krause [MVP - Exchange] wrote: >>> Hello, >>> >>> the attendee status is kept in the recipient table of the message >>> which is unfortunately not available via WebDAV. >>> >>> Kind regards, >>> Henning >>> >>> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in >>> message news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... >>>> I'm desperately trying to extract the list of attendees with >>>> Accepted/Declined/Tentative/No answer status from a calendar >>>> meeting object. >>>> >>>> I've started from the code at: >>>> >>>> http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 >>>> >>>> in order to avoid starting from scratch. >>>> >>>> I cannot get code that would use >>>> "urn:schemas:calendar:attendeestatus" (in the query) / >>>> "d:attendeestatus" (in the processing of the response) to work... >>>> >>>> Any clue? >>>> >>>> >>>> TIA Hello,
the url is the OWA url of the meeting and the same you use in your webdav requests. Only the verb is another (GET vs. PROPFIND). But assuming you are performing a SEARCH request over the calendar folder, you'll have to retrieve the DAV:href property from each item in the search response and perform the GET operation on that url. And you must speficy the Translate: f header, otherwise you'll get a HTML response containing the OWA representation of that item. Kind regards, Henning Show quote "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message news:eixdZTS9HHA.4200@TK2MSFTNGP04.phx.gbl... > Glen Scales [MVP] wrote: >> One option you could consider trying with WebDAV is the attendee >> status is usually held in the vcalendar body part of the appointment. >> So it you do a Get on the appointment stream its possible to parse >> out the status from that bodypart. It not the same as accessing the >> recipients collection but maybe a workaround you can test. eg >> >> set Req = createobject("Microsoft.XMLHTTP") >> Req.open "GET", >> "http://server/exchange/mailbox/Calendar/appoinment.EML", false > > I assume the URL above is a "dummy" one, it should contain "something" > that specifies the meeting you want to read. > > In any case, a GET of > http://TheRealServerName/exchange/MyMailboxName/Calendar/appoinment.EML > gets me nothing but a 404... > > (a GET of http://TheRealServerName/exchange/MyMailboxName/Calendar DOES > get me something) > > Do I miss something? > >> Req.setRequestHeader "Translate","f" >> Req.send >> attendeearry = split(req.responsetext,"ATTENDEE;",-1,1) >> for i = 1 to ubound(attendeearry) >> string1 = vbcrlf & " " >> stparse = replace(attendeearry(i),string1,"") >> attaddress = >> mid(stparse,(instr(stparse,"MAILTO:")+7),instr(stparse,chr(13))) >> attaddress = mid(attaddress,1,instr(attaddress,vbcrlf)) >> attrole = >> mid(stparse,(instr(stparse,"ROLE=")+5),instr((instr(stparse,"ROLE=")+5),stparse,";")-(instr(stparse,"ROLE=")+5)) >> attstatus = >> mid(stparse,(instr(stparse,"PARTSTAT=")+9),instr((instr(stparse,"PARTSTAT=")+9),stparse,";")-(instr(stparse,"PARTSTAT=")+9)) >> wscript.echo attaddress >> wscript.echo attrole >> wscript.echo attstatus >> next >> >> Cheers >> Glen >> >> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in message >> news:OdoXJRG9HHA.3716@TK2MSFTNGP03.phx.gbl... >>> So? What else than WebDAV would I have to use? CDOEX.DLL? Where can >>> I find info / doc / sample code on how to extract the attendee info? >>> >>> TIA >>> >>> Henning Krause [MVP - Exchange] wrote: >>>> Hello, >>>> >>>> the attendee status is kept in the recipient table of the message >>>> which is unfortunately not available via WebDAV. >>>> >>>> Kind regards, >>>> Henning >>>> >>>> "Stephane Barizien" <steNphOane.SbarPiz***@oAcMe.com> wrote in >>>> message news:Our2$KF9HHA.5164@TK2MSFTNGP05.phx.gbl... >>>>> I'm desperately trying to extract the list of attendees with >>>>> Accepted/Declined/Tentative/No answer status from a calendar >>>>> meeting object. >>>>> >>>>> I've started from the code at: >>>>> >>>>> http://www.ericwoodford.com/my_html_calendar_generating_script_for_exchange_2003 >>>>> >>>>> in order to avoid starting from scratch. >>>>> >>>>> I cannot get code that would use >>>>> "urn:schemas:calendar:attendeestatus" (in the query) / >>>>> "d:attendeestatus" (in the processing of the response) to work... >>>>> >>>>> Any clue? >>>>> >>>>> >>>>> TIA > >  |
|||||||||||||||||||||||
Other interesting topics