Web Page System for Automatically Importing Drug Orders into TSBP’s Database

I am going to add some new features to the old web system of Texas State Board of Pharmacy (TSBP) which makes the whole system more automatic. Currently, the TSBP will receive the orders from the wholesalers by Email or submit a specific type of file from TSBP’s unique system. However, the problem is the system now can’t automatically load the data from the uploaded file and save the data into the TWDD database. Currently, this step is finished by a technical employee. Also, although the file’s type is required, the wholesalers sometimes will not follow the requirements. So, I try to make the whole process automatic and check whether the uploaded files are in the ARCOS format. If I finish these aims, that will help the TSBP to improve their efficiency.