GGCE Support issueshttps://gitlab.croptrust.org/grin-global/support/-/issues2021-04-30T23:55:17+02:00https://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/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/64Adding New Accession error2021-04-30T06:29:20+02:00Rizalina SulaboAdding New Accession errorHi, while adding a new accession, it gave this error of validation for 'NOT SET'
![image](/uploads/b768eca6dba526570a3307d733981919/image.png)
thanksHi, while adding a new accession, it gave this error of validation for 'NOT SET'
![image](/uploads/b768eca6dba526570a3307d733981919/image.png)
thanksMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/63Barcode in Check Request items2021-04-30T06:34:12+02:00Rizalina SulaboBarcode in Check Request itemsHi, The barcode to scan items in Form 'Check Request Items' is incorrect for us. It reads the inventory ID but we are using a different format for the barcode here in Manila. Can it be please changed? Thank You
![image](/uploads/6ee92000...Hi, The barcode to scan items in Form 'Check Request Items' is incorrect for us. It reads the inventory ID but we are using a different format for the barcode here in Manila. Can it be please changed? Thank You
![image](/uploads/6ee9200029f5a8c48685c180dbe6ed8a/image.png)https://gitlab.croptrust.org/grin-global/support/-/issues/54Manila restore2021-04-26T13:40:41+02:00Matija ObrezaManila restore@1cgiar/manila I will begin restoring the lastest database sent by @lsison. GG-CE will be offline until the restore is complete.@1cgiar/manila I will begin restoring the lastest database sent by @lsison. GG-CE will be offline until the restore is complete.Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/52Verify Request Items error2021-04-21T10:31:38+02:00Rizalina SulaboVerify Request Items errorHi. The verify items button from the this page is not working, or is there a specific item status for it to work? thanks
![image](/uploads/bdef76a3586be702d3783b5f6736fc89/image.png)Hi. The verify items button from the this page is not working, or is there a specific item status for it to work? thanks
![image](/uploads/bdef76a3586be702d3783b5f6736fc89/image.png)https://gitlab.croptrust.org/grin-global/support/-/issues/51New Request/Distribution error2021-04-21T09:06:05+02:00Rizalina SulaboNew Request/Distribution errorHi, New request vcard on our page 'Not found'
![image](/uploads/ff4c7ef7999561f492b27d15d25105fc/image.png)
![image](/uploads/fd3e24e36fef5ca5693a0273e6016d3c/image.png)
while the Add New request from the Distribution vcard is working ...Hi, New request vcard on our page 'Not found'
![image](/uploads/ff4c7ef7999561f492b27d15d25105fc/image.png)
![image](/uploads/fd3e24e36fef5ca5693a0273e6016d3c/image.png)
while the Add New request from the Distribution vcard is working fine
![image](/uploads/dc35179086d2c6ee26084fbfc0d1171e/image.png)
thankshttps://gitlab.croptrust.org/grin-global/support/-/issues/47Inventory Picker / filter : request2021-04-20T10:15:38+02:00Rizalina SulaboInventory Picker / filter : requestHi. While testing Inventory filter/picker, found that I could not search for inventory suffix under a specific inventory maintenance policy.
![image](/uploads/270059aa6c880461a57fd80cd0f70458/image.png)
Here is the same filter variabl...Hi. While testing Inventory filter/picker, found that I could not search for inventory suffix under a specific inventory maintenance policy.
![image](/uploads/270059aa6c880461a57fd80cd0f70458/image.png)
Here is the same filter variables just without the Full text search for Base
![image](/uploads/862bc535edbf7a9ab0e5b5e57fce907d/image.png)
Sample inventory to filter
![image](/uploads/e9aaeb2449ec4543d9b2c7cac0e00843/image.png)
Can you please add Inventory Suffix in the inventory filter/picker? ThanksMatija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/44Adjust Inventory Quantity - not updating2021-04-12T10:40:14+02:00Rizalina SulaboAdjust Inventory Quantity - not updatingHi. The changes in quantity on hand was not updated after saving
![image](/uploads/89c1130c244d9a50620ee4e9dec26f98/image.png)Hi. The changes in quantity on hand was not updated after saving
![image](/uploads/89c1130c244d9a50620ee4e9dec26f98/image.png)Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/22creating inventory.generation problem2021-04-29T06:39:02+02:00Lilibeth Sisoncreating inventory.generation problem@mobreza Every time I pull the latest version and start the server, I get the 503 error. When I read the logs, there's an error in creating generation column in the inventory table. I manually create this column in MS SQL server because ...@mobreza Every time I pull the latest version and start the server, I get the 503 error. When I read the logs, there's an error in creating generation column in the inventory table. I manually create this column in MS SQL server because that's where I store the generation number of inventory records.
here is an example
![image](/uploads/aa13e4ee404bc1252a3df16059ee93c3/image.png)
So each time, I rename the generation column to generation1, then the pull and startup would be successful. Do you have any suggestions on how to solve this?Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/10Manila storage locations2021-03-01T13:50:26+01:00Matija ObrezaManila storage locationsI'm looking at `storage_location_partX` and I see in `part2` values like `UB1-2;UA6` or `UB 1 & 2` or `UC4, UC5, & UD2`.
What does this mean?I'm looking at `storage_location_partX` and I see in `part2` values like `UB1-2;UA6` or `UB 1 & 2` or `UC4, UC5, & UD2`.
What does this mean?Lilibeth SisonLilibeth Sisonhttps://gitlab.croptrust.org/grin-global/support/-/issues/9Manila GG-CE setup2021-03-01T07:51:02+01:00Matija ObrezaManila GG-CE setupSet up **manila** GG-CE server and web.Set up **manila** GG-CE server and web.Matija ObrezaMatija Obrezahttps://gitlab.croptrust.org/grin-global/support/-/issues/8Manila inventory barcodes2021-06-11T09:04:13+02:00Matija ObrezaManila inventory barcodesWhat is the contents of your current QR code and 1D barcodes on seed packets in storage?
## Fill GG-CE with barcodes
```sql
update inventory set
barcode=concat('GR-', FORMAT(inventory_number_part2, '0000000000'))
where barcode is null...What is the contents of your current QR code and 1D barcodes on seed packets in storage?
## Fill GG-CE with barcodes
```sql
update inventory set
barcode=concat('GR-', FORMAT(inventory_number_part2, '0000000000'))
where barcode is null and form_type_code != '**' and inventory_maint_policy_id in (2,3,4,5,10,11);
-- And for planted
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;
```Lilibeth SisonLilibeth Sisonhttps://gitlab.croptrust.org/grin-global/support/-/issues/6Gitlab groups2021-03-01T06:32:57+01:00Matija ObrezaGitlab groupsThis GG-CE Support (https://gitlab.croptrust.org/grin-global/support/) project is for all CoP members.
> You have been granted Developer access to the *CGIAR / X* group.
I was cleaning up the permissions on our Gitlab and this is how g...This GG-CE Support (https://gitlab.croptrust.org/grin-global/support/) project is for all CoP members.
> You have been granted Developer access to the *CGIAR / X* group.
I was cleaning up the permissions on our Gitlab and this is how gitlab handles groups of users. This is not intended to be the CGIAR gitlab.
You can access all GG-CE Support issues (of other genebanks) to know what goes on.Lilibeth SisonLilibeth Sison