SQL Reports Library v2.0
Hi, I count more than 300 reports on *SQL Reports Library*, is getting a little bit out of control. Become difficult to: + found the needed report, + tag them, + talk about the report, + track easily contributions to each one, + link "related" reports, different flavors of the same one, + vote them, + add easily to Koha, + get statistic information, and much more. I'm not sure what is the best solution. An ad hoc web development? A friend suggest me Semanticscuttle <http://semanticscuttle.sourceforge.net/>. Trying to at least make things more tidy I create: SQL Reports Library in templates <http://wiki.koha-community.org/wiki/SQL_Reports_Library_in_templates> (equivalent to the usual but using mediawiki templates). This use Template:Report <http://wiki.koha-community.org/wiki/Template:Report>. Some things happens (or will happen) with JQuery and SQL libraries: A wiki page is not a good library/database. Regards, Pablo
Pablo, I'm interested on making the wiki simpler to browse and maintain. If you think you can have the time to work on that, just let us know what you need from our side. If you come up with something interesting i'm pretty sure we'll embrace it. Thanks for the effort on making better docs. On Sun, May 10, 2015 at 1:56 AM, Pablo Bianchi <pablo.bianchi@gmail.com> wrote:
Hi,
I count more than 300 reports on *SQL Reports Library*, is getting a little bit out of control. Become difficult to: + found the needed report, + tag them, + talk about the report, + track easily contributions to each one, + link "related" reports, different flavors of the same one, + vote them, + add easily to Koha, + get statistic information, and much more.
I'm not sure what is the best solution. An ad hoc web development? A friend suggest me Semanticscuttle <http://semanticscuttle.sourceforge.net/>. Trying to at least make things more tidy I create: SQL Reports Library in templates <http://wiki.koha-community.org/wiki/SQL_Reports_Library_in_templates> (equivalent to the usual but using mediawiki templates). This use Template:Report <http://wiki.koha-community.org/wiki/Template:Report>.
Some things happens (or will happen) with JQuery and SQL libraries: A wiki page is not a good library/database.
Regards, Pablo
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
Pablo, I'll second Tomas' sentiment -- I refer to the reports library on a regular basis. I ran across your SQL Reports Library in templates last week, and it caught my interest. I would be willing to spend some time working on converting the old SQL Reports Library. Thanks, --Barton On Mon, May 18, 2015 at 11:39 AM, Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
Pablo, I'm interested on making the wiki simpler to browse and maintain. If you think you can have the time to work on that, just let us know what you need from our side.
If you come up with something interesting i'm pretty sure we'll embrace it.
Thanks for the effort on making better docs.
On Sun, May 10, 2015 at 1:56 AM, Pablo Bianchi <pablo.bianchi@gmail.com> wrote:
Hi,
I count more than 300 reports on *SQL Reports Library*, is getting a little bit out of control. Become difficult to: + found the needed report, + tag them, + talk about the report, + track easily contributions to each one, + link "related" reports, different flavors of the same one, + vote them, + add easily to Koha, + get statistic information, and much more.
I'm not sure what is the best solution. An ad hoc web development? A friend suggest me Semanticscuttle <http://semanticscuttle.sourceforge.net/>. Trying to at least make things more tidy I create: SQL Reports Library in templates <http://wiki.koha-community.org/wiki/SQL_Reports_Library_in_templates> (equivalent to the usual but using mediawiki templates). This use Template:Report <http://wiki.koha-community.org/wiki/Template:Report>.
Some things happens (or will happen) with JQuery and SQL libraries: A wiki page is not a good library/database.
Regards, Pablo
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
I'm very happy this brings enthusiasm! In first place I think we should convert the big list to the template form (probably the title will be repeated on template field). Maybe we need some privileges on mediawiki, I need to study more about it (mediawiki and their API), but the idea might be not just split the library on other articles, just *transclude *them, call all the templates with a giben label. Something like this <http://en.wikipedia.org/w/api.php?action=query&list=embeddedin&eititle=Template:Infobox>? An expert on mediawiki API would be great. 2015-05-18 14:05 GMT-03:00 Barton Chittenden <barton@bywatersolutions.com>:
Pablo,
I'll second Tomas' sentiment -- I refer to the reports library on a regular basis. I ran across your SQL Reports Library in templates last week, and it caught my interest. I would be willing to spend some time working on converting the old SQL Reports Library.
Thanks,
--Barton
On Mon, May 18, 2015 at 11:39 AM, Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
Pablo, I'm interested on making the wiki simpler to browse and maintain. If you think you can have the time to work on that, just let us know what you need from our side.
If you come up with something interesting i'm pretty sure we'll embrace it.
Thanks for the effort on making better docs.
On Sun, May 10, 2015 at 1:56 AM, Pablo Bianchi <pablo.bianchi@gmail.com> wrote:
Hi,
I count more than 300 reports on *SQL Reports Library*, is getting a little bit out of control. Become difficult to: + found the needed report, + tag them, + talk about the report, + track easily contributions to each one, + link "related" reports, different flavors of the same one, + vote them, + add easily to Koha, + get statistic information, and much more.
I'm not sure what is the best solution. An ad hoc web development? A friend suggest me Semanticscuttle <http://semanticscuttle.sourceforge.net/>. Trying to at least make things more tidy I create: SQL Reports Library in templates <http://wiki.koha-community.org/wiki/SQL_Reports_Library_in_templates> (equivalent to the usual but using mediawiki templates). This use Template:Report <http://wiki.koha-community.org/wiki/Template:Report>.
Some things happens (or will happen) with JQuery and SQL libraries: A wiki page is not a good library/database.
Regards, Pablo
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
As long as it is still simple for the average joe to contribute their sample query i'm fine. On Tue, May 19, 2015 at 3:29 PM, Pablo Bianchi <pablo.bianchi@gmail.com> wrote:
I'm very happy this brings enthusiasm! In first place I think we should convert the big list to the template form (probably the title will be repeated on template field). Maybe we need some privileges on mediawiki, I need to study more about it (mediawiki and their API), but the idea might be not just split the library on other articles, just *transclude *them, call all the templates with a giben label. Something like this <http://en.wikipedia.org/w/api.php?action=query&list=embeddedin&eititle=Template:Infobox>? An expert on mediawiki API would be great.
2015-05-18 14:05 GMT-03:00 Barton Chittenden <barton@bywatersolutions.com> :
Pablo,
I'll second Tomas' sentiment -- I refer to the reports library on a regular basis. I ran across your SQL Reports Library in templates last week, and it caught my interest. I would be willing to spend some time working on converting the old SQL Reports Library.
Thanks,
--Barton
On Mon, May 18, 2015 at 11:39 AM, Tomas Cohen Arazi <tomascohen@gmail.com
wrote:
Pablo, I'm interested on making the wiki simpler to browse and maintain. If you think you can have the time to work on that, just let us know what you need from our side.
If you come up with something interesting i'm pretty sure we'll embrace it.
Thanks for the effort on making better docs.
On Sun, May 10, 2015 at 1:56 AM, Pablo Bianchi <pablo.bianchi@gmail.com> wrote:
Hi,
I count more than 300 reports on *SQL Reports Library*, is getting a little bit out of control. Become difficult to: + found the needed report, + tag them, + talk about the report, + track easily contributions to each one, + link "related" reports, different flavors of the same one, + vote them, + add easily to Koha, + get statistic information, and much more.
I'm not sure what is the best solution. An ad hoc web development? A friend suggest me Semanticscuttle <http://semanticscuttle.sourceforge.net/>. Trying to at least make things more tidy I create: SQL Reports Library in templates <http://wiki.koha-community.org/wiki/SQL_Reports_Library_in_templates> (equivalent to the usual but using mediawiki templates). This use Template:Report <http://wiki.koha-community.org/wiki/Template:Report>.
Some things happens (or will happen) with JQuery and SQL libraries: A wiki page is not a good library/database.
Regards, Pablo
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Tomás Cohen Arazi Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
Greetings, Obviously others have agreed, because there are bits and pieces elsewhere. Just search for ‘sql reports’ http://wiki.koha-community.org/wiki/SQL_Reports_Holds http://wiki.koha-community.org/wiki/SQL_Reports_Library OBSOLETE: http://wiki.koha-community.org/wiki/3.2_SQL_Reports_Library The biggest problem is metadata tags for each report so they can be found more easily. I like the template notion put forward. GPML, Mark Tompsett From: Pablo Bianchi Sent: Sunday, May 10, 2015 12:56 AM To: Koha-devel Subject: [Koha-devel] SQL Reports Library v2.0 Hi, I count more than 300 reports on SQL Reports Library, is getting a little bit out of control. Become difficult to: + found the needed report, + tag them, + talk about the report, + track easily contributions to each one, + link "related" reports, different flavors of the same one, + vote them, + add easily to Koha, + get statistic information, and much more. I'm not sure what is the best solution. An ad hoc web development? A friend suggest me Semanticscuttle. Trying to at least make things more tidy I create: SQL Reports Library in templates (equivalent to the usual but using mediawiki templates). This use Template:Report. Some things happens (or will happen) with JQuery and SQL libraries: A wiki page is not a good library/database. Regards, Pablo -------------------------------------------------------------------------------- _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
participants (4)
-
Barton Chittenden -
Mark Tompsett -
Pablo Bianchi -
Tomas Cohen Arazi