Automated Daily copy from table calendar

erikj · September 25, 2008

I have a room reservation systtem that has a web based viewer for staff members. I am automating a script to pull the events of the current day - room #, event name and time. place these events into an excel document, which will subsequently automatically be viewed in the kiosk. I have everything down up to the point where the autoit script copies the event/room/time and pastes it into my excel doc. Cannot figure out how to make it work. any help would be appreciated!

#include <IE.au3>
#Include <Date.au3>
#include <Array.au3>
#include <ExcelCOM_UDF.au3>
$oIE = _IECreate()
_IENavigate($oIE, "http://128.164.182.42:8001/Calendar/")
$oFrame = _IeFrameGetObjByName ($oIe, "buttonbar")
Sleep(750)
Send("{Enter}")
$oform = _IEFormGetObjByName($oFrame, "CalForm")
$oSelect = _IEFormElementGetObjByName ($oForm, "calendar")
 _IEFormElementOptionselect ($oSelect, "All_Room_View", 1, "byText")
Sleep(1000)
Send("{Tab}")
Send("{Tab}")
Send("{Enter}")
        
        
Sleep(750)
$oFrame = _IEFrameGetObjByName ($oIE, "mainframe")
$oTable = _IETableGetCollection ($oIE, 10)
$aTableData = _IETableWriteToArray ($oTable, True)
_IELoadWait($oIE)
$todayevent = "c:\todaysevents.xlsx"
$oExcel= _ExcelBookOpen($todayevent)
sleep(1500)
_ExcelWriteSheetFromArray($oExcel, $aTableData, 3)

sleep(1500)

the html from the viewer looks something like this

CODE

<TR>

Events For Today Wednesday September 24, 2008 - Forward 0 Days

</TD>

</TR>

<TD BACKGROUND="./Calendar_art2/bluegrad2.gif">Event Name</TD>

<TD BACKGROUND="./Calendar_art2/bluegrad2.gif">Event Details</TD><TR>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Wednesday , <A HREF=calendar.cgi/calendar.cgi?offset=20&calendar=./All_Room_View&day=24&year=2008&month=9&session_file=1222303895534&view_day=on style=color:990033>9/24/2008</A></TD>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Capitol Educators Meeting</TD>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Names are: 208{2134-G-St.}Deans-Conference-12max, All Room View, tebattle Keyword: None Label: None Agenda: Name: Tee Battle Phone: 4-6161 Event Title: Capital Educators Meeting E-mail: tebattle@gwu.edu Room: 208 (Reserved for Deans) - Cap. 12 Start time: 10:30 AM End time: 12:00 PM Date: September : 24 : 2008</TD></TR>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Wednesday , <A HREF=calendar.cgi/calendar.cgi?offset=20&calendar=./All_Room_View&day=24&year=2008&month=9&session_file=1222303895534&view_day=on style=color:990033>9/24/2008</A></TD>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Names are: All Room View, B08{2134-G}-12max, billym Keyword: None Label: None Agenda: Name: Billy Molasso Phone: 4-0839 Event Title: HEA E-mail: billym@gwu.edu Room: B08(2134 G St) - Cap. 12 Start time: 11:00 AM End time: 12:00 PM Date: September : 24 : 2008 Attendees: 5</TD></TR>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Wednesday , <A HREF=calendar.cgi/calendar.cgi?offset=20&calendar=./All_Room_View&day=24&year=2008&month=9&session_file=1222303895534&view_day=on style=color:990033>9/24/2008</A></TD>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Elementary Education Seminar</TD>

<TD BGCOLOR="#ffffff"VALIGN="top" class="milummain" style="color:990033">Names are: 312{2134-G}-10max, All Room View, sbeck Keyword: None Label: None Agenda: Name: Sylven Beck Phone: x49084 Event Title: Elem Ed Seminar E-mail: sbeck@gwu.edu Room: 312 (2134 G St.) - Cap. 10 Start time: 2:00 PM End time: 3:30 PM Date: September : 24 : 2008 Attendees: 6</TD></TR>

<TD BGCOLOR="#DBE4F8" COLSPAN=4 CLASS="milummain">Event Colors Represent The Number of Day Until The Event : Red = Today, Orange = Tomorrow , Green = Three Days Away & Blue = More Than 3 Days Away</TD>

</TD>

</TR>

</TABLE>

</BODY>

Sign In

Automated Daily copy from table calendar

Recommended Posts

erikj

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Browse

AutoIt Resources

Release

Beta