Texas Wholesaler Distributor Database (TWDD), which is maintained by the Texas State Board of Pharmacy (TSBP), is a database that provides agency staff with information on what drug pharmacies and facilities are purchasing from wholesalers. My project improved the whole working process of TWDD by modifying the upload procedure and processing disorganized Excel files automatically. This project gives TSBP staff the ability to manage and import wholesaler data updates with some level of automation, which saves them a certain amount of time.
Here is the new design of the upload procedure. After determined the new process, I focused on how to achieve the functions in the grey area.
For no-sale option, I redesigned the upload webpage and added some extra textbox to ask users for more information. Then, base on that information, the system can automatically generate a new txt file with ARCOS code in it, so that userS don’t need to upload any files for no-sale situation.
For excel files, I also added new filtering capability so that only those excel files with the correct format can be proceeded. I also program another function for the system with PHP, which is to transform the excel files into txt files with ARCOS code automatically.
