 Now the fourth project is Barcode Studio. Barcode Studio is an independent Java application for generating and printing multiple barcodes using databases or on user defined label and fields. So, interns, please proceed with the presentation. Good evening, everyone. I am Preeti Agrawal along with Reenu and Vinisha. We are the team members of the project Barcode Studio. What is actually our project? The purpose of Barcode Studio is to produce multiple barcodes on a particular label that can be, whose shape, size, style can be modified according to the needs of the user. Further, what was the motivation of developing such a project or such a software? There are different proprietary softwares available which are tightly bonded not open source means user cannot, these softwares are not freely available to the user. But our software, it is open source and will be freely available to the user. Next is customized labels, customized barcode stickers. The barcode stickers can be customized according to the needs of the user. He can resize the barcode directly by drag and drop. He has to, all the things will be dynamic in our project. Now third, there is no single platform that can support multiple barcodes. Means code 128, code 39, etc. There are many barcodes which our platform can support but there is no software till date that can support different barcodes. Further, multiple copies of the same barcode. Means in our software we can have single barcode, single copy, single barcode, multiple copy, multiple barcode, single copy and multiple barcode, multiple copy. Means all the possible mapping we can have in our software. Now moving further, what are the technologies that has been used in our software? First, it is a Java application. Second, the database is maintained in MySQL. The offline database that what it is, why it is needed, we will tell you later. It is maintained using SQLite. Then different libraries are just different libraries. We have to add for barcode and PDF like Z-Zinc and I-Tex PDF, etc. Now further moving to the next slide. What are the benefits of our project? First, it is cost effective. Means that when the barcode printer is there, when we take out the printout in a particular label, then it will save a lot of paper and it will be much more cost effective. Means lot of amount of cost will not be, means very cheaply we can produce the multiple barcodes. Second, we can have customized stickers and barcodes, captions all will be dynamically resized and reshaped according to the needs of user. Then now further, I already have told you that different kinds of mapping are possible in our project such that we can have single barcode, single copy, the multiple barcodes, multiple copies. User can, if there is a list of, in the database table there are list of values available. First value and last value only to be printed, then he has the option of that also. He has to not print all the values, only selected values according to his own need. Now further, in brief I will describe my software and its features. First what the user has to do, he has to create a custom label in which he can have his own page setting, label setting, label order, means many features we have provided in the page setting page up, across the down, down the across page setting also he can give at the time of printing the barcode. Then what, from where he will get the value that will actually appear on the barcode. He has two options, first he can do the database connectivity or second he can directly input the value and get the result. Suppose I am a, means I don't know anything about computer science, but I want to generate the barcode for my name. Then what I will do, directly I will enter my name and I can generate the barcode. No database connectivity, nothing is required. Then further, the user will get a print preview of what actually the barcode for what data he want to barcode to be printed, will get a print preview of that. And finally he can take the print out of the print preview, either he can export it to the PDF or he can directly give the print command, attach the barcode printer and he will take the print out of the barcode. Now we will give you, we will show the demonstration of our project. This is the first frame that actually appears, as already I have told you, user will create a new label on which the barcodes will appear. He has to give the custom settings, so he will give, select the custom label and proceed with the next button. On clicking next, a page setting window appears where he can give the page format according to his requirement. The select scale allows the user to select any scale, he can give the values in inches centimeter according to his requirement. He can change all the settings that we have given, he can change according to his requirement. And he can save that setting also that will be permanently saved so that the next time user comes, he will have that setting that he has already saved. So it is completely dynamic. Now the border you might see the label, it is checked. It shows that when we will take the print out of barcode, each barcode can have the borders, if he unselects then the border will not appear. And the two options like print order, across and down and down the across, means in which order he wants to view the barcode. Now he can see the preview with the dummy value now. Here in this page, we are showing the dummy value so that here only he can do any modification. Further also we will show the print preview. But from starting he has to again come back, so here a small print preview dummy we are showing. Now he will click on finish. Now the window appears in which he will actually design how his barcode after it will be printed on label will look like. He has to do the database connectivity where he will log in user name and password he has to give. We can connect to any PC of yours also if you give IP address and all. Then list of database will be shown. Suppose I want to connect student database. Then you are connected to the database. Now in the combo box there is a data field if you want to add any caption that will appear below your barcode what information it contains. Then you can add the caption. This is the barcode, different barcodes are available so the most commonly used code 128 suppose I am selecting and I can resize. We can resize, reshape, move anywhere what the user wants. Then we can also change the setting of the text that will appear as a caption. Suppose we go for aerial only, let it be aerial only. Then our plain text it can be do bold, do it bold, anything you can do. And size also you can do 10 anything. Now when the user clicks on the caption, double click on caption. Then a pop up window comes in which he will select the table for which he want to actually generate the barcode. Suppose I go for codes, details, anything. Suppose barcode is a column name is the barcode, click on barcode and click on okay. Then the first value of that particular column appears here. Now the user can view the print preview. Not print preview exactly. Now he will select the data for which he want to generate the barcode. He can select all or only certain data scrolls up and down. He can select only certain data for which he want to generate barcode. He can uncheck anything. And also number of times he can specify. Suppose first record I want to print 10 times, five times anything you can write. Similarly you can change all the other values and click on the preview button. Then a preview of the barcode that you have designed with different values and multiple pages are available. You can export it to the PDF, click on export to PDF. Just you have to write the name of your PDF file and it will be saved. Anything right? Okay. And a user can directly print also if the printer is attached. Now there is no printer so cancel it. Close. Now second I told you that directly user can also enter the text. So double click if I don't want to connect to database and anything I don't want to do. Simply you write anything in turn 001 suppose any value can write. Insert. In turn two records, let us check. Insert. Now here also user has a facility to change number of times he want to print certain records. He can change that and click on okay button. Directly the print preview will be shown to the user. There is only one page so and here same no need to do. Here again he has same option print and export to PDF. Now close it. There a small report is also we have we are generating a small report also on the side back of which database user has selected. This is offline database we are maintaining using the SQLite. This is the list. Just now we have entered what steps we have done are also listed here along with the time date etc. You can delete any of the record if you want. Then close and further help menu is provided where the user can go through how actually to use our software and thank you. And we not only develop the software we have also started implementing. First implementation was Wikipedia hackathon we had the barcode sticker that was printed by our printer only and we did it. So thank you. Specification. No where did you get the specifications of your system? Specifications of what you are developing? Hello. How? Hello. So all the things were given by him? Requirements means what? Where did you get the requirements from? Exactly. So that is what I want. No, you are connecting. Correct. Exactly. One mile ahead also. Right. So you took a proprietary that is for everybody. So you took a proprietary software. Analyzed it and then whatever features you wanted to add you added. Whatever you thought something. Now generally they supposed to a business expert who does that. In the absence of the business expert how do I know that the features you added are actually usable by the industry. Well sounds very good. This is actually industrial product. Correct. No, but no, that mile ahead the industry may not need that is what I am saying. They have flexibility what they have. No, they have to justify why they have gone miles ahead. No, miles ahead is the reason that we are using the past. So you are the business user and you felt that the current proprietary software which you are using is not serving your needs. 30 days got nothing to do with it, 30 days you do not want to pay.