Evaluation of reply cards from end customers

The data provision for the application takes place via an FTP server. From here the supplied files are transferred to the file directory of the Windows server. The scripts required for this are created with the help of the WinSCP tool and can run automatically. The delivered data (as .csv and .txt files) are loaded into tables on the SQL server using the BCP tool. In this context, a check of the read files is performed to see whether they have already been read. When processing the read data, it is checked whether the customer contact already exists. In addition, various plausibility checks are performed. When creating the output files for further processing in the subsequent systems, a distinction must be made between data for manual post-processing and the correct data. All steps are running in automated procedures and are checked for possible errors in the process.