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)
21 freelancere byder i gennemsnit $77 for dette job
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.
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.
Hello Sir, Our team has strong experience in web site designing and development. We have biuld many websites.If you feel us relable then we can work with you. Thank You. Regards , RS Infotech.