Parse a PDF file to CSV, and then import to MySQL

System description - A base folder structure named XXX (configurable) has a list of subfolders with several hundrends of pdfs _ A process runs to convert all pdfs to UNICODE UTF-8 text format by using xpdf and rename all processed pdfs to *.pdf_YYYYMMDD_BATCH_SERIALNO All text files are moved to a mirror folder structure [login to view URL] all processed pdf are moved to an archive folder named [login to view URL] BATCH is a batch number to hold an incrementally increased serial for historical reference It is increased each time a batch runs. SERIALNO is a number for 1 to N increased per file processed. All text files are named exactly like the pdf file but renamed to text - When the batch finishes then another script is running to read the content of each text file and convert several values to a CSV file described in the attached excel file. ([login to view URL]) - Based on the examples 2 tables / cvs should be created. One for a Lead and a set of Executives per Lead Records for a Lead should be linked to Executives by using a unique key For a Lead and each Executive linked. For example: [login to view URL] holds a record with ID YYYYMMDD_BATCH_SERIALNO_43 [login to view URL] holds a set of executives linked to the lead by using the format: YYYYMMDD_BATCH_SERIALNO_43 The CSV format should be compatible with mysql [login to view URL] csv import. - Care must be taken to remove all formatting for numbers and convert the date to a mysql compatible format. - All base parameters should be configurable - All scripts should be ready to run on any mac,linux,*nix system using Perl,PHP or Python Deliverables should be: Clean code // Documented code A folder structure to hold MANY files Demo data One script to convert pdfs to text and maintain the structure One script to provide the conversion to CSV as described One script to import the csv to mysql. Provided: A set of example PDFs and expected text files and a csv with exact columns description as ordered.