Search the chemical database

(   http://trinity.ucsf.edu:9944/webport  )

• You must be using a computer which has been given access to the database.
• As of October 2007, the database is accessible using Firefox on Windows or OS X. However, greatest formatting compatibility occurs with Internet Explorer on Windows
• As of Jan. 2006, the username has been changed

Want to download the Excel spreadsheet?  Note the spreadsheet might not contain the latest information.

WARNING: Searching this spreadsheet will cause you to miss hits that you would get if you used the online database.  It is recommended that you do an online search using name_filter entries such as this:

LIKE "%porphyrin%"

to get hits "hemin" and "porphine," as well as porphyrins.  You wouldn't get these searching the Excel spreadsheet.  See below for details on searching the database. If you still want to download the latest spreadsheet (080506) click here.

General Instructions

More details can be found in the Search Inventory Guide, which is a link available from the search pages.

***Important: As a courtesy to others, when you are finished with your search, TRASH your jobs by clicking the Jobs buton, then the Trash icon next to each job you ran. (Details given below.)

First Steps

• Connect to the webpage.
• The first thing you might see is a Security Alert warning you about some certificate problems
  
  
  
  
• You will have to say Yes, to allow the certificate for this session.  Do not Install Certificate.
  The reason for the alert is that the company that wrote the database software (Scitegic) is different from the web server company (UCSF)
• Click the green "Library" button in the upper right corner and then choose "Search_Inventory" under GeneralWebServices on the left panel
• Click "Search Inventory" on the right panel to load the protocol

Searching by Name and CAS Number

• On the 'Execution' tab, you will enter your Name search terms.  (Or, enter the exact CAS number under CAS_Filter.)

• Name_Filter

  LIKE "%coumarin%"

  will give hits not only for compounds with "coumarin" in their names, but also trivially-named coumarins like "psoralen" or "esculin".  (LIKE does a more general search. Otherwise, the search will be nearly exact based on the name only.)

• When ready to search, click the 'Submit' button at the bottom of the left panel

• Results appear on the right side of the window, and each search will produce a new job, listed under Jobs. (These are the links you need to Trash when you are done, otherwise they linger for hours or days, which makes searches by others cumbersome.)
  For Internet Explorer, you may want to 'Save as type: Web archive' to save it into a single file, rather than a file and folder of files.

Searching by substructure

Create a .mol structure, e.g. using IsisDraw, and save it as a file.

• Query_substructure: Browse button
• My Computer, Browse to the file, Add This File
• The structures appear in the Selected Files list
• OK when done adding substructures
• You can use 'AND_substructure' and 'NOT_substructure' to refine the structure search

Viewing the Search Guide for more help

For Search help, go to the Protocol page's Help tab and click "Search Inventory Guide"

Sample Purchase Orders

When buying new "chemicals," write the CAS numbers and future storage location on the Purchase Order. Orders for "non-chemical items" do not need the CAS # or locations. Note that non-chemicals includes "Purely biological items" and "Mixtures of chemicals."