Focal Point
First try with flat file ( Solved )

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

November 27, 2009, 09:35 AM
YKK
First try with flat file ( Solved )
I am trying, for the first time, to make and use a flat file but i did not succeded

Here is the details

Master file is located in
EDASERVE - Applications - raymond - Master Files

whtwer.mas

FILENAME=WHATWERE, SUFFIX=FIX
SEGMENT=BASE, SEGTYPE=S1, $
FIELDNAME=CONO01, ALIAS=F01, USAGE=A3, $
FIELDNAME=LOCA01, ALIAS=F02, USAGE=A10, $

Text file is located in
EDASERVE - Applications - raymond - Other

whatwere.txt

'01','CENTERZIP'
'01','CENTERSB'
'01','CENTERTP'
'01','EASTZIP'
'01','EASTSB'
'01','EASTTP'
'01','WESTZIP'
'01','WESTSB'
'01','WESTTP'
'01','EXPORTZIP'
'01','EXPORTSB'
'01','EXPORTTP'


The procedure is located in

Managed Reporting - Domains - Test - Standard Reports - Test -SAL05

FLATTST

APP HOLD raymond
APP FILEDEF raymond DISK WHTWER/whatwere.txt
TABLE FILE WHTWER
PRINT
CONO01
LOCA01
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,

*other format stuff*

ENDSTYLE
END

Result is:
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

Can someone please tell me what is wrong, i tried all variation of the line
APP FILEDEF raymond DISK WHTWER/whatwere.txt without succes.

Thank you in advance

This message has been edited. Last edited by: YKK,


7.6. / Win 7 / Excel
November 27, 2009, 09:56 AM
GamP
Try this for FLATTST
APP FILEDEF WHTWER DISK raymond/whatwere.txt
TABLE FILE WHTWER
PRINT CONO01 LOCA01
ON TABLE PCHOLD FORMAT HTML
END

Hope this helps...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 29, 2009, 03:42 PM
Waz
Also take note that your flat file is comma delimited.

Flat files can be many formats.

With this one, you should use SUFFIX=COM

See below:
EX -LINES 5 EDAPUT MASTER,whtwer,CV,FILE
FILENAME=WHATWERE, SUFFIX=COM
SEGMENT=BASE, SEGTYPE=S1, $
FIELDNAME=CONO01, ALIAS=F01, USAGE=A5, $
FIELDNAME=LOCA01, ALIAS=F02, USAGE=A12, $

EX -LINES 13 EDAPUT FOCTEMP,whtwer,CV,FILE
'01','CENTERZIP'
'01','CENTERSB' 
'01','CENTERTP' 
'01','EASTZIP' 
'01','EASTSB' 
'01','EASTTP' 
'01','WESTZIP' 
'01','WESTSB' 
'01','WESTTP' 
'01','EXPORTZIP'
'01','EXPORTSB' 
'01','EXPORTTP'

FILEDEF whtwer DISK whtwer.ftm

SET PCOMMA = ON

-RUN

TABLE FILE WHTWER
PRINT *
END



Waz...

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

November 30, 2009, 08:01 AM
YKK
Thank you very much


7.6. / Win 7 / Excel