Diary Milk

Introduction

Show The appointments of you and your colleagues, taking information from the central oracle calender server. At the moment, hard coded for UCL, but will consider alternatives if requested. here's some info on what it does and what you need to do More info soon!



Below are the notes I sent on method I used if it's useful.

you'll need..

to change the people.txt file.
to run the prog
to connect using a web browser to http://computername:7350

If you want to install opera (you should!)
Download it from www.opera.com (its now free)
Install it and run
Visit the page
Right click, reload every 1 minute
F11 to make it full screen

I'll write better notes soon!

JC

-------- Original Message --------
Subject: Oracle Calendar
Date: Wed, 08 Aug 2007 15:10:12 +0100
From: James Clements


Its a messy hack, but here's how I do it (there are some HTML tags in
this email, hopefully it won't confuse your email client!)

I use Delphi 2005 to control a TWebBrowser component, which is just IE
in a control, and then extract the HTML from that.  Anything capable of
sessions (to maintain the login) should be fine.

Firstly log in to:

https://www.diary.ucl.ac.uk/ocas-bin/ocas.fcgi?sub=web&web=login&cgi-path=/ocas-bin/&from_lf=on&js_enabled=false&ada=on&server=&srch_query=USERNAME&srch_xitemid=&password=PASSWORD&ok=ok&ada=on

replacing USERNAME and PASSWORD with your details (I said this was messy!)

then for each person visit:

http://www.diary.ucl.ac.uk/ocas-bin/ocas.fcgi?sub=web&web=viewpub&ada=on&date=TODAYSDATE&view=day&searchTextField=&radioSearch=pub_name_radio&resultSelect=UNIQUEID/1&viewform.x=21&viewform.y=12
replacing UNIQUEID with their user id, and TODAYSDATE with date in the
format: yyyy/mm/dd

To get this ID, I logged into the web diary, and then went to view
anothers diary, and when you add them to the list you can look at the
html and get the number from there..

so if i try for me, it gives..

<OPTION VALUE="1099/1" selected>James Clements</OPTION>

so my number is 1099

Hoping you'll be ok with the extraction of information from the pages,
but here's how I do it...

I check the HTML for the highest value of meetingNumX (where X is is the
number to get the number of meeting on that page, and do the same for
specialNumX

then I grab each meeting from =meetingNumX to </FONT>, using these markers:

</A> is start of times
<BR> is end of times + start of info
</FONT is end of info

then I grab the specials (day notes), from specialNumX to </FONT> again.
Most of these I filter out, since they are usually not work related, and
only include shift and holiday related notes.

And that's pretty much it.  I also do a little extra processing to
remove redundant information because of the way we do holidays to avoid
duplicated information, but hopefully you should need this.

If it doesn't go well or you can't find the time, let me know and I'll
schedule in some time to cleaning up my code and making it configurable.
I'm still working on the network documentation code (and well as all the
usual day-to-day ops work) and am off next week, but should be able to
sort out something in a few weeks time (you may have to prompt me!)

Cheers,

James.

Screenshot

None at present

Download

This should be considered a pre-alpha proof-of-concept. It does work though.
Diary Milk v0.01
UCL NWG Staff can see more info and view our one here: here