processing of telephone system log files and display in a searchable datatable
€40-150 EUR
Completed
Posted almost 6 years ago
€40-150 EUR
Paid on delivery
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.
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 system so i would like to discuss the details with you.
€50 EUR in 10 days
5.0 (29 reviews)
5.3
5.3
5 freelancers are bidding on average €101 EUR for this job
I read your project description ……processing of telephone system log files and display in a searchable datatable
…..and we are very exited to work on it
We are an group and we have an expert & qualified to accomplish your project in professional & unique
We are working all section of integrated solution
And for project ………………processing of telephone system log files and display in a searchable datatable
……. There are an specialist expert that can make your project like you want and more!
We are looking for delivering unique services and add all feature that make your project is complete and professional
You can check our sample and previous work before we start in work
We provide for you the best services with the lowest prices
Hello my name is Anduel, i have several years of experience using PHP and MySQL for scripting and programming purpose. I am hard working and very professional. I would like to have the opportunity to collaborate with you on this project. Feel free to contact me.
Best Regards
Anduel