GGCE 2024.3 update

We are happy to announce the 2024.3.0 release of GGCE.

Please check the complete list of changes at:

Release 2024.3.0 introduces new tools! Now, you can browse and search trait data in wide format, with traits organized into columns. Additionally, Email notifications are now available for actions related to Accession, Inventory, and Order Requests, as well as for the latest KPI results. These actions can be assigned to individual users or groups of users.

With this release, GGCE can generate the SMTA document for requests using the SMTA material transfer agreement. Other additions include the ability to cancel a Viability Test and new date formatting options for labels.

For the API, 2024.3 introduces customizable scheduling for when notifications are generated and sent to subscribers. Moreover, actions can now be assigned to individual users or groups of users.

New features:

Browsing trait data
Email notifications and their scheduling
Assigning actions
Generating SMTA for distribution
Canceling viability tests
Formatting dates on labels

API changes:

Added CANCELED state for InventoryViability
Inventory, Accession and OrderRequest filters include action filters
Added endpoint to generate SMTA PDF
Added endpoint to access trait data in wide format

Database changes:

Added tables notification_schedule and notification_schedule_subscriber
Added column assignee (FK to acl_sid) to *_action tables

Browsing trait data

Most commonly you will find trait observations displayed in GGCE in long format with each observation taking one row in the grid. This display provides a lot of detail about each individual observation, but it is not very useful when inspecting data of many inventories and accessions.

Since 2024.3 you can browse and search trait data in wide format with traits organized into columns:

Clicking on a trait column opens a dialog where you can specify your search criteria. After applying the filter the column that uses filtering is highlighted.

Methods also include the wide display of trait data:

Email notifications

2024.3 includes the following email notifications about actions:

Accession schedule: provides the summary of accession actions scheduled this week or this month.
Inventory schedule: summary of inventory actions scheduled this week or this month.
OrderRequest schedule: for order request actions.

It also sends emails with the latest KPI results.

Scheduling email notifications

Scheduler menu in Admin tools allows Administrators to define when notifications are generated and the subscribers that will receive the notification emails.

Scheduling intervals are defined using cron expressions. GGCE displays the next ten times the scheduler will execute when you provide a cron expression. This allows you to check if the schedule fits your needs.

The timezone must also be specified as it ensures that emails will be sent in your local time.

Managing subscribers

Each schedule has a separate list of subscribers. User groups or individual GGCE users can be subscribed.

Note: Emails are only sent to active user accounts. Emails are sent to the email address of each user's Cooperator record.

Assigning actions

Actions can be assigned to individual users or to groups of users. The assignee column is included in all action grids and the action filters allow for narrowing the results to specific users or groups.

Generating SMTA document

GGCE can generate the SMTA document for requests that use SMTA material transfer agreement. Please note that the resulting document is not automatically attached and stored with the request. You must upload the document manually if you wish to store it in GGCE.

IMPORTANT: GGCE uses a service provided by ITPGRFA's Easy-SMTA. Request information is transmitted from GGCE to Easy-SMTA, which responds with the PDF document. ITPGRFA Secretariat assures us that data is not stored or processed in any other way except to generate the PDF file.

Canceling viability tests

A viability test that is not yet completed is in pending state and does not have a value in percentViable. Once the test is completed, the test results go to Percent viable and the test state can be set to either conclusive (default) or inconclusive. These two both indicate that the test was done.

The new canceled state makes it possible to flag viability tests that were not performed. Such records have no value in Percent viable.

GGCE ensures that data consistently follows these rules, including when updating data with Curator Tool.

Formatting dates on labels

Dates in ZPL label templates can be formatted with {{#formatDate}}...{{/formatDate}} tag. The following are a few examples you can choose from:

Format	Syntax	Result
Year only	`{{#year}}{{{inventory.propagationDate}}}{{/year}}`	2024
Year only	`{{#formatDate}}yyyy {{{inventory.propagationDate}}}{{/formatDate}}`	2024
Year and month	`{{#formatDate}}yyyy-M {{{inventory.propagationDate}}}{{/formatDate}}`	2024-5
Year and two digit month	`{{#formatDate}}yyyy-MM {{{inventory.propagationDate}}}{{/formatDate}}`	2024-05
Date/month/year	`{{#formatDate}}d/M/yyyy {{{inventory.propagationDate}}}{{/formatDate}}`	1/5/2024
Date/month/year	`{{#formatDate}}dd/MM/yyyy {{{inventory.propagationDate}}}{{/formatDate}}`	01/05/2024
Short month	`{{#formatDate}}d MMM yyyy {{{inventory.propagationDate}}}{{/formatDate}}`	1 AUG 2024
Long month	`{{#formatDate}}d MMM yyyy {{{inventory.propagationDate}}}{{/formatDate}}`	1 August 2024

Example: Year only {{#year}}{{{inventory.propagationDate}}}{{/year}}

Edited May 30, 2024 by Juan Carlos Alarcon Maldonado

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information