[CLOSED]Temporary Files

May 20, 2011, 03:03 PM

Charles Richards

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,

May 22, 2011, 06:07 PM

Waz

I think this depends on whether the "file" is generic or specific to a users session.

May 23, 2011, 03:36 AM

GamP

... 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.

May 26, 2011, 03:58 PM

Don Garland

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.

quote:

"Fred Weber Specialty Fastener Reset ","20110722000000000"
"Home Teapot - Transponder Rollout Phase 1 ","20110531000000000"
"Home Teapot - Transponder Rollout Phase 2 ","20110624000000000"
"Storm Depot LNS Refresh 2011 ","20110522000000000"
"Badd Idea - June 2011 ","20110630000000000"
"MomPop Pack Dumping 2011 ","20110415000000000"
"MomPop Hanging Product Reset ","20110701000000000"
"MomPop Picture Hanging Peg Hook Swap ","20110815000000000"
"MomPop Steelworks pamphlets ","20110430000000000"
"MomPop Toggler Replaces Cobra ","20110531000000000"
"MomPop Vision Specialty Drawer Fix ","20110627000000000"
"MomPop Backer Card Clean Up ","20110831000000000"
"Ahoy There anchor conversion project ","20110324000000000"
"Pepsi Boys Thread Gauge Install ","20110729000000000"
"Pears LNS Reset 2011 ","20110731000000000"
"Pears Summer Promo ","20110605000000000"

Create META Data using the Delimited Flat File adapter. Your META Data file (yourmetatdatafile.mas) will look something like this.

quote:

FILENAME=SRVPRJLST, SUFFIX=DFIX ,
DATASET=c:\ibi\wfshare\lookup_data\srvprjlst.txt, $
SEGMENT=SRVPRJLST, SEGTYPE=S0, $
FIELDNAME=SURVEYNAME, ALIAS= , USAGE=A255, ACTUAL=A255B, $
FIELDNAME=DATEEND, ALIAS= , USAGE=P17, ACTUAL=A17, $

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.

May 27, 2011, 09:09 PM

Jim Morrow

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.

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988