peterteckhokgoh

Sims won't have a way of altering this, its not particularly good at dealing with mail merge type senarios at a complex level. Hence I suggest one of two solutions: 1) In the rtf tempate see whether there are any options to fiddle about with field options, particularly field 'switches'. you will have to look on the net to give what you want. don't know whether this will yeild any results, but worth a go. 2) extract the data into a csv and mail merge from there. only problem will be is if you want to deal with a one-to-many relationship which sounds like you'd want to. the only way round this is to use the csv as a table in an access database and create a report from here. sounds like you might have to offer another solution for an easy life! good luck. Pete

Hi I am trying to navigate the system manager module and I am finding it very tedious. does anyone have any documentation on where various bits are stored? some pretty pictures would be nice or even a schematic about how the sims interface is constructed with how various permissions relate to it. thanks Pete

Right here are my two pennies worth....for what its worth. Actually it seems to work although there are 3 aspects which I would critise it on: 1) aestetics of the interface (apparently this is the next project to get a .NET make over, information to be released in Jan 09). 2) it does not drag assessment data in 3) it does not deal with Subject Specific Targets coherantly (you can manipulate the system to allow it to deal with this, but there is nothing to do this specifically). We are relying on an access database set up about 5 years ago, that seems to be fine. We have centralised access database that deals with pretty much everything, and I will integrate the 5 year old one into that. I have found a really handy tool in Access 2007 which allows you to create an attachment as a field. We will publish the IEP's as PDF's then attach these to a student as an intemediate solution.

Thank you very much for your comments they were very useful. I am in the assessing the demo, and other alternatives. When I have come to a conclusion I'll let you know!

We are thinking about buying Capita's IEP writer. what do think of it?

ok brilliant. thanks very much. will look into this. i assume you don't have any info on table structures though? thanks pete

I don't understand. why would it matter if i corrupted a copy of a database? plus there is very little corruption you can do with read only functions.

I am not altering it, i am merely reading from it. plus i have taken a copy of the mdb and am testing everything on there. this is ok right?

Hi i am looking for any documentation anyone might have (homemade or otherwise) regarding the table structures of SIMS Sql tables. I am doing some ugly hacks into it and this kind of information would be really useful. I would also be interested in anyone else who has gone down this route of integrating data straight from the tables. thanks pete

hi there i would really love to get some the documentation for the 3rd party access commands. specifically commandreporter and osql. the osql uses sql and so a the spec of the tables and their relationships would be absolutely tops. anybody any ideas? i think these seem to be so hard to come by, but would so useful and powerful if they were used thanks pete

Hi i have got commandreporter working, but would like to know how to specify parameters for reports. reason being is that commandreporter is throwing out csv's and i would really like it to output xls. don't know whether the in parameters you can specify output, but have no idea how to structure the XML. if anyone has documentation on the commandreporter above what it gives you on the command line i would be very interested. thanks pete

Brilliant! thank you very much, i think this is what i am looking for. is there any documentation that you know about?

Hi i wouldn't mind trying to get a scheduled report to work so that i have excel spreadsheets generated daily. as yet no luck. whats this commandreporter.exe? i am fairly new to sims, having worked with it for about 9 months. thanks pete