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

Befejezett Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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.

Datatables Laravel MySQL PHP Szoftverarchitektúra

Projektazonosító: #17000882

A projektről

5 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

Odaítélve:

sunny945

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 Továbbiak

€50 EUR 10 napon belül
(29 értékelés)
5.3

5 szabadúszó tett átlagosan 101€ összegű árajánlatot erre a munkára

an1566706

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 accompl Továbbiak

€50 EUR 10 napon belül
(63 vélemény)
6.5
anduel

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 y Továbbiak

€166 EUR 3 napon belül
(1 Visszajelzés)
1.8
ariana1982

A proposal has not yet been provided

€106 EUR 3 napon belül
(0 vélemény)
0.0