Updates to Location Import - INF-9762

Requirements:

• Update the Location (Entity) Import
• Country Code is a required field in the entity import
• CFA Do not currently supply the Country, is is hard coded to USA in the XSLT
• Update the XSLT to correctly process the Country Code
• For US stores the zip code is provided in two fields and concatenated together with a hyphen ("74804" & "2522" becomes "74804-2522")
• Use the Country Code to determine how to load the Zip Code
  • For US stores continue as normal
  • For CA stores, when one field is available use that field, with no concatenation. When two fields are supplied, concatenate those fields together with a space ("T2E" & "6Z8" become "T2E 6Z8")
• Use the Country Name to Create/Maintain zones, under a new Zone Type (Location - CountryName)

FRD: FRD INF-9762 CA -Location Import Support.pdf

Country Code
CFA Location Import - add support for importing country for all stores, US and Canada. Currently country code is not included in the Location import provided by Chick-fil-A, so the import XSLT defaults it to 'USA'. Country code will be included for Canada and US stores for each location in the file. The XSLT needs to properly transform the Location import files to appropriately parse the country code for each location from the file and set the appropriate country code on the location/entity in the system.

Post Code
Please see attached Location import and xslt manually modified to include country. Another small change is to remove '-' in the post code.

Need from CFA

1. Please provide a sample file for the location import - CFA expects to have the file by end of May 2018

Stories

1. Update XSLT
   • Country Code
   • Zip Code
2. Update import process to create Auto Zone
   • Location - CountryCode

Sample File:
PLEASE DO NOT LOAD THIS SAMPLE ALL FILE INTO JAT, IT WILL CREATE LOADS OF STORES.
- Trim the file!

• ALL: 20180718_locations_all.zip
• Incremental: 20180719_locations_incr.xml
  This sample was provided by CFA, it includes store # 80549, which has a Canadian Address
  Note: a store number starting with an 8, will not be processed, as the "8" stores are Licensee store, and we do not load these into InFORM
  PLEASE DO NOT LOAD THIS SAMPLE ALL FILE INTO JAT, IT WILL CREATE LOADS OF STORES.
  - Trim the file!