+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
MIS Systems Thread, importing formatted spreadsheet in Technical; Thanks, I have done all that and I have now imported one set of exam results from 2009. Unfortunately, while ...
  1. #16

    Join Date
    Jan 2013
    Posts
    10
    Thank Post
    13
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks, I have done all that and I have now imported one set of exam results from 2009. Unfortunately, while they show up correctly when I open the marksheet for the correct group of pupils when I open an individual pupils assessment results it shows my newly imported results as being on the 1st March when i imported them - rather than 6th june 2009 when they sat them. Can you tell me what i have done wrong? I couldn't see anywhere on the result set to fix a date for the results - there was one on the exported marksheet, but as that part was read only I couldn't change it.
    Thanks
    Last edited by neil27; 2nd March 2013 at 10:53 AM. Reason: grammar

  2. #17

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,787
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    A resultset isn't usually fixed to a particular date, it's a general idea of the time, at least that is the common usage. e.g. Y8 Term 1, could be a different date for kids of different ages.
    It will always use the result date you imported as the result date, but you should be able to ignore this. What you have probably found is that it looks like it's a present result due to having a current date on it. You should still on the import spreadsheet have a row for the result date which you can modify to push the results into the past. It shouldn't be read only. Worst case on import it should be editable by right clicking on the date, but it takes much longer to do it one at a time there.

  3. Thanks to vikpaw from:

    neil27 (2nd March 2013)

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] Batch Import xml Spreadsheets
    By tben2505 in forum MIS Systems
    Replies: 2
    Last Post: 11th January 2012, 09:18 AM
  2. [SIMS] Batch Import Formatted Excel Marksheets into SIMS?
    By tben2505 in forum MIS Systems
    Replies: 10
    Last Post: 15th November 2011, 02:31 PM
  3. 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
  4. Quickest way format C: drive
    By tosca925 in forum Windows
    Replies: 10
    Last Post: 13th October 2005, 10:43 AM
  5. The KiXtart free-format scripting language
    By ninjabeaver in forum Downloads
    Replies: 10
    Last Post: 16th June 2005, 12:11 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
  •