Nova T6 Satellite. How to query database?

[OutOf7]

Hi all,

 

First post, so thank you for welcoming me. I am a scheduler in a big International school that is running Nova T6 and Isams (i.e not Sims!).

 

i have just finished the schedule (well that is what one always believes until the proverbial fan is being hit). I would like to get some custom data report that is not built in. I KNOW there must be a SQL or MYSQL database behind Nova... I just can’t figure out how I can access and query it. Is there any way to get any access to the backend?

Again, this is a Nova T6 standalone installation on a Windows 10 VM and I do not have access to Sims.

 

Any help appreciated,

 

Alain

[RichP]

That it can run as a satellite install should give away the fact that T6 doesn't haven't any SQL backend! It's barely a 32bit app as it is... Unfortunately your reporting is limited to what you can see on screen and save as csv or from the built-in reports. What sort of data are you looking to get

[OutOf7]

Thank you.

I was hoping to get the class code + class label + teacher initials + subject name (and if possible the meeting times as a group_concat all on the same line) but that is less essential.

All the data I seems to get does not get me what I want and is not copying / pasting well in Excel.

I tried to do a SQL export but I get a bunch of useless DAT files.

I now understand there is no back end and all the data is stored in the spl file but I don’t think I can query it.

[RichP]

Would Reports -> Curriculum Analysis -> List of classes for a years (choose all years) work? It will bring out teacher name rather than code but an xlookup to another list would solve that.

You are spot on with the way in ends up in Excel, it's rubbish. A text to columns with a Fixed Width will usually tidy the majority of it up I found in the past though.

Not ideal I know and amongst the reasons i'm not a SIMS customer anymore!

[gordonbarclay]

In T6 Data > Export to Third Party Systems

 

This seems to give one text file per year group