M E N U
Programming Case Study #1
DataGate, a data translation and import utility designed and implemented by EGK Systems:
Solution: a Windows-based application that receives data from third party sources via e-mail and adds it to an existing in-house SQL database residing on a UNIX system.
The program automatically checks the structure of the data received. If it detects problems with the data structure, it sends a report back to the sender explaining the problem encountered. Otherwise, it sends a confirmation that the data was received.
The application includes data-parsers customized for individual contributors to convert their data format to the format of the in-house database. After the data is converted, it is automatically up-loaded to the in-house database that resides on a UNIX server.
An electronic data interchange handbook was given to the organizations contributing data. It documents the preferred format for data and explains the process.
Benefits: Data contributors are happy. They save shipping and media expenses, which makes it easier for them to send data. They send data more often, so the data they send is more current.
How about a similar solution for your company? We can do it for you in record time!
EGK Systems is your source for business computer programming and web design in Pasadena California and surrounding areas. Programming services available in Delphi, C, Access, SQL and ASP. For service, call 626.792.7872.