Re: [Koha] Subject Wise Report

2019-05-05 Thread Tsu-Shuan Chang
Hi Joel, Regarding your email, our church is not so advanced. Basically, we need to catalogue items including books, DVDs, youth books, etc. We can self check out and just leave a borrowing card. Of course, we can lose some books in this way, but not too many. I'll try to put some thinking

Re: [Koha] Subject Wise Report

2019-04-18 Thread Coehoorn, Joel
You can back the holdings and biblio records in marc21 format. You cannot backup circulation history, patron data, serials data, acquisition settings, authorities, system settings, etc using just marc21. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoeho...@york.edu * *Please

Re: [Koha] Subject Wise Report

2019-04-18 Thread Michael Kuhn
Hi Rizwan You wrote: > I am try to write a query in which all fields from items, biblio, > bilioitems tables are required to be shown. But I am facing > difficulties to show subject heading and classification number. I also > tried extractvalue() > function to show subject heading but error

Re: [Koha] Subject Wise Report

2019-04-17 Thread Tsu-Shuan Chang
Response to: Please reply to the mailing list so that others can participate. I am new and have two questions. (1) Can we back up in MARC21 format? If yes, how? (2) Can we restore the data from above mentioned MARC21 format? If yes, how? I ask the questions since we have an old koha, maybe

Re: [Koha] Subject Wise Report

2019-04-16 Thread Owen Leonard
> But I am facing difficulties to > show subject heading and classification number. I also tried extractvalue() > function to show subject heading but error displayed. If you could share the SQL you're working with we might be able to diagnose the error. -- Owen -- Web Developer Athens County

[Koha] Subject Wise Report

2019-04-16 Thread Rizwan Majeed
I am try to write a query in which all fields from items, biblio, bilioitems tables are required to be shown. But I am facing difficulties to show subject heading and classification number. I also tried extractvalue() function to show subject heading but error displayed. Has anyone the solution of