Chemical Inventory at UCLA
If you have access to the Manage Inventory function in UC Chemicals, you can upload your items to UC Chemicals in bulk by using a Microsoft Excel template.
- Import section will allow you to upload your inventory all at once.
Please be aware that Building, Room, and Sublocation fields must exactly match what you see in UC Chemicals under Sublocations. (see screenshot here)
For example, the Sublocation ‘STRATHMORE BUILDING - 410’ must appear exactly like that in the excel file – no lower case letters.
Additional Fields: Building = ‘STRATHMORE BUILDING’; Room = ‘410’.
We suggest copying and pasting this location information directly from UC Chemicals.
Lack of a delete function is a known issue.
Currently there is no way to delete the copies, but what you are able to do is remove all but one of the associations between your lab group and the inventories. That should make it so that members of your group only see one inventory when they login to UC Chemicals.
Follow these steps to accomplish this:
- Login to https://ehs.ucop.edu/chemicals
- Click Manage Inventory
- Scroll down to ‘Inventory Access’ and click the three vertical dots to bring up another menu
- Select Add/Remove Groups from the menu
- Uncheck your group to disconnect it from the inventory
- Click Done
- The next time you login you should see one less inventory; repeat until only one is visible, then add your chemicals to the correct inventory
Afterward, please report this issue and/or your disconnected inventories to [email protected] or by calling 530-638-DESK (3375).
PI and delegate access only
In order to begin adding chemicals, first create a sublocation from the Manage Inventory section of UC Chemicals using the following method:
- Find the section that says Sublocations and click the ‘+’ button on the right side of the screen
- Click the drop down for Building/Room and select the room you want
- Enter a name for the sublocation (for example, ‘Flammables Cabinet’)
- Confirm the correct temperature and pressure
- Click Save
- Now you should have a location available when you add your chemical containers