 Now, I will explain the serial control, the way we catalog the book the same way we need to catalog the serial journals which we continuously based on the frequency of the journal we receive it. There are two things here, one is the vendor, the another one is the item, item type is the journal in this case, the journal may be the magazine or newspaper or periodicals or anything. We need to establish in serial control case, we need to remember three important aspect one is the big by D that is the journal, the second one is the vendor, if you have both you need to connect this both, the way we are placing the order for the book the same way for the journal also you need to connect this one. I will show you first how to create one bibliographic record of the journals then I will either I will use the existing vendor or I will create the new vendor then I will start the subscription. After making the subscription we will start receiving the issues that we need to plan it all these three things I will show you all are in main page only you click serial there is called new subscription click new subscription did you got this one add a new subscription since you have already created a vendor what is you search that vendor that is sci-tech or something every one of you got this one then select choose now I think we have not created any journals. So, you can create a create a record click create a record and enter a minimum bibliographical details here. So, I will go directly serial two which means two fortified title I will all of you type science magazine science probably you do not need a majority of the details the way you enter for the books. What is happening is when you are adding any journal subscription in Koha the title of the journal needs to be available somewhere am I right the title publisher when it is published since when it is published who is the publisher year of publication all these details has to be there somewhere. So, for somewhere means you have to have those details in the cataloging area. So, what Manju is trying to do is he is adding one journal title name in your bibliographic data. Just two fortified I entered the title of this magazine science then you if you know the publisher and all those things immediately you can enter it or if you minimum details if you can carry also another important difference between books and serial is that you need to put it in three zero zero in what is the frequency of this magazine three one zero is the publication frequency you can see that you can hear what is the frequency of those the maximum you can define it suppose I will put it here the weekly. So, science is monthly you have to enter in three hundred and ten dollar eight tab weekly as an option. Here also in case if you need the which subject it deals in six five zero the journal the science magazine subject field you can enter it which this is a keyword use your basically it deals with multidisciplinary you can enter this is a general science you can repeat also this one a again multidisciplinary I know that who is the publisher the publisher is triple A S this much minimum level I know later on we can update it item type instead of book you need to select serial the difference so I will save it the compulsory minimum fields you need to select it yeah who is there yeah I will go once again to serial yeah at the time of receiving so you can define where to it did not understand see we have added the cataloging details and then you you have got the item details space there you have the barcode option there so you are not giving any accession number you have only created a bibliographic entry of a journal which you want to use for renewing your subscription of journals ok. So, you have to leave it there itself and come back to your series module ok since I have already entered this bibliography details I will search this science magazine so what basically I am looking ok I am connecting the these two record bibliographical record as well as a vendor to play to subscribe this magazine science you see that choose the which the magazine which I entered the which library you can since we are ITB library we are doing you can select that which library we are subscribing here we can define that since a weekly magazine is a weekly you can give grace period at least three days or four days ok after that week you can expect this one I will give three days as a grace period pattern notification location yeah as soon as it comes probably we will put it on display so I will select the location serial I will click the next now number of issue to display to stop so we can define that how many issue can be shown in the stop interface suppose if it is a hundred ok we are on 52 yearly we receive it all the 52 will be a big junk to show the stop so only latest 4 or 8 can be displayed so you can define those number of entries here in both stop interface as well as what pack you can define as much as you put it a minimum here then I will click here I will put 8 the pack usually user will expect most latest issue of that magazine so I will put here 4 so then I will click the next you need to define here the planning ok usually the journal we subscribe for a year ok from January to December we need to define that subscription starting date and the ending date so when subscription starts January 1st 2017 frequency 1 per week subscription length I can define it at all months 52 issues 52 issues of first issue as well as subscription period both January 1st and subscription ends with 31st December 2017 here you can define that the which number the which way you want the pattern like volume number issue number I will show you the different numbering pattern you see that usually the volume number and issue we usually practice this one assume that this is around new volume ok this is around new volume begin with for 2017 around 152 volume since I selected this one volume and number I will select the volume and number let me volume is 152 the issue I will take it as a January as the issue number first one this issue number should be followed by volume number I will predict this one how it will look click test predict you see that yeah due to this 12 when more than 52 still it is 152 is going on the third ok every 12 every 12 every 52 begins with 152 number 1 I will select the volume number I will add 1 every 52 issue ok what the volume now set back nothing we will do a 7 new pattern every 52 that is what I had I had said that we did not one second let me see what happens now ok now anyway 152 is there ok now here every 52 no no no now it is correct monthly 1 now every month it will not every year volume will change now volume I do not want to change the volume now I think it should work now I have 52 no no no year I think it should work year 52 am I right correct now correct now it is correct ok so anyway this is how you can predict predict the prediction pattern so basically that you can and then start receiving the issue you see that once you define that frequency and as well as the volume number pattern so automatically it shows that expected the issues of publications you can click the receive it since it is already since we are how many or we are going to receive this one so as soon as this one first one if you receive this one just you can see that you whatever you are going to receive that one you can arrive it yes see that is the one volume one the issue 1 152 I received it like that you can receive the all the 52 issues or either at a time at the end or every month you can receive that after week as soon as week passes since year the disadvantage here is that still it is not connected to accounting so you can receive only the issues here you can do the subscription you can do the receiving that one once you receive that the binding and other things you can take care the next stage even binding also at currently it is not supporting for whereas this is for print journal but whereas resources you need not to do that any prediction just if you put a bibliography details and 856 that URL of that journal the probably every year you can renew it you compare to the print as well as online what we did we created a vendor we created a subscription then we receive the invoice these are the three important things in serial control the only the major task is that you need to predict plan it properly the way currently which I did something wrong so if you do not put it properly that issue number volume number pattern and predict something it will go wrong another advantage here in manual system suppose if you do not receive any particular issue we supposed to send it manually through so these are all the issue we have not received please supply it but here whereas if you set a email after 3 days I given a grace period 3 days if I do not receive within a 3 days automatically mail it will goes to particular supplier ok these are all the following the issue you have not supplied please supply it so you can define that note at the end after subscription is over you can create the generate the report here how many I received how many I not received how many I claim how many late or expected all the details here that is all in serial control so you can practice it monthly and yearly and also unexpected you do not know which issue will come in any year and we are undefined so within a year 3 may come or 4 may come those things also you can select it in a pattern of frequency in serial control do you have any doubts which I have not covered here some unexpected issues will come other than in a frequency as well as a subscription period if you compare to the book acquisition is very simple the only you need to select properly that pattern that is all ok any queries in any module reports 1 2 3 reports ok we will show you 1 2 3 reports reports is a very simple module it just needs to you have to select fields which you need and the reports get generated koa has a huge reports library that reports library already has all the reports generated you have to copy paste put it into your koa and reports get generated but anyway I will show you 1 report it is already 4 10 we can continue we do not mind but since we have a limitation of time slot I will show you the reports how the reports are generated certainly there are many more modules which we could not cover in the today's workshop because you need at least 2 days to conduct the workshop and you fully understand get some confidence practice all that is very much important we have only shown you how exactly each module works you have to practice and then only you get a confidence on let us generate a report quickly go to home click on reports as manju has said you can generate several reports from each module ok acquisition module cataloging module serial control module you can generate the reports from circulation module all the modules you can generate the reports from and there are large number of reports which are available in koa so you do not really will not have any doubt that this report I want and it is not available in koa there are all kinds of reports available as I have mentioned in the last talk at the back end koa uses mysql technology so what happens in the whenever you do any data entry every information that you type in is going to some database some table and some field ok so all that information is stored in some field of mysql database so what you can do is you can do the permutation and combination of various of those fields and generate the reports ok by default koa allow you to now let me just show you there is a reports dictionary which is available and which has all the reports available right now we are going to learn how to generate a report that is called as guided reports wizard so all of you please click on guided reports wizard now let us imagine that you want to generate a accession register report now how you can generate an accession register report you have to go to the cataloging and you can generate now let us say guided reports wizard build new click on build new is there an option build new all of you could find ok now it is asking you from which module you want to generate a report I want to choose catalog are you all here now next ok now the report is in the form of tabular so click on next everybody is here now you can see on the left hand side there are several fields available here ok as I have said these are all the fields where you have entered some data now it is your choice which fields you want and then you can generate a report on now let us say I want first as an accession number so accession number is called as barcode I will say add are you all with me I have selected barcode now I want the title of the book so scroll down until you find title as an option there is an option here biblio.title if you remember I have been mentioning that every cataloging record in koa is called as what biblio ok so I will say select biblio.title and say add done now I want author so author add all of you are with me now I want name of the publisher and place of publication ok now where are they here is publisher yeah so add publication date add then ISBN I want add ok so you can go on selecting the fields which you want in your report all of you have selected these everybody is with me ok those who are with me now otherwise we will now click on next have you all clicked on next now it is again you are getting one big box by which you can control your report imagine that if I have selected a cataloging report and my library has millions of books my whole report will be huge so I can restrict my report by item type or by library type or I can give a barcode range that I want to generate a report on the basis of accession number 1 to 200 I can do that or I can add the restriction by date I can see that whatever books are added today I can only generate a report of those books so I can have this filtration criteria right now anyway I am not putting any filtration criteria say next now it is asking me whether which columns to total anyway I am not saying anything say next ok again still keep on saying now say finish all of you have done now what has happened is can you see here you have generated some report and it has written some SQL query this is called as an SQL query ok because it is combining several fields together and generating a report ok now let us say save give this report name as accession register everybody could do that now say save this report now what you have done in your coha installation you have generated first report that report is from which module cataloging module and this cataloging module report contains accession register details such as barcode title author name of the publisher place of publication ISBN number and year ok now once you have saved this report you can click on run this report are you all here everybody so you can see the number of books which are available in your library and I have selected the report as a pattern barcode title author publisher code publication year and ISBN number if anywhere I have not entered the data so somewhere it has the years have not come we need to check that so whatever books are added all the data will be available to you now you can download that report as a CSV file ok so that you can play with an this book is data and you can customize it or you can share the details with any library and this will be available as a excel sheet for you like if you can see here I can open with my library office cal and I can see this as my excel sheet data ok so this is how you can generate several reports in koha and now today there are 3 books tomorrow I add some 10 more books I only have to do what I have to click on saved reports and then I have to just run this report again when I click on run tomorrow whatever books are added they all will be listed out under my report ok so you have to generate the reports once and then you can run them every frequently ok and koha has a reports library if some reports you do not find you do not know how to generate them there is a reports library in koha let me show you koha report library that is a wikipage this koha reports library they already have generated all the reports you have to copy paste that report mysql statement see here news library you can think of any report and you can just copy paste this statement in your koha and you will be able to generate the report ok so report is a very easy module so anyway we already have 430 we thank you all for paying your attention and we have tried to learn in today's workshop if you have any queries we are going to answer the queries but what we have done today is we have learnt how to set up global system preferences how to use acquisition module how to use cataloging module how to use circulation module how to use serial control module and how to use reports module of course we could not go into more details because it was for one day you really cannot learn everything in one day you need to at least have a practice for 2 or 3 days but I we hope we could make you aware about what are the strengths of koha there would certainly be some weaknesses of koha and I request you if you all have any questions please let us know ok thank you