ben

I found a FAQ document the other day on the BECTA website From the document: The full document can be found here

Is this what you're looking for? :- NOVA-T6 > Data > Export Timetable Cycle to SQL...

Not sure I have used this method successfully with custom reports made in Report Designer. A couple of things to check: In Report Designer, under your filter, make sure "Prompt at runtime" is ticked Does the user specified in the /user parameter belong to SIMS group(s) that have access to the data you're trying to export? (There is a "SIMS permissions spreadsheet" showing which groups can access which information.) What output does CommandReporter produce when it is run with the /paramdef switch? Does it display an error message? Hope this helps

I have lots of small issues with SIMS, all minor irritations which make the program sometimes frustrating to use. e.g. I agree with pete's point 3 about all listboxes accepting keyboard input to jump to a specific row. This would be really useful e.g. in Candidate Chooser in Exams Organiser - it would be a lot faster to locate a student by typing the first few letters of their surname rather than click-click-clicking to find their name in the list. Cover 7 - No page breaks when printing class lists for supply teachers. As far as I can tell from SupportNet, this issue has been known about for several months without being fixed. And it isn't a difficult fix either. (It could be fixed by modifying the elements in the generated HTML, replacing every occurance of frame="box" with class="Pagebreak" frame="box") Student details / Find Student - There's a gap of about a second between clicking on a student and the row actually becoming highlighted. Makes the program feel sluggish to use. System Manager - when adding a member of staff to a group, I always click the plus (+) on the toolbar, instead of the one to the right of the list. This attempts to add a whole new GROUP. (Why would anyone need to do this?) Any attempt to get off this screen results in the message "Insert mode will be cancelled. Cursor will be positioned on the next record. Do you want to continue?" What does this even MEAN? Import facilities - Despite having pretty good export abilities (via Report Designer), the only parts of SIMS which have import facilities seem to be student details (CTF) and Assessment Manager (Excel/XML) e.g. it seems impossible to bulk import * Linked documents * Behaviour incidents (e.g. import from another database) and no standard way to create lots of Aspects or Templates all at once This sort of thing would be really useful. I have to say SIMS has improved in recent years though. It could be worse.

Here is a way I found to do this: First run CommandReporter with the /PARAMDEF switch to find out the parameter ID and subreportfilter commandreporter /user:username /password:password /report:"reportName" /paramdef Parameter id - will look something like this: Ve6cDUFcKeKRuIB/nxAf9w== subreportfilter - will be either True or False This information can then be used in a (very long) command line to run the report I use Windows PowerShell to do this, because it has the get-date cmdlet which makes it easy to get the current date in a format that CommandReporter understands. $a = (get-date).tostring('s') commandreporter /user:username /password:password report:"reportName" /PARAMS:"$a" /output:"c:\test.csv" Obviously replace the green text with your own values.