GGCE Support issueshttps://gitlab.croptrust.org/grin-global/support/-/issues2022-05-18T15:15:30+02:00https://gitlab.croptrust.org/grin-global/support/-/issues/66Recording MLS status in GG-CE2022-05-18T15:15:30+02:00Matija ObrezaRecording MLS status in GG-CEGG-CE can be extended with a new field `mls_status` in the `accession` table, using the MLSSTATUS code value group to ensure a fixed set of allowed values. The field is not mandatory and is initially set to the undetermined (NULL) value....GG-CE can be extended with a new field `mls_status` in the `accession` table, using the MLSSTATUS code value group to ensure a fixed set of allowed values. The field is not mandatory and is initially set to the undetermined (NULL) value.
Available codes in this group are based on the relevant descriptor used by the GLIS DOI Registration Service:
| Code value | Title | GLIS Description | GLIS Code | Genesys |
|-------------|------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------|---------|
| N | Not in MLS | Not available under the MLS | 0 | 0 |
| Y | In MLS* | Available under the MLS | 1 | 1 |
| ANNEX1 | In MLS (Annex I) | The PGRFA belongs to a crop listed in Annex I and is under the management and control of a Contracting Party to the Treaty and declared to be in the public domain | 11 | 1 |
| ARTICLE15 | In MLS (Article 15) | The sample is in a collection subject to an agreement concluded under Article 15 of the Treaty | 12 | 1 |
| SMTA_SOURCE | In MLS (Received with SMTA) | The holder received the sample with SMTA | 13 | 1 |
| VOLUNTARY | In MLS (Voluntary inclusion) | The holder has voluntarily placed the PGRFA into the MLS | 14 | 1 |
| MLS_DEVELOP | In MLS (Under development) | The PGRFA is derived from, and distinct from, material previously received from the MLS, is still under development and not yet ready for commercialization, and may be made available at the discretion of the developer | 15 | 1 |
Genebanks are advised to avoid the use of the `Y` code and rather use one of the more specific options.
@1cgiar/all Your feedback is appreciated before we make changes.https://gitlab.croptrust.org/grin-global/support/-/issues/67barcodes on planted materials2021-05-05T05:10:20+02:00Lilibeth Sisonbarcodes on planted materials@mobreza , please update barcode in the inventory table for planted materials (inventory_maint_policy_id = 8) :
`update inventory
set barcode = concat('GRC-',inventory_number_part3,'-',inventory_number_part1,'-',convert(varchar,inventor...@mobreza , please update barcode in the inventory table for planted materials (inventory_maint_policy_id = 8) :
`update inventory
set barcode = concat('GRC-',inventory_number_part3,'-',inventory_number_part1,'-',convert(varchar,inventory_number_part2))
from inventory
where form_type_code <>'**'
and inventory_maint_policy_id =8
AND INVENTORY_number_part3 is not null `Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/68barcodes on received seeds and seed file records2021-04-30T23:55:17+02:00Lilibeth Sisonbarcodes on received seeds and seed file records@mobreza please update barcodes for incoming/ received seeds and seed file records (inventory_maint_policy_id IN (6,7))
`update inventory
set barcode =
left(inventory_number_part1,1)+RIGHT('0000' + CONVERT(VARCHAR,inventory_number_part2...@mobreza please update barcodes for incoming/ received seeds and seed file records (inventory_maint_policy_id IN (6,7))
`update inventory
set barcode =
left(inventory_number_part1,1)+RIGHT('0000' + CONVERT(VARCHAR,inventory_number_part2), 4)+'/'+SUBSTRING(inventory_number_part1,2,4)
from inventory
where form_type_code <>'**'
and inventory_maint_policy_id IN (6,7)`Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/69Leuven GG-CE instance. Deploy2021-05-11T07:47:20+02:00Ghost UserLeuven GG-CE instance. DeployPlease, **deploy** the Leuven GG-CE instance.
The GG backup of Leuven is available in google drive (`2021CGIAR - ITC` folder)
For the moment, the DB only has accessions with basic information (1.5K accessions).
@ekempenaersPlease, **deploy** the Leuven GG-CE instance.
The GG backup of Leuven is available in google drive (`2021CGIAR - ITC` folder)
For the moment, the DB only has accessions with basic information (1.5K accessions).
@ekempenaersMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/70GG-CE 2021.5 update2021-05-14T09:20:50+02:00Matija ObrezaGG-CE 2021.5 updateI’m happy to announce the availability of the **v2021.5** release of GG-CE.
This release has a number of improvements to GG-CE functionality and several bug fixes. This release includes browsing aggregated inventory amounts (by accessio...I’m happy to announce the availability of the **v2021.5** release of GG-CE.
This release has a number of improvements to GG-CE functionality and several bug fixes. This release includes browsing aggregated inventory amounts (by accession), FAO WIEWS code can be assigned to Cooperators. A new section of GG-CE Web for **in vitro** collections is added. The data model is (again) synchronized with the USDA version.
Please check the complete list of changes at:
* Announcement https://gitlab.croptrust.org/grin-global/support/-/issues/70
* Web https://gitlab.croptrust.org/grin-global/grin-global-ui/-/releases/v2021.5
* API https://gitlab.croptrust.org/grin-global/grin-global-server/-/releases/v2021.5
New features:
* Added a separate section for in vitro tools
* Browse aggregated inventories in storage
* Users can set their passwords and admins can manage user passwords.
* Admins receive important system notifications when accessing /admin page
* Cooperator form and filters updated with `faoInstituteNumber`
Improvements and bug fixes:
* Fixed issue with filtering by auditing fields (e.g. `createdDate`)
* Data model synchronized with USDA version (see f1098d59)
* Barcode scanner only uses inventory barcodes, not inventory `id`
* Accession details page: Backup sites are now displayed
## Admin alerts
Administrators receive notifications of any critical issues encountered by the server:
![image](https://gitlab.croptrust.org/grin-global/grin-global-ui/uploads/8d9aa9b4752b06dc208cdb939999c64b/image.png)
## In vitro: Discarding material
A new section of GG-CE Web for **in vitro** collections is added. The first tool for technicians is for discarding infected or dead tissue culture material by scanning the barcodes on tubes:
![image](https://gitlab.croptrust.org/grin-global/grin-global-ui/uploads/c5716f380828e7e69f0a6f060e5a938d/image.png)
## Aggregated inventory data
Since inventories of any accession are stored in different locations, follow different maintenance policies, it's useful to have access to aggregated quantity on hand (by accession). Apply filters for location to get the summary report:
![image](https://gitlab.croptrust.org/grin-global/grin-global-ui/uploads/94eeeb76123979e220858f11c379767b/image.png)
## Changing your password
Users are (finally) able to change their GG-CE password in the web interface:
![image](https://gitlab.croptrust.org/grin-global/grin-global-ui/uploads/5db2c425f9923f4c46fe83bbac0148de/image.png)
/cc @1cgiar/allMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/71Doesn't show all inventory maintenance policy2021-05-05T05:37:06+02:00James AriasDoesn't show all inventory maintenance policyGood morning/Afternoon @mobreza
When I want to filter the inventories by the `inventory maintenance policy`, it is not showing me all the inventory maintenance policies that are registered in the `database`.
**Do you know why this is?...Good morning/Afternoon @mobreza
When I want to filter the inventories by the `inventory maintenance policy`, it is not showing me all the inventory maintenance policies that are registered in the `database`.
**Do you know why this is?**
- The first image corresponds to the `inventory maintenance policy` that appears in the inventories.
- The second image corresponds to the `inventory maintenance policy` registered in the DB
![ErrorMaintPolicy_Inventory_2](/uploads/aff9cfe869b2d8a11cc5b3d242378d26/ErrorMaintPolicy_Inventory_2.png)
![image](/uploads/8de685dacd3a2e1199f228dd1c5e306c/image.png)
Thank youMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/72Notify sys_user by Email?2022-05-18T06:30:23+02:00James AriasNotify sys_user by Email?Good morning/Afternoon @mobreza
Suddenly are you thinking of creating an email notification to the `sys_user` created, and that it will send you as a link to change the password or confirm the registration?
Thank youGood morning/Afternoon @mobreza
Suddenly are you thinking of creating an email notification to the `sys_user` created, and that it will send you as a link to change the password or confirm the registration?
Thank youMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/73How to use wildcards?2021-05-05T10:01:35+02:00James AriasHow to use wildcards?Good morning/Afternoon @mobreza
How to filter some fields like inventory Prefix, inventory Suffix ..., with wildcards like%?
If you suddenly have this answer in other issues, please attach.
Thank youGood morning/Afternoon @mobreza
How to filter some fields like inventory Prefix, inventory Suffix ..., with wildcards like%?
If you suddenly have this answer in other issues, please attach.
Thank youMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/74Invitro: Discard2022-05-18T15:15:58+02:00Matija ObrezaInvitro: Discard@1cgiar/ibadan Please have a look at the new "In vitro" section accessible at:
![image](/uploads/cabb94792696273e8419649ebd03954f/image.png)
Please explore the form for Discarding material https://ibadan.ggce.genebanks.org/invitro/disc...@1cgiar/ibadan Please have a look at the new "In vitro" section accessible at:
![image](/uploads/cabb94792696273e8419649ebd03954f/image.png)
Please explore the form for Discarding material https://ibadan.ggce.genebanks.org/invitro/discard:
![image](/uploads/782de4c640ce1c966da755bd4607a4bf/image.png)
- Barcode must be invitro inventory
- Must have quantity > 0Marimagne TchambaMarimagne Tchambahttps://gitlab.croptrust.org/grin-global/support/-/issues/75Taxonomy in GG-CE2021-05-19T09:52:34+02:00Matija ObrezaTaxonomy in GG-CELegacy GG requires that accessions link directly to one of GRIN Taxonomy records in `TaxonomySpecies`. This list is curated by experts by USDA (for USDA) and kindly made available for wider use.
Since many @1cgiar/all collections (e.g. ...Legacy GG requires that accessions link directly to one of GRIN Taxonomy records in `TaxonomySpecies`. This list is curated by experts by USDA (for USDA) and kindly made available for wider use.
Since many @1cgiar/all collections (e.g. @1cgiar/nairobi, @1cgiar/addis and others) use taxon names that are not yet in GRIN Taxonomy, I suggest that we introduce a new approach in **GG-CE** that allows you to specify the taxon as you have it in your database today and link it to GRIN Taxonomy when/if it is available.
## Proposal: Genebank taxonomy
A new table `taxonomy_genebank` is added to GG-CE where you register the taxonomic names you already have in your databases. You manage these records separately from GRIN Taxonomy. The table generally follows MCPD descriptors.
This allows you to limit the list only to the species of interest to your collection.
All `Accession` records link to the **genebank taxonomy** not to the GRIN Taxonomy directly. You are able to add `Accession`s with your own taxonomic data.
But, you are still able to spell-check names against GRIN and link your taxonomy record to the matching record in GRIN `TaxonomySpecies`, if available.
## Extras: Hybrids
Many of you also maintain hybrids and those taxonomies are currently difficult to capture in `TaxonomySpecies`.
The genebank taxonomy table would allow for registering names of unnamed hybrids (*M.* *a* x *b*) and applying them to your accessions.
## Bonus: Simple updating of USDA Taxonomy
Since you are not adding records to `TaxonomySpecies`, updating the GRIN Taxonomy from USDA assures you have a valid recent copy from NPGS.Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/76MCPD view/report2022-05-18T15:16:06+02:00Ghost UserMCPD view/reportPassport data (MCPD) is the common information that the users want to see. Although most of those data are in the accession detail section, a view/report would be useful for one or a group of accessions.
![image](/uploads/089d6e569fa3c3...Passport data (MCPD) is the common information that the users want to see. Although most of those data are in the accession detail section, a view/report would be useful for one or a group of accessions.
![image](/uploads/089d6e569fa3c3622c70b3e4d7be3edc/image.png)
Here the "mapping" between **MCPD** and **GRIN-Global**.
The rows highlighted in color `grey` are not considered in GRIN-Global mapping.
| Ref | Acronym (MCPD) | Description (MCPD) | GG-table | GG-field | Comments |
|-------|-------------------|-----------------------------------------------------------------|-----------------------------------------|------------------------------------------------------------------------|-----------------------------------------------------------------------|
| `0` | `PUID` | `Persistent unique identifier` | | | |
| 1 | INSTCODE | Institute code | Site | fao_institute_number | |
| 2 | ACCENUMB | Accession number | Accession | Accession_number_part1, Accession_number_part2 ,Accession_number_part3 | |
| 3 | COLLNUMB | Collecting number | Accession_Inv_Name | Plant_name | Add category_code COLLNUMB |
| | | | | | |
| 4 | COLLCODE | Collecting institute code | Accession_source / Accession_source_map | Accession_source_type / cooperator_id | Add code value "COLLCODE" to ACCESSION_SOURCE_TYPE code group |
| | | | | | |
| 4.1 | COLLNAME | Collecting institute name | Cooperator | All fields | |
| 4.1.1 | COLLINSTADDRDRESS | Collecting institute address | Cooperator | | |
| `4.2` | `COLLMISSID` | `Collecting mission identifier` | | | |
| 5 | GENUS | Genus | taxonomy_genus | genus_name | |
| 6 | SPECIES | Species | taxonomy_species | species_name | |
| 7 | SPAUTHOR | Species authority | taxonomy_species | species_authority | |
| 8 | SUBTAXA | Subtaxon | taxonomy_species | subspecies_name | |
| 9 | SUBTAUTHOR | Subtaxon authority | taxonomy_species | subspecies_authority | |
| 10 | CROPNAME | Common crop name | Crop | name | |
| 11 | ACCENAME | Accession name | Accession_Inv_Name | Plant_name | The name with the lowest number in plant_name_rank / collection name? |
| | | | | | |
| 12 | ACQDATE | Acquisition date(YYYYMMDD) | Accession | initial_received_date | |
| 13 | ORIGCTY | Country of origin | Accession_source | geography_id | |
| 14 | COLLSITE | Location of collecting site | Accession_source | collector_verbatim_locality | |
| 15.1 | DECLATITUDE | Latitude of collecting site(Decimal format) | Accession_source | latitude | |
| 15.2 | `LATITUDE` | `Latitude of collecting site(Degrees, Minutes, Second format)` | | | |
| 15.3 | DECLONGITUDE | Longitude of collecting site (Decimal degrees format) | Accession_source | longitude | |
| 15.4 | `LONGITUDE` | `Longitude of collecting site (Degrees, Minutes, Seconds format)` | | | |
| 15.5 | COORDUNCERT | Coordinate uncertainty [m] | Accession_source | uncertainty | |
| 15.6 | COORDDATUM | Coordinate datum | Accession_source | georeference_datum | |
| 15.7 | GEOREFMETH | Georeferencing method | Accession_source | georeference_protocol_code | |
| 16 | ELEVATION | Elevation of collecting site [masl] | Accession_source | elevation_meters | |
| 17 | COLLDATE | Collecting date of sample [YYYYMMDD] | Accession_source | Source_date | |
| 18 | BREDCODE | Breeding institute code | Accession_source / Accession_source_map | Accession_source_type / cooperator_id | Add code value "BREDCODE" to ACCESSION_SOURCE_TYPE code group |
| 18.1 | BREDNAME | Breeding institute name | Cooperator | All fields | |
| 19 | SAMPSTAT | Biological status of accession | Accession | improvement_status_code | Add code values to IMPROVEMENT_LEVEL code group |
| 20 | ANCEST | Ancestral data | Accession_pedigree | description | |
| 21 | COLLSRC | Collecting/acquisition source | Accession_source | acquisition_source_code | Add code values to ACCESSION_SOURCE_HABITAT_TYPE code group |
| 22 | DONORCODE | Donor institute code | Accession_source / Accession_source_map | Accession_source_type / cooperator_id | Add code value "DONORCODE" to ACCESSION_SOURCE_TYPE code group |
| 22.1 | DONORNAME | Donor institute name | Cooperator | All fields | |
| 23 | DONORNUMB | Donor accession number | Accession_Inv_Name | Plant_name | Add category_code DONORNUMB |
| 24 | OTHERNUMB | Other identifiers associated with the accession | Accession_Inv_Name | Plant_name | Add category_code OTHERNUMB |
| 25 | DUPLSITE | Location of safety duplicates | Accession | Backup_location1_site & Backup_location2_site | |
| 25.1 | DUPLINSTNAME | Institute maintaining safety duplicates | Site | fao_institute_number | |
| 26 | STORAGE | Type of germplasm storage | Inventory | preservation_method_id (--> Method's table) ? | |
| 27 | MLSSTAT | MLS status of the accession | Accession_ipr | type_code | |
| 28 | REMARKS | Remarks | Accession | Note | |
| | URL | | | | added in app_setting table(optional) |
| | DOI | DOI | Accession | DOI | |
_Note._
You can find more information on GRIN-Global-Genesys wizard [here](https://gitlab.com/GRIN-Global/Wizards/GRIN-Global-Genesys) including the get_passport_data dataview.
@1cgiarhttps://gitlab.croptrust.org/grin-global/support/-/issues/77GG-CE in your language2022-05-18T15:17:40+02:00Matija ObrezaGG-CE in your languageEvery @1cgiar/all **GG-CE** can be used in one of supported languages:
- **`/es/`** for Spanish: https://texcoco-m.ggce.genebanks.org/es/
- **`/fr/`** for French: https://leuven.ggce.genebanks.org/fr/
- `/xx/` for another language
Some...Every @1cgiar/all **GG-CE** can be used in one of supported languages:
- **`/es/`** for Spanish: https://texcoco-m.ggce.genebanks.org/es/
- **`/fr/`** for French: https://leuven.ggce.genebanks.org/fr/
- `/xx/` for another language
Some translations for ES and FR are already in place, many need more work! We are looking for coordinators of translation teams and people who wish to contribute to GG-CE by translating from English to your language.
Help make GG-CE better by contributing translations at https://www.transifex.com/crop-trust/gg-ce-web/ !
Please let me know if you'd like to see GG-CE in another language or if you'd like to contribute!Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/78Wizards available with links till 20202021-09-07T19:46:15+02:00Edwin RojasWizards available with links till 2020Wizards available with links: source code, installers and videos till 2020.Wizards available with links: source code, installers and videos till 2020.https://gitlab.croptrust.org/grin-global/support/-/issues/79Inventory update error2021-05-11T06:55:46+02:00James AriasInventory update error**Good Morning/Afternoon** @mobreza
I am trying to update an `inventory`, but I am getting an error when I set a `parentInventory`.
I attach the forms of how I am sending the `JSON`
**Way 1**
```
{
"id":283639,
"availabilityStatusCod...**Good Morning/Afternoon** @mobreza
I am trying to update an `inventory`, but I am getting an error when I set a `parentInventory`.
I attach the forms of how I am sending the `JSON`
**Way 1**
```
{
"id":283639,
"availabilityStatusCode":"ACTIVE",
"inventoryNumberPart1":"COL003GRP1IMB19981125",
"formTypeCode":"SD",
"accession":{"id":67053},
"inventoryMaintenancePolicy":{"id":6},
"site":{"id":2},
"parentInventory":623338
}
```
![image](/uploads/af21772c58d68f8081f64086816bc81e/image.png)
**Way 2**
```
{
"id":283639,
"availabilityStatusCode":"ACTIVE",
"inventoryNumberPart1":"COL003GRP1IMB19981125",
"formTypeCode":"SD",
"accession":{"id":67053},
"inventoryMaintenancePolicy":{"id":6},
"site":{"id":2},
"parentInventory":{623338}
}
```
![image](/uploads/284a01ae3a1e4a118eac67091211bbfd/image.png)
- I don't know, if the cause is because the field is not in the `serialization`. as the following picture shows.
![image](/uploads/1d81299b49d34bedfb2ba1288dd1cdfd/image.png)
- If the way I am sending it in the `JSON` is not correct, please tell me which one it would be?
**Post Data:** If I don't send the `parentInventory`, the `inventory` updated successfully.
**Thank you, Regards**Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/80Features/requirements evaluated or requested for the GG-CE Web2021-09-10T08:51:54+02:00Matija ObrezaFeatures/requirements evaluated or requested for the GG-CE WebFeedback from ~Lima on GG-CE Web version **2021.?** collated by @erojas 11 May 2021.
[Report_GGCE_Improvements_20210511.xlsx](/uploads/b21747c82469a8a2f248f21f94d11998/Report_GGCE_Improvements_20210511.xlsx)
# Security
| Feature ...Feedback from ~Lima on GG-CE Web version **2021.?** collated by @erojas 11 May 2021.
[Report_GGCE_Improvements_20210511.xlsx](/uploads/b21747c82469a8a2f248f21f94d11998/Report_GGCE_Improvements_20210511.xlsx)
# Security
| Feature | Supported |
|--------------------------------|-----------|
| Reuse user and password of LAN | No |
| Define user groups by crop format/biologicla status/process/owner to restrict edition or read-only | No |
User accounts should use LDAP authentication of CGIAR. User groups:
1. In Vitro potato (6 staff)
2. In Vitro sweetpotato (4 staff)
3. In Vitro ARTC (2 staff)
4. Post quarantine in Vitro (2 staff)
5. Seed wild potato (5 staff)
6. seed cultivated potato (2 staff)
7. Seed sweetpotato (5 staff)
8. Seed ARTC (3 staff)
9. Herbarium (2 staff)
10. Cryo potato (10 staff)
11. Cryo sweetpotato (10 staff)
12. Safety backup (2 staff)
# Ease of Use
| Feature | Supported |
|-----------------------------------------------------------------------------------|-----------|
| Drag-N-Drop Content | Yes |
| Mass Upload of data or files for accessions | No |
| Mass Upload of data or files for inventories | No |
| Friendly URLs after searching like Genesys-PGR | No |
| Multi language | Yes |
| Performance | Good |
| Export to Excel | No |
| Update inventories when internet is not available (offline mode) | No |
| Integrate camera of Android device with attach option | No |
| Manage inventories by list when searching, updating, printing, scanning | No |
| Add the functionality to search by list when pasting a list from Excel and search | No |
# Other modules
| Feature | Supported |
|-------------------------------------------|-----------|
| Module of reports with filters | No |
| Module of notifications defined by users | No |
| Print barcode labels with Bluetooth or IP | No |
| Process support | No |
| Module of seed viability registration | No |
| Add the functionality to see morphological data, evaluation data and datasets/subsets | No |
| Add advanced search options with more filters and customize the output result: Needed in the daily work for curators and technicians, similar to Search Wizard | No |
| Add advanced search options with more filters to cross filters of passport, evaluation and morphological data, as well as inventories in the different conservation methods | No |
| The titles used to show passport data in columns or boxes in the GG-CE to use the MCPD standard titles | Not support MCPD |
**Process support**: For each inventory to facilitate tracking enable two boxes for process and sub-process (current stage). This tool should allow to edit and add process and sub-process as needed. And to enable to track inventories location and number of vessels in stock per each process and/or subprocess. This will facilitate the workflow system around the inventories. A first approach.
1. Post-quarantine
1. sub-process 1
1. sub-process 2
1. sub-process 3
2. introduction
1. sub-process 1
1. sub-process 2
3. Conservation
1. sub-process 1
1. sub-process 2
4. Phitosanitary
1. sub-process 1
2. sub-process 2
3. sub-process 3Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/81ISO. Service monitoring.2021-09-07T19:48:13+02:00Ghost UserISO. Service monitoring.Analysis of the service provided by the Distribution process.
**Seed request (Distribution)**
- Percentage of successful Seed requests processed by year. (indicator)
- Detail of successful Seed requests processed.
- Percentage of Seed ...Analysis of the service provided by the Distribution process.
**Seed request (Distribution)**
- Percentage of successful Seed requests processed by year. (indicator)
- Detail of successful Seed requests processed.
- Percentage of Seed requests processed successfully in 4 or fewer weeks. (indicator)
- Detail of Seed requests processed successfully in 4 or fewer weeks.
- Percentage of not processed Seed requests. (indicator)
- Detail of not processed Seed requests.https://gitlab.croptrust.org/grin-global/support/-/issues/82GG-CE 2021.6 update2021-05-31T12:04:52+02:00Matija ObrezaGG-CE 2021.6 updateI’m happy to announce the availability of the **v2021.6** release of GG-CE.
`v2021.6` adds passport data **mapping to Multi-crop Passport Descriptors**, paving the way for automated publishing of passport data from **GG-CE to Genesys** ...I’m happy to announce the availability of the **v2021.6** release of GG-CE.
`v2021.6` adds passport data **mapping to Multi-crop Passport Descriptors**, paving the way for automated publishing of passport data from **GG-CE to Genesys** and other sytems. Work started on improved support for **Viability testing** with a new section of GG-CE Web.
Please check the complete list of changes at:
* Announcement https://gitlab.croptrust.org/grin-global/support/-/issues/82
* Web https://gitlab.croptrust.org/grin-global/grin-global-ui/-/releases/v2021.6
* API https://gitlab.croptrust.org/grin-global/grin-global-server/-/releases/v2021.6
New features:
* Added language selection to the entry page
* Added a separate section for viability testing
* Browse passport data in MCPD format
* Added API endpoints for viability testing actions
* Added API for managing attachment metadata
* Added mapping of passport data to MCPD
Improvements and bug fixes:
* Fixed autocompleter for selecting inventory maintenance policy
* Added basic overview of inventories to the In vitro section
* Added support for managing details of `AccessionInvAttach` records
* Users can schedule actions for multiple selected inventories
Database model:
* There are no changes to the database model between `v2021.5` and `v2021.6` release
## Language selection
**GG-CE** can be used in any of the supported languages. Some translations for Spanish and French language are already in place, but many need more work! We are looking for coordinators of translation teams and people who wish to contribute to GG-CE by translating from English to your language.
Help make GG-CE better by contributing translations at https://www.transifex.com/crop-trust/gg-ce-web/ !
## Viability testing
A new section of GG-CE Web at */viability* focuses on processes around viability testing. The first version allows users to browse and search the existing viability data.
![image](https://gitlab.croptrust.org/grin-global/grin-global-ui/uploads/035bce4a470dca238fd339fc9b8384cd/image.png)
Look for the "Inventory viability" **card** on the entry page!
*Coming soon:* Reviewing inventories in need of testing, making a seed request, labeling and recording observations during germination tests (including tetrazolium tests) and calculation of the final test results.
## Mapping to MCPD
The data model for accession documentation in GG-CE is very rich and goes well beyond what MCPD has to offer. [GG-CE to MCPD mapping](https://gitlab.croptrust.org/grin-global/support/-/issues/76) documents the current approach.
We still need to resolve the following MCPD fields:
* `STORAGE`: Type of germplasm storage
* `MLSSTATUS`: MLS status of the accession (see [MLS status in GG-CE](https://gitlab.croptrust.org/grin-global/support/-/issues/66))
* `CROPNAME`: Common crop name (?!)
![image](https://gitlab.croptrust.org/grin-global/grin-global-ui/uploads/eec1b356a05b5fafa2a5f58d2bb3c8f2/image.png)
Look for the "Passport data in MCPD" **card** on the entry page!
/cc @1cgiar/allMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/83Feedback from M'be2021-09-07T19:47:04+02:00Matija ObrezaFeedback from M'be@rtohoun provides the results of the demo session of GG-CE for @1cgiar/mbe:
- All the participants were very happy with the GG-CE especially for its speed, its ease and also for the fact that we scan directly the accessions.
- They all...@rtohoun provides the results of the demo session of GG-CE for @1cgiar/mbe:
- All the participants were very happy with the GG-CE especially for its speed, its ease and also for the fact that we scan directly the accessions.
- They all preferred to use WEB GG-CE unlike the API which is very slow because of the connection speed we have here.
## Requests
1. If It's possible to export all row of filter result to excel that will be good
1. It's possible on GG-CE you can have the field for the references of attachments files
1. Obtain only the table on viability inventory
1. It's possible to developpe interface for viability test result entry? Using API to entry the data is very low because the performance of internet
1. In the field of request of acessions it is difficult to choose accessions by accession. If we can review so that we can make drag and drop
1. It's possible to obtain in the Web GG-CE the wizard option that will be very goodMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/84On viability testing2021-09-01T08:48:07+02:00Matija ObrezaOn viability testingThe common procedure for **Viability testing** in GG-CE is as follows:
1. Someone (or something) flags the inventories that need to be tested for viability and adds them to the *Pending viability test list*
1. Someone decides which of t...The common procedure for **Viability testing** in GG-CE is as follows:
1. Someone (or something) flags the inventories that need to be tested for viability and adds them to the *Pending viability test list*
1. Someone decides which of the inventories on the *Pending list* will go into testing now and requests retrieval of seeds.
1. Retrieved seeds are packed and appropriately labeled.
1. The viability team receives the seeds and executes the testing protocol, eventually producing the latest viability results for the tested inventories.
This text describes the tools in GG-CE in support of the procedure.
## Flagging inventories for viability testing
When the user has decided that an inventory should be tested for viability (in the near future) they schedule an inventory action `Viability test` for the inventory. A *scheduled inventory action* is one that is in the database, but does not yet have a `startDate`.
One can schedule inventory actions from the Inventory list page by first selecting the inventories, then clicking the **Schedule inventory action** button:
![image](/uploads/5f35377a792396712e3ef4cdf635bbde/image.png)
In the dialog you select *Viability test* for action type and confirm. If you now check the *Pending inventory actions* list, you'll notice the freshly added records:
![image](/uploads/ce62f4997508642279f2a8ffb00f9d18/image.png)
Until this inventory action is **started** and becomes **in progress** (because it has a `startedDate`), GG-CE considers the inventory is *Scheduled for viability testing*.
## Deciding what to test (this month)
The *Pending viability test list* will grow way beyond what can be tested in a month or two. It may have thousands of inventories waiting for viability testing.
In the *Viability* section you will find the **Prepare order** function. It lists inventories with pending viability tests:
![image](/uploads/858588a6b5d85f77bf0f16320e5c79dc/image.png)
Select the ones that should go for testing (now) and click "Prepare order":
![image](/uploads/9299c5aea0907e1cab0e6e41b5154d6f/image.png)
In the dialog, select the `InventoryViabilityRule`, `Site` and `Cooperator` that will receive the seeds for testing:
![image](/uploads/acc08132ac13029abef305dc54427fc1/image.png)
After hitting "Create Order", the system will:
1. Create the `OrderRequest` for selected inventories with the quantities defined in the `InventoryViabilityRule` (e.g. 2 x 40 seed = 80 SD)
1. Create `InventoryViabilty` records with `null` value for end viability result
1. Mark the *pending* inventory action `Viability test` as started, removing these inventories from the list *Pending viability test*
## Seed retrieval / Order processing
The seed retrieval follows its own process and eventually the seed packets are delivered to the Viability team to do the testing.
## Begin testing
Viability team receives the seed packets. They scan the inventory barcode which will immediately display the `InventoryViability` record prepared earlier.
![image](/uploads/60474163e9eb0da16a53cb7c791fff65/image.png)
The *Print labels* button prints labels for each replicate.
The replicates are prepared for testing based on `InventoryViabilityRule` information.
grin-global/grin-global-ui#256 has details.
## Make observations
The viability test labels printed for each replicate are unique to the replicate. By scanning the barcode, the previous observations are loaded and can be edited. A new observation can be registered.
A button to *Finish testing* is available.
The details are in grin-global/grin-global-ui#257
## Finish viability testing
This function follows @gcapilit's [description](https://gitlab.croptrust.org/grin-global/grin-global-server/-/issues/78#note_54570) and summarizes the test results across replicates.
![image](/uploads/a267c05a37856413b75f61b62a8d0b5b/image.png)
The results may require **Retesting** and since this is more of an exception than a rule, we will discuss that separately.
/cc @1cgiar/allMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/85CT and Admin Tool errors @ manila.api.genebanks.org2021-05-28T11:42:31+02:00Lilibeth SisonCT and Admin Tool errors @ manila.api.genebanks.org@jalarcon I am testing Genesys Wizard on CT (version 1.21.3.29) using the gg-ce database. Below is the error
![image](/uploads/96a48f1cccc1cad0de08c644a368c7a3/image.png)
@mobreza I went to GG Admin Tool to check on get_passport_data...@jalarcon I am testing Genesys Wizard on CT (version 1.21.3.29) using the gg-ce database. Below is the error
![image](/uploads/96a48f1cccc1cad0de08c644a368c7a3/image.png)
@mobreza I went to GG Admin Tool to check on get_passport_data dataview (related to the error above), but I am unable to login
to manila.api.genebanks.org
![image](/uploads/908f449e3425ea102fbed3bf80ff2273/image.png)