If your institution has this option turned on, you can edit a list of chemicals automatically.
To know if this option is turned on, please log into Open Enventory with an admin account, then choose Settings (Top menu). Then if you see Import and Edit via Text File (Left menu) then this function is turned on for your institution.
You first need to log in into Open Enventory with an account with admin permission
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.
For chemical containers, it checks if the barcode exists in the current database, and not disposed:
If Yes, it will edit the info of that 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
A similar screen as screenshot below should appear after success uploading
Chemicals
If No (or no barcode in the data entry), it will add the entry as a new container.
Example screenshot of successful uploading of multiple users
Add a single chemical
Add Storagelocation if not exists: see this section
For chemicals from existing database
TODO
Step-by-step instruction here
For chemicals from suppliers
Step 1: change to supplier search and search chemical
Step 2: choose Createnewmoleculebasedondata
Step 3: add more info: amount, person responsible, etc.
This clip below is show the process of adding a new chemical from suppliers:
For custom chemicals or chemical that cannot be found from suppliers list, use Method below.
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
Search Chemicals
Searching Chemicals in Existing Database(s)
Make sure “Chemical Search” mode is on
Step 1: choose what type of search: e.g “names, cas, supplier #”
Step 2: choose options: e.g. allwords,contain(~similarto),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
Note: when Supplierssearch mode is on (see add chemical via suppliers), Open Enventory search includes chemicals from the local database(s) first
Search Chemicals using Structure
The default drawing program in Sciformation Vectormol. You can choose a different program by going to: Settings/Settings/Molecule editing/ and change “Structure Drawing Program” to “ChemDoodle (Javascript)” (recommended).
Step 1: choose search with Structures
Step 2: draw structure
Step 3: choose options: contain, similarto,exact, etc.
Step 4: click search
If it appears that the search is not accurate in ChemDraw plugin, you have to active the ChemDraw plugin:
a) Right click on the background of the chemdraw drawing window
b) Help/Activate my ChemDraw Plugin
c) Input your activation info the same (from email) as what you did for installation of Chemdraw
Supplier search mode
Move multiple chemical containers
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.
Skip this step if you want to move all of the chemical containers into the exact same 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
If you don't see Import and Edit via text file, you might not use the OE version by KV. If you did, you might need to enable it. See more at:
Step 5
Follow the process that is laid out in .
In Step 5 of , you would only need to choose the column for CAS number, Name and most importantly, chemical container barcodeand **chose the correct column for the new location for the storage_name
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
Step 1: search for the chemical of interest (see Search chemicals section)
Step 2: click Borrow button
Return a chemical
Step 1: go to Borrowedchemicals
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 below.
❗Computer that connected to the scanner must be ON
❗Barcode terminal window must be ON and ACTIVE, if not log in with terminal username and pass or contact your local admin
❗ Active barcode terminal look like below:
Step 1: scan your own barcode
Step 2: scan chemical barcode
Watch the terminal window to make sure the info is transmitted/recorded.
Borrow a chemical for guest users
Currently, this function is only available in 2020-09-26 or above.
Step 1: Follow the following guide to create a guest account
Step 2: Follow the step above in
Return a chemical
❗ Computer that connected to the scanner must be ON !!! Barcode terminal window must be ON and ACTIVE
Action: scan borrowed chemical barcode
Note: you don’t need to scan the your own barcode beforehand. The scan on a borrowed chemical will return the chemical.
Note: if the chemical is free and nobody has logged in, scanning the barcode of that chemical will bring up that chemical’s info in the system.
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).
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.
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.
Notes:
CAS number: most important info, OE will use this to look up other info (structures, MW, safety data, etc) from this cas #
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 for other useful videos.
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.
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 (dd.mm.yyyy) or American style (mm/dd/yy, etc.)
