[sims] Sims database structure

[atfnet]

Hi All,

Does anyone have any information on the sims.net database structure ? I am particularly interested in how the time table is stored ? and how to tell which cycle the timetable is in ?

Thanks

 

Andy

[K.C.Leblanc]

Sims are quite guarded about what's goes on in their database. They also release patches every 6 weeks, and any of these could change the database structure.

 

The general consensus is the best way to do this sort of thing is to get sims to generate a report with the data you need.

 

A school I know use this method to use sims to automatically create accounts on AD and Moodle.

[Sivadam]

The Timetable 'Cycle' is shown in each pupil's 'Student Curriculum' via Tab 2 Timetable. It shows at bottom left when you click on any lesson.

If you have changed the cycle part way through a year then all the cycles will show.

[matt40k]

I think it'll be worth saying what your trying to achieve as it'll have already been done before.

[matt40k]

PM me if you want the name of the view that can do this.

 

Ahh... you do listen

[WiPPaH]

Sims are quite guarded about what's goes on in their database. They also release patches every 6 weeks, and any of these could change the database structure.

 

The general consensus is the best way to do this sort of thing is to get sims to generate a report with the data you need.

 

A school I know use this method to use sims to automatically create accounts on AD and Moodle.

 

Hi,

 

I am looking to something similar with merits, do you know if Sims has a way of automating this report generation? The plan is to not have to run a report once a week and have "something" do it for me every X days.

[matt40k]

You can schedule reports.

[LosOjos]

or use CommandReporter if you want to run it from a script (it's in your /Program Files/SIMS/SIMS .net/ directory)

[WiPPaH]

Thanks Matt40k & Los0jos

 

The CommandReporter tool looks perfect!