Data File Extractor PHP Library

Software Functional Specifications for Version 1.0 Project Summary A data file extractor PHP library is desired for extracting records from large flat data files and importing the extracted records into MySQL database tables. The data file structures differ for various vendors and change over time, and therefore, the software must be smart enough to dynamically discover the data file structure. The software (command line application) will load data files from a specific data directory, parse the files, clean data and insert the data groups into database tables. Project Description Workflow 1. Run command line application, accept arguments for vendor type, data directory path and debug mode a. Debug mode should include verbose actions and logging 2. Load data files from data directory path, parse data files using logic to dynamically detect data file structures and fields 3. Scrub data, apply data rules 4. Import data into MySQL database tables in existing data system a. Also notify existing system of import Timeframe 2-4 weeks development 1-2 weeks of testing various vendor data file sets Project Notes - PHP Library should be developed using PHP 5.4 standards - The final product must be a 100% working solution for all vendor data file sets - Nondisclosure agreement required - Basic core library files already exist that will help give a better understanding of expected logic in new software - No 3rd party/open source software (ex: Database Libraries, Parsing Libraries, etc.) should be included in final package - Full and detailed documentation must be provided by developer on completion - Software developers should be very familiar with these PHP topics: o binary file parsing o hex values o regular expressions o memory management o file I/O functions o command line applications