CMIS Export of room data into format for room booking system
I am currently making an enquiry to establish whether the following is possible in CMIS.
Enquiring with a number of companies about a resource booking system built using web technologies (so can be access via a web browser in school or out of school), the system we are looking for is quite bespoke, for this to happen I need to pull out certain information from our MIS system CMIS and the information I need is
Every room in the school that could be booked (classrooms, lecture rooms, IT rooms, hall) along with the teacher who is teaching for that period (if its a classroom) and the lesson being taught in there (e.g. biology, maths etc).
I then need this information in either a comma separated CSV or text format, XML would be great also.
I know in CMIS there is a way to do this but you can only print this information out, not been able to find a way to do this via an export.
Has anyone else done something along the lines to this.
If anyone could help it would be greatly appreciated.