Tag Archives: events
Emails for recent event attendees
I was tasked to produce a list of unique email addresses of CTL event attendees for events held Spring 2013. Short answer: select distinct first_name,last_name,email  from users left join enrollments on enrollments.user_id=users.id left join events on enrollments.event_id=events.id left join event_types … Continue reading
Problem with archived list of events
On Feb 28, 2013, at 12:26 PM, Ines Berrizbeitia <ines.berrizbeitia@uvm.edu> wrote: Hi Wes, ‘Tis me, again, with another problem. 😀 On this page: http://www.uvm.edu/ctl/?Page=services-programs/faculty-events/index.php&SM=m_sp.html I noticed when making some tweaks that the list of archived events doesn’t seem to be … Continue reading
Events calendar mystery solved
On Mar 4, 2013, at 11:17 AM, Wendy Verrrei-Berenback <wverreib@uvm.edu> wrote: Disallowed Key Characters: pspw1-8520-PORTAL-PSJSESSIONID using Firefox 19 The Events Calendar code utilizes a “software framework” (viz.http://en.wikipedia.org/wiki/Software_framework ) called CodeIgnitor. When processing any sort of input (URL, form input via GET … Continue reading
ctl data mining
Lots of SQL. Refactored users table, splitting out ‘organization’ and ‘college’ into a separate table to account for multiple values. With help of Jonathon Trigeux, came up with table to map colleges to organizations. after much  fiddling, arrived at this … Continue reading
Events calendar data mining
Answering presidents questions: who do we serve and how. Ingesting data from footprints via short filtering scripts, constructing reports via SQ
CTL Events Registration
Maintain and develop CTL events calendar and registration. New features request found HERE