Scheduling of RT tickets or calendar integration?

RT Users
1

Hi,
is there any way to schedule tickets in RT and have these displayed in
some kind of calendar, webcal or similar?

It would be nice to be able to view available dates/times and then
schedule tickets to these empty
’slots’ .

I cant find any mention of this functionality on the wiki or google.

Thanks
Mike

2

is there any way to schedule tickets in RT and have these displayed in
some kind of calendar, webcal or similar?

It would be nice to be able to view available dates/times and then
schedule tickets to these empty
‘slots’ .

I cant find any mention of this functionality on the wiki or google.

This is something I’d like, too, and I’m not sure it’s possible to the
degree we’d like. I suspect you’d have to find a way to key-number the
time slots in a week, and cross link it to a resource scheduling
calendar manually.

Cheers,
– jra
Jay R. Ashworth jra@baylink.com
Designer Baylink RFC 2100
Ashworth & Associates The Things I Think '87 e24
St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274

  If you can read this... thank a system administrator.  Or two.  --me
3

I sent this to the list 6 months ago, just wondered if anybody had
found a decent
way around this one?

thanks
Mike---------- Forwarded message ----------
From: Mike Dent mcdent@gmail.com
Date: Jun 9, 2005 7:32 PM
Subject: Scheduling of RT tickets or calendar integration?
To: rt-users@lists.bestpractical.com

Hi,
is there any way to schedule tickets in RT and have these displayed in
some kind of calendar, webcal or similar?

It would be nice to be able to view available dates/times and then
schedule tickets to these empty
‘slots’ .

I cant find any mention of this functionality on the wiki or google.

Thanks
Mike

4

Mike Dent wrote:

I sent this to the list 6 months ago, just wondered if anybody had
found a decent
way around this one?

thanks
Mike

---------- Forwarded message ----------
From: Mike Dent mcdent@gmail.com
Date: Jun 9, 2005 7:32 PM
Subject: Scheduling of RT tickets or calendar integration?
To: rt-users@lists.bestpractical.com

Hi,
is there any way to schedule tickets in RT and have these displayed in
some kind of calendar, webcal or similar?

It would be nice to be able to view available dates/times and then
schedule tickets to these empty
‘slots’ .

I cant find any mention of this functionality on the wiki or google.

Thanks
Mike

Mike,

I have recently created a link from RT to a web calendar

It’s a bit of a hack but it seems to work OK. Basically whenever a
“Starts” or “Due” date is set in a ticket, it creates an entry in the
calendar for that user. At the moment you have to have the same user
names in webcal and RT. I have a global scip that fires of a perl script
to create the calendar entries. Be warned the RT scrip is very rough,
and the perl code even rougher !

I have just had a quick look at the code and it does actually remap one
RT user to a different Webcal user. A real programmer may be able to use
this as a basis for a real interface.

Scott Muller smuller@netcommplete.com.au
Senior Communications Consultant Mobile : +61 (0)4388 300 82
NetCommplete Pty Ltd Phone : +61 (0)2 6331 4773
http://www.netcommplete.com.au Fax : +61 (0)2 6331 4909

5

I have recently created a link from RT to a web calendar
http://www.k5n.us/webcalendar.php

It’s a bit of a hack but it seems to work OK. Basically whenever a
“Starts” or “Due” date is set in a ticket, it creates an entry in the
calendar for that user. At the moment you have to have the same user
names in webcal and RT. I have a global scip that fires of a perl script
to create the calendar entries. Be warned the RT scrip is very rough,
and the perl code even rougher !
I’m running a different webcalendar and have some interface code lying
around for syncing with a Palm. Would you post your code to the list so
that I, and maybe others, can use it as a starting point for
intergrating RT and our webcal.
(http://www.math.utexas.edu/users/mzou/webCal/index.html)

Thanks in advance,

Joop

Joop van de Wege JoopvandeWege@mococo.nl

6

Scott Muller wrote:

Mike Dent wrote:

I sent this to the list 6 months ago, just wondered if anybody had
found a decent
way around this one?

thanks
Mike

---------- Forwarded message ----------
From: Mike Dent mcdent@gmail.com
Date: Jun 9, 2005 7:32 PM
Subject: Scheduling of RT tickets or calendar integration?
To: rt-users@lists.bestpractical.com

Hi,
is there any way to schedule tickets in RT and have these displayed in
some kind of calendar, webcal or similar?

It would be nice to be able to view available dates/times and then
schedule tickets to these empty
‘slots’ .

I cant find any mention of this functionality on the wiki or google.

Thanks
Mike

Mike,

I have recently created a link from RT to a web calendar
http://www.k5n.us/webcalendar.php

It’s a bit of a hack but it seems to work OK. Basically whenever a
“Starts” or “Due” date is set in a ticket, it creates an entry in the
calendar for that user. At the moment you have to have the same user
names in webcal and RT. I have a global scip that fires of a perl
script to create the calendar entries. Be warned the RT scrip is very
rough, and the perl code even rougher !

I have just had a quick look at the code and it does actually remap
one RT user to a different Webcal user. A real programmer may be able
to use this as a basis for a real interface.

Another possibility would be to have an iCal feed, similar to the
current RSS feeds. I have some code around to generate those (not from
RT), and then you can use the resulting URL as a ‘subscription’ in any
calendar app that supports iCal. I don’t use the dates in RT at all, so
it’s not really any use to me, but I think it would be a more ‘standard’
way to do it.

Could you post your code, Scott?

7

Scott Muller wrote:

Mike Dent wrote:

I sent this to the list 6 months ago, just wondered if anybody had
found a decent
way around this one?

thanks
Mike

---------- Forwarded message ----------
From: Mike Dent mcdent@gmail.com
Date: Jun 9, 2005 7:32 PM
Subject: Scheduling of RT tickets or calendar integration?
To: rt-users@lists.bestpractical.com

Hi,
is there any way to schedule tickets in RT and have these displayed in
some kind of calendar, webcal or similar?

It would be nice to be able to view available dates/times and then
schedule tickets to these empty
‘slots’ .

I cant find any mention of this functionality on the wiki or google.

Thanks
Mike

Mike,

I have recently created a link from RT to a web calendar
http://www.k5n.us/webcalendar.php

It’s a bit of a hack but it seems to work OK. Basically whenever a
“Starts” or “Due” date is set in a ticket, it creates an entry in the
calendar for that user. At the moment you have to have the same user
names in webcal and RT. I have a global scip that fires of a perl
script to create the calendar entries. Be warned the RT scrip is very
rough, and the perl code even rougher !

I have just had a quick look at the code and it does actually remap
one RT user to a different Webcal user. A real programmer may be able
to use this as a basis for a real interface.

Another possibility would be to have an iCal feed, similar to the
current RSS feeds. I have some code around to generate those (not from
RT), and then you can use the resulting URL as a ‘subscription’ in any
calendar app that supports iCal. I don’t use the dates in RT at all, so
it’s not really any use to me, but I think it would be a more ‘standard’
way to do it.

Could you post your code, Scott?

Yes, getting the schedule in to iCal would be most excellent!
I believe Webcalendar allows the import of iCal cal formats too.

Mike

8

Hi RT Users,

Today i got a strange error on a new installed RT Box. I’m running Apache
1.3 and Mod_fastcgi, both installed from scratch.

If i try to start the apache i got:

Syntax error on line 957 of /etc/httpd/httpd.conf:
FastCgiServer /opt/rt3/bin/mason_handler.fcgi: User/Group commands must
preceed FastCGI server definitions

My httpd.conf looks like:

User wwwrun
Group nogroup

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 150 -processes 8
-listen-queue-depth 200 -priority 5

<VirtualHost *>
ServerName rt.domain.de
ServerAdmin admin@domain.de
DocumentRoot /opt/rt3/share/html
AddHandler fastcgi-script .fcgi
Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/
ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/

Does anyone know what the error means??? I googled the whole day without
success.

Thanks for any kind of help.

Thanks in advance
…
: Torsten Brumm
: IT Security Engineer
:
: Kuehne + Nagel
: HAM - MI-C
:
: Ferdinand Strasse 29-33
: 20095 Hamburg
:
: +49 (40) 329 15 199
: +49 (40) 329 15 500
:
: torsten.brumm@kuehne-nagel.com
: www.kn-portal.com
: icq: 78258840
…

9

Howard Jones wrote:

Another possibility would be to have an iCal feed, similar to the
current RSS feeds. I have some code around to generate those (not from
RT), and then you can use the resulting URL as a ‘subscription’ in any
calendar app that supports iCal. I don’t use the dates in RT at all, so
it’s not really any use to me, but I think it would be a more ‘standard’
way to do it.

Could you post your code, Scott?

Howard,

I will dig it out and post it in the next few days, when I’m back in the
office.

Scott.

10

Here is a link to the code for the webcalendar integration.

The RT scrip:
http://info.netcommplete.com.au/rtscrip.txt

Lots of debugging in it. This works by using the ‘Starts’ and ‘Due’
field as well as an optional customfield ‘Duration’. as long as the
ticket has an owner and one of the date fields is set, then it creates
and appointment. I have a list of requested changes from the guys at
work, but I haven’t had a chance to implement them, as the code needs to
be cleaned up before it gets any more ugly. Hopefully this will help
someone create a functional interface with decent error checking etc.
Having this functionality built into RT would be really cool, but well
beyond my abilities :frowning:

The Perl Code:
http://info.netcommplete.com.au/webcal.txt

This code is really thrown together. Basically I turned on mysql logging
and then created, altered and deleted webcalendar appointments. I then
watched the logs to see what happened to the database. I then mirrored
this logic in the code. (I Hope !)

Versions:
WebCalendar v1.0.1 (19 Aug 2005)
RT 3.4.2

Scott Muller smuller@netcommplete.com.au
Senior Communications Consultant Mobile : +61 (0)4388 300 82
NetCommplete Pty Ltd Phone : +61 (0)2 6331 4773
http://www.netcommplete.com.au Fax : +61 (0)2 6331 4909

11

Here is a link to the code for the webcalendar integration.

The RT scrip:

http://info.netcommplete.com.au/rtscrip.txt

Lots of debugging in it. This works by using the ‘Starts’ and ‘Due’
field as well as an optional customfield ‘Duration’. as long as the
ticket has an owner and one of the date fields is set, then it creates
and appointment. I have a list of requested changes from the guys at
work, but I haven’t had a chance to implement them, as the code needs to
be cleaned up before it gets any more ugly. Hopefully this will help
someone create a functional interface with decent error checking etc.
Having this functionality built into RT would be really cool, but well
beyond my abilities :frowning:

The Perl Code:

http://info.netcommplete.com.au/webcal.txt

This code is really thrown together. Basically I turned on mysql logging
and then created, altered and deleted webcalendar appointments. I then
watched the logs to see what happened to the database. I then mirrored
this logic in the code. (I Hope !)

Versions:
WebCalendar v1.0.1 (19 Aug 2005)
RT 3.4.2

Hi Scott,
I’d be interested to know if you did any more work on this code?

thanks
Mike