CSV Data Validation and Segmentation Application
$250-750 USD
Paid on delivery
Need a web based application which can import Excel or CSV files then parse, validate, and export records into different csv files or MySql database for import into master database and/or further record scrubbing.
The application should allow the user to browse and select a Excel, CSV or TXT file from their computer and import the record into a temporary database run a series of validation routines described in the attachment.
Most files imported will have a single row of column headings that the user can review and delete columns as necessary. However, one file type will have a first row of headings and a second row of subheadings for the data similar to those in the attachment. These columns need to be parsed into separate files for further processing.
Both the scrubbed data and the errors need to be viewable on specific screens and exportable as CSV.
More specific details are contained in the attachment.
Project ID: #965002
About the project
Awarded to:
9 freelancers are bidding on average $364 for this job
<<<>>> 6+ years experience ! More than 250 projects completed! References can be provided on request ! Ready to start working on your project !
This is a cool task which we have done previously. We assure that, we can do our best for you!!