Change Bulk upload

[pujitha K]

Hi Team,

This is regarding the Change Request bulk upload.

Requirement regarding the change bulk upload, including the expected format, mandatory fields, validations, and any prerequisites.

1. We need to create one front end form (Catalog item or Record producer) for change bulk upload and make Attachment mandatory with some variables like requested for and Is it Bulk upload (only choice is yes) and all other variables which are required- can be done
2. We need to create Excel template such that the fields which are present in the change which are mandatory while creating the change should be present in the excel template.
3. Once user uploads the Excel template and submits the form according to the data provided by the users in the Excel change request should be created in bulk.
4. Whenever user uploads the Excel, we need to verify all mandatory fields which are present in the change are filled by users or no in Excel template shared.
5. If all the data provided by the users are correct, then change requests needs to be created.
6. If at all in Excel template for some of the fields which are present in change and data provided by users is not proper or not filled in template, we need to send one email to requestor telling them that the details filled in the excel or not correct or some fields are empty.

Please suggest me know to proceed on bulk upload and creation of change request and how to validate mandatory fields which are present in the change are added in Excel template.

Thanks,

Pujitha