×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Writing Calender appointments to Exchange 2016

Writing Calender appointments to Exchange 2016

Writing Calender appointments to Exchange 2016

(OP)
I have a VFP client server system running with MS SQL backend where users can create diary appointments within the VFP system but I have a client who is wanting these to appear in their Exchange Server Calendars as well.

I have no experience of MS Exchange and was wondering if this is something any of you guy's may have done and can offer some pointers/advice.

My altenative is to find/have writtain an API that can pick up the data from SQL and push it out to Exchange.

Can anyone help?

Bob Palmer
www.resisystems.co.uk
The most common solution is H2O!

RE: Writing Calender appointments to Exchange 2016

(OP)
Hi Mike,
Some users do but not all. They have a mobile app that posts back to our systems SQL as well which complicates things.
I have read your threads on Outlook integration and for small local apps used some of that but Exchange Server is a different animal to me.

Bob Palmer
www.resisystems.co.uk
The most common solution is H2O!

RE: Writing Calender appointments to Exchange 2016

I do something like this, you will need to work out the details

CODE

SET CONSOLE OFF
				SET ALTERNATE TO (M.TEMPDIR+"Order Event.ics")
				SET ALTERNATE ON
				? "BEGIN:VCALENDAR"
				? "  VERSION:2.0"
				? "  METHOD:PUBLISH"
				? "  X-WR-CALNAME:FINECOSTS"
				? "  BEGIN:VEVENT"
				? "    UID:"+TRIM(M.FULLORDERNO)
				? "    DTSTAMP:"+DTOS(FCTORDR.DATE)+"T09150000Z"
				? "    DTSTART:"+DTOS(FCTORDR.DATEREQD)+"T09160000Z"
				? "    DTEND:"+DTOS(FCTORDR.DATEREQD)+"T09160000Z"
				? "    CATEGORIES:Orders Category"
				? "    X-ALT-DESC;FMTTYPE=text/html:<!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN><html><body><font COLOR='#4F81BD' size=3 FACE='Verdana'><span><b>Finecosts Order Alert "+M.FULLORDERNO+"</span></font></span></html></body>"
				? "    LOCATION:Site"
				? "    SUMMARY:Purchase Order Due for Delivery On : "+DTOL(FCTORDR.DATEREQD)
				? "    PRIORITY:5"
				? "    BEGIN:VALARM"
				? "      ACTION:DISPLAY"
				? "      DESCRIPTION:REMINDER"
				? "      TRIGGER:-PT15M"
				? "    END:VALARM"
				? "    X-PUBLISHED-TTL:PT15M"
				? "  END:VEVENT"
				? "END:VCALENDAR"

				SET ALTERNATE OFF
				SET ALTE TO				
				SET CONSOLE ON
				IF !EMPTY(FCTUSER.EMAIL)
					SECUREEMAIL(m.SMTPSERVER,m.SMTPNAME,m.SMTPUSERNAME,m.SMTPPASSWORD,TRIM(FCTUSER.EMAIL),"Order Raised to "+M.SUPPLIER+" No. : "+TRIM(M.FULLORDERNO),"Order Raised to "+M.SUPPLIER+" No. : "+TRIM(M.FULLORDERNO)+m.crlf+"Please open Order Event.ics attachment to get delivery reminder"+m.crlf+"by adding appointment to your calendar",587,m.FILENAME,M.TEMPDIR+"Order Event.ics")
				ENDIF 

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Writing Calender appointments to Exchange 2016

Bob,

I'm trying to gather this type of information and documentation for Lotus Notes, but for your requirements, this may be useful: https://docs.microsoft.com/en-us/exchange/client-d....

In particular, the Web Services section documents a rich SOAP-based API that allows any system and language to talk to an Exchange Server. For instance, to create a calendar event: https://docs.microsoft.com/en-us/exchange/client-d....

[If you or anyone else has a similar reference for Lotus Notes that I could be lead to, I would be much obliged].

RE: Writing Calender appointments to Exchange 2016

It's been 20 years since I brushed up against Lotus Notes.

At that time a consultant recommended to us by a VP at Lotus told me "you'll never be able to get data from Notes without a custom API I'll write for you".

Phooey on that. The day they installed Notes on my computer I started spelunking the registry and found the exposed COM interfaces. Notes (and Notes people) consider it a closed box, but it really isn't.

I'm sure the information you seek is out there, but expect to have to claw and dig for it.

RE: Writing Calender appointments to Exchange 2016

Thank you, Dan, I found some IBM documentation on this (an overall reference at https://www-10.lotus.com/ldd/ddwiki.nsf/xpAPIViewe...). Unfortunately I won't be able to test it or work on it, since the client decided to not have other applications connecting to their calendar data directly.

Meanwhile, if anyone is interested or in need to build or read ICS files and data, there is an iCal4VFP library available at the VFPX site / GitHub at https://github.com/atlopes/iCal4VFP.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close