Import a list of chemicals

Step-wise guide

This guide is for KV's version of OE that is newer than 2020-02-01. If you use an older version of Felix Rudolphi (FR)'s original version, please see the guide here.
Update (2020-02-01): KV's version of OE (on and after 2020-02-01) now accepts:
  • Excel files (*.xlsx and *.xls)
  • Comma-separated files (csv)
  • Tab-separated files (*.txt).
  1. 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.
Note: in Lines to skip, put 1 if you have a header rows, if not, choose 0
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.
  • CAS number: most important info, OE will use this to look up other info (structures, MW, safety data, etc) from this cas #
  • Name: not too important
  • Empirical formula: do not import this since OE will use this to find the closest chemicals if CAS# is not present or wrong.
  • Amount: = size of the bottle + unit (format should be #+space+unit, for example: 5 g, 125 ml, 1 kg, etc)
  • Still available: the amount that left in the bottles (OK if not imported)
  • Locations: important. Note: Each location will have its own barcode
  • Compartments: = sub-location. Note: each compartment does NOT have its own barcode
  • Barcode: if you already have an existing barcode system, add it here.
  • Suppliers: = suppliers
  • Date open: could be in European style ( or American style (mm/dd/yy, etc.)
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.