Re: [Koha] Framework Reports
Hi, all! In our latest exchange, on 3 Oct. 2021 at 08:01 [JST], I received this through the Koha Discussion Group: for the existing runtime parameters you can refer to the manual:
https://koha-community.org/manual//21.05/en/html/reports.html#report-from-sq...
The one for frameworks is <<Framework list|biblio_framework>>
Thank you for the advisement. My report works properly now excepting for one problem: While I now get a proper list, when I press the Download button, I get only the header. The actual downloaded report is empty excepting for the header. Worse, the downloaded report is empty only when the selected framework is the default. The reports for the other frameworks, e.g., BK (for textual materials), do indeed download the biblionumber, author, and title. Here's the SQL instruction in its entirety: SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS 'Author',
biblio.title AS 'Title' FROM biblio WHERE biblio.frameworkcode = <<Which framework?|biblio_framework>> ORDER BY biblio.biblionumber ASC
This happens to all three download file options: CSV, TAB, and ODS. Any advice on fixing this? Is this a bug? I didn't see such a bug on Bugzilla, so I submitted one, by the way. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
ODS worked for me, I haven't tried the other two. Which version of Koha are you using? Elaine VWML <https://vwml.org> On Sun, Oct 3, 2021 at 7:03 PM Charles Kelley <cmkelleymls@gmail.com> wrote:
Hi, all!
In our latest exchange, on 3 Oct. 2021 at 08:01 [JST], I received this through the Koha Discussion Group:
for the existing runtime parameters you can refer to the manual:
https://koha-community.org/manual//21.05/en/html/reports.html#report-from-sq...
The one for frameworks is <<Framework list|biblio_framework>>
Thank you for the advisement. My report works properly now excepting for one problem: While I now get a proper list, when I press the Download button, I get only the header. The actual downloaded report is empty excepting for the header. Worse, the downloaded report is empty only when the selected framework is the default. The reports for the other frameworks, e.g., BK (for textual materials), do indeed download the biblionumber, author, and title.
Here's the SQL instruction in its entirety:
SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS 'Author',
biblio.title AS 'Title' FROM biblio WHERE biblio.frameworkcode = <<Which framework?|biblio_framework>> ORDER BY biblio.biblionumber ASC
This happens to all three download file options: CSV, TAB, and ODS.
Any advice on fixing this? Is this a bug? I didn't see such a bug on Bugzilla, so I submitted one, by the way.
--
気を付けて。 /ki wo tukete/ = Take care.
-- Charles.
Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338
Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN
+1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell]
mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually. _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hello, Elaine, et al! In our latest exchange, on 6 Oct. 2021 at 05:50 [JST], I received the following through the Koha Discussion Group: Thank you for your reply. ODS worked for me, I haven't tried the other two. Which version of Koha
are you using? Elaine VWML <https://vwml.org>
Koha 20.05. We will begin migrating to 20.11 in a month or so, first on the development machine, then on the production machine. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
We're on 21.05 Elaine VWML <https://vwml.org> On Tue, Oct 5, 2021 at 6:31 PM Charles Kelley <cmkelleymls@gmail.com> wrote:
Hello, Elaine, et al!
In our latest exchange, on 6 Oct. 2021 at 05:50 [JST], I received the following through the Koha Discussion Group:
Thank you for your reply.
ODS worked for me, I haven't tried the other two. Which version of Koha
are you using? Elaine VWML <https://vwml.org>
Koha 20.05. We will begin migrating to 20.11 in a month or so, first on the development machine, then on the production machine.
--
気を付けて。 /ki wo tukete/ = Take care.
-- Charles.
Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338
Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN
+1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell]
mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
Hi again, Elaine! In our latest exchange, on 7 Oct. 2021 at 02:00 [JST], you wrote: We're on 21.05
Elaine VWML <https://vwml.org>
Hmmm. This gives me pause and reconsider migrating to 21.05 instead of 20.05. Maybe my bug was spotted earlier than I reported and fixed. Or it was indirectly fixed when another bug was exterminated. If you have been involved in software development, that does happen, as I'm sure many on this list can attest. So that's what I hope as we begin the upgrade process. In the meantime, my interim solution -- see other correspondence -- solves the problem for the moment. Thanks for your help. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
participants (2)
-
Charles Kelley -
Elaine Bradtke