quote:

Originally posted by John_Edwards:
For a CSV file you can create a plain-jane master file -- one big text field per line. That should read, but then it will be up to you to parse the contents of that single field into its independent parts.

Note that in Dev Studio you can auto-generate a master file from a flat file by right-clicking in the Master Files section of an application directory and selecting New-->Upload Data File. That will parse the file for you for a first round.

If you need to absorb a differently-shaped file each time you'll have to go with the plain-jane option above. If your files will contain the same structure each time and you want to create a master file from your first one option 2 above will help you get started.

J.

FILENAME=VHS_BEDS, SUFFIX=COM     , $
  SEGMENT=VHS_BEDS, SEGTYPE=S0, $
    FIELDNAME=SERV_AREA_ID,      ALIAS=E1, USAGE=A5,    ACTUAL=A5, $
    FIELDNAME=BED_LABEL,         ALIAS=E2, USAGE=A256,  ACTUAL=A256, $
    FIELDNAME=DEPT_ABBREVIATION, ALIAS=E3, USAGE=A20,   ACTUAL=A20, $
    FIELDNAME=BED_NOTES,         ALIAS=E4, USAGE=A1000, ACTUAL=A1000, $
    FIELDNAME=BED_AVAILABILITY,  ALIAS=E5, USAGE=A1,   ACTUAL=A1, $

SET ASNAMES = ON
SET PCOMMA = ON

-SET &FILEPATH = '\\Server\';



-******************************************************************************
-SET &BED_FILE = 'HOSP1\BEDS.csv';
-SET &FULLFILENAME = &FILEPATH | &BED_FILE;

FILEDEF VHS_BEDS DISK "&FULLFILENAME"

TABLE FILE VHS_BEDS
PRINT
	HOSPNAME
	SERV_AREA_ID
	BED_LABEL
	DEPT_ABBREVIATION
	BED_NOTES
	BED_AVAILABILITY

	BY DEPT_ABBREVIATION NOPRINT
	BY BED_LABEL NOPRINT

END

quote:

Have to disagree with this. I have a .csv file and a master that breaks it up into "fields" for reporting

Waz...

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!

  
-* Master
EX -LINES 4 EDAPUT MASTER,GNRL,C,MEM
FILENAME=gnrl, SUFFIX=FIX     , $
  SEGMENT=GNRL, SEGTYPE=S0, $
    FIELDNAME=GNRL, ALIAS=GNRL, USAGE=A250, ACTUAL=A250, $
-RUN
-* Focexec
FILEDEF GNRL DISK app/file.txt
TABLE FILE GNRL
PRINT 
     GNRL
END