processing of telephone system log files and display in a searchable datatable

The task is to transfer the data from the backup-file of a telephone system to a MySQL database and make it available here as a simple, searchable list. I estimated that it should be done in +-5 hours, by an experienced programmer also faster. The telephone system is an Agfeo ES 770 IT: [login to view URL] The mask to be created has an upload button with which I can manually upload and process a new backup file every week. The backup file is [login to view URL] file that contains various files, including SQLite backups. These SQLite backups need to be converted to MySQL, probably best done by Search&Replace of strings (e.g. AUTOINCREMENT -> AUTO_INCREMENT or TEXT -> VARCHAR(255) or delete quotes etc., a [unfortunately incomplete] Approach is at [login to view URL] ) Then the new (!) data must be written to the MySQL table in the backup (so no duplicates, but this can probably be prevented quite simply by suitable UNIQUE indexes). All old data in die MySQL table must be preserverd The evaluation or search can be done e.g. by means of a datatable. The following should be realized here: 8 columns: Date Time duration direction internal extension number internal extension name external phone number external name from contacts (if available) Server-based processing- -Loading partial results (since there are quite a few records in the table, e.g. via [login to view URL] search functions: - Full text search across all columns - Full text search in every single column e.g. via [login to view URL] - Search date [start-date] [end-date] footer: - Number of data records - Sum over column duration Button: - Export current search result to Excel (xlsx, not csv) The displayed table captions should come from a language array in an extra PHP file and the displayed language should be switchable by constant, so that parallel work can be done in German and developed in English. I provide an empty PHP web space and a MySQL database. If you use a php-framework, it must be laravel.