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 ...
8th December 2011, 09:39 AM #1
- Rep Power
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.
8th December 2011, 10:28 AM #2
VBA - So your trying to get an Excel document to run the report to create a Excel document??
9th December 2011, 12:13 AM #3
- Rep Power
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.
9th December 2011, 10:00 AM #4
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.
9th December 2011, 10:57 AM #5
It might just be a typo, but there's no space between your username and password.
Originally Posted by rhbishop2
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
By alexknight in forum Wireless Networks
Last Post: 22nd August 2005, 05:01 AM
By mark in forum Wireless Networks
Last Post: 22nd August 2005, 04:52 AM
By Dos_Box in forum Educational Software
Last Post: 19th August 2005, 03:32 PM
By Rozzer in forum Windows
Last Post: 19th August 2005, 08:49 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread