This is my second try at flatfile and i got a different error

Here is the detail

Master file

EDASERVE - Applications - baseapp - Master Files

plan2010.mas

FILENAME=pln2010, SUFFIX=COM
SEGMENT=BASE, SEGTYPE=S1, $
FIELDNAME=CONORM, ALIAS=F01, USAGE=A2, $
FIELDNAME=YEARRM, ALIAS=F02, USAGE=A4, $
FIELDNAME=PERIODRM, ALIAS=F03, USAGE=A2, $
FIELDNAME=SLMNPL1, ALIAS=F04, USAGE=A6, $
FIELDNAME=SLMNPL2, ALIAS=F05, USAGE=A8, $
FIELDNAME=ITDVPL1, ALIAS=F06, USAGE=A9, $
FIELDNAME=ITDVPL2, ALIAS=F07, USAGE=A15, $
FIELDNAME=AMOUNT01, ALIAS=F08, USAGE=P25.9, $

Text file:

EDASERVE - Applications - baseapp - Other

pln2010.txt

'01','2010','01','EXPORT','EXPORT','SBEXPORT','SB',0
'01','2010','01','EXPORT','EXPORT','SBEXPORT','SB',0
'01','2010','01','EXPORT','EXPORT','SFEXPORT','SLIDEFASTENER',16000.00731
'01','2010','01','EXPORT','EXPORT','SFEXPORT','SLIDEFASTENER',0
'01','2010','01','EXPORT','EXPORT','SFEXPORT','SLIDEFASTENER',69000.00001
'01','2010','01','EXPORT','EXPORT','SFEXPORT','SLIDEFASTENER',0
'01','2010','01','EXPORT','EXPORT','SBEXPORT','SB',0
'01','2010','01','EXPORT','EXPORT','SFEXPORT','SLIDEFASTENER',37000
'01','2010','01','OTHERS','MONTREAL','OTHERS','TP',210.525191
'01','2010','01','OTHERS','MONTREAL','OTHERS','TP',89.124265
'01','2010','01','OTHERS','MONTREAL','SBEXPORT','SB',3839.02725
'01','2010','01','OTHERS','MONTREAL','SBEXPORT','SB',9290.157861
'01','2010','01','OTHERS','MONTREAL','OTHERS','TP',1163.177485
'01','2010','01','OTHERS','MONTREAL','OTHERS','TP',15.159987
'01','2010','01','OTHERS','MONTREAL','OTHERS','TP',0
'01','2010','01','OTHERS','MONTREAL','OTHERS','TP',132.806614
'01','2010','01','OTHERS','MONTREAL','SBEXPORT','SB',3335.044892
'01','2010','01','OTHERS','MONTREAL','OTHERS','TP',52.357666

Managed Reporting - Domains - Test - Standard Reports - WEEKLYSP -FLATTEST

APP HOLD baseapp
APP FILEDEF PLAN2010 DISK baseapp/Pln2010.txt
TABLE FILE PLAN2010
SUM
AMOUNT01
BY CONORM
BY YEARRM
BY PERIODRM
BY SLMNPL1
BY ITDVPL1
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,

$

Here is the result

(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
(FOC416) MORE VALUES SUPPLIED THAN FIELDS IN THE MASTER FILE DESCRIPTION
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

I tried with 1 field in masterfile and '01' inthe text file only 1 line,
I tries removing the commas, making fielsd usage bigger,
Change COM to FIX

Nothing is working.

I know it is probably something small but I can't find it
Can someone tell me what I'm doing wrong

Thank you in advance

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

If you can edit the flat file, try adding

, $

at the end of each line.

Documentation:

Describing Data With WebFOCUS Language > Describing a Sequential, VSAM, or ISAM Data Source

Thank you for the information and the refference to read

Realy appreciated

Raymond.

You don't need to add ",$", just add "SET PCOMMA=ON"