Aloha PMIX automation - Received "No data to report"

[walter1917]

Hi all,

I have Aloha v6.1 and am trying to automate pmix reporting via email. I've followed all of the great advice on this forum and have installed Blat, Stunnel and use Gmail.

In the WINHOOK file, AFTER the 2 EOD calls and BEFORE the DELTRAK calls I added:

@call d:\Aloha\bin\rpt.exe /date data /XP
@call C:\blat\blat323\full\blat.exe -p gmailsmtp -to XX@gmail.com -subject PMIX Report -body Report -attach d:\Aloha\RptExport\Default.pmx.csv -server localhost:25

I received the report email this morning with the Default.pmx.csv attachment but the entire report consists of "No data to report"

Can anyone advise? Are these the correct calls? Where in the WINHOOK file should the calls be?

Thank you in advance!

 

[dauphin2]

Instead of "rpt.exe /date data /XP" use "rpt.exe /date %1 /XP

 

[walter1917]

Thanks Dauphin2!

Does the position in the WINHOOK file matter? I was concerned that it may be running it after the EOD lines and before it's opened the next day?

 

[dauphin2]

Shouldn't matter, but I'd put it up top just to be safe.

 

[walter1917]

So, we replaced it to data with %1 and put it at the top of the WINHOOK. Now, there is no email at all.

Below is the entire WINHOOK.bat file. Can any advise?




@call d:\Aloha\bin\rpt.exe /date %1 /XP
@call C:\blat\blat323\full\blat.exe -p gmailsmtp -to XX@gmail.com -subject REPORT -body Report -attach d:\Aloha\RptExport\Default.pmx.csv -server localhost:25

@call d:\Aloha\deltrack /EOD
@call d:\Aloha\deltrack /EOD


Rem ------------------------------ DELTRACK UTILITY COMMANDS ---------------------------------
Rem ***Runs the DELTRACK utility in default mode on Iberdir if able to find a valid Iberdir parameter ***
@CALL d:\Aloha\Deltrack\deltrack.exe /iberdir d:\Aloha /s /delinfo 14
@Call d:\Aloha\ftp\PollCheck.exe /eod

 

[AlohaRoss]

e:\bootdrv\aloha\BIN\RPT.EXE /DATE %1 /XP /LOAD "default.pmx.set"

Here is what I used. you need to set what report you want for it to work.

To test run from dos prompt but run as

e:\bootdrv\aloha\BIN\RPT.EXE /DATE data /XP /LOAD "default.pmx.set"

AlohaRoss

http://www.needalohahelp.com

 

[walter1917]

Thanks AlohaRoss!

We test ran that same line from dos prompt and it did NOT work with the /LOAD variable, but did work when we removed it.

Default.pmx.set does exist and is the report we want to run. Any idea why that may be the case?

 

[AlohaRoss]

Remove the "" "" and try again

AlohaRoss

http://www.needalohahelp.com