GitHub - github.com/MLSA-Assistant/Cer...
Requirement - pip install requests pandas urllib3 python-docx docx2pdf pywin32
These scripts will help you to do the following:
MLSA_1getDetailsviaAPI = Get the CSV file for participants who have completed all the modules of your CSC, and then intersects the data with those who have filled the form.
MLSA_2createCertificate = Creates certificates of those who have completed all the modules in pdf and word format.
MLSA_3LuckyWinnerSelection = Selects lucky winner randomly from those who completed all the modules.
MLSA_4SortWinner CrossCheck = This is to cross check all the winners to ensure no past winner is getting the voucher again!
MLSA_5LuckyWinnerListWith VoucherCode = This adds the voucher codes with the lucky winner's info and creates a merged xlsx file, which you can use for sending unique mails via Microsoft Word's Mailings feature. Helpful when the winners are greater than 5.
MLSA_6SendMailCert = This sends the certificates(pdf format) along with digital swag kit to all those who completed all the modules of your cloud skills challenge or simply participated in your session!
View the Imagine Cup $100,000 winners on 21st May Live - imaginecup.microsoft.com/?wt....
Hope this helps!
Have a productive day ahead!
#MLSA #Github #Scripts #python #Automation #Certificate #DigitalSwags #CSC #Event #Microsoft #MSWord #Mail #outlook