Ex ESS IT tool for SDS batch generation

Ex. ESS IT tool for SDS batch generation, distribution and web interface 12 January 2009 SDS batch generation, distribution and web interface 1

Ex. ESS IT toolbox 12 January 2009 SDS batch generation, distribution and web interface 2

The complete IT solution for Chemicals Management 12 January 2009 SDS batch generation, distribution and web interface 3

Input from Other IT Application (orders) • Ex. ESS Inventory • Ex. ESS Chemicals Management • Classification calculation • SDS versioning • SDS phrases/languages • SDS, label and document MS SQL SMTP templates • Distribution lists Batch Document generation SDS batch, distribution, web 1 Structured folder with Pdf documents 2 www Information exchange through web browser : • Chemical Product Info as label, SDS, SIC • Input/output stock data • Documents 12 January 2009 3 SDS batch generation, distribution and web interface 4

1 SDS batch generation The SDS Batch Generation 1. Select one or more chemicals or trigger automatically a selection of a defined set of chemicals 2. Create for each selected chemical one or more SDS’s with the following definable parameters : • the document format (Word or PDF) • the document template (SDS, label, SIC, other…) • the structure of the stored documents (Folder) • the required languages • the composition of the document name • confirm automatically a date stamp to identify the batch time reference • activate generation of different document types at the same time 12 January 2009 SDS batch generation, distribution and web interface 5

1 SDS batch generation Select <Report> from the detail layout of a chemical and select <batch> 12 January 2009 SDS batch generation, distribution and web interface 6

1 SDS batch generation Identifier : Ex. ESS Name of the batch generation data set Name : Name of the Batch Generation Data Set Report : Select batch report template Output format : Word or Pdf Root folder : Start of document network collection folder Time stamp field : Select field to adjust as time stamp Languages : Selection of document languages Filename script : HEMMIS script for automatic document name generation 12 January 2009 SDS batch generation, distribution and web interface 7

1 SDS batch generation result All defined documents are automatically stored in a certain structure , ready to be distributed manually or automized 12 January 2009 SDS batch generation, distribution and web interface 8

2 Document (SDS) distribution The document (SDS) distribution is useful to : 1. Define triggers and conditions on which documents must be distributed to users and/or external persons (clients, suppliers, …) 2. Send revised SDS versions to existing clients by email 3. Send relevant SDS documents to new clients by email 4. Logfile to follow up automized distribution Define triggers 12 January 2009 Create or find document(s) Send documents by email SDS batch generation, distribution and web interface 9

2 Document (SDS) distribution Based on : • Distribution list • Distribution settings • Links and settings to mail system • Logging of mailings 12 January 2009 SDS batch generation, distribution and web interface 10

2 Document (SDS) distribution 12 January 2009 SDS batch generation, distribution and web interface 11

2 Document (SDS) distribution The document (SDS) distribution can include by parametrization : 1. Tracking who (based on distribution list and date-condition) received in the past a document and who must receive an upgrade of this document 2. Tracking errors or logging communication problems 3. Automatic links to ERP information as : orders, new customers, recent changed uses or product information, …Information can lead to trigger conditions on which communication of documents must be activated 12 January 2009 SDS batch generation, distribution and web interface 12

3 web interface Web interfaces are used to • Distribute print ready documents : SIC; labels, SDS • Give controlled access to trade product information to clients/distributors • Track stock movements in labs • …. In general, web interfaces allow restricted input and output of Ex. ESS data 12 January 2009 SDS batch generation, distribution and web interface 13

3 web interface DEMO 1 12 January 2009 SDS batch generation, distribution and web interface 14

3 12 January 2009 Web based Search engine SDS batch generation, distribution and web interface 15

3 12 January 2009 Search Result SDS batch generation, distribution and web interface 16

3 12 January 2009 Information presentation SDS batch generation, distribution and web interface 17

3 12 January 2009 Label information SDS batch generation, distribution and web interface 18

3 12 January 2009 Stock entry SDS batch generation, distribution and web interface 19

3 MSDS search Presentation and printout of Safety Data sheets via web interface to Ex. ESS and PDF documents 12 January 2009 SDS batch generation, distribution and web interface 20

3 SIC search Presentation and printout of Safety Instruction Cards via web interface to Ex. ESS and PDF documents 12 January 2009 SDS batch generation, distribution and web interface 21

3 12 January 2009 MSDS search SDS batch generation, distribution and web interface 22

3 web interface DEMO 2 12 January 2009 SDS batch generation, distribution and web interface 23

3 12 January 2009 MSDS/document search SDS batch generation, distribution and web interface 24

3 12 January 2009 MSDS/document search SDS batch generation, distribution and web interface 25

3 12 January 2009 MSDS/document search SDS batch generation, distribution and web interface 26

3 12 January 2009 MSDS/document search SDS batch generation, distribution and web interface 27

3 12 January 2009 MSDS/document search SDS batch generation, distribution and web interface 28

4 PUBLICHEM interface DEMO 3 12 January 2009 SDS batch generation, distribution and web interface 29

4 12 January 2009 PUBLICHEM interface SDS batch generation, distribution and web interface 30

4 12 January 2009 PUBLICHEM interface SDS batch generation, distribution and web interface 31

Ex. ESS, more with less § Compiled by Frans Lemaire, April 2011, Lisam : frans. L@lisam. com Although the information in this presentation are presented in good faith and are believed to be correct at the time of compilation, LISAM is never responsible for the completeness or accuracy of the information in this presentation 12 January 2009 SDS batch generation, distribution and web interface 32