+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, SIMS.Net CommandReporter scheduled doesn't work in Technical; I am using CommandReporter to export reports to XML files from SIMS.Net and have put a number of these command ...
  1. #1
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20

    SIMS.Net CommandReporter scheduled doesn't work

    I am using CommandReporter to export reports to XML files from SIMS.Net and have put a number of these command lines into a batch file.

    When I run the batch file logged in as an admin on our SIMS.Net server it works fine.

    When I schedule the same batch file, the batch file runs (because it makes entries in the Event Logs) but the CommandReporter aspects are not running.

    Does anyone have any idea why not? Below is a representation of the batch file:

    eventcreate /L Application /T INFORMATION /SO WDX /ID 0001 /D "WDX XML Data Export Process Began"
    C:
    CD C:\Program Files\SIMS\SIMS .net\
    commandreporter.exe /USER:SimsUsername /PASSWORD:SimsPassword /REPORT:SimsReportName /OUTPUT:"S:/Users/Username/My Documents/WDX/Students-StudentData.xml" /QUIET
    eventcreate /L Application /T INFORMATION /SO WDX /ID 0002 /D "WDX XML Data Export Process Completed"
    Last edited by u8dmtm; 8th January 2009 at 09:28 AM.

  2. #2

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,610
    Thank Post
    1,224
    Thanked 772 Times in 670 Posts
    Rep Power
    234
    Quote Originally Posted by u8dmtm View Post
    When I schedule the same batch file, the batch file runs (because it makes entries in the Event Logs) but the CommandReporter aspects are not running.
    Is S drive mounted when your batch file is run as a scheduled job? You might have to add a "net use ..." line in to tell the computer to mount the SIMS area first before you run CommandReporter.

    --
    David Hicks

  3. #3
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20
    Quote Originally Posted by dhicks View Post
    Is S drive mounted when your batch file is run as a scheduled job? You might have to add a "net use ..." line in to tell the computer to mount the SIMS area first before you run CommandReporter.
    Drive S is a drive letter on the server (not a mapped network drive) and is also where the batch file itself is run from. Just to be sure, I moved everything to C: and tried again, but the same issue persists.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,335
    Thank Post
    367
    Thanked 619 Times in 506 Posts
    Rep Power
    155
    perhaps redirect the output to a file.

    >>c:\output.txt

  5. #5

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,610
    Thank Post
    1,224
    Thanked 772 Times in 670 Posts
    Rep Power
    234
    Quote Originally Posted by matt40k View Post
    perhaps redirect the output to a file.
    Good idea - might want to catch stderr as well:

    >>c:\output.txt 2>&1

    --
    David Hicks

  6. #6
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20
    Thanks, that was useful. The output returned was:

    <CommandReporterError>Login failed for user username. Reason: Incorrect F:\Apps\Sims\Connect.ini file</CommandReporterError>

    It looks like I will need to log this issue with our LA (who provide SIMS support). Unless anyone knows of a quick fix?

  7. #7

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,400
    Thank Post
    636
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    What is the contents of that connect.ini file?

  8. #8

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,898
    Thank Post
    1,182
    Thanked 1,053 Times in 748 Posts
    Rep Power
    327
    Quote Originally Posted by u8dmtm View Post
    <CommandReporterError>Login failed for user username. Reason: Incorrect F:\Apps\Sims\Connect.ini file</CommandReporterError>
    There is your answer incorrect ini file at F: not S:

  9. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,335
    Thank Post
    367
    Thanked 619 Times in 506 Posts
    Rep Power
    155
    check your sims.ini

  10. #10
    u8dmtm's Avatar
    Join Date
    Feb 2006
    Posts
    231
    Thank Post
    7
    Thanked 13 Times in 12 Posts
    Rep Power
    20
    Excellent, thanks to all.

    Drive F: is a mapping so needed to use NET USE to map it for SIMS and it then worked without a problem.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 23
    Last Post: 3rd October 2009, 05:44 PM
  2. SIMS edit pupils' details crashing SIMS.net
    By CadlaM in forum MIS Systems
    Replies: 12
    Last Post: 13th January 2009, 02:20 PM
  3. CommandReporter - History of Changes?
    By DaveS in forum MIS Systems
    Replies: 5
    Last Post: 27th February 2008, 11:44 AM
  4. Anyone Work In A Local NotSchool.net Project
    By russdev in forum General Chat
    Replies: 2
    Last Post: 8th September 2006, 07:32 AM
  5. Replies: 3
    Last Post: 7th July 2006, 02:21 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
  •