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
Daniel wrote:
> 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
==================
On Aug 23, 4:56 pm, Daniel
> 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/Sugar_Plug-in_for_Outlook_ 4.5.1/Sugar%20Outlook%20Plug-In_4.5.1.2.7.html
I would try barking up that source tree.
ELINTPimp wrote:
> On Aug 23, 4:56 pm, Daniel
>> 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/Sugar_Plug-in_for_Outlook_ 4.5.1/Sugar%20Outlook%20Plug-In_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
==================
Daniel wrote:
> 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/08/19/trivial-encoder/
On Aug 24, 4:17 am, Toby A Inkster
wrote:
> Daniel wrote:
> > 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/08/19/trivial-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/10MinuteSolution/20508/0/page/ 1
Daniel
On Aug 24, 8:17 am, Daniel
> On Aug 24, 4:17 am, Toby A Inkster
> wrote:
>
> > Daniel wrote:
> > > 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/08/19/trivial-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/10MinuteSolution/20508/0/page/ 1
>
> Daniel
Here one more really good source to learn from.
http://www.phpbuilder.com/columns/chow20021007.php3?print_mo de=1
Daniel
Daniel wrote:
> 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/10MinuteSolution/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/08/19/trivial-encoder/