Generate & Upload Final SWXL Tables

OVERVIEW:

Generate SWXL tables and upload to Expedia SFTP.

• Export SWXL tables to text files – Primary Language Only
• Upload SWXL files to Expedia SFTP – Primary Language Only
• Record SWXL import time – Primary Language Only

PROCESS:

1. Run

   https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/util/execute-usp-generate-swxl-tables.sql

2. Check SWXL tables against ILG QA with:

   select count(*) from s_swxl_keyword;
   select count(*) from s_swxl_url;
   select count(*) from s_swxl_relation;

3. Look for swxl_relation records without matching keyword, URLs without protocol etc.

   https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/qa/qa_swxl_tables.sql

4. In ILG working directory, configure conf.mk and run:

   $ make production

5. In ILG directory, run:

   $ make outbox/{OUTDIR}/SWXL_{TIMESTAMP}.upload

6. In ILG working directory, run ‘make prod-imported’ to detect whether the SWXL data files have been imported, and if so record the timestamp and report this value to the PM.