+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 44
MIS Systems Thread, SIMs and Command Reporter in Technical; I am trying to create an auto script to dump a rtf on the network that shows all children not ...
  1. #1

    Join Date
    Nov 2009
    Posts
    24
    Thank Post
    1
    Thanked 7 Times in 6 Posts
    Rep Power
    11

    SIMs and Command Reporter

    I am trying to create an auto script to dump a rtf on the network that shows all children not in school when the report is run.

    I have created the report in reports using

    Attendance Marks
    Is not Present
    Mark Date

    As filters

    Running it is fine and gives me the result i want either using sims or the command reporting tool.

    Running through sims - i can change the date at prompt for "Mark Date"

    But i need to tell the command reporting tool to use the current date on run.

    Anyone know how i can do this?


    Thank you

    Jamie

  2. #2

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,620
    Thank Post
    1,234
    Thanked 776 Times in 673 Posts
    Rep Power
    235
    Quote Originally Posted by RuAware View Post
    But i need to tell the command reporting tool to use the current date on run.
    I seem to remember you have to pass an XML file with your parameters to CommandReporter. Sorry, I don't have any more details to hand at the moment and that's all I can remember.

    --
    David Hicks

  3. #3

    Join Date
    Nov 2009
    Posts
    24
    Thank Post
    1
    Thanked 7 Times in 6 Posts
    Rep Power
    11
    Thanks for the reply... I am trying to pass paramaters using xml but it is just not listening!! Any help greatly appreciated

    Thanks

  4. #4

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    243
    Thank Post
    23
    Thanked 35 Times in 26 Posts
    Rep Power
    20
    Ask your LA or Capita support for the third-party reporting documentation - apparently that'll tell you how to do it.

  5. #5

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    you can do this via a bat file.
    You need to get the date and then convert into the correct format in DOS. The required date format is yyyy-mm-dd

    You can do this with the following code
    for /f "tokens=1-4 delims=/ " %%f in ('date /t') do (
    set dd=%%f
    set mm=%%g
    set yyyy=%%h
    )

    Then call commandreporter with the required parameters and add the following between the <ReportParameters><Parameter> </Parameter></ReportParameters> tags
    subreportfilter='True'><Values><Date>%yyyy%-%mm%-%dd%</Date></Values>

    Make sure that you have a corresponding date filter set in the report.

  6. #6
    robins's Avatar
    Join Date
    May 2007
    Posts
    44
    Thank Post
    15
    Thanked 5 Times in 5 Posts
    Rep Power
    15
    Thansk - thats clever. With regards the SIMS report designer - I've asked for the concept of a current date range like today, this week, this month, this term etc to be added to the data dictionary in some future release.
    Simailarly it would be nice to choose 'current user' as a filter so its not necessary to customise report designs to only pick up records that relate to them, eg kids in their class or behaviour incidents attributed to them etc.

  7. #7

    Join Date
    Jan 2010
    Location
    Spalding
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Using Parameters

    I'm having great trouble making commandreporter do what I want it to. I have got it running reports, but it does not use the parameters I try to give it. This is what I have rtied to use:

    C:\Program Files\SIMS\SIMS .net>commandreporter /user:MYUSERNAME /password:MYPASSWORD /report:"JPs Todays Register" /params:"<ReportParameters><Parameter><Values><Date >2010-01-15</Date></Values></Parameter></ReportParameters>" /output:"C:\current register.txt"

    The report runs fine, but it doesn't use the parameter (instead it gives me the register for 5/10/09 as that is the default day in the prompt when you run the report in sims).

    Any idea how I can make it use my parameter to limit it to today's register.

    PS I'm generating the above line in VBA from Microsoft Access so I can import the data to a database to process it.

    Cheers

    J Pratt

  8. #8

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    243
    Thank Post
    23
    Thanked 35 Times in 26 Posts
    Rep Power
    20
    Have you tried running commandreporter without an output switch (or whatever the syntax is) to see what the parameters should look like? I'm pretty sure you have to name the parameter.

  9. #9

    Join Date
    Jan 2010
    Location
    Spalding
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I have tried doing that, but I'm not sure which bit I'm looking for.

    My report starts:

    - <SuperStarReport>
    - <xs:schema id="SuperStarReport" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    - <xs:element name="SuperStarReport" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    - <xs:complexType>
    - <xs:choice minOccurs="0" maxOccurs="unbounded">
    - <xs:element name="Record">
    - <xs:complexType>
    - <xs:sequence>
    <xs:element name="multiple_id" type="xs:string" minOccurs="0" />
    <xs:element name="Adno" type="xs:string" minOccurs="0" />
    <xs:element name="Mark" msdata:Prefix="REL" type="xs:string" minOccurs="0" />
    <xs:element name="AM_x002F_PM" msdata:Prefix="REL" type="xs:string" minOccurs="0" />
    <xs:element name="Mark_x0020_date" msdata:Prefix="REL" type="xs:dateTime" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:choice>
    </xs:complexType>
    </xs:element>
    </xs:schema>


    The mark date data is also very complicated, as it is includes a time.

    Mark Date in the main report is recorded as either:
    • 2009-10-01T09:00:00+01:00
    • 2009-10-01T13:00:00+01:00


    I have tried changing <Date> in my original attempt to <Mark_x0020_date>, but it still ignored it.

    J Pratt

  10. #10

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    if you run the report from commandreporter with the /PARAMDEF switch, the output file will be the paramdef file you need to pass to set parameters. Just read the XML from that and alter the relevant values to specify your parameters.

    EDIT:
    Set a default value for the parameters manually in Sims before you run commandreporter, that way you get an example in the output XML
    Last edited by LosOjos; 18th January 2010 at 11:24 AM.

  11. Thanks to LosOjos from:

    dhicks (18th January 2010)

  12. #11

    Join Date
    Jan 2010
    Location
    Spalding
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks - it is working beautifully now.

    J Pratt

  13. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by robins View Post
    Thansk - thats clever. With regards the SIMS report designer - I've asked for the concept of a current date range like today, this week, this month, this term etc to be added to the data dictionary in some future release.
    Simailarly it would be nice to choose 'current user' as a filter so its not necessary to customise report designs to only pick up records that relate to them, eg kids in their class or behaviour incidents attributed to them etc.
    good idea have you got a change request number we can vote on..?

  14. #13
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,524
    Thank Post
    106
    Thanked 88 Times in 74 Posts
    Blog Entries
    46
    Rep Power
    40
    anychance someone can email me the documentation for command reporter? /pm

  15. #14
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by browolf View Post
    anychance someone can email me the documentation for command reporter? /pm
    The documentation is bound by an agreement with capita, so can't be shared.

    To be frank you have more information here plus the /? output of command reported than the documentation contains.

  16. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by penfold_99 View Post
    The documentation is bound by an agreement with capita, so can't be shared.

    To be frank you have more information here plus the /? output of command reported than the documentation contains.
    lol - that's shocking

SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. [SIMS] Command reporter paramters [Solved]
    By browolf in forum MIS Systems
    Replies: 5
    Last Post: 19th August 2011, 11:02 AM
  2. Replies: 1
    Last Post: 19th October 2010, 09:48 AM
  3. [SIMS] Java API for Command Reporter
    By vikpaw in forum MIS Systems
    Replies: 26
    Last Post: 17th July 2010, 09:11 AM
  4. [Sims] Command reporter working examples
    By browolf in forum MIS Systems
    Replies: 3
    Last Post: 1st July 2010, 12:45 PM
  5. urgent: Sims.net command line reporter (CLR)
    By russdev in forum MIS Systems
    Replies: 2
    Last Post: 20th September 2007, 02:00 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
  •