GGCE Support issueshttps://gitlab.croptrust.org/grin-global/support/-/issues2021-09-07T19:47:04+02:00https://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/62Mbe: Restore recent backup2021-04-30T11:26:05+02:00Matija ObrezaMbe: Restore recent backup@rtohoun asked for a restore of a recent GG backup to GG-CE.
## Missing tables
The `taxonomy_cwr` table is missing from your schema. Please add it to your copy of the database:
```sql
CREATE TABLE [dbo].[taxonomy_cwr](
[taxonomy_cwr_...@rtohoun asked for a restore of a recent GG backup to GG-CE.
## Missing tables
The `taxonomy_cwr` table is missing from your schema. Please add it to your copy of the database:
```sql
CREATE TABLE [dbo].[taxonomy_cwr](
[taxonomy_cwr_id] [int] IDENTITY(1,1) NOT NULL,
[taxonomy_species_id] [int] NOT NULL,
[crop_name] [nvarchar](100) NOT NULL,
[display_name] [nvarchar](100) NULL,
[crop_common_name] [nvarchar](100) NULL,
[is_crop] [nvarchar](1) NOT NULL,
[genepool_code] [nvarchar](20) NULL,
[is_graftstock_genepool] [nvarchar](1) NOT NULL,
[trait_class_code] [nvarchar](20) NULL,
[is_potential] [nvarchar](1) NOT NULL,
[breeding_type_code] [nvarchar](20) NULL,
[breeding_usage] [nvarchar](100) NULL,
[ontology_trait_identifier] [nvarchar](20) NULL,
[citation_id] [int] NULL,
[note] [nvarchar](max) NULL,
[created_date] [datetime2](7) NOT NULL,
[created_by] [int] NOT NULL,
[modified_date] [datetime2](7) NULL,
[modified_by] [int] NULL,
[owned_date] [datetime2](7) NOT NULL,
[owned_by] [int] NOT NULL,
CONSTRAINT [PK_taxonomy_cwr] PRIMARY KEY CLUSTERED
(
[taxonomy_cwr_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[taxonomy_cwr] ADD DEFAULT ('N') FOR [is_graftstock_genepool]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_cit] FOREIGN KEY([citation_id])
REFERENCES [dbo].[citation] ([citation_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_cit]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_created] FOREIGN KEY([created_by])
REFERENCES [dbo].[cooperator] ([cooperator_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_created]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_modified] FOREIGN KEY([modified_by])
REFERENCES [dbo].[cooperator] ([cooperator_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_modified]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_owned] FOREIGN KEY([owned_by])
REFERENCES [dbo].[cooperator] ([cooperator_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_owned]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_ts] FOREIGN KEY([taxonomy_species_id])
REFERENCES [dbo].[taxonomy_species] ([taxonomy_species_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_ts]
GO
```Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/11Mbe access levels2021-05-04T13:53:29+02:00Matija ObrezaMbe access levelsThe different levels of permissions:
| Groups | Users: Creation | Users: Update | Users: View | Passport: Creation | Passport: Update | Passport: View | Inv: Creation | Inv: Update | Inv: View |
|----------------|----------|----...The different levels of permissions:
| Groups | Users: Creation | Users: Update | Users: View | Passport: Creation | Passport: Update | Passport: View | Inv: Creation | Inv: Update | Inv: View |
|----------------|----------|--------|------|----------|--------|------|----------|--------|------|
| Administrator | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Senior Curator | No | No | No | Yes | Yes | Yes | Yes | Yes | Yes |
| Curator | No | No | No | No | No | Yes | No | Yes | Yes |
| Simple user | No | No | No | No | No | Yes | No | No | Yes |Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/7MBe inventory barcodes2021-03-01T06:07:39+01:00Matija ObrezaMBe inventory barcodesInventory barcodes at M'Be use the following format: `${inventoryNamePart1}${inventoryNamePart2}`
![image](/uploads/bb6fbb29ef47ce753314fb64b9d4c5b7/image.png)
- Full inventory name: `LTS 43556 SD`
- Barcode contents: `LTS43556`Inventory barcodes at M'Be use the following format: `${inventoryNamePart1}${inventoryNamePart2}`
![image](/uploads/bb6fbb29ef47ce753314fb64b9d4c5b7/image.png)
- Full inventory name: `LTS 43556 SD`
- Barcode contents: `LTS43556`Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/1MBe: Accession number part22021-03-09T08:44:27+01:00Matija ObrezaMBe: Accession number part2All `accession` records use only `accession_number_part1` (the Prefix) to store the full accession number (e.g. **WAB0021657**).
This prevents GG-CE from automatically assigning the next number when registering new accessions.
`accessi...All `accession` records use only `accession_number_part1` (the Prefix) to store the full accession number (e.g. **WAB0021657**).
This prevents GG-CE from automatically assigning the next number when registering new accessions.
`accession_number_part1` will be split:
|Accession number|`_part1`|`_part2`|`_part3`| |`_part1`|`_part2`|`_part3`|
|--|--|--|--|--|--|--|--|
|WAB0021657|WAB0021657|`null`|`null`|-->|WAB|21657|`null`|
## Changes
After these changes, use `WAB` for your accession prefix **and** a number. You can use number `-1` to automatically assign the next one in `WAB` group.
![image](/uploads/0070d87db83bbfebe0fafa15c5ad628f/image.png)
You can see the number of accessions in each prefix group at https://mbe.ggce.genebanks.org/a/summary -> "Accession Prefix"Matija ObrezaMatija Obreza