Zoom webinars are used to present live content during workshops, some socials and for sponsor booths. Zoom meetings are used for the presenters and SlidesLive to give Q&A and other live segments during orals and invited talks.
Clone the repository with git clone email@example.com:leetncamp/xltozoom.gitIf using ./misc.py --exportScheduleIntegrationXLSXZoom, you'll need to clone this into the top level directory on your development server and add xltozoom to your .gitignore file. This can be done on a development server with an updated copy of the database.
I recommend creating new account at Zoom.us to handle the current year's conference. Something like firstname.lastname@example.org.
In your account page at Zoom.us, click Billing in the sidebar and choose to “Upgrade your Account”. Because the Pro plan only scales to 9 licenses, choose Business. Be sure to choose monthly billing rather than annual. Purchase the correct number of video webinar add ons. Your main Zoom account consumes one zoom meeting license; go to users and remove your licenses for webinar and meeting if you don't need them.
Generate your api keys by by visiting https://marketplace.zoom.us, in the develop menu dropdown choose Build App and choose JWT. Click the create button and name your app, e.g., ICML2021. Then copy your credentials and add them to the zsecrets.py
For each event, we need to create a zoom user where the user name is created from our base account name above. E.g, for email@example.com and for the workshop IPRL, we might create a user name icml2021zoom+IPRL@gmail.com. This way, the firstname.lastname@example.org account will receive all the Zoom account activation emails. Use “Users” in the sidebar to create users with both a basic license and a webinar license. (Remember that not all events need a webinar).
Now that you have the right number of activated and licensed user accounts at zoom.us, we are ready to use the xltozoom scripts to create the webinars: password, zoom_host_password, and host_zoom_user_email.
cd to the xltozoom folder making sure it's checked out into the root of the Django project. Run ./go.py --file PATH-TO-EXPORTED-SPREADSHEET.xlsx. That will iterate over each row of the spreadsheet and create or update a workshop or webinar for each event. As it finishes, it stops to ask permission to write the resulting zoom information back into the spreadsheet. Close Excel and allow it to write.
Then cd back to the root of the conference directory and run ./misc.py --importZoomLinks -TO-EXPORTED-SPREADSHEET.xlsx, E.G, ./misc.py ---importZoomLinks xltozoom/schedule.xlsx. After testing this on your development server, you must copy the XLSX file to the production server and import it there.