Poll: Have you considered an alternate MIS to SIMS.net due to lack of required functionalit

+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, SIMS Report with Current Date Report with Current Date in Technical; Hi, Does anyone know a way of automatically inserting today's date into a SIMS report filter of a scheduled report? ...
  1. #1
    Unvalidated User
    Join Date
    Jan 2008
    Posts
    54
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    0

    SIMS Report with Current Date Report with Current Date

    Hi,

    Does anyone know a way of automatically inserting today's date into a SIMS report filter of a scheduled report?

    Also, can the predefined reports (those below create & build) be run via commandreporter.exe? My Local Support say both are not possible and wont be until schools move to SQL 2008 which wont happen until 2010!!!

    If correct, this is quite unacceptable and I feel a move to CMIS or a.n other MIS as SIMS is sadly falling out-of-touch with what we need to be able to do with OUR data!

    Thoughts please (Phil)?
    Jody

  2. #2

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,356
    Thank Post
    36
    Thanked 362 Times in 247 Posts
    Rep Power
    81
    PreDefined Reports can be run via the commandreporter.exe.

    I'm told that some reports require runtime parameters which will have to be provided as a string or in an input filename parameter as part of the command line.

    The report generator is extremely powerful and I would recommend asking on SupportNet as you will find there are many experts on the SIMS Report Generator that are willing to assist.

    You could also ask your support team to log a specific question and that way it will find its way to an expert.

  3. #3
    Unvalidated User
    Join Date
    Jan 2008
    Posts
    54
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Quote Originally Posted by PhilNeal View Post
    PreDefined Reports can be run via the commandreporter.exe.

    I'm told that some reports require runtime parameters which will have to be provided as a string or in an input filename parameter as part of the command line.

    The report generator is extremely powerful and I would recommend asking on SupportNet as you will find there are many experts on the SIMS Report Generator that are willing to assist.

    You could also ask your support team to log a specific question and that way it will find its way to an expert.
    Thanks for that Phil.

    My support team said it couldn't be done. Can we not have some official documentation please?

    Jody

  4. #4
    ben
    ben is offline

    Join Date
    Apr 2008
    Location
    Wolverhampton
    Posts
    5
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Here is a way I found to do this:

    First run CommandReporter with the /PARAMDEF switch to find out the parameter ID and subreportfilter

    commandreporter /user:username /password:password /report:"reportName" /paramdef



    • Parameter id - will look something like this: Ve6cDUFcKeKRuIB/nxAf9w==
    • subreportfilter - will be either True or False



    This information can then be used in a (very long) command line to run the report

    I use Windows PowerShell to do this, because it has the get-date cmdlet which makes it easy to get the current date in a format that CommandReporter understands.


    $a = (get-date).tostring('s')
    commandreporter /user:username /password:password report:"reportName" /PARAMS:"<?xml version ='1.0' encoding= 'utf-8'?><ReportParameters><Parameter id='Ve6cDUFcKeKRuIB/nxAf9w==' subreportfilter='True'><Values><Date>$a</Date></Values></Parameter></ReportParameters>" /output:"c:\test.csv"



    Obviously replace the green text with your own values.

  5. #5

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,356
    Thank Post
    36
    Thanked 362 Times in 247 Posts
    Rep Power
    81
    Your support unit can request a copy of the manual for you.

  6. #6

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,356
    Thank Post
    36
    Thanked 362 Times in 247 Posts
    Rep Power
    81
    Someone has pointed out to me that the documentation is actually available on EduGeek at

    SIMS 3rd Party Access Documentation

  7. #7
    Unvalidated User
    Join Date
    Jan 2008
    Posts
    54
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Hiya

    None of our custom made reports give the details:

    • Parameter id - will look something like this: Ve6cDUFcKeKRuIB/nxAf9w==
    • subreportfilter - will be either True or False


    CES Reports do? Any ideas people?

    TIA



    Quote Originally Posted by ben View Post
    Here is a way I found to do this:

    First run CommandReporter with the /PARAMDEF switch to find out the parameter ID and subreportfilter

    commandreporter /user:username /password:password /report:"reportName" /paramdef



    • Parameter id - will look something like this: Ve6cDUFcKeKRuIB/nxAf9w==
    • subreportfilter - will be either True or False



    This information can then be used in a (very long) command line to run the report

    I use Windows PowerShell to do this, because it has the get-date cmdlet which makes it easy to get the current date in a format that CommandReporter understands.


    $a = (get-date).tostring('s')
    commandreporter /user:username /password:password report:"reportName" /PARAMS:"<?xml version ='1.0' encoding= 'utf-8'?><ReportParameters><Parameter id='Ve6cDUFcKeKRuIB/nxAf9w==' subreportfilter='True'><Values><Date>$a</Date></Values></Parameter></ReportParameters>" /output:"c:\test.csv"



    Obviously replace the green text with your own values.

  8. #8
    ben
    ben is offline

    Join Date
    Apr 2008
    Location
    Wolverhampton
    Posts
    5
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    Not sure

    I have used this method successfully with custom reports made in Report Designer.

    A couple of things to check:

    • In Report Designer, under your filter, make sure "Prompt at runtime" is ticked
    • Does the user specified in the /user parameter belong to SIMS group(s) that have access to the data you're trying to export? (There is a "SIMS permissions spreadsheet" showing which groups can access which information.)
    • What output does CommandReporter produce when it is run with the /paramdef switch? Does it display an error message?



    Hope this helps

  9. #9
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    964
    Thank Post
    37
    Thanked 171 Times in 136 Posts
    Rep Power
    95
    Phil is it possible to run any of the specific module reports from command line? I like the look of the attendance reports and would like to use then scheduled to allow for schools that are using online attendance, but can't easily see a way of doing this as the advise states that the report must be in a the favorite of the user named to run the report

SHARE:
+ Post New Thread

Similar Threads

  1. Sims report help
    By Jamie_a in forum MIS Systems
    Replies: 1
    Last Post: 4th October 2008, 04:34 PM
  2. SIMS Effective Date
    By danIT in forum MIS Systems
    Replies: 2
    Last Post: 18th July 2008, 02:05 PM
  3. Sims report Template
    By imiddleton25 in forum MIS Systems
    Replies: 1
    Last Post: 27th June 2008, 05:08 PM
  4. SIMS.net report problem
    By localzuk in forum MIS Systems
    Replies: 6
    Last Post: 20th May 2008, 03:22 PM
  5. Another Sims Report
    By Jamie_a in forum MIS Systems
    Replies: 2
    Last Post: 29th January 2008, 04:58 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
  •