Hi ,
How to create bulk data upload facility in a form with validation like if salary of employee is less than 0 its should show error at last after remaining data uploaded and should be able to export the error data.Please find the requirement.
Form should facilitate Bulk data Upload functionality via excel. While bulk upload it should check all the validations as stated above before loading the data to table. Only valid data will move to table and Invalid data will be reported as errors.
User should be able to export the invalid data to an excel and correct the data and import the same.
Functionality says All the employee information will be uploaded in every upload.
During sequential upload if the employee already exists , then only update the details as per the new upload.
..