Keypress BlogInsights, Case Studies, and Resources
Our client was overwhelmed by the amount of manual data entry involved in producing these custom SDS documents. With production reaching as many as 100 custom solutions daily, the staff was spending hours a day inputting detailed chemical information into a website provided by a third party safety compliance service. In order to keep costs in line and reduce errors, the client needed a more accurate and efficient system to generate SDSs.
When our client first contacted us, they were highly dependent on Microsoft Excel Spreadsheets. Excel was their primary tool for data collection and reporting. They were looking for a way that multiple users could input and manage data simultaneously. They started searching for a Microsoft Access developer to design a program based on their spreadsheets, but Access was not powerful enough for what they needed.
One of the markets that our client deals with the most is New York City. The NYC Department of Transportation maintains a website called NYCServ which allows users to lookup info for a specific summons. The client handles thousands of tickets a week, and there is information on NYCServ that they need to fetch for each one. Prior to our help, they had an employee manually searching NYCServer one ticket at a time. NYCServ did not offer any type of API at the time.