(ATS4-DEV06) Building Morphit Binders within Accelrys ELN

Mike Wilson

Advisory Product Manager

mike.wilson@accelrys.com

The information on the roadmap and future software development efforts are intended to outline general product direction and should not be relied on in making a purchasing decision.

Agenda

• What is the Morphit Section?

• Morphit integration with Accelrys ELN

• Demo: Connecting a Morphit binder to Accelrys ELN properties

What is Morphit?

A multi-dimensional spreadsheet that provides an flexible and robust analysis and templating environment

• Familiar

• Flexible templates

• Relational

• Change tracking

Morphit Terms and Definitions

• Design Mode: allows user to create Morphit binder

• Binder: a Morphit data file • Workbook: (multiple) held within a binder

– Sheet: like the classic MS Excel sheet, held in workbooks – Table: a spreadsheet page with an explicitly defined hierarchical structure

• Header: nameable headers of Fields are similar to the “Columns” of Excel

• Linking: matching values of the source Field can be accessed • Borrowing: take all the values from one Field and insert into

another Field in a new Table

• Morphit – Audit Trails – Authorisation (Author vs. User modes) – Morphit Render

• Mapping to PSD – Tables – Forms – Direct (document indexing)

• Content Management – Electronic signatures – Versioning – Printing, PDF output

Integration to Accelrys ELN

• All ELN users can view Morphit binder data

• An additional license is required to edit/create Morphit data

• Morphit binders can be connected to Acclerys ELN PSDs for indexing and reporting – Binder metadata – Binder table data

• Morphit binder is saved with the document

• Reporting – Template author selects Morphit

tables/worksheets that are available for reporting

Morphit ELN Section Overview

• Add Morphit section to Notebook Template

• Import Morphit binder into Morphit section

• Click Configure Section icon

• Select Notebook property sets that should be available to the binder for indexing

Setting up the Morphit binder

Morphit Section Configuration

• Mapping binder data/metadata to ELN properties

Demo

Mapping Notebook Sections

• The following Notebook sections can be mapped for data transfer with the Morphit section – Form sections with data of the following Notebook widget types:

• Checkbox • Combo Box • List Box • Textbox of the types Date, Integer, Real (Double), and Text (String)

– Table sections that are not of the “Master-Detail” type, which include: • Generic “Table” sections • Equipment sections • Any Materials sections that do not contain multiple sub-lots for a single material

• Mappings are between the property set definitions (PSDs) used by the Notebook section

to fields in a Morphit table – Supported property class types are String, Integer, Long Integer, Decimal, Double, Boolean,

DateTimeOffset, Value, Structure and MolecularFormula

Mapping Limitations

• A Morphit table may be mapped to only one Notebook section – Tip: Morphit linking and borrowing features can be used to bypass this limitation

• A Notebook section may be mapped to more than one Morphit tables

• Data mapping is unidirectional – a single Morphit field cannot receive from and return data to Notebook

• Sending data to Morphit – Data can only be sent to top level formula fields in a Morphit table – Tables containing top-level borrowed fields may not receive data from Notebook

• Returning data from Morphit

– Only indexable properties can be mapped – Only the following Morphit data types can be returned: Formula, Hyperlink, Drop Down, Check Box,

Date/Time

Mapping notes

• When mapping table sections to a Morphit table, hidden fields are used to track rows between the applications

– Thus, the application will be able to manage addition and removal of rows from either application

• When mapping a form section to a Morphit table, a single row is created in the Morphit table

– Any additional rows are deleted

Summary

• Morphit is a powerful templating and analysis tool. The Morphit Section brings that power to the Accelrys ELN and makes the data available via the ELN’s property system

• Other Notebook sessions that may interest you – (ATS4-DEV07) How to Build a Custom Search Panel for Accelrys ELN – (ATS4-DEV08) Building Widgets for the Accelrys ELN Home Page – (ATS4-APP08) Managing Notebook Configurations with ADM – (ATS4-APP09) Tips and tricks for managing Accelrys ELN server performance

• Resources

– Notebook IT/Admin forum on the Accelrys Community • Email support@accelrys.com to join

– Troubleshooting guidance: support@accelrys.com