[Year 12 IT Apps] OT/ Timetable

[Alexakos, Zach Z]

Thanks Robert, 

that is very useful information as the office end has been telling me
that only excel ss files were possible.  

 

I'll chase that one up.  

 

Zach Alexakos

 

________________________________

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Timmer-Arends
Sent: Thursday, 15 February 2007 4:46 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] OT/ Timetable

 

 

Hello Zach

 

not wishing to defend CASES21 at all (we stopped using it for
timetabling and moved to TimeTable Solutions), but re

 

>Also did you know that CASES only exports in Microsoft Excel?  You
can't even get a Text file out of it.

 

You can export text files (as CSV) - I do it all the time to collect
data for MarkBook. You need to be given access to the Export Utility and
once you enter it there are many standard exports and you can also
create your own. To do the latter you need to nut out the CASES schema
to some extent and knowing some SQL helps as well. There is an
MS-Access-like query grid but it's a bit clunky and seems to get lost if
you try something too complex (...but apart from that, what else have
the Romans done for us??)

 

All-in-all, if you only intend to export a particular data set once then
the Quick list which generates an Excel SS is the best way to go (by the
way, watch out for the macro - or something - that gets embedded in the
sheet!). Otherwise, for regular export, coming to grips with the export
tools is well worth the trouble.

 

Regards

Robert T-A

Brighton SC

_______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and 
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc


Important - This email and any attachments may be confidential. If received=
 in error, please contact us and delete all copies. Before opening or using=
 attachments check them for viruses and defects. Regardless of any loss, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070215/e7349a98/attachment-0001.html