| Order Entry Data Integration
TechTonics Software Architects, Inc., has created an auto
import for Order Entry. This modification has been written
in Cobol. This program will read a text file and populate
the fields on the screen with what is in the text file. If
a field is left blank in the text file, the program will
use the standard Macola default values.
The naming convention of the text file is as follows:
- The first two characters determine which program to run.
- 01 = Order Entry
- The next six characters is the time in hhmmss format.
- The extension of the file ends in “.TSA”.
- Example: 01091435.TSA
The general flow of the import program is as follows:
- The user creates a text file with the provided record layout.
The record layout contains the starting and ending position
of each field. It will also state if a field is a required
field or an optional field. If the field is an optional
field, the layout will also give you the default values
to use for that field.
- The user places the text file into the x:\macola\data_??
Directory.
- The TSA Polling Program will look for all files that end
in a *.TSA and will read the first two characters of the
file name and determine which program it will need to call
to do the processing.
- The TSA Order Entry Auto Import program will populate the
fields on the screen with the values in the text file.
The import program will continue to use Macola’s
validation and business logic. If there is an error during
import, the
import program will move the invalid record to an error
reprocessing file for a user to review the error.
- The TSA Reprocess program gives
the user the ability to view the errors from the TSA Order
Entry Auto Import
program.
This program allows the user to change the data in the
text
file and after save the changes, the TSA Polling Program
will find the just corrected text file and start the
processing loop all over again.
TSA Polling Program – This program
can be started in the morning and left running all day
or it can be started
and stopped by the user at any given time as long as it is
not processing any text files. This program will look for
the text files in the x:\macola\data_?? Directory and call
the TSA Order Entry Auto Import program. A screenshot of
the TSA Polling Program is seen below:
TSA
Order Entry Auto Import Program – This program
will read the text file passed from the TSA Polling Program
and populate the fields that are in the text file onto the
screen. If any fields in the text file are left blank or
the default values are used, the TSA Order Entry Auto Import
program will use the defaults from the customer master and
the item master. This program will read the OE Setup file
and if the “Use Macola Order No” is checked,
the program will use the F5 key logic to get the next order
number otherwise it will use the order no provided by the
user in the text file. If any errors are found during the
importing of the text file, the entire order, for that order
number, will be written to the Reprocessing file. The user
can then use the TSA Reprocess program to fix any errors.
The order will not be in Macola at all. The import program
will also accept text files that are for deletions of line
items or the deletion of the entire order. The import program
will also allow changes to line items. The import program
can handle adds, changes and delete records.
TSA Reprocess Program – This
program will read all the orders that are in error and
display them on the screen
so that user can select which order to reprocess. Once the
order number has been selected, another screen will be displayed
showing the detail record. The user will have the capability
to fix the field in error and save the record. Once the record
is saved, the TSA Polling Program will pick up the fixed
text file and process the file. Screen shots of the TSA Reprocess
Program are shown below:
|
