| Bill Select Data Integration
TechTonics Software Architects, Inc., has
created an auto import for Bill Select. 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.
- 12 = Bill Select
- The next six characters is the time in hhmmss format.
- The extension of the file ends in “.TSA”.
- Example: 12091435.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 Bill Select 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 Bill Select 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
Bill Select Auto Import Program – This
program will read the text file passed from the TSA Polling
Program and populate the fields and processing the billing
selection just as if a user was doing it manually. 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. This will not put the order into
a status code of 8. If all records are correct, the order
will be ready for invoicing.
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:
|
