PHP programming of a CSV converter

Development of a PHP solution for the automated conversion of CSV files

eWorks has developed a PHP application for converting booking data on behalf of Hahn Air Interline Services GmbH (Dreieich) and in cooperation with IT Pohl (Großostheim).

The objective was to convert large volumes of booking and personal data automatically and 100% error-free from existing CSV files into an IATA ("International Air Transport Association") target format.

The software was developed using PHP to enable optimum integration into the client's existing technical infrastructure. To carry out the data conversion itself, eWorks developed a PHP library for importing the source data from the CSV files and exporting it to the IATA target format.

Because future format changes were to be expected, the import and export functions were developed to be as customizable as possible for the client. Particular attention was paid to the robustness of the conversion solution, as the conversion process was to run unattended and, if possible, "unnoticed" in the background, and therefore should neither require human interaction nor produce incorrect results. To achieve this stability, eWorks implemented meticulous data validation in combination with detailed logging of all process steps, input data and output data of the converter.

eWorks programmed the converter with PHP, quality assured it and handed it over to the client ready for operation. Following the handover, eWorks supported its client with the installation, commissioning and use of the conversion tool.