Certificate Generator from Image Template

Project Abstract

Usually, most clubs in college use some kind of python scripts to generate certificates from a csv file using an image template.
How nice would it be if we could set up a webapp for a nice gui for easily configuring and managing✨

Main parts:

• U for uploading a csv of names.
• UI for uploading a certificate template (with blank fields in the name position, signature position, text content etc)
• Some way to assign which variables should correspond to which headings in csv.
• A button to click generate and a way to save/download the images generated.

P.S. You have the freedom to tweak the idea and above mentioned points as long as the core idea of easy certificate generation using a Web UI is achieved. Have fun✨

Tech Stack

You'd probably require a backend framework for reading image file and manipulating it.
If that's the case, then for UI, you can try nodejs with ejs templating.. or maybe Flask with Python.
Worth exploring if you can do the same using just javascript. In that case probably can be achieved with just React and some npm libraries for csv parsing and image manipulation.

Social Impact

• Once properly made, this could help a lot of folks in the managing departments of various clubs to generate certificates for their events.
• Won't require any manual tweaking of code

Additional context

• Bonus point if you could add some simple password based auth for accessing it so that only the club admins can use your site and not anyone could randomly generate certificates for them.

Few links which may come useful:

• https://github.com/IEDCMEC/certificate_generator/blob/main/cert_gen.py
• https://github.com/IEDCMEC/lambda-functions/blob/main/functions/generateCertificate.js
• https://www.npmjs.com/package/sharp-
• https://chat.openai.com/ :)

Duty Leave application generator

Project Abstract

Create a simple web application which accepts the following values and generates a pdf file of a duty leave application

1. From Address (string)
2. To Address (string - deafult to the Principal)
3. Date (date input - auto selected with the current date)
4. Subject (string: Default to"Request for duty leave")
5. Event name (string)
6. Content (textarea: Default to something which requests duty leave for following students for the above event)
7. Students names,class and Roll No. (list of input fields or a textarea to which names can be directly pasted)

Tech Stacks

• HTML, CSS, JS
• Or just React
• Some pdf generation npm library

Additional context

• Would be great if there is a simple password check to ensure that only authorized people can generate the pdf
• Leave some space at the bottom for signature

Example of a duty leave

Whatsapp bot to notify members when they are tagged in Trello

Project Abstract

Trello is a project management tool. Once you are added to a trello card, an email will be sent to you by Trello; but often times people may forget to check mails or even the notifications from Trello app(if installed that is). What if we could use the Trello API to create a Whatsapp bot which can notify the user on Whatsapp whenever they are tagged in a Trello card✨

Possible steps(No need to follow exactly this)

• We could use Trello Webhooks (custom functions we write that will be called when an action we specify takes place - eg: adding a user to a card ) to achieve this
• create a function (either serverless based or normal backend api route) which listens for requests from trello webhooks
• Once the function is triggerred, find the user who is newly added and then get their number. You can either get this from a json object/csv sheet or you can even assume that the mobile numbers would be present in the description of user's object from trello(choose whichever option that you think would be most feasible and practical).
• once the user's number has been identified, using the whatsapp business api, trigger the bot to send a template message to the user: eg: "Ahoy name!, Congragulations you have been chosen to be added to a new card titled: "adipoli card title". The card is set to expire on "deadlinedate". Your destiny awaits! All the best 🤗"

Tech Stacks

• Preferrably nodeJs
• Whatsapp Business API
• Trello API

Social Impact

• This could be useful to a lot of large teams using Trello for project mangement
• Would be nice project to mention in your resume when you may join some startup in future✨

Additional info

• Feel free to use your creativity to see how you could improve upon the idea and make it more customisable or feature rich.
• (Optional) see if you can maybe extend this bot for applications other than Trello. eg: maybe we could use a similar webhook event from github to dm folks via whatsapp if they have been mentioned in any organization's repo/issue thread. Just need a mapping of github usernames and phone-numbers.
• Please store all API keys in separate env file which is in .gitignore

Have fun:)

Personal URL shortener server

Features to have

• login feature where the admin can log in with some password
• input fields for longUrl eg: (docs.google.com/...) and a slug name (eg: report)
• The url shortner should generate a shortened url(eg: yourHostedDomain.com/links/report) with the given slug name which when navigated to will redirect the user back to the long url
• in case the slug name entered has already been assigned to the user, a warning message should be shown immediately

Tech stack

• any backend language of your choice can be used, though python or nodeJs preferred
• Any database of your choice can be used