mylabstocks issueshttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues2021-12-14T11:56:31+01:00https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/16upload items in batch2021-12-14T11:56:31+01:00Gael Yvertupload items in batchWe must define and implement a way to upload batches of items from .csv filesWe must define and implement a way to upload batches of items from .csv filesv2.1Guillaume PommierGuillaume Pommierhttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/21build a manyToMany relationship between oligos and plasmids2021-12-16T10:06:45+01:00Gael Yvertbuild a manyToMany relationship between oligos and plasmidsv2.2https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/22build a manyTomany relationship between oligos and strains2021-12-16T10:06:37+01:00Gael Yvertbuild a manyTomany relationship between oligos and strainsv2.2https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/23build a manyTomany relationship between plasmids and strains2022-01-31T13:58:27+01:00Gael Yvertbuild a manyTomany relationship between plasmids and strainsv2.2https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/25migrate auxotrophies to a table genetic_markers2022-05-23T09:48:31+02:00Gael Yvertmigrate auxotrophies to a table genetic_markersWe can store all genetic markers in a table, with columns:
- id
- name
- species_id
- gene
- allele
- comments
and then make a manyToMany relationship with the strains. Ideally, subsetting on the relevant species. This will cover auxotr...We can store all genetic markers in a table, with columns:
- id
- name
- species_id
- gene
- allele
- comments
and then make a manyToMany relationship with the strains. Ideally, subsetting on the relevant species. This will cover auxotrophies and Mating types for yeast strains. It will also include markers of other species (C. elegans etc...) in the future.
I see this as a secondary implementation (after we have imported gylab database)v2.2Gael YvertGael Yverthttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/27Add storage tables (rooms, freezers and boxes)2021-06-11T16:38:17+02:00Gael YvertAdd storage tables (rooms, freezers and boxes)And build relationships between items and their locationAnd build relationships between items and their locationsecond upgrade of gylab prod sitehttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/30Migrations to species of interest2022-06-21T14:56:54+02:00Gael YvertMigrations to species of interestWe will distribute a core database with: users, oligos, plasmids... and then, for every species (eg cerevisiae, elegans, melanogaster....) a migration that can add or remove this species.We will distribute a core database with: users, oligos, plasmids... and then, for every species (eg cerevisiae, elegans, melanogaster....) a migration that can add or remove this species.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/31write doc for full backup2021-04-23T15:27:25+02:00Gael Yvertwrite doc for full backupfirst upgrade of gylab production sitehttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/32Plasmapper implementation2022-06-21T14:58:07+02:00Gael YvertPlasmapper implementationNon-essential functionality for now: we'll need to have the palsmid Controller call plasmapper, which will return the plasmid map image that can then be passed to the plasmid View.Non-essential functionality for now: we'll need to have the palsmid Controller call plasmapper, which will return the plasmid map image that can then be passed to the plasmid View.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/52export tables in CSV format2022-06-21T15:01:00+02:00Gael Yvertexport tables in CSV formatv2.1https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/66projects table2021-06-11T16:36:44+02:00Gael Yvertprojects tableIt would be VERY convenient to link projects with plasmids, strains etc...
For this, we can make a projects table and build many-to-many relationships to it.
However, it is important to make this table SIMPLE, so that people don't use M...It would be VERY convenient to link projects with plasmids, strains etc...
For this, we can make a projects table and build many-to-many relationships to it.
However, it is important to make this table SIMPLE, so that people don't use MLS to manage the projects (as in companies, with gantt, milestones, budgets, human resources etc...), because there are all sorts of other softwares for this.second upgrade of gylab prod sitehttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/77Improve relationships (sort in dropdowns, ...)2021-07-06T10:48:50+02:00Gael YvertImprove relationships (sort in dropdowns, ...)Voyager's BREAD editor allows to set relationship more finely than what is done yet, with proper displaying/storing etc...
However, I once got error message of model not existing (see issue #32). Needs further readings and fixings.Voyager's BREAD editor allows to set relationship more finely than what is done yet, with proper displaying/storing etc...
However, I once got error message of model not existing (see issue #32). Needs further readings and fixings.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/80Make BLAST output dynamic (clickable)2022-06-02T12:51:40+02:00Gael YvertMake BLAST output dynamic (clickable)Would be very nice to have the possibility to click on the items retrieved by BLAST to display them in browse and/or read mode.Would be very nice to have the possibility to click on the items retrieved by BLAST to display them in browse and/or read mode.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/81pre-fill id with incremented integer when adding a new item2021-04-28T11:17:28+02:00Gael Yvertpre-fill id with incremented integer when adding a new itemfirst upgrade of gylab production sitehttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/82edit-add view: mention which fields are required2021-04-07T10:48:50+02:00Gael Yvertedit-add view: mention which fields are requireddeploy a production site for Yvert lab members onlyhttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/85Make read views more synthetic2021-04-30T14:57:30+02:00Gael YvertMake read views more syntheticWe need to better group the info, with columns etc... instead of being obliged to scroll down.We need to better group the info, with columns etc... instead of being obliged to scroll down.first upgrade of gylab production sitehttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/115Add column 'warning' to strains table2021-04-28T13:51:35+02:00Gael YvertAdd column 'warning' to strains tableWhere users can explicitely warn about issues/doubts/inconsistencies they noticed regarding a strain.Where users can explicitely warn about issues/doubts/inconsistencies they noticed regarding a strain.first upgrade of gylab production sitehttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/122add well plates2021-06-11T16:37:25+02:00Gael Yvertadd well platessecond upgrade of gylab prod sitehttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/129Add tables and BREAD for cryotubes of passages2021-06-25T09:04:45+02:00Gael YvertAdd tables and BREAD for cryotubes of passagesFor each passage of a cellline, we store several cryotubes.
We need to establish appropriate data and relationships on these cryotubes regarding the passage they belong to, and the place they are stored (box).For each passage of a cellline, we store several cryotubes.
We need to establish appropriate data and relationships on these cryotubes regarding the passage they belong to, and the place they are stored (box).https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/130add racks info to boxes2021-06-25T16:16:17+02:00Gael Yvertadd racks info to boxesEvery box is stored in a **rack** of a given freezer. Users need to enter the id of this rack and the id of the position in the rack.Every box is stored in a **rack** of a given freezer. Users need to enter the id of this rack and the id of the position in the rack.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/131add boxpositions2021-07-06T11:12:39+02:00Gael Yvertadd boxpositionsWe need to track positions of samples, for example passages of celllines, and to easily identify empty positions in boxes.
What I plan to do is:
- a boxpositions table, with fields id, box_id, row, column
- a routine (controller somewher...We need to track positions of samples, for example passages of celllines, and to easily identify empty positions in boxes.
What I plan to do is:
- a boxpositions table, with fields id, box_id, row, column
- a routine (controller somewhere) that automatically create positions in this table when a new box is added to the table boxes
- add relationships in BREADs. For example, in the passages BREAD, add a oneToMany relationship to boxpositions to indicate where the samples of this passage are stored. This implies having a pivot table boxposition_passages.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/136establish relationships in events' BREAD2021-07-15T17:44:19+02:00Gael Yvertestablish relationships in events' BREAD- Add relationship between events and data_types.
- Add a `item_id` column that will store the id of the data_type for which the event occurred.
- Propose event types directly from DropDown menu (options). We don't need the event_types t...- Add relationship between events and data_types.
- Add a `item_id` column that will store the id of the data_type for which the event occurred.
- Propose event types directly from DropDown menu (options). We don't need the event_types table.
- Offer an upgrade procedure to re-import the data stored in pipet_events into the events table with links to pipets. Indeed, after upgrading from v1 to v2.0.1, what was in pipet_histories is now in table pipet_events. We must store this as `events` and then drop the pipet_events table.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/139add a Description field in projects table2022-06-21T14:53:55+02:00Gael Yvertadd a Description field in projects tableA rich text box to briefly describe the project.A rich text box to briefly describe the project.v2.1Gael YvertGael Yverthttps://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/168visualize the content of boxes ?2022-06-14T09:39:25+02:00Gael Yvertvisualize the content of boxes ?It would be nice to have pages that display the content of boxes. This could be done in the frontend with dedicated read views. Ideally, a matrix dipslayed with boxe's rows and columns, where each cell is clickable to display the read vi...It would be nice to have pages that display the content of boxes. This could be done in the frontend with dedicated read views. Ideally, a matrix dipslayed with boxe's rows and columns, where each cell is clickable to display the read view of the item stored at this boxposition.v2.2https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/169How to export selected plasmids to a spreadsheet file?2022-12-15T17:15:01+01:00Zhiping XieHow to export selected plasmids to a spreadsheet file?Currently (v2.0.7), when exporting plasmids in the backend, all plasmids in the database are exported. Is there a way to export only plasmids selected by user, or filtered by a search term, instead of everything?Currently (v2.0.7), when exporting plasmids in the backend, all plasmids in the database are exported. Is there a way to export only plasmids selected by user, or filtered by a search term, instead of everything?v2.2https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/173Searching a field with constrained choices2023-02-09T11:33:21+01:00fduveauSearching a field with constrained choicesWhen entering new data, some of the fields are constrained by a predetermined list of choices. It would be nice to also be constrained by the same list of choices in the search tool when searching based on a constrained field.When entering new data, some of the fields are constrained by a predetermined list of choices. It would be nice to also be constrained by the same list of choices in the search tool when searching based on a constrained field.https://gitbio.ens-lyon.fr/LBMC/yvertlab/mylabstocks/-/issues/174upgrade to Laravel 102024-02-02T13:58:10+01:00Gael Yvertupgrade to Laravel 10Of course, this should be solved AFTER solving issue #163
Apparently, Voyager became compatible with Laravel 10 when version 3.7 was released, see [this discussion](https://github.com/thedevdojo/voyager/issues/5740). So we should first...Of course, this should be solved AFTER solving issue #163
Apparently, Voyager became compatible with Laravel 10 when version 3.7 was released, see [this discussion](https://github.com/thedevdojo/voyager/issues/5740). So we should first upgrade voyager before going to Laravel 10.Gael YvertGael Yvert