Bug 40906 - Update the "New SQL from mana" interface
Summary: Update the "New SQL from mana" interface
Status: Needs Signoff
Alias: None
Product: Koha
Classification: Unclassified
Component: Mana-kb (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: elias.lorgnier@biblibre.com
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks: 40885 41652
  Show dependency treegraph
 
Reported: 2025-09-30 12:30 UTC by elias.lorgnier@biblibre.com
Modified: 2026-01-29 15:24 UTC (History)
3 users (show)

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: Sponsored
Comma delimited list of Sponsors: Biblibre
Crowdfunding goal: 0
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments
Bug 40906: Redesign Mana report import UI (34.29 KB, patch)
2025-12-04 09:33 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Redesign Mana report import UI (34.24 KB, patch)
2025-12-10 14:25 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Redesign Mana report import UI (34.31 KB, patch)
2025-12-16 13:53 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Dropdown sort button in mana import UI (5.36 KB, patch)
2025-12-16 13:53 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Redesign Mana report import UI (34.23 KB, patch)
2025-12-22 11:06 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Redesign Mana report import UI (34.23 KB, patch)
2025-12-22 11:08 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Dropdown sort button in mana import UI (5.36 KB, patch)
2025-12-22 11:08 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Redesign Mana report import UI (34.25 KB, patch)
2026-01-08 08:46 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Dropdown sort button in mana import UI (4.86 KB, patch)
2026-01-08 08:46 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Redesign Mana report import UI (33.41 KB, patch)
2026-01-26 10:55 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Dropdown sort button in mana import UI (5.41 KB, patch)
2026-01-26 10:55 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Redesign Mana report import UI (33.58 KB, patch)
2026-01-27 14:47 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review
Bug 40906: Dropdown sort button in mana import UI (5.41 KB, patch)
2026-01-27 14:47 UTC, elias.lorgnier@biblibre.com
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description elias.lorgnier@biblibre.com 2025-09-30 12:30:43 UTC
The idea is to create a better interface than search only for importing reports from mana. 

A marketplace would allow discovering new reports, while maintaining a good searchability. The information presented as a grid of cards would allow seeing immediately informations that are important to evaluate the relevance and "reliability" of a report : title, description, author, number of download. It would also allow for a better visual hierarchy between title, description, and other information. 

Each card will show the following informations 

- Title 
- Author
- number of downloads 
- description (Note in Koha)


The full SQL code from the report will be available by clicking on each card, as well as the full description of the report.
Comment 1 elias.lorgnier@biblibre.com 2025-12-04 09:33:51 UTC
Created attachment 190148 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the test-bug-40906 branch from my repo of mana : https://gitlab.com/elorgnier/koha-mana/-/tree/test-bug-40906?ref_type=heads
- Run docker compose up in the repo
- in the .env file of ktd, for the MANA_URL option, use 127.17.0.1:5000 (if you have the default host ip defined in the  docker bridge network)
- run ktd
- in koha > Administration, configure a mana account with random username and email (no need to validate it)
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

By default there is no report loaded in mana, so you will want to create sample reports to be able to test it, i'll push a sample to the test branch of mana as soon as possible.

You can create your own sample or mount a dump of the existing database in the docker compose of mana by mounting the sql dump in the place of the /sql/schema.sql
Comment 2 elias.lorgnier@biblibre.com 2025-12-10 14:25:01 UTC
Created attachment 190396 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the test-bug-40906 branch from my repo of mana : https://gitlab.com/elorgnier/koha-mana/-/tree/test-bug-40906?ref_type=heads
- Run docker compose up in the repo
- in the .env file of ktd, for the MANA_URL option, use 127.17.0.1:5000 (if you have the default host ip defined in the  docker bridge network)
- run ktd
- in koha > Administration, configure a mana account with random username and email (no need to validate it)
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

By default there is no report loaded in mana, so you will want to create sample reports to be able to test it, i'll push a sample to the test branch of mana as soon as possible.

You can create your own sample or mount a dump of the existing database in the docker compose of mana by mounting the sql dump in the place of the /sql/schema.sql
Comment 3 elias.lorgnier@biblibre.com 2025-12-16 13:53:06 UTC
Created attachment 190544 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the test-bug-40906 branch from my repo of mana : https://gitlab.com/elorgnier/koha-mana/-/tree/test-bug-40906?ref_type=heads
- Run docker compose up in the repo
- in the .env file of ktd, for the MANA_URL option, use 127.17.0.1:5000 (if you have the default host ip defined in the  docker bridge network)
- run ktd
- in koha > Administration, configure a mana account with random username and email (no need to validate it)
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

By default there is no report loaded in mana, so you will want to create sample reports to be able to test it, i'll push a sample to the test branch of mana as soon as possible.

You can create your own sample or mount a dump of the existing database in the docker compose of mana by mounting the sql dump in the place of the /sql/schema.sql
Comment 4 elias.lorgnier@biblibre.com 2025-12-16 13:53:07 UTC
Created attachment 190545 [details] [review]
Bug 40906: Dropdown sort button in mana import UI

Using the datatable "collection" button, i added a dropdown menu to the datatable, making it possible to sort results, so no feature are lost in the patch.
Comment 5 elias.lorgnier@biblibre.com 2025-12-22 11:06:46 UTC
Created attachment 190660 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the mana repo on yout machine (from https://gitlab.com/koha-community/koha-mana)
- Run docker compose up in the repo
- in the .env file of ktd, for the MANA_URL option, use http://<gateway ip in the kokhanet bridge network>:5000
- run ktd
- in koha > Administration, configure a mana account with random username and email (no need to validate it)
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

By default there is no report loaded in mana, so you will want to create sample reports to be able to test it, i'll push a sample to the test branch of mana as soon as possible.

You can create your own sample or mount a dump of the existing database in the docker compose of mana by mounting the sql dump in the place of the /sql/schema.sql
Comment 6 elias.lorgnier@biblibre.com 2025-12-22 11:08:22 UTC
Created attachment 190661 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the mana repo on yout machine (from https://gitlab.com/koha-community/koha-mana)
- Run docker compose up in the repo
- in the .env file of ktd, for the MANA_URL option, use http://<gateway ip in the kokhanet bridge network>:5000
- run ktd
- in koha > Administration, configure a mana account with random username and email (no need to validate it)
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

By default there is no report loaded in mana, so you will want to create sample reports to be able to test it, i'll push a sample to the test branch of mana as soon as possible.

You can create your own sample or mount a dump of the existing database in the docker compose of mana by mounting the sql dump in the place of the /sql/schema.sql
Comment 7 elias.lorgnier@biblibre.com 2025-12-22 11:08:24 UTC
Created attachment 190662 [details] [review]
Bug 40906: Dropdown sort button in mana import UI

Using the datatable "collection" button, i added a dropdown menu to the datatable, making it possible to sort results, so no feature are lost in the patch.
Comment 8 Martin Renvoize (ashimema) 2025-12-22 11:23:47 UTC
Initial testing and this is looking great.

I got the Mana Docker up and running and connected, but I am struggling to populate it with any reports. For some reason, my shares from KTD never appear on the Mana side
Comment 9 elias.lorgnier@biblibre.com 2026-01-08 08:46:47 UTC
Created attachment 191020 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the mana repo on yout machine (from https://gitlab.com/koha-community/koha-mana)
- Run docker compose up in the repo
- in the .env file of ktd, for the MANA_URL option, use http://<gateway ip in the kokhanet bridge network>:5000
- run ktd
- in koha > Administration, configure a mana account with random username and email (no need to validate it)
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

By default there is no report loaded in mana, so you will want to create sample reports to be able to test it, i'll push a sample to the test branch of mana as soon as possible.

You can create your own sample or mount a dump of the existing database in the docker compose of mana by mounting the sql dump in the place of the /sql/schema.sql
Comment 10 elias.lorgnier@biblibre.com 2026-01-08 08:46:48 UTC
Created attachment 191021 [details] [review]
Bug 40906: Dropdown sort button in mana import UI

Using the datatable "collection" button, i added a dropdown menu to the datatable, making it possible to sort results, so no feature are lost in the patch.
Comment 11 elias.lorgnier@biblibre.com 2026-01-26 10:55:49 UTC
Created attachment 192018 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- In follow up, adds a drop down button to sort reports
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the mana repo on yout machine (from https://gitlab.com/koha-community/koha-mana)
- Set up the mana utility to start mana
- run `mana up` to launch a mana instance (it will create a mana network with docker)
- run `ktd --mana up`
- in koha > Administration > ManaKB settings, set the mana usage to yes
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

By default there is no report loaded in mana, so you will want to create sample reports to be able to test thr patch. You can simply uncomment the line in the `compose/base.yml`, under db -> volumes to add the sample reports.

To be able to export your reports from koha to mana requires that you create a librarian account, wich can be done from koha administration page, and that you verify that account, which can only be done directly with SQL or by allowing mana to send emails for now, wich is not configurable easely.

If you already have a mana instance running, you can use the --mana-url option of ktd to choose the url of your mana instance.
Comment 12 elias.lorgnier@biblibre.com 2026-01-26 10:55:51 UTC
Created attachment 192019 [details] [review]
Bug 40906: Dropdown sort button in mana import UI

Using the datatable "collection" button, i added a dropdown menu to the datatable, making it possible to sort results, so no feature are lost in the patch.
Comment 13 elias.lorgnier@biblibre.com 2026-01-27 14:47:28 UTC
Created attachment 192098 [details] [review]
Bug 40906: Redesign Mana report import UI

Why :
This patch is a revamp of the interface of the menue "Import SQL from Mana". It is supposed to make it feel more like a marketplace of plugin or apps. I believe it is more coherent visually and fonctionally with what this feature is doing. Also, reports are immediatly displayed when the modal opens, inviting the user to explore report, while maintaining the ability to search for it. When the patch 40826 will be applied, we'll be able to sort reports based on the number of imports they recieved.

It also includes :
- Moving the search of report from the deprecated svc to the rest API
- Paginating results so it doesn't load 1300 reports each time we search for reports.
- In follow up, adds a drop down button to sort reports
- Pagination makes it future proof in case of an augmentation of available reports.

Test plan :
- Clone the mana repo on your machine (from https://gitlab.com/koha-community/koha-mana)
- By default there is no report loaded in mana, so you will want to create sample reports to be able to test the patch. You can simply uncomment the line in the `compose/base.yml`, under db -> volumes to add the sample reports.
- Add the bin/mana utility to your path
- run `mana up` to launch mana and create a docker network koha will connect to (see how to use the mana utility here : https://gitlab.com/koha-community/koha-mana/-/tree/main/compose?ref_type=heads)
- run `ktd --mana up` to connect koha to mana
- in koha > Administration > ManaKB settings, enable Mana (no need to create a secority token to test this patch)
- In the report section, select new SQL report, and then in the dropdown menu, New SQL from mana.

To be able to export your reports from koha to mana requires that you create a librarian account, wich can be done from koha administration page, and that you verify that account, which can only be done directly with SQL or by allowing mana to send emails for now, wich is not configurable easely.

If you already have a mana instance running, you can use the --mana-url option of ktd to choose the url of your mana instance.
Comment 14 elias.lorgnier@biblibre.com 2026-01-27 14:47:30 UTC
Created attachment 192099 [details] [review]
Bug 40906: Dropdown sort button in mana import UI

Using the datatable "collection" button, i added a dropdown menu to the datatable, making it possible to sort results, so no feature are lost in the patch.