Meeting Directory Data

What meeting data looks like.

Data

Data Flow

Using the SIA Meeting Update Form, we get basic meeting and contact information.
These responses go automatically to the Responses tab in the Meeting Update Form Responses worksheet.
The responses are automatically copied and edited* to the Feed tab in the Meeting Update Form Responses worksheet.
The Feed tab is linked as a data source for the 12 Step Meeting List, and the meeting list can be updated (data can be imported) by clicking the Refresh button on that page.

Interactive Data Flow Diagram with links to the Form, Google Sheet, and Apps Project (pictured below)

Responses Transformed To The Feed

The chart below is an example of how some data is edited and transformed. Meeting Update Form Information includes a list of types and the complete transformation map.

Responses

Meeting Name	L'heure	End Time	Day	Supporters Allowed	Langue	Meeting Access Types	Participant Focus	Meeting Format Types
survive and thrive	8:00 PM	9:30 PM	Lundi	Participants : Fermé (survivants uniquement)	Langue : Anglais		Participants : Nouveau venu	Format: Open Share

Feed

Meeting Name (Proper Case)	L'heure	End Time	Day	Les types (Merged)
Survive And Thrive	8:00 PM	9:30 PM	Lundi	Participants: Closed (Survivors Only), Language: English, Participants: Newcomer, Format: Open Share

Filters

On the meeting listing page you’ll see options to filter by location, day, time, et type.

Filters : Type

For every meeting listing, we get additional meeting info in certain categories:

Langue
Access
Participants
Format

In the plugin, all this info is merged as “types”. To avoid having a dropdown list that looks like this:

Anglais
Female Identifying
Ouvrir l'action
Espagnol
Step Study
Wheelchair Accessible

All the types have been renamed, so all the similar types are grouped by category. It looks more like this:

Langue : Anglais
Langue : Espagnol
Format: Open Share
Format : Etude par étapes
Access: Wheelchair Accessible
Participants : Femmes s'identifiant

Changes to types were made in the WordPress theme functions.php file. Language codes not conforming to ISO set 1 language codes were standardized. Shortcodes for types display were defined. The full list of types redefined for SIA are in the Meeting Update Form Information,

Default types are defined in the variables.php file in the source code for the plugin.

Filters: Location, Day, Time

The meeting directory has headings to filter by location, day of the week, and time of day.

Day is just a weekday match.

A location that can be recognized by Google Maps or Mapbox is required for all 12SML meeting listings. On the SIA Meeting Update Form, the city is required and used to set a time zone.

Time is an approximate time (morning/midday/evening/night). The time zone is not implemented yet in 12SML.

TBD: HANDLING TIME ZONES