Use parameters to make the file path dynamic

AJ_BI

commentary_test.rtf

commentary.qfr.000022.202412.rtf

when called with static link.png

we have requirement in BI Publisher template to call template from External file in the folder mounted in BIP Server.

<?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000022_202412.rtf?>

<?call-template: QFR_PR_TITLE?>

I have two parameter which would be passed to the Main BIP template

<?param@begin:FUND_ID;'000022'?>

<?param@begin:END_DATE;'202412'?>

the above parameters data should replace the appropriate data in the link /commentary_qfr_000022_202412.rtf

and based on this parameters , the link should dynamically call the file in the folder.

so if the i pass the parameter as

<?param@begin:FUND_ID;'000060'?> ,

<?param@begin:END_DATE;'202409'?>

the link should call -

<?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000060_202409.rtf?> at runtime

Any help on this is appreciated. Thank you

Kevin M-Oracle

You can wrap the import with a conditional statement so you pull the file you want.

Rgds,

Kevin

AJ_BI

Thanks kevin. I am bit lost here. appreciate if you can give an example. commentary_test is my main template and it calls the <?call-template: QFR_PR_TITLE?> from commentary_qfr_000022_202412.rtf which is in the file system using

<?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000022_202412.rtf?>

The file path needs to be dynamic based on the parameters pass to the main template.

Kevin M-Oracle

You can use:

<?if:whatever?>

<?import:file:/istinc/OBIE/board/commentary/commentary_qfr_000022_202412.rtf?>

<?end if?>

Do this for each subtemplate.

Rgds,

Kevin

AJ_BI

got it but there is problem. The files will be loaded every month and we want to automate that link in the template and I wouldn't know the name of the file it its uploaded to the shared folder. but I have parameters which user will supply on which file needs to called based on

<?param@begin:FUND_ID;'000060'?> ,

<?param@begin:END_DATE;'202409'?>

so based on the Parameters, the import file name will change.

Kevin M-Oracle

Depending upon the requirement, can you reuse file names rather than use new names each month?

Rgds,

Kevin

AJ_BI

We are currently reusing the file by replacing the info in the file. But the requirement got changed where they want to maintain the file and so they will get us new file every month with fund and date combination.