Does anyone know if there is a way to run the MREEXTRACT utility from a dashboard. Our issue is that our client is on zLinux. We have several group admins who for SOX controls need to run reports against the data provided by the MREXTRACT utility. We would like to set it up so that they can run the utility without having to logon to zLinux and run the utility especially since some are not familiar with that environment. This is a new environment for myself also as in past the client was on windows.

Thanks

You didn't say which dashboard.

If it is WebFOCUS, you can create a focexec that runs the mrextract.bat file by putting a ! in front of it, e.g.:

!/home/ibi/WebFOCUS76/utilities/mrextract.bat

Check the permissions on the file to make sure it is world executable.

Then have code to report off of the extract files.

If it is not a WebFOCUS dashboard, the mradmin manual describes how you can run the extract via java.

Sorry I meant the webfocus dashboard. My problem is that with the reporting server running on windows and the client on zLinux no code I write can seem to find the mrextract file. Which I think makes sense as this is running on the Reporting server so it looks for the file on windows and it is not there as this is a client utilitiy

We run the mrrextract utility from a dashboard as part of our administration routine whenever we add users, groups, etc.. Our reporting server is on AIX, but the concept should be similar.

Create a htm pointing to a fex or just a fex and add to the dashboard.

Add the below line first in your fex with the correct path. (Fully path the command) Create a batch file (.bat) that contains the command or call the command directly.

-WINNT C:\...\mrextract.bat

This is how we do it, but we use the -UNIX instead of -WINNT

We wrapper the mreeextract program in a .ksh, because we need to do additional system level processing on files.

Hope this helps
David

Thanks, That worked great on our servers where the client and the reporting server our on the same platform.

However on the systems where the client is zLinux and the reporting server is windows this does not work. If I change the command to UNIX instead of DOS it seems to ignore the command as nothing happens no errors that I can find but no data either. Any ideas how to do this in a mixed environment ?