+ 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,214
    Thank Post
    138
    Thanked 347 Times in 293 Posts
    Rep Power
    90

    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,522
    Thank Post
    374
    Thanked 675 Times in 550 Posts
    Rep Power
    166
    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,214
    Thank Post
    138
    Thanked 347 Times in 293 Posts
    Rep Power
    90
    Cool Could be a useful snippet of info down the line.

  5. #4

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    636
    Thank Post
    100
    Thanked 135 Times in 105 Posts
    Rep Power
    68
    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,214
    Thank Post
    138
    Thanked 347 Times in 293 Posts
    Rep Power
    90
    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
    636
    Thank Post
    100
    Thanked 135 Times in 105 Posts
    Rep Power
    68
    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, 04: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, 03: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, 06: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, 03:53 PM
  5. SIMS Lesson Monitor runs like dog on wireless ...
    By moonwalker in forum MIS Systems
    Replies: 14
    Last Post: 2nd April 2008, 06: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
  •