 |
(DIP) Data
Import Processor Since companies use varied sources and types of data storage, it was necessary to create a series of generalized import programs to allow for the easy import of foreign data into the Benepack system. The import process had to allow for myriad of file types, file structures, and the like, ranging from simple ASCII to complex multiple table structures. |
| It had to be able to quickly correlate the input data into the standard file layouts of the Benepack system. As a result of this need, we developed a comprehensive import application that can import data from foreign data sources into any of the related tables of the Benepack system. | |
| The left side of the screen would
list all the DBF type files in Benepack. When the operator selected a
given DBF file, the program would display all the associated fields within that DBF that
are available for import. The operator would then select the database format they wish to
import the data into. The above example shows the GV_LIST master database. Each field of
the master file would be displayed in the upper right portion of the screen. The operator would then click on a field in the input file on the left and "drag and drop" that field in the area beside the field to receive that data. This process would be repeated for each field of the file to import. By automating this process, Benepack users can easily and quickly update their master files with large databases from clients as opposed to having to re-enter the data manually. What is special about this process is the fact that since it is a generic process, it can be used within any application as the generalized import process. |