+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Running reports programmatically on MISs other than SIMS in Technical; Over the past week or so the SIMS CommandReporter.exe feature has really come into its own for us, through some ...
  1. #1
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,192
    Thank Post
    134
    Thanked 340 Times in 287 Posts
    Rep Power
    84

    Running reports programmatically on MISs other than SIMS

    Over the past week or so the SIMS CommandReporter.exe feature has really come into its own for us, through some custom reports and various SSIS packages it is driving things like our Moodle class enrolments, our in house designed trip management system and over the summer we will be mashing it into to PowerShell and Active Directory to do some really cool things.

    So...the question is (just out of personal interest more than anything else) is do the 'cloud' based MIS provider have anything which matches this feature? (aka the ability to programmatically run automated reports exporting as CSV or even raw access to the SQL data through a VPN/whatnot).

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Most I know about have a web api - you can just plug straight into SSIS. The web component in SSIS is pretty cruddy, so you'll be better off with the scripting component. Its far superior to the SIMS reporting engine \ CommandReport.exe

  3. Thanks to matt40k from:

    jamesfed (14th July 2014)

  4. #3
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,192
    Thank Post
    134
    Thanked 340 Times in 287 Posts
    Rep Power
    84
    Cool Could be a useful snippet of info down the line.

  5. #4

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    621
    Thank Post
    95
    Thanked 129 Times in 100 Posts
    Rep Power
    66
    Progresso allows for subscription reports ussing SSRS so once you have a report built you can schedule it to go by email in various different formats to whoever you like at specified times and include relative (such as date) or fixed parameter.

  6. #5
    jamesfed's Avatar
    Join Date
    Sep 2009
    Location
    Reading
    Posts
    2,192
    Thank Post
    134
    Thanked 340 Times in 287 Posts
    Rep Power
    84
    Quote Originally Posted by michael2k6 View Post
    Progresso allows for subscription reports ussing SSRS so once you have a report built you can schedule it to go by email in various different formats to whoever you like at specified times and include relative (such as date) or fixed parameter.
    Ahh now the only problem there is I wouldn't want a human to be involved in the process at all (from what I understand you have written a human would need to take the attachment out of the email and feed it into a path.

    For a match in the criteria in the OP it would need to be csv export to a path or direct SQL to SQL.

  7. #6

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    621
    Thank Post
    95
    Thanked 129 Times in 100 Posts
    Rep Power
    66
    Sorry, understood, you'd have to use the API to achieve that.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS : Batch Schedules : Auto Running Reports
    By bwfc_nottingham in forum MIS Systems
    Replies: 17
    Last Post: 16th January 2014, 03:35 PM
  2. [SIMS] SIMS reporting issues on some Win 7 PCs
    By MrWu in forum MIS Systems
    Replies: 3
    Last Post: 17th September 2013, 02:11 PM
  3. [SIMS] SIMS B2B and other LA systems other than ONE
    By pbainbridge in forum MIS Systems
    Replies: 6
    Last Post: 7th February 2013, 05:28 PM
  4. [SIMS] Running reports on next year's timetable for data extract
    By anne1 in forum MIS Systems
    Replies: 1
    Last Post: 1st September 2011, 02:53 PM
  5. SIMS Lesson Monitor runs like dog on wireless ...
    By moonwalker in forum MIS Systems
    Replies: 14
    Last Post: 2nd April 2008, 05:35 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
  •