Connecting Tech Pros Worldwide Forums | Help | Site Map

generate calendar appointments

Daniel
Guest
 
Posts: n/a
#1: Aug 23 '07
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


Jerry Stuckle
Guest
 
Posts: n/a
#2: Aug 24 '07

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
==================
ELINTPimp
Guest
 
Posts: n/a
#3: Aug 24 '07

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.

Jerry Stuckle
Guest
 
Posts: n/a
#4: Aug 24 '07

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
==================
Toby A Inkster
Guest
 
Posts: n/a
#5: Aug 24 '07

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/
Daniel
Guest
 
Posts: n/a
#6: Aug 24 '07

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

Daniel
Guest
 
Posts: n/a
#7: Aug 24 '07

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

Toby A Inkster
Guest
 
Posts: n/a
#8: Aug 25 '07

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