[AG-TECH] Automated room booking.

[Jackie Kern]

So during the Retreat Shawn Davis and myself will be giving a talk about AG 
Schedule.  It seems that these two things are closely related.  We have 
developed a calendaring system that will assign virtual venues, house 
powerpoint files for distribution, and show a link to the beacon 
information for the participating sites.  We used portions of this system 
during SuperComputing for the SC Global event. (mainly the PowerPoint 
portion)  This system will also take local time and convert it to UTC.

Please attend the talk if you are going to the retreat.  We will be 
answering questions and looking for feedback on our system.

Thanks
Jackie Kern



At 01:30 PM 2/28/2002 -0600, Ivan R. Judson wrote:

>Cool.
>
>Here's how I mucked mrbs to do timezones:
>
>On the index page, have a little javascript that grabs the timezone then
>passes it to a second index page that is the actual content page.
>
>It's an icky method, but you can capture the client timezone that way and
>keep only UTC/GMT times in the database and transform them on a per client
>basis.
>
>--Ivan
>
> > -----Original Message-----
> > From: owner-ag-tech at mcs.anl.gov [mailto:owner-ag-tech at mcs.anl.gov]On
> > Behalf Of S.Booth
> > Sent: Thursday, February 28, 2002 11:08 AM
> > To: s.booth at epcc.ed.ac.uk
> > Cc: ag-tech at mcs.anl.gov
> > Subject: Re: [AG-TECH] Automated room booking.
> >
> >
> > On Mon, 11 Feb 2002, S.Booth wrote:
> >
> > > On Tue, 29 Jan 2002, S.Booth wrote:
> > >
> > > >
> > > > The AG framework is potentially very useful for short ad-hoc
> > meetings but
> > > > the current booking mechanism is not really set up for this.
> > > > It would help if any bookings for a venue showed up on the
> > virtual venue
> > > > page, and even better add booking information to the doors in
> > the lobby
> > > > so people can see if a room is free before entering. This
> > will help with
> > > > the newbie problem (speaking as a newbie myself)
> > > >
> > >
> > > I'm going to have a go at adding automated room booking to the virual
> > > venues server. All the hard stuff (authentication, DB access etc) is
> > > already in the server so it should not be too hard.
> > >
> > > I'm planning something very simple, a booking page that lets you
> > > view existing booking or select a room, start time and duration. And add
> > > a listing of todays bookings to the to room descriptions and the room
> > > entry.
> > >
> > > If anyone else is working on something similar let me know.
> > >
> >
> > OK I have had a go at this and have something working.
> >
> > I have attached a tarfile of changes to the vvenue software.
> > index.php and ag-tables.sql are changed the rest are new files.
> > you need to apply the changes before configuring the venues as it needs to
> > create a new database table.
> >
> > I have simple automated room booking.
> > You can delete your own bookings by going to the booking form for the day
> > in question.
> >
> > Each room page contains a table of the bookings for that day with
> > currently active bookings in bold.
> >
> > Each room link also has such a table if there is an active booking in that
> > room.
> >
> > There are 2 main problems at the moment
> >
> > 1) old bookings are not deleted automatically.
> > 2) At the moment it all works in a single time-zone as all dates etc are
> > handled by the database and I have not worked out how to switch the
> > timezone of displayed times on a request by request  basis.
> >
> > I'll continue to work on this but I thought I should let people have a
> > look.
> >
> >               Stephen
> >
> > ======================================================================
> > |epcc| Dr Stephen P Booth             Project Manager           |epcc|
> > |epcc| s.booth at epcc.ed.ac.uk          Phone 0131 650 5746       |epcc|
> > ======================================================================
> >