Story

As an admin, I would like BLANK or NA categories to be updated with a concatenation of N/A and the DEPARTMENT NAME from the same record

Details

This story is related to CFAMX-16700.

In an effort to resolve errors triggered by a blank CategoryName field in the Sales Item Import, it was discovered that there is a relationship between the DepartmentName and CategoryName fields in that there has to be a valid CategoryName associated with the provided DepartmentName or the import will fail.

The overall goal is to ensure that when CFA delivers a Sales Item Import file where the CategoryName is BLANK or some variant of "N/A" InFORM can successfully process this file by updating the data so that it is valid on insert and does not cause errors. Below is an example of the error that is triggered when there is no DepartmentName / CategoryName relationship:

To fix this we need to take a few steps:

1. Create and insert dummy CategoryName data for each existing DepartmentName. This should be a concatenation of the Department Name and "-N/A". The Sales Item Import will not successfully run without this relationship in place. Below is a list of all the Category Names in the expected concatenated format:
   1. Other-N/A
   2. Breakfast-N/A
   3. Breakfast Meals (w/o Drinks)-N/A
   4. Dessert-N/A
   5. Drink-N/A
   6. Entree-N/A
   7. Meals-N/A
   8. Outside Sales-N/A
   9. Party Trays-N/A
   10. Sides-N/A
   11. Value Sizes-N/A
   12. N/A-N/A
   13. Sample-N/A
   14. Non-Food-N/A
   15. Discounts & Giveaways-N/A
   16. Catering - Bulk Drinks-N/A
   17. Packaged Meals-N/A
2. Update the SSIS so that when a CategoryName is BLANK or some variant of "N/A", we insert the concatenation of the DepartmentName value and "-N/A" into the CategoryName field.

AC

Confirm

1. When the CategoryName field is BLANK, InFORM inserts a concatenation of the DepartmentName from the same record and "-N/A" into the CategoryName field.
2. When the CategoryName field is N/A or NA, InFORM inserts a concatenation of the DepartmentName from the same record and "-N/A" into the CategoryName field.
   1. Example: Breakfast-N/A
3. When the CategoryName field is not BLANK, NA. or N/A, InFORM does not change the CategoryName data for that record.
4. When the CategoryName field is not BLANK, NA, or N/A, the existing functionality persists:
   1. The DepartmentName / CategoryName validation works correctly.
   2. When there is not error, the record is processed without issue.