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

Step 1: scan your own barcode

Step 2: scan chemical barcode

Return a chemical

Action: scan borrowed chemical barcode

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:

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.

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.

   • Location column: remove all commas ( , ) if there is any. Dashes ( - ) are ok. Update (2020-02-01): for KV's version of OE, if you updated to version after 2020-02-01, this has been fixed.

2. Copy all of the cells in this file (Ctrl-C for Windows, Cmd-C for Mac) and paste (Ctrl-V for Windows, Cmd-V for Mac) them into Notepad (Windows) or TextEdit (Mac)

3. Save this new file as your-file-name.txt. The “.txt” part is important.

Save As… the file using Window Formatted Text (for Mac OS)

For Windows, Office 2016 of Office 365, use “Text (Tab delimited) (*.txt)” option:

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

5. Go to Settings

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

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

8. Click green check mark

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

10. 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.

11. 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.

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

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