Report Normalization & Data Extraction Tool
Budget: €250 – €750 EUR
I'm looking for a skilled PHP/MySQL developer to create a tool that normalizes various reports from different measurement platforms (DCM, IAS) and filters specific columns and rows. The reports will be automatically sourced from a server path, requiring no user intervention.
Key Requirements:
- The tool will need to process different report templates (10-12) that we will provide.
- You should be able to select and extract varying data columns from each report (sometimes as few as 3, other times up to 10).
- Column names will be specified in a pre-defined configuration file.
- The filtered data needs to be stored in a MySQL database, grouped by different fields includes in the report.
Ideal Skills:
- Proficiency in PHP 8.1 and MySQL
- Experience with data normalization and filtering
- Familiarity with working with measurement tools reports
- Ability to develop automated, server-based processes.
Please note, the project does not require you to source the reports. You will be provided with the necessary tools and access. The successful completion of this task will help streamline our data processing significantly.
The tool should process and store new reports daily. The tool should log any errors encountered during report processing to a specified log file. The error log should be in plain text format. The tool should send an email to a specified address when an error is logged. The tool should produce summary reports. The summary reports should be produced in email format. The summary reports should be produced in plain text email format. The tool should generate daily summary reports.
Key Requirements:
- The tool will need to process different report templates (10-12) that we will provide.
- You should be able to select and extract varying data columns from each report (sometimes as few as 3, other times up to 10).
- Column names will be specified in a pre-defined configuration file.
- The filtered data needs to be stored in a MySQL database, grouped by different fields includes in the report.
Ideal Skills:
- Proficiency in PHP 8.1 and MySQL
- Experience with data normalization and filtering
- Familiarity with working with measurement tools reports
- Ability to develop automated, server-based processes.
Please note, the project does not require you to source the reports. You will be provided with the necessary tools and access. The successful completion of this task will help streamline our data processing significantly.
The tool should process and store new reports daily. The tool should log any errors encountered during report processing to a specified log file. The error log should be in plain text format. The tool should send an email to a specified address when an error is logged. The tool should produce summary reports. The summary reports should be produced in email format. The summary reports should be produced in plain text email format. The tool should generate daily summary reports.