howsono

We're moving to Bromcom apparently. Does anyone know if I can schedule reports to save or email specific reports/filters at a particular time?

Hrm - SQLManager - even that is dodgey difficult in this place. Waiting for chap to get back to me about API. One example - we sent letters when students get 10 negatives in a term. So every morning an admin has to log on and run a report, move things around, mail merge etc... I want an automatic list emailed to directors each morning.

I want to be able to pull the data out and do stuff with it - in Excel or PHP preferably. And I want this to happen automagically. Our access is through username/password which is not linked to active directory and getting the IT team to set up anything non-standard is a no-no (I'm a CS teacher and it's taken me EIGHT YEARS to get anything other than IE on the network). Everything I want to do is read-only. - - - Updated - - - Oh and don't think I've got powershell access! VBA could work - if I can provide u/p instead of relying on AD setup.

Hope he responds then!

Anyone know a way of running a CMIS/facility report from a shortcut? I'm thinking something like cmis.exe -u:me -p:secret -dataset:201516.cdb -report:xyx >> out.csv but don't have a clue. thanks