Devam Ediyor

.csv records processing/matching with MySQL records

Task Summary

A CDR file, in .CSV spreadsheet format, must be processed, and matched to existing records in a MySQL Database. In particular, for each record in the CDR file, the corresponding record in the call table of the Database must be found and matched. Once the match is found, that record in the database must be tagged as "matched" and some fields from the CSV-CDR must be written in the database record.

After upload of the .CSV file, first there is some preprocessing of the records, such as stripping "011" from every record in column B, and adjusting the timestamp to GMT time.

Then for each .csv record there is a lookup in the DB for the matching record. Fields in the call Table may not match exactly those in the CDR file because those on the .CSV file are derived independently from those in the database. So we are looking for close matches, not exact matches (e.g. Starttime +/- 30 seconds)

Beceriler: Veri İşleme, PHP

Daha fazlasını görün: matching mysql records php, matching csv mysql, mysql comma separated values matching, php csv list match, unable add records mysql csv, csv record php, mysql csv records, mysql best match cdr rating, mysql timestamp csv columns, php mysql record csv, mysql matched, csv record, java record processing, matching record php, may g, csv spreadsheet, timestamp, summary table, record call, csv, csv php, csv data, cdr, call record, php upload file csv

İşveren Hakkında:
( 29 değerlendirme ) Vienna, Austria

Proje NO: #35297

20 freelancer bu iş için ortalamada 78$ teklif veriyor

omtechnologies

Dear Sir/ Madam, Our team have taken a close look at your requirements and have come up with a solution with most competitive bidding rates. This bid is for a highly professional and quality work/service that we render Daha fazlası

in 2 gün içinde100$ USD
(190 Değerlendirme)
7.7
momleetech

we can do it

in 3 gün içinde65$ USD
(114 Değerlendirme)
6.8
gigapromoters

Can be done easily.. [url removed, login to view]

in 2 gün içinde100$ USD
(20 Değerlendirme)
6.4
GuruDeveloper

You need me! (i hope :) )

1 gün içinde 50$ USD
(21 Değerlendirme)
5.6
quality1st

we have A DEMO

in 0 gün içinde70$ USD
(34 Değerlendirme)
5.6
survivor

Dear Sir, I have 3 years working with PHP-Mysql and 2 years with Java I have worked in importing data into Mysql Databases where data is represented in many formats like XML , Excel , CSV , Tab separated The proc Daha fazlası

1 gün içinde 75$ USD
(4 Değerlendirme)
4.4
Spin

We will doing all that you want (and more... :-))). Quickly, Professional, Quality - our answer you and your organization. We work more than 5 years.. There are questions? Examples of jobs [url removed, login to view] Daha fazlası

in 7 gün içinde100$ USD
(3 Değerlendirme)
4.7
GLTechnologies

We can do it.

in 4 gün içinde60$ USD
(3 Değerlendirme)
2.8
pmcnally

I have done this type of work before. I have used .CSV files parsed through PHP and I have done theorized about timezone correction.

in 3 gün içinde35$ USD
(2 Değerlendirme)
2.9
wit55

Hi. This is a straight-forward job. I can do this one.

in 2 gün içinde50$ USD
(2 Değerlendirme)
2.2
knowledgehub

Hello, Please check PMB. Kind Regards VIS

in 5 gün içinde100$ USD
(3 Değerlendirme)
4.4
SIVA99

This project is very interesting one, we are INDIA based software and web developers using .NET, ASP, ORACLE, SQL, MySQL, PHP. We are looking forward for your favourable reply.

in 10 gün içinde85$ USD
(1 Değerlendirme)
2.8
rajatprasad

I can write a macro in excel & query in SQL to do this process automatically for you

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
amohunta

Hello! We rea working on a similar reqt. for a UK based client. We can write the application for it that will enable you to upload CSV to MySql yourself each time. But definitely not at this price. If you decide Daha fazlası

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
mnaveed

I am expert in developing solutions using vb.net,[url removed, login to view],databases and crystal reports. I am working in a telecom company (Billing Department), so I have very strong concepts of CDRs, streams, menipulating the fi Daha fazlası

in 7 gün içinde90$ USD
(0 Değerlendirme)
0.0
daypex

We have completed a number of CSV/MySQL systems in the past and would be happy to work on this project for you. Please feel free to message me with any questions or to discuss this further.

in 7 gün içinde100$ USD
(0 Değerlendirme)
0.0
rsinfotech

Hello Sir, Our team has strong experience in web site designing and development. We have biuld many [url removed, login to view] you feel us relable then we can work with you. Thank You. Regards , RS Infotech.

in 7 gün içinde60$ USD
(0 Değerlendirme)
1.0
enggdatasoft

Your matching will be done according to yopur satisfaction. Thanks

in 10 gün içinde100$ USD
(0 Değerlendirme)
0.0
keerthipavan1982

Altura IT Solutions (P) Ltd is an upcoming Software Development Centre based in India. Our Team of professionals are very experienced in handling projects related to Application Development([url removed, login to view], Daha fazlası

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
ggsoft

Hello Sir, I have seen your requirements and assure you of quality work. I have 2 years of experience in web technologies. I have handled import/export of data between MYSQL and .CSV file. Waiting for reply. R Daha fazlası

in 2 gün içinde90$ USD
(0 Değerlendirme)
4.4