The process starts with the user generating two types of CSV files from their internal system (one format for shipments below $200 and a different format for shipments above $200). Due to the large number of shipments involved, there are multiple data files. The data files are themselves saved within two "zip" files.
The process continues when the "zip" files are imported using the EDI-Link - Web Import page. Both types of zip files can be imported at the same time. The process automatically unzips the files, determines the type and uploads the data to the EC Dynamics WebServer.
Shipments of $200 and above are assigned both an entry number and an ACE trip number. Shipments below $200 are assigned only the ACE trip number.
The data files being imported do not contain all the required information. In this case, the information about the FDA Producer (name, address, registration number, etc.) is not contained in the data file. Instead the file contains a code representing the FDA Producer. The missing fields are stored in an external database. As the data file is imported, the import process uses the Product code and the FDA Producer code to identify the proper file in the external "FDA Producer" database and "pull" the missing fields and embed them into the new shipment record.
The import process contains several edit checks to verify the existence and format of selected fields. If any required field is missing, the process notifies the user and stops the import process.
When the import process is complete, the user has the ability to print the required forms. In addition, the EC Dynamics WebServer automatically: