Excel Data Uploader and Verifier
Budget: $750 – $1,500 USD
The successful candidate will create a function that serves to upload and validate data from an excel file to a database. This function should be equipped with the following features:
1. Data Type Validation
2. Data Format Validation
This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus.
Here is the main flow:
1. User upload excel file
2. System will check and validate the data
3. System saves record into multiple tables in a database
2 types of excel files involved. Please check attachments.
3 types of data will be stored into database
1. User profile
2. User farm
3. User plant
Detailed flow:
1. User upload excel file and save records in a temporary table with a batch number (Eg: 20240318A)
2. System will check data format for 1 row. If data format passed, proceed step 3. If failed, state which cell has wrong format in the temporary table and jump to step 6.
3. System will check if user profile exists in database. If not exist, insert new record for user profile (3 tables involved). If exist, skip. Proceed for user farm
4. System will check if farm ID exists in database. If not exist, insert new record for user farm. If exist, skip. Proceed for user plant
5. System will check if plant ID exists in database. If not exist, insert new record for user plant. If exist, skip. Proceed step 6.
6. Repeat step 2 for the next row from excel file until the last row.
Need to develop using latest Laravel.
1. Data Type Validation
2. Data Format Validation
This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus.
Here is the main flow:
1. User upload excel file
2. System will check and validate the data
3. System saves record into multiple tables in a database
2 types of excel files involved. Please check attachments.
3 types of data will be stored into database
1. User profile
2. User farm
3. User plant
Detailed flow:
1. User upload excel file and save records in a temporary table with a batch number (Eg: 20240318A)
2. System will check data format for 1 row. If data format passed, proceed step 3. If failed, state which cell has wrong format in the temporary table and jump to step 6.
3. System will check if user profile exists in database. If not exist, insert new record for user profile (3 tables involved). If exist, skip. Proceed for user farm
4. System will check if farm ID exists in database. If not exist, insert new record for user farm. If exist, skip. Proceed for user plant
5. System will check if plant ID exists in database. If not exist, insert new record for user plant. If exist, skip. Proceed step 6.
6. Repeat step 2 for the next row from excel file until the last row.
Need to develop using latest Laravel.