Back to forum list… Back to How Do I?...

Process task to export a report (9 replies)

Browndog
10 years ago
Browndog 10 years ago

We use report commander from the command line to automate exporting of crystal reports, I have been trying to get Iman to initiate an export from Report commander using the process task however with no success, I believe it should be able to run and hasve been using the below test command which does not throw any errors.

"C:\Program Files (x86)\Arcana Development\Report Commander 2\adcrutil.exe" -report="C:\Users\administrator\Desktop\OEQUOT03 -QUOTE MASTER.rpt" -login!=sage:CTOWFfDJDMV2mLalwPCaJA== -refresh -exportformat=PDF -exportfile="C:\Users\administrator\Desktop\1234.pdf" -namedparameters CMPNAME="" PATH="" EXT="" SYSPATH="" SORTFROM="QT0000795" SORTTO="QT0000795" PRINTED="1" QTYDEC="2" SWDELMETHOD="3" PRINTKIT="0" PRINTBOM="0" 

Failing the above could I use a script task to run the above from the command line with Iman?

Support
10 years ago
Support 10 years ago

First, I would alter the paths to not use C:\Users\Administrator to a path which is known to be accessible by IMan....e.g.

C:\IMan\....

Browndog
10 years ago
Browndog 10 years ago

I have revised the paths as below but still no output file. 

"C:\Program Files (x86)\Arcana Development\Report Commander 2\adcrutil.exe" -report="P:\IMan\OEQUOT03 -QUOTE MASTER.rpt" -login!=sage:CTOWFfDJDMV2mLalwPCaJA== -refresh -exportformat=PDF -exportfile="P:\IMan\1234.pdf" -parameters "" "" "" "" "QT0000795" "QT0000795" "1" "2" "3" "0" "0"

Support
10 years ago
Support 10 years ago

Is P:\ is a local drive?

Can you define no success? Is it failing silently?

What do you have set as the 'Action on Transform Error'?

Have you run the integration from the scheduler? There may be some warnings on the audit report which are not displayed through preview.

Browndog
10 years ago
Browndog 10 years ago

P: is a local drive and is used for the iman config files etc

The integration fails silently and even when I run from the scheduler no errors are reported. The action on transform error is set to abort.

Support
10 years ago
Support 10 years ago

When you run, can you even see the adcrutil.exe starting?

Browndog
10 years ago
Browndog 10 years ago

The adcrutil.exe does not start when it is run.

Browndog
10 years ago
Browndog 10 years ago

I really need to get around this issue one way or another, is it possible for Iman to run a cmd file by a script task? This way I could create a text file with Iman with a cmd extension and run it with a script task. I have tried to get the script task to use the below but it is not happy with the syntax. Do you have any suggestions? Dim objShellSet objShell = WScript.CreateObject("WScript.Shell")objShell.Run "P:\IMan\test.cmd"0 

Browndog
10 years ago
Browndog 10 years ago

The report commander has another mode of operation  much simpler command line syntax which works when from a run task on our server, however this still does not work with Iman and again fails silently. I am using the task with an administrator account.

"C:\Program Files (x86)\Arcana Development\Report Commander 2\adrcexec.exe" -project="P:\IMan\test3.rcproject" SORTFROM="QT0000796" SORTTO="QT0000796"

Is there anything else I can try?

Browndog
10 years ago
Browndog 10 years ago

I was able to track down the issue which was the Crystal report itself, I reset the Datasource location and it worked. Thanks for your help.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close