+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, CommandReporter problem in Technical; I wish to export some data from Sims on a regular basis using VBA. I have created and saved a ...
  1. #1

    Join Date
    Mar 2009
    Location
    Chingford, London
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Question CommandReporter problem

    I wish to export some data from Sims on a regular basis using VBA. I have created and saved a report definition in Sims which creates an xls file. I can run this report in Sims although I have to enable macros before I can see it. I have created the following statement in my application:
    ShellWait crPath+" /USER:" + userName + "/PASSWORD:" + simsPassword + " /REPORT:" + reportName + " /OUTPUT:" + importFolder + importFile, vbMinimizedFocus
    The application provides the parameters (importFolder + importFile are the destination path and filename).
    When run no error is reported, but the xls file is not created.
    Can anyone tell me where I am going wrong.
    A solution would benefit a number of different schools who use my application.

  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
    VBA - So your trying to get an Excel document to run the report to create a Excel document??

  3. #3

    Join Date
    Mar 2009
    Location
    Chingford, London
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    No. I have created a report definition in SIMS which produces the correct data when run and the data saved manually. As I understand it CommandReporter should create the same effect, saving the data to the specified location. But it doesn't.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 675 Times in 550 Posts
    Rep Power
    166
    The command report tool allows you to run SIMS reports outsite of SIMS with the specified settings. Contact Partner Support and they'll send you info on how to use it (or you might have to request it via one of your SIMS schools if you don't have a license - not sure how it works).

    You can either run it as a batch file or embedded it in an application.

  5. #5

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,767
    Thank Post
    1,510
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    Quote Originally Posted by rhbishop2 View Post
    I wish to export some data from Sims on a regular basis using VBA. I have created and saved a report definition in Sims which creates an xls file. I can run this report in Sims although I have to enable macros before I can see it. I have created the following statement in my application:
    ShellWait crPath+" /USER:" + userName + "/PASSWORD:" + simsPassword + " /REPORT:" + reportName + " /OUTPUT:" + importFolder + importFile, vbMinimizedFocus
    The application provides the parameters (importFolder + importFile are the destination path and filename).
    When run no error is reported, but the xls file is not created.
    Can anyone tell me where I am going wrong.
    A solution would benefit a number of different schools who use my application.
    It might just be a typo, but there's no space between your username and password.

    Also, if your application is providing the parameters, you need to specify the location of an XML based paramfile with the "/paramfile:[path to XML]" option in Command Reporter

    There are many threads on this site with great information on the CLR tool, just do a search for Command Reporter or CLR on here



SHARE:
+ Post New Thread

Similar Threads

  1. Intermitent problems with logging on
    By alexknight in forum Wireless Networks
    Replies: 27
    Last Post: 22nd August 2005, 05:01 AM
  2. Problem accessing machines from a sub-domain
    By mark in forum Wireless Networks
    Replies: 13
    Last Post: 22nd August 2005, 04:52 AM
  3. Problems with Google Earth
    By Dos_Box in forum Educational Software
    Replies: 8
    Last Post: 19th August 2005, 03:32 PM
  4. Replies: 2
    Last Post: 19th August 2005, 08:49 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •