home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Black Box 4
/
BlackBox.cdr
/
database
/
jobapp.arj
/
LOADDATA.DOC
< prev
next >
Wrap
Text File
|
1991-07-29
|
6KB
|
111 lines
The purpose of load data is to merge already existing data into
the DataBase without re-entry. Converting data is a low technical
chore that sooner or latter you must face doing if you are at all
serious at computing so why not start now. First you must make a
printout of the file in question knowing what the file looks line is
vital to the successful operation of this program
The program is as user friendly and as universal as possible,
upon entering the loaddata program. (if the run from the dos prompt
the datapath must be the default) which may be done either by menu
from JOBAPPS or from the dos prompt.
It first asks what drive, path, file.ext you wish to upload. If
you omit the drive and path the program looks in the default path. if
the program cannot find the file the program declares a 'FILE' error
and aborts (more can be found about errors in appendix A of
JOBAPPS.DOC
Next it asks what device to send to print parsed and converted
records, (including record number and week designated for extraction)
although any legal filename may be typed it is looking for a printer,
NUL may be used it you do not want a printout, and a blank reassigns
to LST default the first parallel port
Then it wants an extraction code Local, Distant, Contractor, and
Employment agent this code determines the frequency that
reapplications occur. Last before getting down to business It requests
a Notes string that will be saved as a comment in all the new records
NOW DOWN TO BUSINESS
You will be presented with a short but incredibly powerful menu.
the first selection is line by line that means the data elements are
each on different lines such as the following example
Personnel
Company
Address
City, State Zip
greetings
Sherlock Holmes
British detective consulting
221 B. Baker St.
London, England
Dective Holmes
OR
Personnel
Company
Address
City, State Zip
*
Sherlock Holmes
British detective consulting
221 B. Baker St.
London, England
*
If your Text looks Like the above Choose 1. {the first example
uses a line count as the delimiter the second uses an asterisk. Now
LOADDATA.DOC PAGE 2
you are poised with a new set of questions the first is what line does
personnel occur In the above example It occurs in the first line you
would then enter one, use the actual line personnel occurs in your
case. Then the rest of the fields of the address, when the field is
not present to enter 0 this is true on any field.
The last question asks for a field count if your text is like the
first example the addresses are every four lines you would enter 4 but
if your text has a delimiter, in the second example an asterisk you
would enter 0. When the program will ask what is the delimiting char.
Now wait for the dos prompt to return and all should be good.
The Second selection is delimited this means all the fields occur
on one line but are separated by a special character such as the
following example:
Personnel\Company\Address\City, State Zip\greetings
Sherlock Holmes\British detective consulting\221 B. Baker St.\London E
ngland\Dective Holmes
If your text falls into this category then enter 2 the first
question after is what is the delimiting character in the example it
is a back slash (in your case it may be something else). Next is a set
of address questions similar to line by line (ABOVE) except they refer
to fields instead of lines.
Since the end of the line is the only possible record delimiter.
no further questions are necessary, Simply wait for the dos prompt.
The third selection refers to data that is presented in a table
format such as the following:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7
Personnel Company Address City, State Zi
p
Sherlock Holmes Detective Consulting 221 B. Baker St. London, Englan
d
James Hooker HookreSoft Sysop W8753 State Rd. 54 Shiocton WI 54
170
OR
----+----1----+----2----+----3----+----4----+----5----+----6----+----7
Personnel Company Address City, State Zi
p Sherlock Holmes Detective Consulting 221 B. Baker St. London, En
gland James Hooker HookreSoft Sysop W8753 State Rd. 54 Shioct
on WI 54170
Personnel occurs at 1 for a length of 16 to be entered as: 1,16.
Company occurs at 17 for a length of 21 to be entered as: 17,21.
Address as 38,18 and so on this as you can see according to the sample
for you will have to get a ruler and do some character counting on
your own listing.
After the program is done asking questions about the locations of
the fields it will ask if the records are Variable, such as the first
example, or Fixed such as the second example if it is fixed it will
then want to know what the record size is, in the example it is 74