processing of telephone system log files and display in a searchable datatable
€40-150 EUR
S-au achitat serviciile după ce au fost prestate
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.
ID Proiect: #17000882
Detalii despre proiect
Acordat lui:
Hi there! I am a professional SOftware developer and have developed many Backup software for MYSQL and other databases. i saw the link you mentioned but there i am not able to view any sort of API for that telephone s Mai multe