+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, How do you create a definition file for extraction of MIS data? in Technical; We are looking at running 3 Squares Conduct Data Online but to set it up need to extract three sets ...
  1. #1

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,623
    Thank Post
    3,560
    Thanked 300 Times in 228 Posts
    Blog Entries
    3
    Rep Power
    123

    How do you create a definition file for extraction of MIS data?

    We are looking at running 3 Squares Conduct Data Online but to set it up need to extract three sets of data from SIMS. The data needs to be uploaded as a xml file. I know with other extractions from SIMS we achieve it by running a definition file and am trying to find out how to set about creating definition files for this data? Or is there another way?

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,768
    Thank Post
    1,510
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    Quote Originally Posted by speckytecky View Post
    We are looking at running 3 Squares Conduct Data Online but to set it up need to extract three sets of data from SIMS. The data needs to be uploaded as a xml file. I know with other extractions from SIMS we achieve it by running a definition file and am trying to find out how to set about creating definition files for this data? Or is there another way?
    As far as I'm aware, you just create a report in SIMS, select output type as text and there you get the option to output XML. It would of course depend on the system receiving the data being aware of the XML tags used, so I'd hope they would send you some report def files to help you as there are usually many ways of getting the same data from SIMS and the XML tags can vary!

    In fact, the XML tags change depending on whether you run the report from SIMS or extract it via CLR!

  3. Thanks to LosOjos from:

    speckytecky (15th November 2011)

  4. #3

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,623
    Thank Post
    3,560
    Thanked 300 Times in 228 Posts
    Blog Entries
    3
    Rep Power
    123
    Thanks for that. What I was looking for is how do I create the *.RptDef file

    We use CASPA as well and the extraction of the annual pupil update from SIMS is accomplished using a CASPA Pupil Data Year.Reptdef

    Quote Originally Posted by LosOjos View Post
    As far as I'm aware, you just create a report in SIMS, select output type as text and there you get the option to output XML. It would of course depend on the system receiving the data being aware of the XML tags used, so I'd hope they would send you some report def files to help you as there are usually many ways of getting the same data from SIMS and the XML tags can vary!

    In fact, the XML tags change depending on whether you run the report from SIMS or extract it via CLR!

  5. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,768
    Thank Post
    1,510
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    Quote Originally Posted by speckytecky View Post
    Thanks for that. What I was looking for is how do I create the *.RptDef file
    Ahh I see... first thing is to create the report in SIMS as you would any other report, then simply click through "Reports > Export", select the report you created earlier and it'll be exported in the RptDef format

  6. Thanks to LosOjos from:

    speckytecky (16th November 2011)

  7. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    771
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    But you wouldn't run the report def file to extract data, it's just a way of backing up the report or sending it to another user. Maybe the companies usually send you a file to use.
    You would need to import the report def file, then run the report(s) that it loaded into your sims.
    If you're making your own, there is a tool that allows you to alter the supplier tag too, but i think that's for third party support and LAs mostly.

    edit: i'd check with them, exactly what they want, as you'll only need to create a report and then send them the output, not the definition. It should be they who send you the definition so you don't have to make up your own reports as @losojos said.
    Last edited by vikpaw; 16th November 2011 at 07:32 AM. Reason: addition

  8. Thanks to vikpaw from:

    speckytecky (16th November 2011)



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 27th July 2011, 12:29 AM
  2. Replies: 14
    Last Post: 30th October 2010, 10:20 AM
  3. Replies: 1
    Last Post: 11th June 2010, 10:23 PM
  4. how do you convert an xml file to xls
    By speckytecky in forum How do you do....it?
    Replies: 6
    Last Post: 15th June 2009, 11:09 AM
  5. How do you create a mandatory profile on a network?
    By hig in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 7th April 2009, 10:34 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
  •