Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Session Hold file
 Login/Join
 
Member
posted
I m trying to generate Hierachical type report.

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 2000

This message has been edited. Last edited by: cdprasad,
 
Posts: 20 | Registered: December 21, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 173 | Registered: November 16, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 20 | Registered: December 21, 2006Reply With QuoteReport This Post
Master
posted Hide Post
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

 
Posts: 865 | Registered: May 24, 2004Reply With QuoteReport This Post
Master
posted Hide Post
Can't we use the Accordian report? Just a thought.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.
 
Posts: 118 | Location: Omaha, NE | Registered: June 12, 2003Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 20 | Registered: December 21, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
We are creating user specific hold directories for this very purpose.

This should give you an idea as to how we're doing it.

-DOS mkdir c:\temp\&IBIMR_user
APP MAP ARTEMP c:\temp\&IBIMR_user
APP PREPENDPATH ARTEMP
APP HOLD ARTEMP


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
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Trav,

Can't we use the above method in other environments.
If yes Please tell me how we can do
 
Posts: 20 | Registered: December 21, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 20 | Registered: December 21, 2006Reply With QuoteReport This Post
Member
posted Hide Post
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.
 
Posts: 20 | Registered: December 21, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005Reply With QuoteReport This Post
Master
posted Hide Post
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

quote:
-DOS mkdir c:\temp\&WF_REMOTE_USER
APP MAP ARTEMP c:\temp\&WF_REMOTE_USER
APP PREPENDPATH ARTEMP
APP HOLD ARTEMP


&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.
 
Posts: 953 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.