 I am Aditya, with my teammate, Dixia and we are here to present our project, automation of certificate generator. Let's start with the introduction. Basically, automation of certificate generator is a web-based tool to generate digital certificates. Here the users are organizers. So we made this project from the point of organizer. Here organizer can login, then create an event, add participants and their basic information and generate certificates, view certificate, add it and then send certificate to its participants via mail. And for every certificate, we generate a unique QR code. So participants can verify their certificate. And our certificate verification is secured using hashing. Here we are using SHA128. So why the project is important? Here's the purpose of the project. As we all know in today's world, most of the workshops and nanodegree programs are held online. So there's very much need to send the certificates to participants. And sending hard copy certificates is not that reliable. So it is very easy and reliable to send digital certificates to a large number of participants at a time. And here we are using hashing techniques. So this is secured using hashing. Digital certificates are part of a developing set of technologies. And we can address here like today's security using hashing identity. So participants can verify their certificate accessibility issues. Like we directly mail the certificates to participants email ID. These are the technologies we used. Python for backend, Django for database. Using latex, we are generating the digital certificate. And HTML, CSN, Bootstrap for our front-end designing. This is the basic database, a class diagram of our project. Like we created these classes and they have their attributes and functions. And there is relationship between the classes. Like one to one, one to many, how the different classes are related to each other. Now Dixia will give us an overview of the project. Good evening everyone. So I'll be giving a brief overview of the project. So as an organizer would log in, then he could create an event. Then he can add a certificate. So what's meant by adding a certificate? It's like adding a zip folder which will contain a latex template.txt file. And also the related things which that latex file needs. So there are basically some formats and rules we have defined for that latex file's name and everything. We'll cover them up later. Then organizer can organize an event. So what's the difference between create an event and organize an event? It's like suppose a Java workshop. So organizing, we can organize the Java workshop many number of times. So he can put the event entry in the event table and organize event entry in the organized event table. So it's like that. And then he can add the participants. So we know that these workshops, they have large number of participants. So it's like we have made a feature like adding a CSV file. The first line, there's also format associated with it that the first line would contain the name of the organized event. And then from second line onwards, there would be the details of the students. And the last, he would send the certificates to the students. So the second thing is the verification. So there's basically a QR code in the certificate of the students. So student can just copy that QR code and paste it on the link given. And they can actually see that their details and the organized event name will show you in the demo. And there's also a picture of the QR code in the certificate. So he or she can scan it also and verify their details also. So I'll show you the demo. So this is the front page of our website. So there are various options associated here. The profile, the profile of the organizer. It is this. And you can add a user. So here we have given the CSV file. You can choose the CSV file. And if it clicks submit, then automatically the details would be added to our database. The second thing is certificate, add and use certificate. He can add a certificate. He can choose a template. So template as we said earlier that these are the rules for template that template must be a zip file. And there are various rules, variables available. Actually the tech file it would contain actually in every tech file we have to substitute the name and all the details of the participant. So we have created like we have put a dollar with the variable name. So that thing would be replaced with the student's name and whatever things like event name and everything. So these are the variables available till now. We can also extend it in our database. So this is the basic format. We can give a title to the certificate. Second is the view certificates. So he can actually view those certificates he has like uploaded. So for example, I click on the preview button. And now the latex has been converted to PDF. So it's taking some time. So here the preview has been downloaded. You can actually see the certificate like we have just put some dummy names test first name test last name. This is the QR code. And this is the serial number. He can copy and paste it on our link website and he can verify it. So this is basically the sample certificate we have got from Fosse. So this was all about preview. Then he can add an event, create an event. So he can choose on the certificates available. He has already uploaded some certificates. He can choose that and he can give the name to the event. He can organize an event. Like this is event name, start date, end date, organizers name, place and participants. And the last one is the sending of certificates. So suppose he wants to send the certificate too. Like this is the sample organized event name test one. And suppose this is the mail sent already. So suppose here mail hasn't sent. So I'll click the send all button or I can also send individual mails to the participant. So mail sent successfully and here it has turned green. So it was all about the demo, about the website. So Aditi would, oh yeah, we have verify also. Suppose this is the sample, this thing we have kept here. If we click verify, then all the details would be shown of that serial number or QR code. Like who has the QR code in that certificate. All the details would be shown here. So this was all about the demo. Now Aditi would go on with the future scope. As we design this project at this point from the organizer point of view. But this can be extended from the student's point of view. As the authentication system for participants. So they can view and edit their details after the mail sending. Generate certificate PDF from other software than latex. Like right now we are using latex but we can use other also. Features for participants to add their opinion and review on the events. Like after we are sending the certificates to the participant then they can also review and mail us any issues if they are regarding. So this is the future scope. Thank you. What certificate generation? Actually then it would be like spam so we have created like some time gap between like suppose we send 40 certificates at once then. No no no no not sending. Can you generate bulk said 20,000 certificates based on. Because you have many participants right. So yeah. Or are you going to generate one by one. Actually we can generate like when the mail is being sent. So it's what it's doing that. It's doing what it is substituting the values of substituting the name and everything of the participant in the latex file and then it is converting it to PDF. So for every participant it is doing like that. Okay. So in bulk we can generate. Sir. I see. Like what is. Because suppose I have registered for some force or something like that. Okay. So that database and your certificate is the database. No it's the same actually. Actually what we are doing like if we are converting it to the PDF or suppose some XYZ participant is there we are converting we are making it certificate then we are deleting it from the database because it's no longer required. After sending mail we delete it from our system. How do you verify? Actually verify verification is done through the database. We are storing the details of the participants and the organized events in a database. So we are verifying it from that. And what you are deleting? We are deleting the PDF generated. Oh PDF. That's fine. And how do you import the data the large number of participants, student participants. Through that CSV file only like. CSV file. Like there's a format given like the first name then last name then college if there's some. Name correction if you want to do. Name correction of the participant. Yeah he can he can do it actually we have. In view all the he can edit certificate title event. Like in view users he can actually correct the. He can edit and then save in all. Can you also create certificates for an event which was not organized by your software. No. No, they had this option now organized events and then certificate. If the event is not organized. Okay, otherwise you can just say generate certificates for this template. Is that is possible right. Generate we can preview it of course the template we can preview it. But we can generate the certificate for the organized event. Or not organized events if I have now organized on in the past and now I get your software I have to generate some 20 certificates. Like you have to generate it again. First time but I had not used your software to organize the event. You got started and ended. Can I generate a certificate before the end date. Yes, now it is done. Any more corrections. So because we will improve it like in one week. Good job.