Focal Point
[SOLVED]How to create dynamically a fex file in the user content folder

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7167042086

January 12, 2016, 04:00 PM
rbissonMDF
[SOLVED]How to create dynamically a fex file in the user content folder
Hi,

From a fex procedure (PROC1), we try to create a new fex(NEW_PROC) with the parameters received in the by the PROC1.

The new fex need to be save in the 'My Content' folder of current user.

and the user will be able to run it from an Ad Hoc page.

In the new fex we would write some -SET of variable and at the end of the new fex we want write a -INCLUDE of exiting fex.

It look like the Save Parameter in the HTML Composer. But in our current case i'm not able to use it.

I don't know if my request is clear...

Thank a lot

René Bisson

This message has been edited. Last edited by: <Emily McAllister>,
January 12, 2016, 04:14 PM
Waz
I think this will depend on where you write the new fex to content.

You can use Web Services to do this, and if you have the web services adapter, possibly do it from a Fex.

There may be defines IBI ways to do this. I would suggest asking Tech Support as well as the forum.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 14, 2016, 10:00 AM
rbissonMDF
Hi
We found a way to create a dynamic fex, but we can juste saved it on the server

here a example of how we did it:
-SET &USER_PATH = &IBIMR_domain | 'usr_saved_report/';

FILEDEF OUTPUT_FL DISK &USER_PATH |'test1.fex'
-RUN

-DEFAULTH &MY_NAME='TEST NAME';

-WRITE OUTPUT_FL NOCLOSE -SET &|MY_NAME='&MY_NAME';
-WRITE OUTPUT_FL -INCLUDE IBFS:/WFC/Repository/testapp/test_fex_after.fex


as the included fex is in the repository and the new test1.fex is on the EDASERV, it is unable to include it. We wanted to create the new fex in the repository but we have not figured out how.

So we used an alternative approach using a table in the database in which we make INSERT by SQL.
This way is easier to manage.

Thank you


WebFOCUS 8.1.5
Windows, All Outputs
January 14, 2016, 10:12 AM
MartinY
Instead of writing :
quote:

-WRITE OUTPUT_FL -INCLUDE IBFS:/WFC/Repository/testapp/test_fex_after.fex


You need to use:
quote:

-WRITE OUTPUT_FL -MRNOEDIT -INCLUDE IBFS:/WFC/Repository/testapp/test_fex_after.fex


That will allow the repository to call something from the reporting server.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007