Location Import - Update XLST to support Country Name & Code and CA Zip Code

As an admin I want the Location Import to support Country Names & Codes and Canadian Zip Code so that I can pass them into InFORM

Notes

• Location Import = Entity Import
• Country Code is a field supported by the Entity Import (it is in fact a required field)
• Country is currently hard coded in the XSLT , to be USA

•             </xsl:element>
              <xsl:element name="Country">
                <xsl:value-of select="'USA'"/>
              </xsl:element>
  

•             </xsl:element>
              <xsl:element name="PostalCountry">
                <xsl:value-of select="'USA'"/>
              </xsl:element>
  

• The location file will be updated to provide the Country Code:

• // Street Address
  
  <common:StreetAddress>
              <common:Address1>2000 Airport Rd NE</common:Address1>
              <common:City>Calgary</common:City>
              <common:County>Calgary Metro Area</common:County>
              <common:State>AB</common:State>
              <common:ZipCode>
                 <common:Zip>T2E 6Z8</common:Zip>
              </common:ZipCode>
              <common:IsoCountryCode>CA</common:IsoCountryCode>
              <common:CountryName>Canada</common:CountryName>
           </common:StreetAddress>
  
  // Billing Address
  
  <common:BillingAddress>
              <common:Address1>HMS Host</common:Address1>
              <common:Address2>Box 160</common:Address2>
              <common:Address3>2000 Airport Road N.E.</common:Address3>
              <common:City>Calgary</common:City>
              <common:County>Alberta</common:County>
              <common:ZipCode>
                 <common:Zip>T2E</common:Zip>
                 <common:ZipExtension>6W5</common:ZipExtension>
              </common:ZipCode>
              <common:IsoCountryCode>CA</common:IsoCountryCode>
              <common:CountryName>Canada</common:CountryName>
           </common:BillingAddress>
  
  

• Zip Code
  • For US stores, the zip code is passed in two fields, and concatenated, with a hyphen, as a part for the import process

  •             <common:ZipCode>
                   <common:Zip>74804</common:Zip>
                   <common:ZipExtension>2522</common:ZipExtension>
                </common:ZipCode>
    

  • For Canada stores the Zip Code will be passed sometimes in one field for the Street Address, and two fields in the Billing Address

  • // Shipping Address
                <common:ZipCode>
                   <common:Zip>T2E 6Z8</common:Zip>
                </common:ZipCode>
    
    // Billing Address
                <common:ZipCode>
                   <common:Zip>T2E</common:Zip>
                   <common:ZipExtension>6W5</common:ZipExtension>
                </common:ZipCode>
    

• Use the Country to determine the format in which the Zip Code should be imported:
  • USA - 74804-2522
  • CA - T2E 6Z8
• ALL vs Incremental
  • CFA Send us an ALL Locations import on Sunday's, which includes all restaurants
  • During the week, they send Incremental files, which include updates and deletes

Rollout related

• An ALL Locations file should be imported after the deploy to change existing restaurants from USA to US

Acceptance Criteria

Country Code

1. Verify that the Country Name is successfully imported for both:
   • Street Address
   • Mailing Address
   • 
2. Verify that the Country correctly reflects what is included in the Import
   • 
3. Verify that if a Country Name needs to be added to the database to support data received in the file, it is added as a part of the deploy
4. Verify that restaurants currently configured as USA are all changed to United States the first time an ALL Location Import is run
   • The XSLT inserts USA, but the sample uses United States, and the value must match one that is in the database
5. Verify that if No Country Name is supplied, the record will fail and a warning will be sent
   • Previously the Country was being hard coded by the XSLT, now it is up the the system generating the file to provide that data

Zip Code

1. Verify that if the Country = US, the Zip Code continues to be imported as it is today
   • Two fields concatenated, with a hyphen between them
   • "74804" & "2522" becomes "74804-2522"
2. Verify that if the Country = CA, the Zip Code is either:
   • Imported whole
     • If only common:Zip is supplied: T2E 6Z8 (Shipping Address)
   • Concatenated together with a space in between, if supplied in two fields (Billing Address)
   • "T2E" & "6Z8" become "T2E 6Z8"