 |
|||||
|
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 |
| [CLOSED]Temporary Files | Login/Join |
| Platinum Member |
I would like to create procedure or HTML file that loads data from a temporary file created by other procedures. My question is what is the best way/format to export data as a temp file to be loaded back into either a HTML via the HTML composer or to load into another fex file?This message has been edited. Last edited by: Charles Richards, WebFOCUS 7.6 Windows, All Outputs | ||
|
| Expert |
I think this depends on whether the "file" is generic or specific to a users session. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
... and of course what the purpose of the file is. If it is meant to show data in an HTML manner then it needs another format then a file meant to upload data into a database. GamP
| |||||||||
| ||||||||||
| Guru |
Okay, I'll step out on a limb here and assume you mean that you'd like to create a data source to report from. I'll also assume that "other procedures" means something other than WF is creating the file in question. Otherwise you'd just create a WebFOCUS file with automatic META DATA Creation and use that. If all of that's true, here is what I would do. I suggest a CSV file for your solution because almost every "other procedure" can output that. You'll need the WebFOCUS 'Delimited Flat File' adapter. I don't remember if this is licensed or not. One-Time Tasks: Create a share folder off the \ibi\[yoursharename] of the report server to store your new data files. You don't want to go mixing your custom files in with IBI's stuff. Create the text (quote delimited, comma separated) file, like the one below and store it in the new share folder. This example file contains two columns of data, Survey Name and Date End.
Create META Data using the Delimited Flat File adapter. Your META Data file (yourmetatdatafile.mas) will look something like this.
Once this structure is in place, the external program can update the file at will and the data source will look like any other data source that you have META DATA created for. Can't tell a Flat File from a MSSQL database. Also, you'll need to add your share folder to the app path. If that's not what your were thinking then, never mind. | |||
|
| Platinum Member |
If you want the data in Excel. You get set up a spreadsheet which will load from your WebFocus server when it is opened. Use the Excel menu option All you have to do is distribute the Excel You may want to but a reminder in a heading or footing as to the source of the data. This way you can get some credit for a slick tool. Jim Morrow Web Focus 7.6.10 under Windows 2003 MVS 7.3.3 | |||
|
| 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 |