+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Sims Report Question: Merging Fields & DFES Number in Technical; Hi guys I have quick question for Sims experts we need to do the following things on a sims report ...
  1. #1

    russdev's Avatar
    Join Date
    Jun 2005
    Thank Post
    Thanked 556 Times in 371 Posts
    Blog Entries
    Rep Power

    Sims Report Question: Merging Fields & DFES Number

    Hi guys

    I have quick question for Sims experts we need to do the following things on a sims report and wondering if it can be done.

    First is run report that exports students details as csv (the easy part) but against each of the student records it also has the schools dfes number. Then the second question want export student records to csv but column last column to be combination of other columns for example forename/surname.

    Does that make sense..

    Any experts out there with ideas..


  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    West Midlands
    Thank Post
    Thanked 1,266 Times in 860 Posts
    Rep Power
    Hi russdev,

    AFAIK, there's no way to add the current school's DfES number to a report. You can get student's previous schools, but not the current one.

    As for merging fields, again, you're out of luck in SIMS. What I would do to get around that is either feed the report in to a script that parses the CSV and merges the necessary fields in to a new column, or create an Excel report in SIMS with a macro to do the same job.

    It sounds like this is a report you'll want to run on various sites, hence the need to identify the source school in the report. I know it's not ideal, but using the Excel/Macro method above you could prompt the user for their school's DfES number and have you macro add it in to a column.

    If the point of the DfES number is purely to identify which school the report originated at, could you use the school's exam centre number instead? That is available in SIMS reports, however it will only show for students who have been added to the school's exams module as candidates, so it's not without setbacks of it's own...

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Saudi Arabia
    Thank Post
    Thanked 1,467 Times in 1,219 Posts
    Rep Power
    I'd be tempted to yank the data out manually, but that would be frowned upon. What columns need combining exactly, as there are various options for surname/forename available.

    The only one you'd struggle to get is the dfes number, but i'd just hard code that in, either via a macro or dumping it into a udf or result field, though in the excel macro would be the least maintenance.
    You'd just have to set up each school manually with their own macro template.

    To be honest, what are you doing with the CSV? why not just get a standard report to dump the data raw to CSV which you can give to all schools to import, and then adjust your import / processing routine to process it.

    I can't believe you can get the dfes number out though, especially with all the reports for returns and such like.

+ Post New Thread

Similar Threads

  1. Replies: 18
    Last Post: 18th October 2014, 09:20 AM
  2. Replies: 4
    Last Post: 13th January 2014, 01:20 PM
  3. Replies: 4
    Last Post: 19th February 2013, 07:35 PM
  4. SIMS Performance Reporting Questions
    By DBMan in forum MIS Systems
    Replies: 21
    Last Post: 22nd June 2009, 11:28 AM
  5. SIMs.net - User defined fields in reports?
    By duncane in forum MIS Systems
    Replies: 4
    Last Post: 21st September 2008, 09:07 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