Connecting Tech Pros Worldwide Help | Site Map

generate calendar appointments

  #1  
Old August 23rd, 2007, 10:05 PM
Daniel
Guest
 
Posts: n/a
Hello,

Could someone point me in the right direction. I have a db with event
info (date, time, location,...) and would like to be able to generate
a file that the user can click on so that the event is added to their
Outlook calendar. Is there a standard format for such a file or name
for this? Where can I get information to be able to program the
creation of this file?

Thank you for your time and help,

Daniel

  #2  
Old August 24th, 2007, 01:25 AM
Jerry Stuckle
Guest
 
Posts: n/a

re: generate calendar appointments


Daniel wrote:
Quote:
Hello,
>
Could someone point me in the right direction. I have a db with event
info (date, time, location,...) and would like to be able to generate
a file that the user can click on so that the event is added to their
Outlook calendar. Is there a standard format for such a file or name
for this? Where can I get information to be able to program the
creation of this file?
>
Thank you for your time and help,
>
Daniel
>
Maybe try an Outlook newsgroup? Find out what format you need, then see
how to do it.

But you'll probably find it can't be done from the server - otherwise I
could fill your Outlook calendar with all kinds of bogus "appointments".

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
  #3  
Old August 24th, 2007, 02:45 AM
ELINTPimp
Guest
 
Posts: n/a

re: generate calendar appointments


On Aug 23, 4:56 pm, Daniel <d_pinea...@hotmail.comwrote:
Quote:
Hello,
>
Could someone point me in the right direction. I have a db with event
info (date, time, location,...) and would like to be able to generate
a file that the user can click on so that the event is added to their
Outlook calendar. Is there a standard format for such a file or name
for this? Where can I get information to be able to program the
creation of this file?
>
Thank you for your time and help,
>
Daniel
SugarCRM (PHP/MySQL) manages to do it:

http://www.sugarcrm.com/docs/Misc/Su...4.5.1.2.7.html

I would try barking up that source tree.

  #4  
Old August 24th, 2007, 02:55 AM
Jerry Stuckle
Guest
 
Posts: n/a

re: generate calendar appointments


ELINTPimp wrote:
Quote:
On Aug 23, 4:56 pm, Daniel <d_pinea...@hotmail.comwrote:
Quote:
>Hello,
>>
>Could someone point me in the right direction. I have a db with event
>info (date, time, location,...) and would like to be able to generate
>a file that the user can click on so that the event is added to their
>Outlook calendar. Is there a standard format for such a file or name
>for this? Where can I get information to be able to program the
>creation of this file?
>>
>Thank you for your time and help,
>>
>Daniel
>
SugarCRM (PHP/MySQL) manages to do it:
>
http://www.sugarcrm.com/docs/Misc/Su...4.5.1.2.7.html
>
I would try barking up that source tree.
>
This uses an special Outlook plugin - which is neither PHP nor MySQL.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
  #5  
Old August 24th, 2007, 10:05 AM
Toby A Inkster
Guest
 
Posts: n/a

re: generate calendar appointments


Daniel wrote:
Quote:
a file that the user can click on so that the event is added to their
Outlook calendar. Is there a standard format for such a file or name
for this?
Yes, it's called iCalendar.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 64 days, 11:56.]

TrivialEncoder/0.2
http://tobyinkster.co.uk/blog/2007/0...ivial-encoder/
  #6  
Old August 24th, 2007, 01:25 PM
Daniel
Guest
 
Posts: n/a

re: generate calendar appointments


On Aug 24, 4:17 am, Toby A Inkster <usenet200...@tobyinkster.co.uk>
wrote:
Quote:
Daniel wrote:
Quote:
a file that the user can click on so that the event is added to their
Outlook calendar. Is there a standard format for such a file or name
for this?
>
Yes, it's called iCalendar.
>
--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 64 days, 11:56.]
>
TrivialEncoder/0.2
http://tobyinkster.co.uk/blog/2007/0...ivial-encoder/
It took a while but I finally found a great article that covers
exactly this. It create a file that the user clicks on and then get
sent to their calendar. If interested you can see it at

http://www.devx.com/getHelpOn/10Minu...20508/0/page/1

Daniel

  #7  
Old August 24th, 2007, 03:15 PM
Daniel
Guest
 
Posts: n/a

re: generate calendar appointments


On Aug 24, 8:17 am, Daniel <d_pinea...@hotmail.comwrote:
Quote:
On Aug 24, 4:17 am, Toby A Inkster <usenet200...@tobyinkster.co.uk>
wrote:
>
Quote:
Daniel wrote:
Quote:
a file that the user can click on so that the event is added to their
Outlook calendar. Is there a standard format for such a file or name
for this?
>
Quote:
Yes, it's called iCalendar.
>
Quote:
--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 64 days, 11:56.]
>>
It took a while but I finally found a great article that covers
exactly this. It create a file that the user clicks on and then get
sent to their calendar. If interested you can see it at
>
http://www.devx.com/getHelpOn/10Minu...20508/0/page/1
>
Daniel
Here one more really good source to learn from.

http://www.phpbuilder.com/columns/ch...3?print_mode=1

Daniel

  #8  
Old August 25th, 2007, 12:05 AM
Toby A Inkster
Guest
 
Posts: n/a

re: generate calendar appointments


Daniel wrote:
Quote:
It took a while but I finally found a great article that covers
exactly this. It create a file that the user clicks on and then get
sent to their calendar. If interested you can see it at
>
http://www.devx.com/getHelpOn/10Minu...20508/0/page/1
Indeed. iCalendar is a very nifty format. You should also look up
hCalendar as it may be of interest: it's a mapping of vCalendar
semantics to HTML, and there are various tool to convert between
the two. There's also such a thing as xCalendar, an XML serialisation
of vCalendar, though in practise there is very little software that
supports it.

I did a bunch of research on this sort of thing a few months ago as
I've written support for my CMS to offer feeds in iCalendar as well
as the usual suspects like RSS and Atom.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 65 days, 2:17.]

TrivialEncoder/0.2
http://tobyinkster.co.uk/blog/2007/0...ivial-encoder/
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Move, Edit or Delete any Recurring Appointments - Outlook 20 =?Utf-8?B?TWVlbWEgSnVkeQ==?= answers 0 July 18th, 2008 04:25 AM
Interfaces to MS Exchange/Outlook to add Calendar appointments or =?Utf-8?B?RU1jQ2FydGh5?= answers 2 March 13th, 2008 01:25 PM
Recurring appointments philosophy steve answers 1 November 21st, 2005 09:11 PM
Recommendations on how to speed up code Wilk Teverbaugh answers 8 July 19th, 2005 09:45 AM