Category: SWXL Templates

Documented in “GKMS Stand-Up 04) Keyword Generation” – https://docs.google.com/a/myersmediagroup.com/spreadsheet/ccc?key=0AhGkM7mSsh-4dElYRXNIRWUxX1p1UVRGa3QwTWhVUVE&authkey=CO3iqYgG&authkey=CO3iqYgG#gid=0

Define POS-specific case dictionary to be used to put EDW keywords in proper Title Case format. For foreign-language POS, contact the SEO Specialist to determine if they have any documentation from their language team to assist with this task.

Define Case Dictionary – Primary Language
Define Case Dictionary – 2nd Language
Define Case Dictionary – 3rd Language

QA Case Dictionaries

OVERVIEW: If there are any custom URL templates that there are available XML Sitemaps for, import these URLs into new custom URL templates for this POS. Check with the PM to see if the Customer has identified any XML sitemaps available.

OVERVIEW:

Initialize FM Interface for POS

PROCESS:

Do whatever needs to be done so that the FM interface will recognize the new POS.

OVERVIEW:

Generate Report: Live Site QA Report

• Manually check if SWXL links are displaying on live site as intended – All Languages
• Set up automated script to check SWXL links on live site monthly – All Languages

PROCESS:

1. Check the Expedia SWXL Production endpoint and verify the correct SWXL package is listed.

https://s3-us-west-2.amazonaws.com/swxl-us-west-2/prod.properties

1. Browse to a page which is in the SWXL and note the SWXL section. Run something like:

   select u.url, k.keyword from s_swxl_relation r
   join s_swxl_keyword k on k.keyword_id = r.keyword_id
   join s_swxl_url u on u.url_id = r.current_url_id
   join (select top 10 * from s_swxl_url) t on t.url_id = r.current_url_id
   order by u.url, k.keyword

2. Compare the results with the links rendered.
    
3. From https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/qa

• Run 01-insert_swxl_qa_list.sql manually.
• For new SWXLs, create “test_swxl_{pos}” as a Jenkins job on builds.mmg, using an existing job as a template.

STANDARD & CUSTOM TEMPLATES:

Generate all valid URLs for each template.

1. Import all datafeeds for custom templates
2. Generate all URLs
3. Run merge.pl
4. Check merge.log for errors. If errors result, you must use the ‘double-match-fix’ script to resolve and rerun merge again until it runs cleanly all the way through.
5. Clone SMG outputs to 2nd language (change folder strings in URLs).
6. Clone SMG outputs to 3rd language (change folder strings in URLs).

OVERVIEW:

Run the title-case script to convert all SWXL keywords that are not currently in Title Case into that format. All KWG terms should be in Title Case already, because we set KW variants up that way. But there will be EDW terms and terms from other sources that may not be.

PROCESS:

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/util/title-case-keywords.pl

NOTES:

Nordic languages follow different capitalization rules, so use the “-n” parameter.

Make sure working directories are updated, then run migrations to bring database up to date.
Some new DB objects might have been changed.

DB Migrations – Primary Language
DB Migrations – 2nd Language
DB Migrations – 3rd Language

Reference:
https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/DB/tools/db_builder/script/build-db.pl