The requirement is to create a catalog item that allows users to perform a bulk import of license key data into the samp_sw_license_key table. When the user submits the catalog item with the bulk upload file, the system should validate the data before loading it into the target table.
As part of the validation, the system should check for duplicate license keys and identify any other errors encountered during the import/transform process. Records with valid data should be loaded into the target table, while duplicate or invalid records should not be created.
After the import process is completed, all error details, including duplicate license keys and other validation or transformation errors, should be captured and sent to the requester through a notification. The notification should provide sufficient details to identify the records that were not successfully processed.
