The author and subject fields are hyperlinked fields. If you click on them it will result all the records on the same name/heading. If you still need a report, you may check koha wiki report page. There you will definitely find what you are looking for.
Sir, Saved reports are displaying barcode wise arrangement. But sir, if I entered 250th book finally, and after I edit the inner any one eg. 195th book once more edit in some details, then its barcode is same but it is displaying most finally sir. I want to it become again in the correct barcode position. How its possibles sir? Help me
Here is the video of how to add a customised SQL report ruclips.net/video/kkUz6Tr1k1A/видео.html You will get the SQL code here wiki.koha-community.org/wiki/SQL_Reports_Circulation#List_of_books_issued_in_between_two_date_ranges_and_accession_number_range
If you are asking ERP as in Electronic resources, then no, we can't. That's a complete different thing. But, if we make an entry of those resources in Koha then we can normal reports as it will consider those as other resources.
@@TheCoProfessionals I am talking about Enterprises Resources Planning software, where entire institute is connected with a single software, report can be integrated from koha.
You know I have shifted my library from egranthalaya to koha 24.04 and imported 5000 records successfully into koha but I am unable to find the barcodes of books, please help me and let me know if the barcodes gets generated during import process automatically or I have to assign manually
Barcode is a mandatory field while importing data. If you haven't mentioned the barcode while importing, then how the system accepted it I doubt. If you have mentioned the barcode while importing, check whether it is reflecting on the staff end in a record or search by the barcode directly. If it is not showing on OPAC, then you just need to check whether the barcode option is unchecked in administration. Go to Koha Administration > Additional Parameters > Table Settings > OPAC and then uncheck the item_barcode option under Table id: holdingst.
@TheCoProfessionals I have installed koha as a fresh instatnce again please suggest necessary instructions before importing records so that I may not face any issue
Dear sir, can we take patrons batch wise total taken number of books? for example we create a group like ug students..that groups are around 185 members. we want, that all members are how many books taken? can you tell me?
Apply the following SQL code, it may solve your problem. select count(*) as Total_Checkout, borrowers.cardnumber as Card_Number, concat(borrowers.title,' ',borrowers.firstname,' ',borrowers.surname) as Name, borrowers.categorycode as Category_Code from issues left join borrowers on borrowers.borrowernumber = issues.borrowernumber where borrowers.categorycode='AM' group by issues.borrowernumber
You can. You need to create a simple report first. You can hava a look to the Koha wiki reports for that. Copy that sql code and paste it and run the report.
Very useful video.
Hi Sir,
Hope you're having a beautiful day.
Thanks a lot for sharing this informative video!
So nice vdo sir, Thank you
Sandar Sir ji
Sir ji play List Bana do Koha software ke video ka
Thank you so much Sir.🙏
Hello sir thanks for your video
Pls. Tell me about report for total no. Of books of a particular author and total no. Of books on a subject
The author and subject fields are hyperlinked fields. If you click on them it will result all the records on the same name/heading.
If you still need a report, you may check koha wiki report page. There you will definitely find what you are looking for.
@@TheCoProfessionals Thanks sir
Sir, Saved reports are displaying barcode wise arrangement.
But sir, if I entered 250th book finally, and after I edit the inner any one eg. 195th book once more edit in some details, then its barcode is same but it is displaying most finally sir.
I want to it become again in the correct barcode position. How its possibles sir?
Help me
I am not able to understand your problem.
Aap hindi me simplify kar sakte ho.
Dear sir, how to calculate the total fines paid reports in koha 23.05 ?
How to create a monthly or daily circulation report? Please make a video🙏
Here is the video of how to add a customised SQL report
ruclips.net/video/kkUz6Tr1k1A/видео.html
You will get the SQL code here
wiki.koha-community.org/wiki/SQL_Reports_Circulation#List_of_books_issued_in_between_two_date_ranges_and_accession_number_range
Can we integrate the koha report with other ERP system? If yes pl. describe how?
If you are asking ERP as in Electronic resources, then no, we can't. That's a complete different thing. But, if we make an entry of those resources in Koha then we can normal reports as it will consider those as other resources.
@@TheCoProfessionals I am talking about Enterprises Resources Planning software, where entire institute is connected with a single software, report can be integrated from koha.
You know I have shifted my library from egranthalaya to koha 24.04 and imported 5000 records successfully into koha but I am unable to find the barcodes of books, please help me and let me know if the barcodes gets generated during import process automatically or I have to assign manually
Barcode is a mandatory field while importing data. If you haven't mentioned the barcode while importing, then how the system accepted it I doubt. If you have mentioned the barcode while importing, check whether it is reflecting on the staff end in a record or search by the barcode directly. If it is not showing on OPAC, then you just need to check whether the barcode option is unchecked in administration.
Go to Koha Administration > Additional Parameters > Table Settings > OPAC and then uncheck the item_barcode option under Table id: holdingst.
@TheCoProfessionals I have installed koha as a fresh instatnce again please suggest necessary instructions before importing records so that I may not face any issue
@TheCoProfessionals thanks, these instructions are similar to instructions i was using in earlier software
Dear sir, can we take patrons batch wise total taken number of books? for example we create a group like ug students..that groups are around 185 members. we want, that all members are how many books taken? can you tell me?
Apply the following SQL code, it may solve your problem.
select count(*) as Total_Checkout, borrowers.cardnumber as Card_Number, concat(borrowers.title,' ',borrowers.firstname,' ',borrowers.surname) as Name, borrowers.categorycode as Category_Code from issues left join borrowers on borrowers.borrowernumber = issues.borrowernumber where borrowers.categorycode='AM' group by issues.borrowernumber
which screen recorder u used dear. highly informative vedieo.
Simple screen recorder in Ubuntu.
Bro i want take subject wice report can you pl how get pl tel me thx urgent need your help.
You can check on koha wiki reports. Definitely you will find there.
I want to se all checkout book list in one report
You can. You need to create a simple report first. You can hava a look to the Koha wiki reports for that. Copy that sql code and paste it and run the report.
@@TheCoProfessionals thanks sir
I am having koha 21.05 version
Is anything to share regarding that..!
सर जी क्या आपका नम्बर मिल सकता है
kolrahaman04@gmail.com
Ap ye email par mail kar sakte hain.