Monday, September 15, 2008

Publishing Files to Report Manager / RDS

In short the generated files must be created in the same folder that is generated for the process. I've found that App Engines at least are very fussy with filenames and they must follow the following convention:

AE_ProcessName_ProcessInstance.txt/csvI have found, with App Engines at least, that the RDS only likes extensions txt and csv. Worth trying a few more.

The path can be found here:
SELECT PRCSOUTPUTDIR '\'
FROM PSPRCSPARMS
WHERE PRCSINSTANCE = 11579

Example code:

Local string &pathNmSQLExec("select prcsoutputdir '\' from PSPRCSPARMS where prcsinstance = :1", UQ_UQAP0860_AET.PROCESS_INSTANCE.Value, &pathNm);
Local string &fileNm = "AE_UQAP0860_" UQ_UQAP0860_AET.PROCESS_INSTANCE.Value ".csv";

Note: Michael noticed that the file does not publish to RDS/Report Manager if... well I'm not sure. Check that filename is not too long, does not contain extra periods (don't use %DateTime in the filename) etc., etc..

No comments: