Requirements: Supposer Root is R1 Childerens of R1 : L1 L2 L3 Childrens of L1 : C1 C2 C3
In the first step Im retriving the only R1 and storing in some TEMP file showing in the Html form when i click on the R1 then im retriving L1, L2 , L3 and appending to previos file i.e TEMP and showing the R1,L1,L2,L3 and so on
The problem here is that the file TEMP will be accessible for both the users who have been using the same procedure.
One solution is that we can append user ids to the temp hold file name . Immediately after the user session completed the TEMP hold file should be deleted. Is this possible or we have any special hold file Is there any special hold file i.e, session related and independent of users.
Please, if u have any solutions provide us.
-CD Prasad
7.14/win 2000This message has been edited. Last edited by: cdprasad,
April 30, 2007, 03:29 PM
RichH
Use the Search function and I think you will find exactly what you are looking for. This has been posted several times by many different users. Regards, Rich
WebFOCUS 8202 Win 2012 Test - WebFOCUS 8203 on Win 2012
April 30, 2007, 03:45 PM
susannah
cd, your question is a bit confusing. By default, two separate users would operate in two separate agent directories, and not share the temporary extract files, given of course that you have not explicitly filedefed these temporary hold files in your fex. As soon as a fex has delivered its output to the users screen, the contents that agent directory are erased, automatically. But we don't understand your question. Do you want the interim files to vanish? they do, by default. Do you want the interim files to be kept and shared among users? very tricky...
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
May 02, 2007, 02:27 AM
cdprasad
Hi Susannah, Exact requirements Im generating Hierarchical based report. When i click on the Root it has to show child reports in the consecutive rows just below the clicked one. Approach For the first time Im holding the Records R1 in a temp hold file say Temp_hier in focus format. Im accessing this Temp_hier file and showing all the records as as html output. Now this R1 has link to the same fex procedure again. When the user click on the R1, im calling the same fex procedure to append R1 childs i.e L1, L2, L3 in the same Temp_hier and showing all records in the html ouput. Same thing is repeated for all the childs
Here the problem is wid the Temp_Hier temp Hold file.
If the two users viewing the same report, the temp hold file will be shared by both the users at the same time. Then Both the users get unwanted results.
Is there any way to hold the records temporarily for some amount of time(as long as the users are viewing the Html report ouput) with the same file name but with out the problem above stated.
Thanks & Regards, cdprasad
May 02, 2007, 08:21 AM
TexasStingray
cd, you have to do something like you stated above appending the userid to the end of the file, storing each users file in a seperate directory. The problem is that there is no presistance to the backen reporting server after the user gets there response the server cleans us the temp/working directory for that user allowing someone else to use it. You must be using a FILEDEF or APPHOLD to hold the ouput to directory that all uses see and use. so each file must be FILEDEF differently for each your or they will walk on each other. For cleanup you can have report caster run a procedure that deletes the old files say older then the current date and of the same prefix and extention.
Hope this Helps
Scott
May 02, 2007, 09:58 AM
Kamesh
Can't we use the Accordian report? Just a thought.
WFConsultant
WF 8105M on Win7/Tomcat
May 02, 2007, 10:43 AM
Lusheng
If you want to keep the temp files for some time and don't want to share the files among the users, you have to put these temp files in user specified folders.
May 03, 2007, 07:46 AM
cdprasad
Can we create user specific folders and store the temp file in that folder. If possible can any body give a sample code
Next quesiton is How to read that folder names and files so that we can delete them by using report caster. can any body give a sample code for this also
Thanks & Regards, CD PRASAD
May 03, 2007, 09:32 AM
Trav
We are creating user specific hold directories for this very purpose.
This should give you an idea as to how we're doing it.
Keep in mind, we're operating in a managed reporting environment and I have populated &IBIMR_user with the userid of the user that is currently logged into MRE.
For the steps above: Create the user specific directory Map an application name to the new directory Prepend the current app path with the new app name Make any hold files save (permanently) to the new directory.
This comes in very handy for us because several users may be running the same report at the same time. And in addition to that, the hold file is still available after their report request is complete for additional drilldowns, etc. without having to re-retrieve the data.
Hope that helps!
Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio Testing: <none> Using MRE & BID.  Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF
May 04, 2007, 01:01 AM
cdprasad
Trav,
Can't we use the above method in other environments. If yes Please tell me how we can do
May 04, 2007, 09:03 AM
Trav
If by "other environments" you mean besides MR, then I would assume you could -- you simply need a unique identifier for your user. If you can get their user id, the same method should still apply.
All in theory of course because everything we do is in MR...
Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio Testing: <none> Using MRE & BID.  Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF
May 04, 2007, 10:28 AM
cdprasad
Can any one give the code how to read filenames and its properties like last modified time, and how to delete those files
Thanks & Regards, cdprasad
May 07, 2007, 08:24 AM
cdprasad
Hi I think u know the requirements (above)
Is there any hold file that persits data for some time and automatically deletes itself at some point of time.
Is there any variable kind of thing that will automatically deletes the selected focus file at some point of time.
May 07, 2007, 09:04 AM
Trav
You could run a job in ReportCaster to do this.
Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio Testing: <none> Using MRE & BID.  Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF
May 07, 2007, 09:39 AM
jgelona
cd, yes, you can use the method outlined by TRAV. Since you appear to be in a pure Windows environment, it depends if IWA is on or off. If it is on, try
&WF_REMOTE_USER should have the user's Windows login id if IWA is on.
You asked:
quote:
Next quesiton is How to read that folder names and files so that we can delete them by using report caster. can any body give a sample code for this also
The following:
-DOS DIR c:\temp\&WF_REMOTE_USER > c:\temp\&WF_REMOTE_USER\filelist.txt
will put the screen output from the -DOS DIR command into a file named filelist.txt.
Now just you can read the file with TABLE if you create a master or with -READ.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.