Ansible Workshop Attendee List to CSV Playbook Version 2

What does this playbook do?

This playbook will record down the attendees name and emails from the Ansible Wokrshop and store it in a CSV. This is then pushed into Google Sheets and shared with the email accounts that are stored in the master-upload.py python script.

There are three files required for this playbook to run successfully.

1. list2.yml
2. master-upload.py
3. client_secret.json (Ask Nas)

Pre-reqs

1. Make sure that the workshop is fully provionsed and that all the users have used the http://login.d98x.open.redhat.com/ page to grab their workshop credentials.
2. You have access to the login url for the workshop for example http://login.d98x.open.redhat.com/list.php
3. Ansible and Python installed on the machine that will be running the playbook (default is localhost).
4. Most importantly make sure that the client_secret.json is in the folder that you launch the playbook from. The client_secret.json can be retrieved from Nasim Miah ([email protected]).

Running the playbook

Run the playbook as follows.

Example for workshop environment ...

ansible-playbook list2.yml
What is the workshop URL? An example would be http://login.d98x.open.redhat.com/list.php: http://login.a76d.open.redhat.com/list.php
What is the workhop student password?: cNQn9ZxY9pAHYx
What is the your Red Hat email?: [email protected]

Result

attendee-list-{workshop-date}.csv which is local and also a Google Sheets verison sent to the email used.