+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Command Reporter to pull sims to mrbs report in Technical; does anybody have a script which pulls all the rooms using the SimstoMRBS rooms report using command reporter? if not ...
  1. #1

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,817
    Thank Post
    272
    Thanked 1,138 Times in 1,034 Posts
    Rep Power
    350

    Command Reporter to pull sims to mrbs report

    does anybody have a script which pulls all the rooms using the SimstoMRBS rooms report using command reporter?

    if not does anybody know what the syntax would be as i've never used commandreporter before.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Check the other command reporter threads. There was one recently, and one from a while back, linked into that recent one.
    Does the report require input? If not, then perhaps it's a little easier.
    Usually, you would run it from command line with an output file specified to see the parameters it wants, then you can send these in via file or on the command line.
    Would you be able to use schedule reports, or do you need the output saved somewhere ready to use?

  3. #3

    Join Date
    Jan 2008
    Posts
    157
    Thank Post
    12
    Thanked 29 Times in 27 Posts
    Rep Power
    26
    You can get commandreporter to pull content out and save it to an XML file to import into MySQL. I have it doing all staff and student timetables once a week. It's just a case of setting up the report in SIMS and then a user to export the data.

  4. #4

    PICNIC's Avatar
    Join Date
    Oct 2010
    Location
    Zooniverse
    Posts
    292
    Thank Post
    187
    Thanked 84 Times in 45 Posts
    Rep Power
    109
    Quote Originally Posted by glennda View Post
    does anybody have a script which pulls all the rooms using the SimstoMRBS rooms report using command reporter?
    Sorry resurrect an old thread, but SimstoMRBS report? Sounds interesting can anyone point me at it or send me a copy, I have googled to no avail.

    [EDIT]
    Google skills obviously not working today, found it
    [/EDIT]
    Last edited by PICNIC; 24th July 2012 at 03:38 PM.

  5. #5

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,817
    Thank Post
    272
    Thanked 1,138 Times in 1,034 Posts
    Rep Power
    350
    Quote Originally Posted by PICNIC View Post
    Sorry resurrect an old thread, but SimstoMRBS report? Sounds interesting can anyone point me at it or send me a copy, I have googled to no avail.

    [EDIT]
    Google skills obviously not working today, found it
    [/EDIT]
    The one I used at my previous place was a lot more customized after I did this. unfortuantly that script requires manual import for each room whereas we had it import the entire timetable.

  6. Thanks to glennda from:

    PICNIC (24th July 2012)

  7. #6

    PICNIC's Avatar
    Join Date
    Oct 2010
    Location
    Zooniverse
    Posts
    292
    Thank Post
    187
    Thanked 84 Times in 45 Posts
    Rep Power
    109
    Thanks glendda

    I have tried to get this script working in the past but never managed, only takes me a few hours to import the timetable now, but still would be nice to automate the process.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS to MRBS: Script Available
    By McTedo in forum Scripts
    Replies: 105
    Last Post: 21st March 2014, 12:16 PM
  2. [SIMS] SIMs and Command Reporter
    By RuAware in forum MIS Systems
    Replies: 43
    Last Post: 25th February 2011, 06:57 PM
  3. Writing a custom app to pull data from SIMS?
    By robinm in forum MIS Systems
    Replies: 8
    Last Post: 17th September 2009, 08:24 AM
  4. Copying Command prompt to clipboard
    By russdev in forum Windows
    Replies: 10
    Last Post: 21st April 2009, 07:39 AM
  5. Replies: 1
    Last Post: 8th November 2006, 09:57 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
  •