Yes it can indeed be done.
Our cluster of schools used this guy to create a tool for them.
The real answer of course is to get it inputed into CMIS in the first place.
I've just started looking into using CMIS and am trying to teach myself. I've been told that Year 10 targets have to be inputted manually which is hours of work. Does anybody know if and how you can import targets on mass via an Excel spreadsheet?
You don't need a tool you can run a data import routine within Facility. Ideally the Excel sheet will contain three items; Student ID, Subject code and Target Level.
You can then create an import routine that will take this data straight into the Template.
There is a manual which should be available from your support provider (LA or serco direct)... a word of caution tho - test your data transfers on a copy database, you dont want to corrupt your live database with test data etc..
From memory it's the very last step that can cause big time issues - it's a pretty innocuous step (can't remember it from the top of my head) but if you don't get it right it ignores the import rules that you have set up on where the data should go, and slaps the results in a shotgun fashion into the database!
Have a look at http://s3.parature.com/ics/support/D...p?fileID=87416 (you dont need the target points, you need to be logged into sercofirstline). Ignore the backfill section.
After doing whats in the linked pdf, select the data transfer you created, click the transfer button and select Test Run. You want to select No to the box that pops up so you can tell it which assessment/column you want it in. Select the exam from the drop down box, due to a bug you then have to hit cancel (after selecting the exam it doesnt update the options lower down until you go back in). Then hit transfer->Test Run again, this time you can click on the import column name and select which assessment table column you want i to go into. If all goes well you now do Transfer->Do Transfer.
Make sure you excel sheet has no spaces in the sheet names, or the name of the file itself and normally we set the columns in the excel sheet to text (if you use picklists in your assessment column you are importing into you want to import it as varchar rather then a number). Importing assessments has always been iffy for us as if you already have data in different datasets it can create a duplicate record that confuses the system (one time it will show results from the first record, the next time you view it you get the results from the second.) I normally try to avoid importing data into columns where theres already data there for the student.
All of the above advice regarding backups and test runs is very important and must not be ignored - the option of setting up a stand alone for testing purposes may also be worthwhile if other data is being entered.
Generally for target data as long as the following fields are in the spreadsheet and populated you can then transfer straight into nsturesults.
- Setid (This can be specified during the import routine - however I usually just included this in my spreadsheet, e.g. 2011/2012)
- Moduleid (Id for subject - this is case sensitive)
- Deptid (Id for department - this is case sensitive - only include if your school use departments and have these setup within facility under Data|Academic|Departments)
- Criteriadata (This is the column for the target)
- Examid (This can be specified during the import routine - however I usually just included this in my spreadsheet, e.g. KS3TRGT)
- Assessid (This can be specified during the import routine - however I usually just included this in my spreadsheet, e.g. _KS3TRGT)
A quick note that the details column names I have defined above can be called anything within the spreadsheet. Try to avoid any fancy formatting and generally the spreadsheet should be formatted as text, with the obvious exception for numbers which can be set as integers.
During the transfer routine, all data will usually go in with data set as varchar.
Sorry to drag up an old thread. The link from PyROm is now dead - any ideas where I can get instructions on importing?
Also is it possible to import events? Event data is spread across two tables so this is likely to be more complex than just importing from a spreadsheet... Or am I better off just writing a script to enter it direct into the database using SQL?
Importing into Assessment is relatively 'easy' as it involves just one table- NSTURESULTS. The events structure is a lot more complex so may well defeat the Data Transfer process
MrGravell (23rd October 2012)
Thanks PyROm. Not sure how I actually access the document though - get a 'session expired' message. Not to worry though, I think I can get around all this crap by interacting with the database direct from PHP scripts. The database structure is a bit of a mess, but it's not totally indecipherable...
Im guessing its a cookie problem, you need to add Serco firstline - Facility Support and s3.parature.com to your trusted sites list (allow non https sites). Ive done a lot of php scripts that read from the assessments section, im not brave enough to write back to it
HA HA HA HA HA!!!!!
Not laughing at you PyROm - am laughing at the prospect of adding serco firstline to my list of "trusted sites". As far as I can tell, firstline (which is by far and away the worst website I have EVER used) is storing my password as plain text in the database. Firstline in my list of trusted sites? I think not. It took about a week for them to sort my account out, and even now I don't have read permissions so I can't even read any forum posts. Utterly useless.
Why is everyone so paranoid about writing to the database? People at my school are even afraid of reading from the database. Obviously I'd try it on a test server first, and also take a backup when I tried it for real. But really, how hard can it be? Is the database that crazy? It might be...
There are currently 1 users browsing this thread. (0 members and 1 guests)