Connect the legacy files.
Custom PHP parsing and database imports turn FTP files into data the application can report on.
PEARLCROP / CUSTOM WEB APPLICATION
From truckloads.
To clear reports.
I built a custom PHP application that gives growers access to their shipment and yield reports. It connects Pearlcrop’s existing FTP data with a database and uses the Google Drive API to make each account’s report PDFs available to view and download.
Visit Pearlcrop ↗- MY ROLE
- Custom application development
Data & API integration - THE APPLICATION
- Grower reporting portal
Built in PHP - THE DATA
- Legacy FTP files
Parsing & database imports - THE DOCUMENTS
- Google Drive API
Account-specific PDF reports
Pearlcrop Grower Portal
Enlarge ↗THE PROJECT
Keep the existing system.
Make the data useful.
Pearlcrop’s shipment data lived in an older FTP file system. I built the PHP application to retrieve those files, parse the data, and import it into a database that could power the reporting portal.
Growers could sign in to see what their trucks had shipped, review their yields, and download the reports tied to their account. I also connected the company’s Google Drive through its API so customer report PDFs could be accessed through the application.
THE CONNECTIONS I BUILT
Old systems.
One reporting workflow.
The application brings the shipment data and report documents together for the people who need them.
01 / INPUTLegacy FTPShipment & yield data files
02 / PROCESSCustom PHPParse files · import data
03 / STOREDatabaseData behind the reports
Database → account-specific reports ↓
DOCUMENTSGoogle Drive APICustomer report PDFs
ACCOUNT-SPECIFIC ACCESSGrower portalView shipments & yields · download reports
THE WORK, CONNECTED
Built around
the way they work.
A fully custom application connecting the company’s existing systems with reporting growers could use.
Make the numbers usable.
Account-based access lets growers review shipments and yields, filter their reports, and export the information.
Bring the PDFs together.
A Google Drive API integration connects customer report PDFs with the right account in the portal.