Location Import - Update Process so the failed records are skipped

As a system integrator I want the Location Import to be updated so that it continues to process after a single record fails

Notes:

• See feature: CFAMX-12257 for example files and Log records of what happens today (Incremental)
• The issue that we are trying to solve is that today, when a file is processed, that contains many records (where one location = one record), if one of those location records does not contain one of the required fields, see below, the entire file is rejected, not just that record.
• For example:
  • A file contains 10 location records
  • One location record is bad/incomplete
  • 9 location records should be processed, and only one should be rejected
  • Note: today we reject all 10 records, as we reject the entire file, rather than skipping the one bad record
• This request is to enhance the process so the bad/incomplete records are skipped, and good location records are loaded successfully
• XSLT will discard the record if the Location Number missing, so no warning will be created
• XSLT will discard the record if the Concept Code is "LIC" missing, so no warning will be created
• Required fields:
  • Location Code
  • Operator Team Name
  • Service Team Name
  • Region Name
  • Market Name
  • Country Name
  • ISO Country Code
  • Distributor Name
  • Distributor Distribution Center

Acceptance Criteria:

1. Confirm when the location import is processed, and one record fails, other good records are processed successfully
2. Confirm that if all records in the file are bad no records are processed
3. Confirm that if all records in the file are good, all records are processed
4. Confirm that the Required fields are documented, and reviewed with both Product and Chick-fil-A
5. Confirm that should data not be present in any fields that are considered Required, the record is skipped, and the record is logged, but the file continues to process
6. Confirm that the Confluence page is updated to reflect the changes that are made: https://cfacorp.atlassian.net/l/c/1tsf8cmA