Update CMS URLs & Datafeeds

OVERVIEW:
Cross-reference and import applicable CMS URLs and associated data feeds.

PROCESS:

1. To generate URL/meta-data dump, use:

   https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SEOCluster/trunk/cms/script/dump-urls.php

   Alternatively, the latest dump is probably available from the latest build_cms-sitemap build at:

   dev:/var/jenkins/workspace/build_cms-sitemap/{lob}-{pos}.1.dump.gz.

   If the Jenkins job is running, wait until it’s finished.
    

2. To import URLs, use:

   https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWUrlAssociation/trunk/UserAssociation/script/import-urls.pl

   Note that if there are “Multi-City” pages, they go in the “City” template.
    

3. To import data-feeds, use:

   https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWUrlAssociation/trunk/UserAssociation/script/import-data-feed.pl 

4. After import, to check how to handle data feed updates, see:

   https://dev.myersmediagroup.com/mmgsvn/Users/rchung/swxl_queries/Handle-Custom-Template-URL-Change.sql

   For updates, use these same steps but specify new data-feed table names. Then, match ds.SEO_StaticURLs URLs by template_id, set deleted = 1 if not in the new data-feed, e.g.
    

   update ds.SEO_StaticURLs set deleted = 1 where id in (select id from (select * from ds.SEO_StaticURLs v where v.template_id = 3001 and url not in (select url from ds.flights_airports_3001_20130930)) selected) 

5. Manually delete old kwg.Template_DataFeed entries. Optionally clean up old data-feed definitions.
6. Repeat for 2nd language
7. Repeat for 3rd language