projects by Ed Freitas
Automatically Tracking File Changes with Python
In this liveProject, you’ll use the flexible Python language and SQLite database to develop a simple-but-useful document tracking tool for a pharmaceutical company. This sort of automation tool is in high demand from businesses that need to keep track of changes to their important documents. Your challenges will include creating and connecting to a local SQLite database, working with file information and MD5 hashes, and applying automation principles to your tool.
Delivery Notes Data Entry Automation with Python
In this liveProject you’ll step into the shoes of a developer at PharmaChain Iberia, a pharmaceutical supply chain company. A big global competitor has recently set up shop in your region and has been steadily gaining market share, thanks to hyper efficient business process automation in its supply lines. This automation service can receive and read delivery notes ten times faster than the admin staff in your company—and you need to innovate fast to keep your status as the regional market leader. You’ve been tasked with implementing your own company-wide automation solution, using Python to automate your processes. To achieve this, you’ll use Python to iterate through subfolders of your current text-based PDFs and PDF form files and extract field keys and values. You’ll write scripts that can identify field IDs on web forms that correspond to the PDF documents, and automatically populate the web forms with information extracted from your PDFs—no manual data entry needed! Finally, you’ll prepare a report detailing your conclusions for your manager at PharmaChain.
