Use Chemical Search and Export - Hasmate
1943
post-template-default,single,single-post,postid-1943,single-format-standard,ajax_fade,page_not_loaded,,qode_grid_1300,footer_responsive_adv,qode-child-theme-ver-1.0.0,qode-theme-ver-13.3,qode-theme-hasmate health and safety systems,wpb-js-composer js-comp-ver-7.5,vc_responsive

Use Chemical Search and Export

10 Apr Use Chemical Search and Export

Posted at 13:18h in Chemicals Module by

Please click on “Chemicals” in the program menu.

Order of Chemicals

The Chemical Search page shows 15 chemicals alphanumerically by Chemical Number.  Any empty fields show at the top, then registration numbers that start with numbers (e.g. 123ABC, 156GH, etc), then registration numbers that start with letters (e.g. AB1234, AB1237, AC456, etc).

You can reorder the chemical search page temporarily, by clicking on another column title, e.g. “CAS Number“, “Common Name“, etc.  In each case, empty fields will show at the top, then fields that start with numbers, then fields that start with letters. Clicking on the column title again will put them in reverse order.

Note – if you go to another part of the Hasmate program, or log out and log back in, the Chemical Search page will return to the default ordering by Chemical Number.

Chemical pages

To go to the appropriate page of chemicals, you can use the page numbering buttons.

<< takes you to the first page of chemicals

< takes you back one page

1, 2, 3, etc takes you to the exact page that you want

> takes you forward one page

>> takes you to the last page of chemicals

Using Search

To find the chemical or chemicals you wish, you can use one or more of the following fields to search by:

  • Chemical Name
  • Active (dropdown of Yes or No)
  • Business Level 1, 2, and 3 (these will be named whatever you’ve named them in “Controls“, and will be drop-downs of the options you’ve previously set)

Then click the “Search” button to see the search results of chemicals appropriate to the criteria you’ve set.

To clear a search, click the “Clear” button.

Using Export

At any point, you can export some of the chemical details as a spreadsheet.

Information can also be exported after a search.

The information in the spreadsheet will include the following fields:

  • CommonName
  • CommercialName
  • ChemicalNumber
  • CASNumber
  • UNNumber
  • BusinessLabel1Desc
  • BusinessLabel2Desc
  • BusinessLabel3Desc
  • ChemicalTypeDesc
  • HazardDesc
  • ActiveFlag
  • ControlsRequired
  • EmergencyProcedure
  • BundingRequiredFlag
  • ContainerDisposalMethod
  • ContractorName
  • DegradationofProduct
  • FilePath
  • FolderPath
  • HealthMonitoringRequiredFlag
  • MSDSFolderPath
  • SegregationRequiredFlag
  • ShelfLifeMonths
  • SignageRequiredFlag
  • SpecialBundingRequirements
  • StorageLocation
  • StorageMethod
  • TestCertificateRequiredFlag
  • TraceabilityFlag
  • SDSExpiryDate
  • HSNOApprovalNumber
  • ContainerSizeLessThan5L
  • ContainerSizeGreaterThan5L
  • MaxLikelyAmount
  • SDSAvailableFlag
  • ContainerOpenFlag

If you have further questions or require training, please contact Hasmate.