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

Finalizat Postat la acum 5 ani S-au achitat serviciile după ce au fost prestate
Finalizat 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.

Datatables Laravel MySQL PHP Arhitectură software

ID Proiect: #17000882

Detalii despre proiect

5 propuneri Proiect la distanță Activ acum 5 ani

Acordat lui:

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 Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% EUR în 10 zile
(29 Recenzii)
5.3

5 freelanceri plasează o ofertă medie de 101€ pentru proiect

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 Mai multe

€50 EUR în 10 zile
(63 recenzii)
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 Mai multe

€166 EUR în 3 zile
(1 părere)
1.8
ariana1982

A proposal has not yet been provided

€106 EUR în 3 zile
(0 recenzii)
0.0