GGCE Support issueshttps://gitlab.croptrust.org/grin-global/support/-/issues2024-03-25T07:31:46+01:00https://gitlab.croptrust.org/grin-global/support/-/issues/326Inventory viability INCONCLUSIVE not updated2024-03-25T07:31:46+01:00Jaime Andres AristizabalInventory viability INCONCLUSIVE not updatedCurrently, in GGCE, it's not possible to set `INCONCLUSIVE` with viability percent equal to null. The services require that the `INCONCLUSIVE` status have a viability percent greater than or equal to 0. We request that this rule be elimi...Currently, in GGCE, it's not possible to set `INCONCLUSIVE` with viability percent equal to null. The services require that the `INCONCLUSIVE` status have a viability percent greater than or equal to 0. We request that this rule be eliminated because an `INCONCLUSIVE` test may be not have been evaluated, nor viability observed. Therefore, it should remain `null`.
## Actual Scenario:
![image](/uploads/80312d49e2676a6c47d66a9e1dc6ec2b/image.png)Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/325Seed viability. Allow users attach images/documents to Seed viability2024-03-15T13:08:32+01:00Juan Carlos Alarcon MaldonadoSeed viability. Allow users attach images/documents to Seed viabilityOnly the administrator user can attach images/documents to the `Viability of the seed`. Add an `Action` to manage these permissions.
![image](/uploads/5d2f0ad15987e4e714e3a310b8b074c2/image.png)
/cc @mobrezaOnly the administrator user can attach images/documents to the `Viability of the seed`. Add an `Action` to manage these permissions.
![image](/uploads/5d2f0ad15987e4e714e3a310b8b074c2/image.png)
/cc @mobrezaJuan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/324There is an error in XML document (1, 1596).2024-03-28T06:43:24+01:00Antonio RiveraThere is an error in XML document (1, 1596).The following window is raised randomly while using CuratorTool.
![image.png](/uploads/d236bf5036167543b0a6211884e84ec9/image.png)
Most of the times the message is shown on close the main Curator Tool window or SearchTool window too.The following window is raised randomly while using CuratorTool.
![image.png](/uploads/d236bf5036167543b0a6211884e84ec9/image.png)
Most of the times the message is shown on close the main Curator Tool window or SearchTool window too.https://gitlab.croptrust.org/grin-global/support/-/issues/323Suggestions for improvements. IITA training 2024 Ibadan, Nigeria2024-03-14T09:55:58+01:00Juan Carlos Alarcon MaldonadoSuggestions for improvements. IITA training 2024 Ibadan, Nigeria- grin-global/support#319 See the image of accession on the inventory/lots
- Download inventory to Excel.
- grin-global/grin-global-server#462 grin-global/grin-global-ui#670 Moisture content determination.
- Allow to update the field h...- grin-global/support#319 See the image of accession on the inventory/lots
- Download inventory to Excel.
- grin-global/grin-global-server#462 grin-global/grin-global-ui#670 Moisture content determination.
- Allow to update the field hundred seed weight with the electronic balance.
- For the Viability test, allow to change the number of seeds to be tested of a replicated only for a less value than the original one.
- Record the weight at harvest
- Record the weight after storage
- Record the introduction date in the inventory information
- Reading and printing RFID labels
- Show the Cryo containers once read
- I want to see inventory in Svalbard not available in other Safety duplicate sites
- I want to see inventory in other sites not available in Svalbard
- I want to see inventory in Ibadan not available in other Safety duplicate sites
- I want to see the acquisition source in the search and Accession summary
- I want to add to the distribution the viability and quantity on hand of the inventoriesJuan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/322Add characterization data to images2024-03-13T16:47:14+01:00James AriasAdd characterization data to imagesGood Morning @mobreza
The proposal is to add **characterization data** to the images in order to give the user a more individual or detailed characterization throughout the image.
As shown in the following example:
1. Inventory detai...Good Morning @mobreza
The proposal is to add **characterization data** to the images in order to give the user a more individual or detailed characterization throughout the image.
As shown in the following example:
1. Inventory detail
![InventoryDetail](/uploads/1d60d68ee1e33d5dd9134ca620443b65/InventoryDetail.png)
2. Shows modal Image
![CharacteriizationImage](/uploads/8d82c2e90114c1c74cff810f516e29d2/CharacteriizationImage.jpg)
Thank you so much
Greetings
**James Arias**Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/321Include URLs for BarTender printers (App Label-Printer)2024-03-07T04:15:30+01:00James AriasInclude URLs for BarTender printers (App Label-Printer)Good Morning @mobreza
Taking advantage of the fact that the **Label printer** app already exists, it would be good to register URLs for the printers that are associated with the **BarTender**, the app would only receive the **JSON** fr...Good Morning @mobreza
Taking advantage of the fact that the **Label printer** app already exists, it would be good to register URLs for the printers that are associated with the **BarTender**, the app would only receive the **JSON** from ggce and from the Label Printer only the URL would be selected to print.
**Data for printing from the BarTender**
**URL:** http://server/Integration/P2W_EM_BL_RFID/Execute
**Body:** {
"accession_number":"G52590",
"availability_status_code":"",
"dm_barcode":"f7938656-f1ce-4fd2-a760-70412ea401bf",
"form_type_code":"SD",
"group_name":"TEN2015B",
"inventory_number_part1":"COL003GRP1IMB2015",
"inventory_number_part2":1804,
"name":"Phaseolus vulgaris",
"rfid_barcode":"f7938656f1ce4fd2a76070412ea401bf"
}
***The URL and JSON are editable to the needs of each label to be printed**
Thank you very much for your attention
Greetings
**James Arias**Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/319Add accession image in inventory detail UI2024-03-26T16:12:00+01:00James AriasAdd accession image in inventory detail UIGood Morning @mobreza
It is a requirement that our users have asked us a lot, since it quickly facilitates the visual identification of the germplasm when consulting the inventory, as shown in the following example.
1. Inventory is co...Good Morning @mobreza
It is a requirement that our users have asked us a lot, since it quickly facilitates the visual identification of the germplasm when consulting the inventory, as shown in the following example.
1. Inventory is consulted
2. Inventory detail UI show
![ImagenUIInventory](/uploads/38aec5a49d03c59a919d4042c7ded90f/ImagenUIInventory.jpg)
3. Optional: Click on the image and show the detail
![DetailImagen](/uploads/5392c8d8feb833e353708d09a8a20fe7/DetailImagen.png)
Thank you very much for your attention
Greetings
**James Arias**Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/309GGCE 2023.8 update2023-11-28T14:37:52+01:00Juan Carlos Alarcon MaldonadoGGCE 2023.8 updateDear all, We are happy to announce the availability of the `2023.8` release of **GGCE!**
Please check the complete list of changes at:
- Announcement #309
- Web https://gitlab.croptrust.org/grin-global/grin-global-ui/-/releases/v2023.8...Dear all, We are happy to announce the availability of the `2023.8` release of **GGCE!**
Please check the complete list of changes at:
- Announcement #309
- Web https://gitlab.croptrust.org/grin-global/grin-global-ui/-/releases/v2023.8
- API https://gitlab.croptrust.org/grin-global/grin-global-server/-/releases/v2023.8
This release improves the **attachment handling in GGCE**: the files are now streamed directly between the client and server (instead of loaded into memory) and multiple attachments can use the same file in the repository. A new tool for migrating attachment files from GG's `/uploads` folder to GGCE is available to administrators.
GGCE instances with a large number of inventory records were not handling the Curator Tool **lookups for GGCE** (i.e. "Inventory Lookup \*") efficiently. These are now much faster and require less server resources. (grin-global/grin-global-server#429)
USDA upgraded their GRIN Taxonomy tables and introduced a new unique constraint on the `taxonomy_species` table. With `2023.8`, updating the **GRIN Taxonomy data** in your GGCE database is again possible.
The *status* of a viability test in GG is based on the value of `percent_viable`: when the value is provided (not null) the test is considered to be completed. GGCE `2023.8` allows for recording that the result of a viability test is **conclusive** or **inconclusive**. See [Tolerance and Confidence Interval Calculator for Germination Tests](https://www.seedtest.org/en/services-header/tools/germination-committee.html).
For the UI the **Seed viability** was upgraded for conclusive and inconclusive test results, updated translations, and a few squashed bugs.
**New feature:**
* Conclusive and inconclusive test results.
**Database changes:**
* Upgraded unique index on `taxonomy_species` (USDA)
* Added column `status` to `inventory_viablity`.
Existing viability tests will be set to *conclusive* if `percent_viable` is populated and to *pending* if blank.
## Conclusive and inconclusive test results.
Now the viable percentage per replica is calculated, allowing users to determine whether the test is conclusive or not.
![image](/uploads/7732196dfb777d45d0c5b1f60b1e1a31/image.png)
![image](/uploads/584473174870744865168585fb6da726/image.png)Juan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/308Suggestions for improvements. GOAL-DM 2023 Azerbaijan2023-11-27T13:35:28+01:00Juan Carlos Alarcon MaldonadoSuggestions for improvements. GOAL-DM 2023 Azerbaijan- [ ] Better to see the list of actions and the list of accessions on each action
- [ ] Source date: better not to display the calendar to select a date as for some accessions the acquisition date is not precise.
- [ ] Add a map for coll...- [ ] Better to see the list of actions and the list of accessions on each action
- [ ] Source date: better not to display the calendar to select a date as for some accessions the acquisition date is not precise.
- [ ] Add a map for collection site coordinates
- [x] Ensure that RESET button really resets the filters.
- [ ] Make locations mandatory.
- [ ] Distribution: Add SMTA generation and printing.
- [ ] Record old taxon and new taxon when modifying taxa.
- [ ] When registering new species, would it better to distinguish between the popped-up genera with the same name?
- [ ] For location of germplasm in storage, is it possible to add another section so it will be: chamber - rack - column - shelf - tray.
- [ ] Automatic indication of safety duplicate status on accession whose inventory has been safety duplicated.Juan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/306How to capture moisture content2023-10-23T21:20:03+02:00Alejandro VelazquezHow to capture moisture contentHow to capture moisture content, 3 readings per monitoring and automatically calculate the
average of the 3 readings (In CIMMYT these records are inventory_actions).
We are using a macro to capture each read
![image](/uploads/085f6502e...How to capture moisture content, 3 readings per monitoring and automatically calculate the
average of the 3 readings (In CIMMYT these records are inventory_actions).
We are using a macro to capture each read
![image](/uploads/085f6502ef329bd272c906d1c756a0ed/image.png)
When you click save, it saves the readings as inventory_actions and later we copy and paste into the curator tool.
We take initial moisture and subsequently every month until we obtain moisture between 6 and 8%.
The tasks could be automatically scheduled from the initial date and notify me that N inventories need monthly monitoringJuan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/304GRIN-Global. Genesys wizard doesn't get access to Genesys.2023-10-11T17:03:05+02:00Juan Carlos Alarcon MaldonadoGRIN-Global. Genesys wizard doesn't get access to Genesys.The Genesys wizard was updated to support secure access but still, it can not access Genesys.
![image](/uploads/de99885fa008927c281cef39d7043344/image.png)
we are using this URL `https://api.genesys-pgr.org` for the connection.
/cc @...The Genesys wizard was updated to support secure access but still, it can not access Genesys.
![image](/uploads/de99885fa008927c281cef39d7043344/image.png)
we are using this URL `https://api.genesys-pgr.org` for the connection.
/cc @ariveraJuan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/302Migration of images from GG standard to GGCE2023-11-15T19:39:05+01:00Alejandro VelazquezMigration of images from GG standard to GGCEWe currently have images and PDF files loaded in our standard GG DBs,
We have migrated our DBs to GGCE for testing but our attachments are not showing.
How can we perform data migration from standard GG to GGCE?We currently have images and PDF files loaded in our standard GG DBs,
We have migrated our DBs to GGCE for testing but our attachments are not showing.
How can we perform data migration from standard GG to GGCE?Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/299Accession summary bug report2023-09-06T08:08:50+02:00Andrew ChanAccession summary bug reportSome of the tags of accession summary cannot be used.
They show 'NullPointerException' when clicked.
The tags show this error from 'Original source type' to 'Action Name'
![image](/uploads/d7afa7111791b080da45bff293d9abb2/image.png)Some of the tags of accession summary cannot be used.
They show 'NullPointerException' when clicked.
The tags show this error from 'Original source type' to 'Action Name'
![image](/uploads/d7afa7111791b080da45bff293d9abb2/image.png)Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/290quantity on hand - when is it updated?2023-06-16T09:21:29+02:00Lilibeth Sisonquantity on hand - when is it updated?@mobreza what triggers the updating of seed stocks?
is it after the orders were released?
please refer to this [vid](https://drive.google.com/file/d/1R8aqWyEEuZTFHjKK6CsnRQDOgDButX_R/view?usp=drive_link)@mobreza what triggers the updating of seed stocks?
is it after the orders were released?
please refer to this [vid](https://drive.google.com/file/d/1R8aqWyEEuZTFHjKK6CsnRQDOgDButX_R/view?usp=drive_link)Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/285Improve the loading time to acces data from apps2023-08-09T16:07:50+02:00Juan Carlos GuerreroImprove the loading time to acces data from appsSome screens require combining a significant amount of information, resulting in loading times of up to 8.4 seconds. To address this, a service is proposed to expose pre-existing database views, shifting the responsibility of data combin...Some screens require combining a significant amount of information, resulting in loading times of up to 8.4 seconds. To address this, a service is proposed to expose pre-existing database views, shifting the responsibility of data combination to the database and improving availability and response time. The proposed architecture would be as follows:
![MicrosoftTeams-image__65_](/uploads/7f4acc5eb73943ba2d663bd1375ff529/MicrosoftTeams-image__65_.png)
The Read View Mediator Service has the function of listing and exposing all the views of the database, as well as providing an access point to query those views. Additionally, it allows receiving filtering parameters that will be used as conditions in the query. An example of the request body would be as follows:
![image](/uploads/c699af0a9ed5274c605ae950a8238c44/image.png)
Where "view" would be the name of the view, unique in the database. The "params" would essentially be the conditions for the WHERE clause in SQL (one option to implement this logic would be JOOQ). It is worth noting that one of the important factors in this query is the absence of pagination and recycling of the body, which ensures optimal performance when querying the views.
The IT team at CIAT conducted a test with an order of 300 items, evaluating the loading times for the most complex view in the viability application. Here are the results obtained:
![image](/uploads/9b071f3851d2282372ed4c5102d613d4/image.png)Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/278Barcodes for storage address2023-10-05T20:09:59+02:00Matija ObrezaBarcodes for storage address
A request has been received to allow the scanning of barcodes for storage addresses in cold storage rooms where, once the user scans the label, the system will show the inventories storages in the location.
As you figured out, each ins...
A request has been received to allow the scanning of barcodes for storage addresses in cold storage rooms where, once the user scans the label, the system will show the inventories storages in the location.
As you figured out, each institution has its own storage address format, so, please, share your ideas to try to get a standard format for the storage address.
Any suggestion is welcome.
@lsison, @rsulabo, @achan, @arivera, @jguerrero, @phreyesJuan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/277Suggestions from Montevideo2023-07-17T22:29:25+02:00Matija ObrezaSuggestions from MontevideoThe following were suggested for GGCE at the workshop in Montevideo:
- [x] ~Copy summaries and KPI data to Excel/CSV~ Exists
- [x] ~Security. Enable the option to configure GGCE for Site.~ Managing groups and permissions is already avai...The following were suggested for GGCE at the workshop in Montevideo:
- [x] ~Copy summaries and KPI data to Excel/CSV~ Exists
- [x] ~Security. Enable the option to configure GGCE for Site.~ Managing groups and permissions is already available.
- [x] ~Assign the Viability rule to a set of inventories.~ Available in Seed Viability when creating the order.
- [x] grin-global/grin-global-server#399 Attach images to Viability test
- [x] Show pathogen status code in the inventory items requested in a order
- [x] Allow to use the camera to scan the barcode in the search filters
- [x] Verify if the Distribution type is mandatory field in Order request
- [x] grin-global/support#278 Allow to read the storage address barcodes and show the information
- [x] Once that a Genesys request is processed, the ID of the GGCE request must be a link to the Order Request
- [x] grin-global/support#279 Enable to upload images from GGCE to Genesys
- [x] Show a report of the data uploaded to Genesys
- [x] Select inventories requested to create another order
- [ ] Extend the KPIs for reporting and show metrics
- [ ] Store the search filters
- [x] grin-global/grin-global-ui!522 Extend the accession/inventory filtering for deep geography information
- [ ] Add the date when an inventory was placed in storage
- [ ] For upload Passport data to Genesys, add the option to select the columns to upload
- [x] Enable to get DOI in batch
- [ ] Enable Alerts in GGCE
- [x] Allow filters by crop trait
- [ ] Publish trait data from GGCE directly to Genesys
- [ ] Add the mean/average germination time to the result of the Viability test (Filippo will send an example)Juan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/254Save Filter Parameters in Inventory Filter2023-07-17T22:15:12+02:00Rizalina SulaboSave Filter Parameters in Inventory FilterIn Filtering Inventories for selecting planting materials or for other purpose, it will be helpful to have a function to save the filter parameters for future use and for other users transaction.
Thank YouIn Filtering Inventories for selecting planting materials or for other purpose, it will be helpful to have a function to save the filter parameters for future use and for other users transaction.
Thank YouJuan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonadohttps://gitlab.croptrust.org/grin-global/support/-/issues/216Traceability of activities using actions2022-08-09T10:56:53+02:00Alejandro VelazquezTraceability of activities using actionsIs it possible to do activities traceability using actions with inventories?
that is to say, to register actions by activity but that GG-CE doesn't allow me to register without first having registered a previous one.
Starting activities ...Is it possible to do activities traceability using actions with inventories?
that is to say, to register actions by activity but that GG-CE doesn't allow me to register without first having registered a previous one.
Starting activities from the regeneration process to inventory packaging
I do not know if I explain myself very wellhttps://gitlab.croptrust.org/grin-global/support/-/issues/215Close order request2023-07-17T22:10:18+02:00Alejandro VelazquezClose order request
In the curator tool we use the "Ship all remaining items" button to complete (close) an order.
How do we close an order in GG-CE?
We know that you have the "ACTIONS" tab to create them manually but it would be nice to have some button...
In the curator tool we use the "Ship all remaining items" button to complete (close) an order.
How do we close an order in GG-CE?
We know that you have the "ACTIONS" tab to create them manually but it would be nice to have some buttons to automatically create the actions.
![image](/uploads/42953996809c2b7e1ff6cd670de92076/image.png)
It is possible to add 2 buttons:?
1.- "Delivered to the distribution seed unit" (here the automatic discount is made and create action)
2.- "Delivered to the cooperator (here create action)
![image](/uploads/59b58df1871b0f21eae3604a4e55c0a6/image.png)Juan Carlos Alarcon MaldonadoJuan Carlos Alarcon Maldonado