Unpack a PL logistics board into calendar-ready rows

Transforms a raw PL (professional learning) logistics board, as returned by get_monday_board() and augmented with monday_id, site, and L&R name columns, into a flat tibble of session rows. The Monday "Timeline" range column is split into a Session Date (range start) and Session End Date (range end); single-day timelines yield identical start and end dates. List columns produced by the Monday API are unnested to scalars.

Usage

rename_logistics_alias(df, canonical, aliases)

Arguments

df

A data frame for a single PL board. Must contain a Timeline column (the Monday timeline range), a name column, a group_title column, and the site / L&R name join columns.

Value

A tibble with one row per facilitator/session, including Session Date, Session End Date, Facilitator, Start Time, End Time, Delivery, L&R Course Name, site, L&R name, monday_id, and a derived content_area.