+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Exam Submissions File Format? in Technical; Hi all, does anybody have any details about the format of exam submissions files? I've taken a look at one ...
  1. #1

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707

    Exam Submissions File Format?

    Hi all,

    does anybody have any details about the format of exam submissions files?

    I've taken a look at one in notepad and can see that it's plain text and see some logic to the layout, but could do with a sort of 'White paper' on the format.

    In case anybody's curious, my aim is to solve the problem of having to make entries in one SIMS database from a school using two different centre numbers. If I can work out the format of the file, I'm 99% certain a fix could be made that would simply take the submissions file for one centre and 'strip out' the students that are from the other centre (using a predefined list that could be generated by a simple SIMS report for most schools) and place them in to a new submissions file, taking away the need to keep changing the centre number in Exams (which doesn't appear to help anyway as when you create the submissions file it will just use the centre number that is set at the time of creation anyway).

    Any help will be thanked

  2. #2

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    50
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    The full details are published by JCQ

    http://www.jcq.org.uk/attachments/pu...%202010%29.pdf

    This doucment should answer any queries

    Please note this is for version 13 of the basedata spec which came into operation at the beginning of September - You may therefore need to check that any 'old' files you are playing with are V13 spec...

  3. Thanks to AndyCope from:

    LosOjos (28th September 2010)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    Thanks, that's exactly what I was looking for

  5. #4

    Join Date
    Sep 2009
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hey LosOjos

    did you ever get anywhere with splitting out the submission files, cos i think i've just stumbled apon a problem for my split site entries for January.

    We need to send off entry files for both sites entries for Jan exams but as there is only one lot of base data for both pre 16 and post 16 it will only create one entry file, therefore i cant change the centre number in the school set up when i create the file as its only going to make 1 per exam board!

    love to know if you managed to figure it out.

    thanks

  6. #5
    scholarpack's Avatar
    Join Date
    Jul 2010
    Location
    UK
    Posts
    191
    Thank Post
    12
    Thanked 30 Times in 20 Posts
    Rep Power
    38
    Slughtly O/T by why aren't exam submissions handled by XML/web services these days? Fiddling round with parsing text based files seems very ancient.

  7. #6

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    Quote Originally Posted by scholarpack View Post
    Slughtly O/T by why aren't exam submissions handled by XML/web services these days? Fiddling round with parsing text based files seems very ancient.
    Because you assume that exam boards are competent and proactive, and want to help their customers.

  8. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    Quote Originally Posted by emmaburt View Post
    Hey LosOjos

    did you ever get anywhere with splitting out the submission files, cos i think i've just stumbled apon a problem for my split site entries for January.

    We need to send off entry files for both sites entries for Jan exams but as there is only one lot of base data for both pre 16 and post 16 it will only create one entry file, therefore i cant change the centre number in the school set up when i create the file as its only going to make 1 per exam board!

    love to know if you managed to figure it out.

    thanks
    Hi emmaburt, we had the exact same problem and I wrote a small program that splits the file in to two separate submissions files, however it's not in a very user friendly format at the minute as I had about 15 minutes to write it before the submissions needed to be sent. I'll happily edit it a little to work for you (eventually I hope to make it easy enough to use that anybody in the same position can use it), but need to know some details from you first, I'll PM you.

    Quote Originally Posted by powdarrmonkey View Post
    Because you assume that exam boards are competent and proactive, and want to help their customers.
    It doesn't help that SIMS doesn't support multiple exam centres and Capita tell you/your local support team that you will receive absolutely no support if you try to use multiple centre numbers. Somebody needs to budge, whether it's the MIS suppliers or the exam boards, one of them needs to give a little help here!

  9. #8

    Join Date
    Sep 2009
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi josh,

    it won't let me pm you back.

    yes we use a similar format so student exam numbers our post 16 students are 5000 or 4000. we then don't need to split it out more than that as everything on one site is pre 16 so 7000 or 8000 and all post 16 is on the other site.

    hope that makes sense.

    thanks

    Emma

  10. #9

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    I think I get it Emma, I'll alter my program in the morning and send it to you

  11. #10

    Join Date
    Sep 2009
    Posts
    24
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Much appreciated!

SHARE:
+ Post New Thread

Similar Threads

  1. Converting VHS videos to either DVD or file format
    By ctbjs in forum How do you do....it?
    Replies: 8
    Last Post: 17th May 2013, 10:38 PM
  2. Ad Infinitum file format for user creation?
    By tazz in forum How do you do....it?
    Replies: 1
    Last Post: 28th August 2009, 05:26 PM
  3. Replies: 1
    Last Post: 19th May 2008, 10:24 AM
  4. Delete certain file format using a script
    By FN-GM in forum Scripts
    Replies: 3
    Last Post: 27th December 2007, 12:17 AM
  5. ical file format to csv convert
    By russdev in forum Windows
    Replies: 2
    Last Post: 1st November 2006, 06:22 AM

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
  •