Skip to content

Latest commit

 

History

History
107 lines (91 loc) · 6.34 KB

Monthly Guide.md

File metadata and controls

107 lines (91 loc) · 6.34 KB

Monthly Guide automation process

Version 1.0

Location: Google\ Drive/Content/Documentation/Oral\ Histories/Assets/Monthlies

Steps

  1. Organize Airtable Monthly Guide view
  2. Create monthly directory
  3. Pull and process raw thumbnails
  4. Prepare branded thumbnails
  5. Compose the guide

Organize Airtable Monthly Guide View

  1. Determine the publishing schedule for the month ahead.
  2. Review the Airtable Monthly Guide view to make sure all twelve videos are in place, and that all required data is there, including thumbnails.

Create Monthly Directory

  1. From Monthlies/editions directory, run command:
mkdir -pv *YYYY_MM*/thumbnails/{branded,raws}

Pull Raw Thumbnails

  1. Once the Monthly Guide view is organized, go to the .raw_thumbnails view and order it by Youtube Publish schedule. Export a CSV and save it in the parent directory YYYY_MM.
  2. Sanitize it.
    1. Replace header line (ID,Raw Thumbnail) with empty line.
    2. Move URLs to a new line after their respective IDs.
    3. Add a new line after each URL.
    4. Delete unnecessary file names using the regex (.*?)\(
    5. Remove the trailing )
    6. Prepend raws/ to each ID. Append .png to each ID.
    7. Wrap URLs and IDs in quotes.
    8. Precede each ID with -o .
    9. Precede each URL with url = .
  3. Save the file as urls.txt.
  4. Pull all thumbnails from Airtable with curl -K urls.txt.

Expected entries on urls.txt should look like this:


-o "raws/Varney and Omoru_s1_MM_20170527_vai.png"
url = "https://dl.airtable.com/xQFgqYSHTNKVlbHq9DB4_Screen%20Shot%202017-06-01%20at%2013.19.44.png"

Prepare Branded Thumbnails

  1. With the organized Airtable Monthly Report view, export a CSV from the .branded_thumbnails view and save it in the parent directory YYYY_MM.
  2. Prepare thumbnail_worksheet.csv
    1. From /thumbnails, prepare a list of thumbnails to work with using ls raws > thumbnail_worksheet.csv
    2. Add csv header row @File Path,Language1,Language2,Language3,Language4,Language5,Language6
    3. Determine your absolute system file path by running pwd from raws folder.
    4. Prepend each data entry with absolute file path, using : instead of / for folder structure.

      For example, Macintosh HD:Users:FreddieAndrade:Google Drive:Content:Documentation:Oral Histories:Assets:Monthlies:editions:2017_09:thumbnails:raws:Varney And Omoru_s1_MM_20170527_vai.png. Make sure the path uses the correct USERNAME

    5. Copy languages spoken from exported CSV to thumbnail_worksheet.csv. Each entry should have it's own languages.

      For example, Macintosh HD:Users:Amicus:Google Drive:Content:Documentation:Oral Histories:Assets:Thumbnails:raws:Zaeem_s2_M_20160721_hnd+pbu.png,Hindko,Pashto has two languages, Hindko and Pashto. Note: extended latin characters do not work, which means no accents or fancy things.

  3. Data merge
    1. With thumbnail_worksheet.csv ready, open thumbnail-template.indd in Adobe InDesign
    2. Open Data Merge panel from Window>Utilities>Data Merge
    3. From panel menu, click Select Data Source....
    4. Select thumbnail_worksheet.csv
    5. Preview the merge
    6. Create merged document
  4. From merged document, review all pages to make sure
    1. All images look good
    2. All languages are correctly represented
  5. Export images as .jpg from File>Export
  6. Rename files so they are all named according to their Oral History ID.
  7. Be sure to upload branded thumbnails to Airtable.

Compose the guide

  1. Make sure frontCover.indd has the right date and volume number.

  2. Prepare TOC.indd.

    1. Prepare TOC spreadsheet
    2. Prepare toc.csv

    Language1|Language2|Language3|Language4|Language5|Language6|Language7|Language8|Language9|Language10|Language11|Language12|Speaker1|Speaker2|Speaker3|Speaker4|Speaker5|Speaker6|Speaker7|Speaker8|Speaker9|Speaker10|Speaker11|Speaker12|Continent1|Continent2|Continent3|Continent4|Continent5|Continent6|Continent7|Continent8|Continent9|Continent10|Continent11|Continent12|@File Path1|@File Path2|@File Path3|@File Path4|@File Path5|@File Path6|@File Path7|@File Path8|@File Path9|@File Path10|@File Path11|@File Path12 |-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|

    1. Prepare TOC.ai.
    2. Update TOC.indd to reflect the correct data.

  3. Prepare singles.indd.

    1. Prepare the merge document data.csv in the format below.

    @File Path|Speaker|L1|L2|L3|L4|L5|L6|Description|Continent|D1|D2|D3|D4|D5|D6|G1|G2|G3|G4|G5|G6|Published|Quote|Quote2 |-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|

    1. Perform a data merge on both singleA.indd and singleB.indd, selecting data.csv as your data source. Name outputs after the edition, 6_17_singleA.indd for example.

    Note: If Indesign refuses to load the data file, it might have an encoding problem. A quick fix is opening it up in TextEdit and saving a version.

    1. Delete all pages with vertical thumbnails from 6_17_singleA.indd, and all pages with horizontal thumbnails from 6_17_singleB.indd.
    2. Join the two documents, placing pages in order. You can move pages between different files within InDesign. Save new file as 6_17_singles.indd.
    3. From merged document, review all pages to make sure:
      1. All images look good.
      2. All languages, captions, content etc are correctly represented.
    4. Correctly place all Wikitongues logomarks at the end of each description.
    5. Remove Poly elements from pages who's languages are not yet available on the Poly platform. (Double-check by quickly searching Poly.)
    6. Link all Poly elements remaining to their respective documents (if only one example available) or search results (if multiple examples available) on the platform.

  4. Make a book.

    1. Add frontCover.indd, TOC.indd, 6_17_singles.indd and backCover.indd in order.
    2. Preflight
    3. Save as PDF

  5. Review

  6. Move to Dropbox

  7. Name correctly.