Focal Point
[CLOSED] how to access file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/265106261

June 25, 2009, 02:37 PM
WF_Novice
[CLOSED] how to access file
Will try to explain..
Objective: Want to create a report from csv file.
Description:
I saved the .csv file into "OTHER" folder in my Domain. - MRE or DataServers.
Is this possible to create MFD & Report in same fex.
Example:
::Report.fex::
FILE=TRADE, SUFFIX=COM
SEGNAME=QMTRADE, SEGTYPE=S1, $
FIELD=NUMBER, ALIAS=M01, USAGE=A40, ACTUAL=A40, $
FIELD=DATE, ALIAS=M02, USAGE=MDY, ACTUAL=DATE, $
-*
FILEDEF TRADE1 DISK "how to specify .csv file located in OTHER folder"
TABLE FILE TRADE
PRINT *
END

Thanks for any help

This message has been edited. Last edited by: Kerry,
June 25, 2009, 02:57 PM
Doug
Check out the the documentatiosn for the creation of synonyms. There's a lot more to it then a FILEDEF. Not to mention that the "FILE=..." doesn't go in the fex.
June 25, 2009, 04:10 PM
GinnyJakes
Another way is to do an 'import' from the masters logical folder. It will load the file into the WebFOCUS environment and create a master for you.

Novice, please update your profile signature with your release and such so that we can better help you. We don't want to tell you to do things that you can't do in your environment.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google