Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old August 23rd, 2007, 10:05 PM
Daniel
Guest
 
Posts: n/a
Default generate calendar appointments

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
Default 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
Default 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
Default 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
Default 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
Default 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
Default 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
Default 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/
 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles