Find Jobs
Hire Freelancers

CDR to MySQL parser Perl script

€30-250 EUR

In Progress
Posted about 9 years ago

€30-250 EUR

Paid on delivery
We need a parser that is run from crontab and parses the newest file from the source directory. The custom file format is ascii with fixed field length without delimiters. After accepting the job, we will send you the specifications in table format and a test file. In the spec, each field has a common name, tech name, start position, length, type (hex, digit, char) and an explanation. There are 138 fields. Project tasks: 1. Read the specification file into a MySQL table. (one time, not automated task) 2. Write script to parse file based on the above table. 3. Script writes parsed data into a second MySQL table, one MySQL row per file row. 4. Script writes the file name of the parsed file into a third table. If any errors occurred during the parse, then write binary flag and dump errors into a BLOB/TEXT. The error messages should be human readable. Required error cases are: 1. file incomplete (all rows are fixed length), 2 row/field contains data that is the wrong type and 3. directory/file inaccessible/unreadable etc. The script is to be written in Perl and use DBI for the MySQL connection. Strict and warnings are required. The script will be running on a Solaris server, but you can write and test the script on any OS you are comfortable with. For compatibility, only use packages/modules that are standard Perl or can be downloaded from CPAN. Bid range = 50 - 100 EUR Bid deadline is Thursday 26/02/2012 midnight EET
Project ID: 7198582

About the project

12 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear potential employer. Perl/MySQL professional here. Please, accept this bid to have your task done with the best professional quality,
€95 EUR in 2 days
5.0 (27 reviews)
5.9
5.9
12 freelancers are bidding on average €85 EUR for this job
User Avatar
Hello, interested. I can write pure perl + DBI clear flexible script (no need any CPAN modules) with configuration of mysql connection and logfile at top of script. Regards, Max
€90 EUR in 2 days
4.9 (106 reviews)
6.4
6.4
User Avatar
Hello, I have many experience create perl script Please give me sample data file and MySQL structure
€100 EUR in 2 days
5.0 (129 reviews)
6.2
6.2
User Avatar
I'm Perl expert with huge experience in data parsing / processing that's why I'm sure you'll be impressed with my work. You have really good project description so I have no questions at all. All I need to start is your source file specification (fields/length) and MySQL schema (or I need to create it by myself?). Also I need escrow payment. You'll release it after you'll check everything on your side. I need less than two days to finish it. Strictly speaking I think about end of Wednesday. Thanks. Roman
€98 EUR in 2 days
5.0 (184 reviews)
6.1
6.1
User Avatar
HI, I'm Perl developer and I can write the script for you. Please send the specification and test file. Thanks
€100 EUR in 2 days
5.0 (35 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
€144 EUR in 3 days
5.0 (2 reviews)
3.7
3.7
User Avatar
I've done that kind of work so often in my life, I've worked for VoIP telcos, Airtime transfer companies, SMS Hubs ... where we parse CDR files permanently (for reconciliations purpose mostly).
€122 EUR in 3 days
5.0 (1 review)
2.5
2.5
User Avatar
Hi. We are a group of experienced engineers with different backgrounds (telecommunications, electronics and systems) with experience in technologies like C/C++/C#/Java/J2EE/Linux/Scripting/SQL, who work for a telecommunications company. Along these years we have worked mainly with embedded systems, for example, high availability communications servers and cable modems. Since we have experience implementing applications in both Windows and Linux environments we think that we are suitable for this job. Could you please provide a CDR example? We just want to take a look at it. Best regards, Matias.-
€100 EUR in 5 days
5.0 (1 review)
1.8
1.8
User Avatar
I'm from Ukraine, Kiev. Perl, MVC Catalyst (Mojolicious), jQuery/jQuery UI, JavaScript, SimpleModal, ExtJS, etc. Engine: OTRS, xFileSharing, RT. 7 years experience. === Need Job Details! ~1-2 days; Comfortable - 5 days.
€49 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€55 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a good working knowledge for this type of task and have 8 years of exp in Perl and MySQL. I am working on Perl since starting of my career.
€111 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of FINLAND
Helsinki, Finland
5.0
8
Payment method verified
Member since Feb 9, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.