 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Session Hold file | Login/Join |
| Member |
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 2000This message has been edited. Last edited by: cdprasad, | ||
|
| Platinum Member |
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 | |||
|
| Expert |
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...
| |||||
|
| Member |
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 | |||
|
| Master |
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  | |||
|
| Master |
Can't we use the Accordian report? Just a thought. WFConsultant WF 8105M on Win7/Tomcat | |||
|
| Platinum Member |
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. | |||
|
| Member |
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 | |||
|
| Platinum Member |
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 | |||
|
| Member |
Trav, Can't we use the above method in other environments. If yes Please tell me how we can do | |||
|
| Platinum Member |
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 | |||
|
| Member |
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 | |||
|
| Member |
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. | |||
|
| Platinum Member |
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 | |||
|
| Master |
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:
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. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |