| Confirm Ship Data Integration
TechTonics Software Architects, Inc., has
created an auto import for Confirm Ship. 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.
- 10 = Confirm Ship
- The next six characters is the time in hhmmss format.
- The extension of the file ends in “.TSA”.
- Example: 10091435.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 Confirm Ship 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 Confirm Ship 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 Confirm Ship 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
to do a Confirm Ship transaction. If any errors are found
during the import, the order 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 a confirmed pick
status.
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:


|