Basics

Explore the tables

The data can be explored by going in the 'content' section (Cube on the module bar). The tables are listed on the left.
By clicking on one item, one can navigate through all the values of that one item. Some tables are read-only mode (e.g. Pyinat) and others can be edited (e.g. Samples).
One can search for a particular item on the top right part and add a filter to see only items of interest.

The data can be visualized with other layouts (e.g. map) than the table one by changing the layout options on the right menu.

How to add items to the samples table

1. Copy the Google sheet template: Or export the table as a csv from directus:

2. Fill the template with your data (no need to add the dbgi_spl_id,user_created,date_created,user_updated,date_updated - it is autoincremented)

3. Save the file in a COMMA separated csv file

4. Import the data on directus

redo sequence

If one does a mistake and needs to get back in the incremantation of the emi_external_id:

1. Delete the wrong entries
2. Connect to the psql database
   From postgres

   Go to text →

   Connect to postgresql

   psql -U username
   

3. Restart the sequence padding
   From postgres

   Go to text →

   Restart the sequence padding

   If one do a mistake in the emi_external_id incremantation and needs to go back in the sequence:

   SELECT setval('samples_padding',1057); #If one want to restart the sequence at 1057
   

Change password

In the 'user directory' section (peoples on the module bar), one can select its own user and change its password and other informations.

---

Backlinks

• wetlab
• 2023-05-04