Contents of the CONVDB.DOC file
'Easy Data' v1.7
Ascii to dBASE/LOTUS Converter
Copyright (c) 1990
John J. Caputo
Easy Data is a fast and simple way of converting ascii files into
dBASE compatible files or a LOTUS v2.x compatible file. All you do
is describe your ascii file to Easy Data and it does the rest. It
can even create a Clipper format(.NTX) index file to save you the
time in Clipper. Your file descriptions are saved in mask files
which can be used again later.
-All non numeric bytes automatically removed from numeric
fields. This includes , and $ signs.
-0 fields in LOTUS files are now left blank.
-LOTUS cells are formated as comma and the number of decimals
CONVDB.EXE Easy Data main program
CONVDB.DOC This file
DEFAULT.ADB Default ascii to dbase mask file.
DEMO.ADB Demo mask file.
DEMO.TXT Demo non field delimited ascii file for
DEMO2.ADB Demo mask file 2.
DEMO2.TXT Demo delimited ascii file for conversion.
- Input ASCII files.
-with or without field delimiters.
-with or without record delimiters.
- Output dBASE compatible Data and Index files.
-up to 40 fields.
-up to 254 characters/field.
-field types C,N,D or L
- Output LOTUS compatible file.
-up to 40 columns.
-up to 254 characters/column
-field types C,D or L will convert to a LOTUS label
N will convert to a LOTUS numeric cell.
- Works in interactive mode or from batch files.
- Save configuration(mask) files for reuse.
[file_name] (optional) this invokes the batch mode. The
mask file_name will be loaded and the conversion process
will take place.
If file_name is omitted you go into the interactive mode
of Easy Data. The file named DEFAULT.ADB will be loaded
as the current mask.
The screen will be split in two windows. The top window is
Easy Data's main menu. The bottom window is a description of
the current conversion mask.(the mask describes the input and
output files for Easy Data)
To make a menu selection press the number of your choice. No
carriage return is needed.
To convert the demo file type:
The files demo.dbf and demo.ntx will be created.
The second demo mask should produce an identical data file.
To practice converting to LOTUS change the convert to field in
the mask to an L. Also change the extension of the output
file to .WK1. Then rerun the conversion. A LOTUS 2.x
compatible file will be created.
1.) Load Mask
A pop-up menu will appear with a list of all mask files
in the current directory.(up to 50 files) Point to the
mask of your choice with the up and down arrows. Press
Enter to make your selection.
Once a mask is loaded its description will be displayed
in the lower screen window.
2.) Edit Mask
This selection allows you to edit the current mask. The
edit keys work the same as read/get in dBASE.
The edit takes place in two separate screens.
The first screen is the description window already
displayed on the screen. Most of these items describe
the input file. You must describe the following items in
-Name: the name for this mask.
-Desc: a description of the mask.
-Convert to: this determines the format of the output
file. If you use a D then dBASE, use an
L for a LOTUS file.
-Input File: the input file name.
-Output File: the output file name.
-Number of Fields: the number of fields.
-Field Delimiter: the way the fields are delimited.
0 = no delimiters (ex. DATA01019012DATA)
1 = delimiters (ex. "DATA","010190",12,"DATA")
-Record Delimiter: the way the records are delimited.
0 = CR/LF pair. (most common)
1 = CR only
2 = LF only
3 = no record delimiter
-Index Expression: the index exp. for the new index file.
It must contain a valid index expression.
The index will be Clipper format (NTX).
If this is left blank no index will be created.
All index expressions will be ignored if LOTUS
-Chars. to Ignore: this is for special characters which
are in your file which should be ignored. You
can have up to 10 of these characters. If any
of these characters are found in your file
they will be converted to spaces when
An example would be if your file had $ signs
in front of dollar amounts. In order to place
these in a numeric field you need to strip the
The second screen contains the field descriptors for the
new dBASE file. These are standard dBASE field
descriptions. You need complete a description for every
field in the new database file.
-The following information is required for each field.
NAME: Name of the field (up to 10 characters)
The name of the fields will appear in row
1 of your LOTUS spread sheet if you
perform a LOTUS conversion.
TYPE: Type of field. C = character
N = numeric
D = date
L = Logical
LENGTH: Length of the field (up to 254).
DEC: Number of decimals in numeric field.
3.) Save Mask
This will save the current mask in the default directory.
The file name will be the same as the mask name with the
extension of .ADB. If a file already exists by that name
you will be prompted to overwrite (y/n).
4.) Convert File
This performs the actual conversion. The current mask
file will be used.
0.) Quit Easy Data and return to a dos prompt.
Now that you know how to use Easy Data and are happy with the
results its time to pay for it. All I'm ask for is a small
registration fee to cover my time. This will entitle you to free
upgrades to Easy Data.
To register please send $29.00 to: John J. Caputo
4830 S. Blvd. N.W. # 9
Canton, OH 44718
You should find Easy Data simple and fast to use. If you have any
questions or comments please forward them.
dBASE is a registered trademark of Ashton-Tate.
Clipper is a registered trademark of Nantucket Corp.
LOTUS is a registered trademark of LOTUS Development Corp.