Import and display the Spanish language audio

[reginafcompton]

Metro will soon include Spanish-language broadcasting of events.

DataMade will scrape these links and include them on the Boardagendas site. They will appear as a distinct button (during a current meeting) or url (on the Events page and Event detail page) - with text in Spanish language, e.g., "Escuchar."

Metro will add some test events in Legistar in April or May, and DataMade will do a test run with this data.

[shrayshray]

This is high priority for April (Chair's request). We're still waiting on the device from Granicus, and internal hardware setup to support this, but have some additional info for reference which may help Datamade get a head start on initial development so we're closer to "ready-to-go" once we have everything in place an are ready to deploy ...

Spanish Language broadcast of meetings is handled as a second meeting by Granicus. See example from LA City's Granicus site: https://www.lacity.org/your-government/audiovideo/council-meeting-video

Metro displays broadcast links on Legistar site, not Granicus site: https://metro.legistar.com/Calendar.aspx
Mockup of potential display:

@reginafcompton @hancush could you remind me of the prefix used for test meetings, so they are excluded from display on the live site? I can set up some fake/test meetings once I have this info. Thank you!

[reginafcompton]

@shrayshray - we did not yet decide on a prefix. We could identify test events in several ways, but I think the best strategy would be to list the EventLocation as "TEST".

(Since the event name correlates with the committee, I'd rather not use that to identify test events - to avoid unexpected data cascades.)

First, we'll add a filter on Councilmatic to hide these test events.
After that, you can populate Legistar with some test data.

A question - will these test events be visible on Legistar?

[shrayshray]

@reginafcompton Yes, these events will be visible on Legistar.

[hancush]

Hi, @shrayshray, just an FYI that I'm getting started on this, this week. I'll be in touch in the next couple of days about adding test data!

[hancush]

The Plan

Overview

Instead of creating near-duplicate events in the OCD API, we are going to scrape English and Spanish events as a pair, and combine them into a single event with multiple media links, one for the English audio and one for the Spanish audio. This will enable us to display bilingual event pairs from Legistar as a unified event, with both English and Spanish audio, in the LA Metro Councilmatic interface.

Changes

In python-legistar

• Create a handle on the api_events generator, so it can be customized in the jurisdictional scrapers (Break api_events generator into its own method opencivicdata/python-legistar-scraper#65)
• Create a method to search API events by name (semi-related to Add a method for scraping specific bills and events opencivicdata/python-legistar-scraper#59)

In scrapers-us-municipal.lametro

• Override the new api_events handle to return English and Spanish event pairs, and store as one event with media links to the English and Spanish audio (started in the spanish_event branch)
• Clean up existing English / Spanish event pairs already in the API (this will most likely only apply to the test events added for development of this feature)

Indjango-councilmatic

• Add support for multiple event media links (Add support for multiple Event media links datamade/django-councilmatic#199)

In la-metro-councilmatic

• Clean up existing English / Spanish event pairs (ditto likely only test data)
• Pin to new version of django-councilmatic
• Display events with multiple media links, as described

[shrayshray]

@hancush Just wanted to check in with you on timing ... do you think all will be in place to test this, at least on the staging site, during the Board Meeting next week? Thursday, 4/26.

[hancush]

@shrayshray Yes, it should be!

[shrayshray]

Thank you! From: Hannah Cushman [mailto:[email protected]] Sent: Monday, April 16, 2018 12:46 To: datamade/la-metro-councilmatic Cc: Ray, Shelly; Mention Subject: Re: [datamade/la-metro-councilmatic] Import and display the Spanish language audio (#263) @shrayshray<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fshrayshray&data=01%7C01%7Crays%40metro.net%7Cd0f5f42199a046baef9108d5a3d2b489%7Cab57129bdbfd4cacaa77fc74c40364af%7C0&sdata=M37HqmpjE%2F3HlNOvcg9AazG2VBjVNiL5ZvMuDBxu%2Bps%3D&reserved=0> Yes, it should be! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fdatamade%2Fla-metro-councilmatic%2Fissues%2F263%23issuecomment-381726087&data=01%7C01%7Crays%40metro.net%7Cd0f5f42199a046baef9108d5a3d2b489%7Cab57129bdbfd4cacaa77fc74c40364af%7C0&sdata=MRl7foDdCRQoVU6hQP7INKzwAWKJAanosTY0GKnsD48%3D&reserved=0>, or mute the thread<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAaw49Ogstx1BAdZKGYh0AhAE-vshXp9Mks5tpPUCgaJpZM4ShNQY&data=01%7C01%7Crays%40metro.net%7Cd0f5f42199a046baef9108d5a3d2b489%7Cab57129bdbfd4cacaa77fc74c40364af%7C0&sdata=%2FgZQxiFFo18m3iDBsqzUMvOLLxTzhHad1i4V1FAgkgo%3D&reserved=0>.

[hancush]

@shrayshray Hi there!

Quick question: In your mockup of English and Spanish events, it looks like the audio link in the Legistar interface will look the same (both say "Listen link").

If this will be the case, no problem! We can disambiguate in our scraper. Before we do that, though, I just want to confirm: Will English and Spanish audio links look the same (i.e., appear as an "Audio" link) in the live Legistar interface?

[shrayshray]

@hancush Yes, that is correct -- the English and Spanish audio links both display as "Audio" on the Legistar site.
They list two meetings, one for the English meeting and one for the Spanish meeting, with identical links.
We'd like to have one meeting listed, with two different audio links, "English" and "Espaniol". Thanks!

[hancush]

@shrayshray Got it, thanks!

[hancush]

@shrayshray Are you all able to add audio links to the test events currently in Legistar? Thanks!

[hancush]

Hi, @shrayshray –

I've deployed changes to the staging site to import and display the Spanish media. Two immediately visible changes:

1. You'll see links to audio for past events now say "Watch in English". We don't yet have meetings in the past with Spanish audio, but a link to the Spanish audio ("Ver en Español") would appear beneath "Watch in English".

2. Events with English and Spanish audio have links for both.

I'll email to set up a time to test live event display!

[hancush]

And we're live:

Confirmed generic URLs lead to English and Spanish streams. Will check links again when the event-specific streams go live.

[hancush]

Update: The event-specific URLs are now displaying appropriately!

[hancush]

This has been deployed! Closing.