In Inventory Mode

Borrow a chemical

Step 1: search for the chemical of interest (see Search chemicals section)

Step 2: click Borrow button

Return a chemical

Step 1: go to Borrowed chemicals

Step 2: click Return button

In Terminal Mode

Borrow a chemical for users of that database

This function only works for users and chemical containers in the same database. For cross-databases (guest) borrowing, please see the guest borrowing guide below.

Step 1: scan your own barcode

Step 2: scan chemical barcode

Borrow a chemical for guest users

Step 1: Follow the following guide to create a guest account

Step 2: Follow the step above in Borrow a chemical for users of that database

Return a chemical

Action: scan borrowed chemical barcode

Searching Chemicals in Existing Database(s)

Step 1: choose what type of search: e.g “names, cas, supplier #”

Step 2: choose options: e.g. all words, contain (~ similar to), exact

Step 3: type is your search query, this can be name, CAS, supplier #, best with CAS and name

Step 4: choose database(s): choose one, or several (holding Ctrl while Left-click, or All databases (default)

Step 5: click Search

Video demonstration:

Searching Chemicals in Supplier Mode

Search Chemicals using Structure

Step 1: choose search with Structures

Step 2: draw structure

Step 3: choose options: contain, similar to, exact, etc.

Step-wise guide

1. Prepare the Excel file, an example might look similar as below. A few important things:

   • Columns that are highlight in blue are important info.

   • You don't need all of the info that show in this example.

   • Empty cells are OK.

   • The amount need to be “xx Y” with xx is the amount and Y is the unit.

   • For unit, it is best to have all in lower case, for example, “ML” should be either “ml” or “mL”. It is best to convert all unit to lower case (use lower() command in excel).

   • Double check the CAS number column, Open Enventory uses CAS number as primary source to look up chemical info from the internet.

   • See step 9 for more info about each column in the excel sheet.

2. Login into your database using root user or any users with admin permission

3. Go to Settings

4. Go to Import Tab-separated text file (or Import in KV's version)

5. Choose Browse… and choose the exported text file.

6. Click green check mark

7. Screens as below should show up, you can scroll down to see if they show up correctly (info appear correctly in each row)

8. Choose Column X for each content. If you choose None, that column will not be imported. You can also add a default value for each column that will apply for ALL items being imported.

9. Click green check mark. Screen similar as below should show. Note: line X:… will tell you which lines in the text file is being imported.

10. Depend of how many chemical containers are imported, this might take a long time, so please be patient.

Demo video

Author: Nathanyal Truax, Baylor University. You can check out his Youtube channel for other useful videos.

Step 1: Search chemical in the database:

Step 2: Click on the structure

Step 3: Depends on the type of info you want to edit, choose the corresponding tab below:

For chemicals from existing database

Step-by-step instruction here

For chemicals from suppliers

Step 1: change to supplier search and search chemical

Step 2: choose Create new molecule based on data

Step 3: add more info: amount, person responsible, etc.

This clip below is show the process of adding a new chemical from suppliers:

Add a single chemical from scratch

Step 1: choose New

Step 2: use CAS number (if exists) to pull info from suppliers

Step 3: add more info

Step 1:

Login into OE and extract the list of chemical containers that need to be move. You don't need all of the details for each container, just: - CAS number - Names - Chemical container barcode: most important thing as this is the lookup point

Step 2

Open and add a new column with the name of the new location for each container. New LOCATION NAME MUST BE EXACT or OE would create a new storage location.

Step 3

Login into OE with an admin account if you have not done so in step 1

Step 4

Go to Settings > Import and Edit via text file

Step 5

Follow the process that is laid out in Edit Multiple Chemical Containers .

If you want to change all chemical container into the same new storage, simply typing the EXACT STORAGE NAME in the input instead of choosing the column for the storage_name

If your institution has this option turned on, you can edit a list of chemicals automatically.

To turn on this function, please see this page:

Instruction

then:

Step 1: Choose Settings

Step 2: choose Import and Edit via Text File

Step 3: on the Import page:

• Choose package in the table field:

• Click on Choose file button to choose your prepared file

• Choose the number of Lines to preview

• Choose number of lines to skip (header lines)

Step 4: click the green check mark to start uploading the file

Step 5: match the appropriate column for each info

• Most importantly: match Barcode for chemical container with the correct column on your prepared file. This is how Open Enventory use as ID of the container.

• Match the rest of the info in the red rectangle area as desired:

• Preview of the data:

Step 6: click the green check mark