KSP Program

Windows App that help KSP committee generate and share certificate by giving automation for generating gdrive folder, qr code, certificates and bulk mail (works with non-premium gmail).

Background

In iSTTS, there is a program called Knowledge Sharing Program (KSP). This program is used as a medium to share knowledge carried out by iSTTS internal lecturers, guest lecturers, and iSTTS students. The knowledge to be shared can vary, including technology, design, business, and others. Sharing will be carried out per episode in the form of seminars/workshops. All participants who have participated will receive an e-certificate which will be sent to the participant's email. KSP has a special architecture in certificate storage. In one KSP Episode Folder, there will be a folder for each participant. And in each participant folder, there is a certificate for that participant. The KSP certificate is also specially made so that it can be validated by the iSTTS, in the KSP certificate there is a QR Code that directs to the Participant Folder.

There are several problems. It is impossible to create each gdrive folder manually especially when the number of participants reaches hundreds. To create a QRcode that points to the participant gdrive folder there must be a link for the participant folder, and if there are many folders it will take a long time to get the folder link. Given a large number of participants, making certificates that consist of unique names and QRcode manually was not possible. If there are many participant certificates, it is not possible to upload them one by one directly to the participant folder. KSP email is not a premium Gmail, so it's only limited to 50 emails mail merge/day.

My solution is KSP APP.

By programming, all repetitive problems can be solved. Because the folder is created on GoogleDrive, it requires the GoogleDrive API to be able to access the GoogleDrive FileSystem. After that, by entering the participant data (name & email) the participant folder will be generated immediately on Google Drive. In addition to creating folders for each participant, the program also makes the folders accessible to participants, and the program also takes the link used to create QRcode. Then a QRCode will be generated with the program using the python library "pyqrcode". To create a certificate with the name & QR Code according to the participant, Photoshop API is used to generate certificates based on the dataset. After that, the certificate will be uploaded into the main folder. After that with the program, the certificate will be transferred directly into the participant folder. Finally, for the 50 emails/day email problem, the program is also coded so that it can send emails automatically one by one. In addition, this program is also made so that not only KSP accounts can be used but all other Gmail accounts can be used. Email content can be dynamic because this program provides input in the form of (.html) from the email body

My parts in this project

• Create whole app by myself
• Design system
• Write a maintainable code