+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SIMS Data transfer from large excel spreadsheet in Technical; I have been asked to transfer all our PIPS. KS1, KS2 and MidYs results from EXCEL into SIMS (and then ...
  1. #1

    Join Date
    Jan 2013
    Posts
    10
    Thank Post
    13
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS Data transfer from large excel spreadsheet

    I have been asked to transfer all our PIPS. KS1, KS2 and MidYs results from EXCEL into SIMS (and then make it available in Discover). I have tried to follow the method given in the SIMS information but nothing gets transferred. Has anyone else previoulsy done this and might suggest what i am doing wrong or what the correct method might be?

    Thanks

  2. #2

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    Hi,
    not sure what the method in SIMs information is but this is what I do:
    1 create a marksheet template containing all of the required aspects in the same order as the Excel sheet.
    2 create mark sheet for relevant group of students
    3 export the formatted marksheet
    4 copy data from Excel to formatted marksheet making sure students are correct etc.
    5 use Routines>Data In>Assessment>Import from Spreadsheet to import the formatted spreadsheet.

    It works with lots of columns but I would split the data up to make it manageable.

  3. Thanks to number34 from:

    neil27 (7th January 2013)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,506
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Using the "Routines > Data In > Assessment > Import from Spreadsheet" method should work for CSV files, but you'll have to make sure your data is valid for the aspects you match them up to. For instance, you can't upload a grade in to a marks-decimal aspect, and any grades you do upload must be available in the gradeset associated with the selected aspect.

    Also, if you are using result sets, make sure you select the correct one when matching aspects to columns in your CSV, otherwise hey won't show up in your marksheet.

    I use this method a lot so I suspect there is some problem with the data you're trying to upload as opposed to the problem lying with SIMS itself.

  5. Thanks to LosOjos from:

    neil27 (7th January 2013)

  6. #4

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    Neil,
    in the light of LosOjos post I should emphasise that by using a formatted spreadsheet you remove the problems associated with matching columns when importing as all of information required is already in the sheet.
    Last edited by number34; 7th January 2013 at 12:09 PM. Reason: typo

  7. Thanks to number34 from:

    neil27 (7th January 2013)

  8. #5
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    Quote Originally Posted by LosOjos View Post
    Using the "Routines > Data In > Assessment > Import from Spreadsheet" method should work for CSV files, but you'll have to make sure your data is valid for the aspects you match them up to. For instance, you can't upload a grade in to a marks-decimal aspect, and any grades you do upload must be available in the gradeset associated with the selected aspect.

    Also, if you are using result sets, make sure you select the correct one when matching aspects to columns in your CSV, otherwise hey won't show up in your marksheet.

    I use this method a lot so I suspect there is some problem with the data you're trying to upload as opposed to the problem lying with SIMS itself.
    setting the proper result set was giving me fits when I first started importing data in...now it's one of the first things I check

  9. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,506
    Thank Post
    1,457
    Thanked 1,203 Times in 816 Posts
    Rep Power
    713
    Quote Originally Posted by tombry View Post
    setting the proper result set was giving me fits when I first started importing data in...now it's one of the first things I check
    Yeah it can be a nightmare at first, especially as not all schools use them the same way. Here, we strictly use result sets to identify results (e.g. Y11 Check 1, Y9 Check 5 etc.) but some schools use date ranges to identify results... the key is finding a method that works for you and sticking with it

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 12
    Last Post: 31st March 2012, 04:06 PM
  2. [SIMS] SIMS Data Changes
    By chrisgoodrich in forum MIS Systems
    Replies: 6
    Last Post: 18th October 2011, 02:08 PM
  3. PDF from results to Excel SpreadSheet
    By 01hanstu in forum How do you do....it?
    Replies: 2
    Last Post: 3rd October 2011, 04:12 PM
  4. Importing live SIMS data as XML to Google spreadsheet
    By CyberNerd in forum Office Software
    Replies: 4
    Last Post: 4th March 2011, 09:39 AM
  5. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 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
  •