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	زمان	End Time	Day	Supporters Allowed	Language	Meeting Access Types	Participant Focus	Meeting Format Types
survive and thrive	8:00 PM	9:30 PM	دوشنبه	Participants: Closed (Survivors Only)	Language: English		Participants: Newcomer	Format: Open Share

Feed

Meeting Name (Proper Case)	زمان	End Time	Day	انواع (Merged)
Survive And Thrive	8:00 PM	9:30 PM	دوشنبه	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, and type.

Filters : Type

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

Language
Access
Participants
Format

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

انگلیسی
Female Identifying
اشتراک‌گذاری باز
اسپانیایی
Step Study
Wheelchair Accessible

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

Language: English
Language: Spanish
Format: Open Share
Format: Step Study
Access: Wheelchair Accessible
Participants: Female Identifying

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