[Year 12 IT Apps] OT/ Timetable

[fiona at balmoralhs.vic.edu.au]

you can also export in .xmls (you need to do this for the end of year rollovers for markbook)
"Alexakos, Zach Z" <alexakos.zach.z at edumail.vic.gov.au> on Thu, 15 Feb 2007 22:10:23 +1100 wrote:
> 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, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.


---
Fiona Bain, Balmoral High School