2024-05-18: sm.hkcos.org.hk

Event Name
HKCOS Scientific Meeting 2024

Organised by
Hong Kong College of Orthopaedic Surgeons

Date
2024-05-18 09:00-17:00
(08:30 registration begins)

Event Type
Physical Only

Event Website
sm.hkcos.org.hk

Event Address
Level 7, The Ballroom
Cordis, Hong Kong
555 Shanghai St, Mong Kok, Hong Kong

Ticketing Email
"HKCOS Scientific Meeting" 

Additional Notes
Registration Slug (TBC):
[/registration/->] /register/

Add new form for students


To-do: Dropbox File Request for Speakers'
[Alex to prepare] Holding slides and title slides

N.B. Lunch has award ceremony handled by client

15:40-16:55 Live polling (among audience)
PIC Patrick@controlpanel [Vendor on secondment from CUHK]
[Katrina to prepare] Questions from panellists to Patrick

05-17 3x lectures +
14:00-17:00 Zoom: 13 trainees to present
Moderator: Dr CHAN Ying Kei, Dr Albert HSU
Zoom meeting hosted by [email protected]
Co-hosted by Patrick TSANG@controlpanel

https://www.icmecpd.hk/event_calendar_view_details.aspx?EventId=72288
+ CPD (separately handled)

To-do: e-ticket for SC + File request
To-do: CP ("Past Presidents", "Invited Guests", "Adjudicators")
To-do: SP 
// To-do: SM ("Speakers (non-Council)", "Moderators (non-Council)")
if (isCouncil) 
then { GG }

Above-the-line: katrina.tong@ send email reminder speakers/moderators/adjudicators
Below-the-line: scientificmeeting@ send tickets to (non-Council) speakers/(non-Council) moderators/adjudicators

Email + SMS reminder (15 May) 

Banquet for Speakers/Moderators/Past Presidents [Ming Court, invite by Katrina]

Badge printing - name only on badge "Title SURNAME Given Name"
16:30 Survey SMS + Email (for attending guests only, customised) - non-closing

sm.hkcos.org.hk/register

editable, but don't create new row please id=17 SELECT * FROM tblEventGuest from wpdb-heebay-events

sm.hkcos.org.hk sponsor master

editable. id=14 imported from https://1drv.ms/x/s!AnuIWm_ms_Ljg4Zed5q_zHLtK-B8tQ?e=wD6IoQ 2024-04-04 14:57 UTC+1

sm.hkcos.org.hk/sponsor-ticket-machine/

read-only id=19 CREATE VIEW `wpdb-heebay-events`.hkcossm2024_encoded_sponsor_info AS SELECT wdt_ID, TRIM(TRAILING '=' FROM REPLACE(REPLACE(REPLACE(TO_BASE64(CONCAT(wpt_ID, '|', sponsorname, '|', email, '|', complementaryticketsforguests)), '+', '-'), '/', '_'), '\n', '')) AS encoded_data FROM `wpdb-heebay-events`.wpdatatable_14; SELECT esi.wdt_ID, CONCAT('https://sm.hkcos.org.hk/sponsor-ticket-machine/?data=', encoded_data) AS sponsor_url FROM `wpdb-heebay-events`.`hkcossm2024_encoded_sponsor_info` esi JOIN `wpdb-heebay-events`.wpdatatable_14 s ON esi.wdt_ID = s.wdt_ID;