Skip to Content (Press Enter)
Post Closed
2018-11-09 09-14-06
Gonçalo Almeida
1507Views
37Comments
Sending an Outlook Calendar Event
Question
Hi all,

Is there an extension that allows me to send an outlook calendar event instead of a regular email?
I'm able to create the vcs file correctly and if I use Outlook to open it, I can send it and it works ok. But I'd like to send it without using outlook.
As anybody developed something to do this?

regards

2
0
27 Nov 2012
Copy Link
2022-11-12 11-28-30
Gonçalo Martins
Staff
Hi Gonçalo,

You don't need an extension to do that..You can do that only using the outsystems tools and power ;)
1- Build the content of the file as a text in the correct format, like for example:

"BEGIN:VCALENDAR
                  VERSION:2.0
                  BEGIN:VEVENT
                  STATUS:TENTATIVE
                  DTSTART:"+NewStartDate+"T"+NewStartTime+"Z
                 DTEND:"+NewEndDate+"T"+NewEndTime+"Z
                 LOCATION;ENCODING=QUOTED-PRINTABLE:"+Location+"
                  CATEGORIES:Profissional
                 DESCRIPTION;ENCODING=QUOTED-PRINTABLE:"+Description+"
                  SUMMARY;ENCODING=QUOTED-PRINTABLE:"+Subject+"
                  PRIORITY:3
                  END:VEVENT
                  END:VCALENDAR"

2- Convert your string to binary, using TextToBinaryData method (UTF-8).

3- Use an email screen and in the Preparation do something like this:

 

And here you have what you need..I think I didn't forget anything..Any doubt, just ask..
Note that you can look at this page to: https://support.microsoft.com/kb/287625

Hope this helps..

Best Regards,
Gonçalo Martins
4
0
28 Nov 2012
Copy Link
UserImage.jpg
Antima Dahel

Gonçalo Martins wrote:

Hi Gonçalo,

You don't need an extension to do that..You can do that only using the outsystems tools and power ;)
1- Build the content of the file as a text in the correct format, like for example:

"BEGIN:VCALENDAR
                  VERSION:2.0
                  BEGIN:VEVENT
                  STATUS:TENTATIVE
                  DTSTART:"+NewStartDate+"T"+NewStartTime+"Z
                 DTEND:"+NewEndDate+"T"+NewEndTime+"Z
                 LOCATION;ENCODING=QUOTED-PRINTABLE:"+Location+"
                  CATEGORIES:Profissional
                 DESCRIPTION;ENCODING=QUOTED-PRINTABLE:"+Description+"
                  SUMMARY;ENCODING=QUOTED-PRINTABLE:"+Subject+"
                  PRIORITY:3
                  END:VEVENT
                  END:VCALENDAR"

2- Convert your string to binary, using TextToBinaryData method (UTF-8).

3- Use an email screen and in the Preparation do something like this:

 

And here you have what you need..I think I didn't forget anything..Any doubt, just ask..
Note that you can look at this page to: https://support.microsoft.com/kb/287625

Hope this helps..

Best Regards,
Gonçalo Martins

Hello,

I am trying to achieve similar behavior. I am using Calendar widget in Oustystems and sending email to the users with a link "Add to Calendars". How we can convert the calendar events in ics file and send it as an attachment. So that a user can add it to their Outlook or gmail account. Any help would be highly appreciate. 

Thanks,

Antima


0
0
21 Sep 2017
Copy Link
2011-06-15 10-51-22
Joop Stringer
Just a little additional info

for the AttachFile action:
extension: .vcs
mimetype : text/x-vcalendar

And the datetime should be in a special form ...

	Year( InDateTime) + If(Month(InDateTime)<10,"0" ,"" ) + Month(InDateTime) + If( Day(InDateTime) < 10, "0","") + Day(InDateTime) + "T" + If(Hour(InDateTime)<10, "0", "") + Hour(InDateTime) + If(Minute(InDateTime)<10, "0", "") + Minute(InDateTime) + "00Z"
3
0
28 Nov 2012
Copy Link
2011-06-15 10-51-22
Joop Stringer
I can confirm it works like a charm :-)
1
0
28 Nov 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida
Hey guys. Thanks for the tips. It works, but not exactly as I thought.
I'm not looking to send the vcs as an attachment, but as an email itself, like when you send an appointment request.
Do you know how to do that?
 
0
0
28 Nov 2012
Copy Link
2011-06-15 10-51-22
Joop Stringer
Gonçalo Almeida wrote:
Hey guys. Thanks for the tips. It works, but not exactly as I thought.
I'm not looking to send the vcs as an attachment, but as an email itself, like when you send an appointment request.
Do you know how to do that?
 
 
 I don't think it is possible the way you want it ... to me this is an Outlook Special thingy

What you could try to do is add Attendee and Organizer information to the file.
Change the extension into .ICS (mime type  text/calendar) and see what that will bring you

Here are some sample lines how to incorporate these 

ORGANIZER;SENT-BY:"MAILTO:sray@host.com":MAILTO:jsmith@host.com
 
ATTENDEE;RSVP=TRUE:MAILTO:jsmith@host.com
ATTENDEE;RSVP=TRUE;ROLE=REQ-PARTICIPANT:MAILTO:jsmith@host.com
ATTENDEE;RSVP=TRUE;ROLE=CHAIR:MAILTO:jsmith@host.com

For full extensive :-) description see this site https://www.ietf.org/rfc/rfc2445.txt
0
0
28 Nov 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida

Hey Joop,

Unfortunatly the result is the same. I think I'll have to develop some extension in .NET to do this (I'll share it afterwards).
Unless the costumer accepts the attachment solution.

thanks anyway ;)

 

0
0
28 Nov 2012
Copy Link
2013-03-12 12-27-41
Diogo Miguel
Hi Gonçalo,

You have to do an .Net Extension using ExchangeService to create an Appointment.
You will have to do something like this: https://msdn.microsoft.com/en-us/library/exchange/ff597939%28v=exchg.80%29.aspx

Best Regards,
Diogo Miguel
0
0
28 Nov 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida

Thanks Diogo, that is very usefull.

0
0
28 Nov 2012
Copy Link
2022-11-12 11-28-30
Gonçalo Martins
Staff
Diogo Miguel wrote:
Hi Gonçalo,

You have to do an .Net Extension using ExchangeService to create an Appointment.
You will have to do something like this: https://msdn.microsoft.com/en-us/library/exchange/ff597939%28v=exchg.80%29.aspx

Best Regards,
Diogo Miguel
 
 Hi Diogo,

When you finish your solution it would be interesting to share it with the community, adding your solution to the one I described only using Outsystem logic.
Good luck on that.

Kind Regards,
Gonçalo Martins
0
0
28 Nov 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
0
0
30 Nov 2012
Copy Link
2013-03-12 12-27-41
Diogo Miguel
I and a teammate did this code to create the appointment in outlook.
I hope it help someone.


public void MssCreateAppoitment(string ssEmail, DateTime ssData, string ssAssunto, string ssDescricao, string ssUser_Exchange, string ssPassword_Exchange, string ssDominio_Exchange, string ssURL_Exchange, DateTime ssDuracao, bool ssAllDay, string ssCc_List) {
          
            //Connection
            ExchangeService service = new ExchangeService();
            service.Credentials = new NetworkCredential(ssUser_Exchange, ssPassword_Exchange, ssDominio_Exchange);
            service.Url = new Uri(@"Exchange URL");
            service.ImpersonatedUserId = new ImpersonatedUserId(ConnectingIdType.SmtpAddress, ssEmail);

            // Create the appointment.
            Appointment appointment = new Appointment(service);

            // Add item properties to the appointment.
            appointment.Body = new MessageBody();
            appointment.Body.BodyType = BodyType.Text;
            appointment.Body.Text = ssDescricao;
            appointment.Importance = Importance.High;
            appointment.ItemClass = "IPM.Appointment";
            appointment.Subject = ssAssunto;
            if(ssCc_List != ""){
                string[] emails = ssCc_List.Split(' ');
                foreach (string email in emails)
                {
                    appointment.RequiredAttendees.Add(email);
                }
            }
            appointment.Start = ssData;
            appointment.End = ssDuracao;
            appointment.IsAllDayEvent = ssAllDay;
            appointment.Save(SendInvitationsMode.SendOnlyToAll);
        } // MssCreateAppoitment

Best Regards,
Diogo Miguel
0
0
30 Nov 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida

Thanks Diogo, that will be very helpfull, yes.

0
0
30 Nov 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida
Hey guys,
I created this on forge: https://www.outsystems.com/NetworkForge/ProjectDetail.aspx?ProjectId=349

Feel free to comment and use.




1
0
04 Dec 2012
Copy Link
UserImage.jpg
Ma Raven Ann Araga

Hi is the component still available?


0
0
23 May 2023
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
UserImage.jpg
Ma Raven Ann Araga

Replying to Kilian Hekhuis' comment on 23 May 2023 09:24:15

Is there a component that can send an Outlook meeting invite?

0
0
24 May 2023
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Replying to Ma Raven Ann Araga's comment on 24 May 2023 03:28:26

Maybe iCalendar or ICalendar Connector? And then there's Add to Calendar. Note I haven't used any of these, but they popped up in the Forge search.

0
0
24 May 2023
Copy Link
UserImage.jpg
Ma Raven Ann Araga

Replying to Kilian Hekhuis' comment on 24 May 2023 09:23:39

Thanks for your reply, but the iCalendar and iCalendar Connector doesn't work. I have tried the Add to Calendar but it's giving me a wrong link. 

Hoping you can help me with this. 

Thank you!

0
0
29 May 2023
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Replying to Ma Raven Ann Araga's comment on 29 May 2023 06:03:39

I suggest you start a new topic on the forum, and if iCalendar and iCalendar connector don't work, ask question in the Forge asset's subforum. This topic is already more than 10 years old, so not very suited to attract many viewings. 

0
0
29 May 2023
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Well, I made a quick test to see whether it would work (simple edit record with all the parameters, calling the action from the extension), but alas it doesn't work. That is, it returns Error = false and empty error text, but no appointment is created.
0
0
04 Dec 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida
Kilian Hekhuis wrote:
Well, I made a quick test to see whether it would work (simple edit record with all the parameters, calling the action from the extension), but alas it doesn't work. That is, it returns Error = false and empty error text, but no appointment is created.
 
 
Hmmm...it worked for me.
What are the input parameters you're using? you don't need to say de password ;)
0
0
04 Dec 2012
Copy Link
2022-11-12 11-28-30
Gonçalo Martins
Staff
Gonçalo Almeida wrote:
 
 
Hmmm...it worked for me.
What are the input parameters you're using? you don't need to say de password ;)
 
Hello Gonçalo,

I think that the best way to show to Kilian and everyone that could be interested in this extension, is adding an eSpace showing the usage of your action and even some comments to certain steps I think that are important.
Just a tip ;-)

Kind Regards,
Gonçalo Martins
0
0
04 Dec 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Nothing weird. I supplied username/domain/password, begin/end date/time, subject, etc.

EDIT: Never mind, when renaming the action (it has a typo in it) Integration Studio found it necessary to create a new, empty action. I'll test it further and come back...
0
0
04 Dec 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Ok, after fixing the above, I now get this: "The expected XML node type was XmlDeclaration, but the actual type is Element." I'll do some more tests tomorrow to see if I can pinpoint the source of the problem...

EDIT: Couldn't resist doing a last test. It seems the AutodiscoverUrl  isn't working. Could be a permission thing, but I don't have time to look into it.
1
0
04 Dec 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida
I corrected the typo and uploaded a new version to the forge ;)
As for your last error Kilian, I can't help you.
0
0
04 Dec 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
It was indeed a problem with AutodiscoverUrl. When setting the Url property to the right URL, it works fine.
0
0
05 Dec 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida
Kilian Hekhuis wrote:
It was indeed a problem with AutodiscoverUrl. When setting the Url property to the right URL, it works fine.
 
 
Can you detail a little bit more?
You mean you're not using the AutodiscoverUrl?
0
0
05 Dec 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Yes, that's what I mean, AutodiscoverUrl didn't work for me. Apparently it's a setting in the server to allow this or not. But since we have a single Exchange server at a fixed location, directly setting the URL posed no problem.
0
0
05 Dec 2012
Copy Link
2018-11-09 09-14-06
Gonçalo Almeida
Kilian Hekhuis wrote:
Yes, that's what I mean, AutodiscoverUrl didn't work for me. Apparently it's a setting in the server to allow this or not. But since we have a single Exchange server at a fixed location, directly setting the URL posed no problem.
 
 
Hmmm, ok.
Can you paste the code you changed?
0
0
05 Dec 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

That's rather boring:

//service.AutodiscoverUrl(ssEmailFrom);

service.Url = new Uri((string)AppInfo.GetAppInfo().Tenant.SiteProperties["ExchangeConnector.ExchangeURL"]);

0
0
05 Dec 2012
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
Hi Kilian,

That's a really unsupported way to do it ... if you need a site property in an extension, pass the value as input parameter.


Regards,
João Rosado
0
0
06 Dec 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Hi João,

I took it from here: https://www.outsystems.com/NetworkForums/ViewTopic.aspx?Topic=Accessing-a-site-property-inside-some-extension, which is written by OutSystems staff (albeit quite a while ago). It works flawlessly, and passing parameters is not always an option (I have extensions that use a dozen site properties).

Best regards,

Kilian
0
0
06 Dec 2012
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
Hi,

Don't want to side-track this thread, but passing parameters is always an option.
If you have extensions using that type of code I recommend changing it.
That the particular line of code is actually deprecared at the moment. From what I know that shouldn't even work at all in 7.0.

Regards,
João Rosado
0
0
06 Dec 2012
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
João Rosado wrote:
Don't want to side-track this thread, but passing parameters is always an option.
If you have extensions using that type of code I recommend changing it.
That the particular line of code is actually deprecared at the moment. From what I know that shouldn't even work at all in 7.0.
 
We're using 6.0, so we're quite safe then. Good to know it's not available in 7.0, as we are considering moving to 7.0 in the near future. Of course it is always possible to pass parameters, but it can be quite cumbersome. I have an extension with some 20 actions, all of which need to know a bunch of configuration settings for connecting to external webservices (certificates, URLs, ports etc.), and having to pass all these every time I make a call is plain stupid. Perhaps OutSystems can actually do something about it, and provide a cleaner way to eSpace site properties, or, maybe even better, add site property-like functionality to extensions.


0
0
06 Dec 2012
Copy Link
UserImage.jpg
Carlos Monteiro
Sorry for ressurecting this post.
Is there any way to process the answers to an ics from our application?

For example, an attendee answers "yes" to an invite, it stores on google calendar and also on our application. Is it possible?
0
0
04 Apr 2014
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Antima,

First, you resurrected a post over three years old, and quoted a post that's over five years old. In general, it's better to create a new post (and reference the old one). This will get you more attention, and allow you to be more on target.

That said, I'm not sure what you want to achieve. You say you are sending an e-mail, and that e-mail has a link in it? Where does that link point to? And what do you mean by "convert the calendar events in ics file and send it as an attachment"? The ICS file is the attachment? Perhaps you could describe what you want to achieve, functionally.

0
0
21 Sep 2017
Copy Link
Post Closed