+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, CMIS - Importing data into CMIS. Can it be done? in Technical; I've just started looking into using CMIS and am trying to teach myself. I've been told that Year 10 targets ...
  1. #1

    Join Date
    Oct 2011
    Location
    Bromsgrove
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    CMIS - Importing data into CMIS. Can it be done?

    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?

  2. #2
    CheeseDog's Avatar
    Join Date
    Jan 2006
    Location
    West Midlands
    Posts
    217
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    18
    Yes it can indeed be done.

    Our cluster of schools used this guy to create a tool for them.

    Hugh Kirke

    The real answer of course is to get it inputed into CMIS in the first place.

  3. #3

    Join Date
    Mar 2010
    Location
    UK
    Posts
    175
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    17
    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.

  4. #4

    Join Date
    Oct 2011
    Location
    Bromsgrove
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by Banjo View Post
    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.
    Thanks for the advice. Do you happen to have a set of instructions for that or a reference to a CMIS manual?
    It would save hours of data inputting which seems such a waste of valuable time when it could be done in seconds.

  5. #5
    APC
    APC is offline

    Join Date
    Jul 2008
    Location
    Staffordshire
    Posts
    40
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    24
    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..

  6. #6
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    548
    Thank Post
    179
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    49
    Quote Originally Posted by APC View Post
    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..

    I must second that!


    Test your data transfer on a backup database. Then backup the live system before you import. These things can go very wrong very quickly.

  7. #7

    Join Date
    Mar 2010
    Location
    UK
    Posts
    175
    Thank Post
    0
    Thanked 17 Times in 16 Posts
    Rep Power
    17

    Lightbulb

    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!

  8. #8

    Join Date
    Jan 2008
    Location
    Chesterfield, Derbyshire
    Posts
    196
    Thank Post
    11
    Thanked 36 Times in 26 Posts
    Rep Power
    21
    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.

  9. #9
    TS1988's Avatar
    Join Date
    Nov 2011
    Posts
    6
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    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.

  10. #10

    Join Date
    Oct 2012
    Posts
    7
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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?

  11. #11
    tli
    tli is offline

    Join Date
    Mar 2010
    Location
    Birmingham
    Posts
    17
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    10
    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

  12. #12

    Join Date
    Jan 2008
    Location
    Chesterfield, Derbyshire
    Posts
    196
    Thank Post
    11
    Thanked 36 Times in 26 Posts
    Rep Power
    21
    Hi, the pdf is now linked off this knowledge base artice http://s3.parature.com/ics/support/K...+26&docID=4736

  13. Thanks to PyROm from:

    MrGravell (23rd October 2012)

  14. #13

    Join Date
    Oct 2012
    Posts
    7
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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...

  15. #14

    Join Date
    Jan 2008
    Location
    Chesterfield, Derbyshire
    Posts
    196
    Thank Post
    11
    Thanked 36 Times in 26 Posts
    Rep Power
    21
    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

  16. #15

    Join Date
    Oct 2012
    Posts
    7
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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...

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Google Earth install via GPO? Can it be done in v6?
    By Ben_Stanton in forum How do you do....it?
    Replies: 19
    Last Post: 10th August 2011, 11:22 AM
  2. [Pics] Musical Score: Can It Be Played?
    By DaveP in forum Jokes/Interweb Things
    Replies: 13
    Last Post: 27th February 2011, 07:21 PM
  3. Linux workstation - Windows Network : Can it be done?
    By Nimon in forum Wireless Networks
    Replies: 4
    Last Post: 28th April 2010, 09:24 AM
  4. Student Webpage with Moodle - can it be done?
    By dgarner in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 9th February 2010, 06:05 PM
  5. Is this quote good? Can it be beaten?
    By danielson81 in forum Budgets and Expenditure
    Replies: 15
    Last Post: 21st August 2008, 05:57 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •