I have a web-based data processing utility that screens and filters job postings in a csv file. I need that existing tool enhanced, and then I need a second utility that utilizes some of the information from the first tool.
The tool:
Imports a CSV File
Filters out unwanted records
Creates a new directory for each customer
Saves output files
Creates master file
Gives the option to scrub against the master file for that customer, so that only unique records are returned
Here is a summary of what needs to be done:
I. Adjustments to existing script:
A) Allow for positive and negative keyword filters for fields of job title and company name
B) Allow option to save settings for each customer. Save whatever was checked for that customer so it comes up again whenever that customer is selected. (However, if this adds a lot of work or makes this project more expensive, we can skip it)
II. Part 2 - new processing features
A) Import 3 files from hard drive. Should be 3 separate form fields for uploading. There are 3 options here. These should be radio buttons. One must be selected.
B) Fix errors in Company Name and Job Title fields
C) Run query of 2 files, and Link files on website field, and output file should only contain records that match based on website for both.
D) We will query the output file against the master, after the master has been added to.
E) Undo option - Because in Part1, and part 2a, the records are added to a master file, if there are any mistakes, I need to be able to delete the records that were added to the master, so that I can run it again and have the correct results.
F)Email results - Output from both queries in Part 2 should be emailed to a specified email address.
More details, and files, in the zip file.
## Deliverables