PEEKAY-CAD

Import Data

THIS SECTION IS UNDER REVIEW
12.1 Setup the dBASE Programme.
      Setup a file with a "PRG" extension with a line for each file as follows:- APPEND FROM [filename] TYPE SDF
12.2 Create the dBASE file.
Create a dBASE file having same structure as the template file as follows: -
      12.2.1 Drawing Index
FIELD NAME TYPE   LENGTH
DWGNO  CHARACTER  8
REV   CHARACTER  3
TITLE1  CHARACTER  25
TITLE2  CHARACTER  25
TITLE3  CHARACTER  25
TITLE4  CHARACTER  25
SCALE  CHARACTER  5
      12.2.2 Instrument Index
FIELD NAME TYPE   LENGTH
NAME   CHARACTER  8
DWGNO  CHARACTER  8
TITLE   CHARACTER  20
FUNC   CHARACTER  8
LOOPNO  CHARACTER  8
      12.2.3 Material List
FIELD NAME TYPE   LENGTH
QTY   NUMERIC  3
UOM   CHARACTER  5
SCODE  CHARACTER  8
DESC   CHARACTER  55
12.3 Import the Data Into The dBASE File.
      Start dBASE and use the appropriate data base file. Run the appropriate programme file. This will add the data from the ASCII text files.
12.4 Generating Reports.
      Create a report form for the dBASE file and print out the data in the desired format.

RETURN TO TABLE OF CONTENTS