DIPPR v01 Import Dialog
Applicability: Cranium, Synapse (core versions 0315+)

The DIPPR database is an extensive compilation of rigorously evaluated pure component physical property data. The DIPPR version 1.0 database is based on the Microsoft Access database format. This format can be read in by a number of third party software programs. Cranium and Synapse can also import physical property data and estimates from DIPPR version 1.0 database format.

Warning: Import into a 'test' knowledge base first

Both Cranium and Synapse have import capabilities that enable them to add large quantities of values to knowledge bases. These values are often distributed across many chemicals, techniques, and references. Thus the importation of values cannot be undone. We strongly recommend that you: 1) first import values into a new, expendable knowledge base; 2) verify that the values were imported correctly; 3) backup the destination knowledge base (see documenation on Copy Document for details); 4) only then import values into your permanent, destination knowledge base.

Cranium and Synapse create a DIPPR v01 formatted database containing eleven tables. Note that information in some of the columns are applicable only to DIPPR specific activities, e.g., review dates, and thus values for such columns are not imported. Examples of the tables generated by Cranium and Synapse are shown here (note that only the first 250 records of each file are shown):

Example: Import values from a DIPPR v01 Database
  1. Open a Knowledge Base using either Cranium or Synapse.
  2. Click on the File menu and select the Import Values command.
  3. The application will activate the KB Import Dialog.
  4. Select 'DIPPR Database v01 Format' from the Input File Format list and press the Import button. The Import Values dialog is activated.
    Browse button for entering the name of the export file.
    The entity type being displayed. The entity types are Chemical, Reference and Technique.
    List of entities selected that can be imported.
    The properties to be imported. Often you use the All Props button to select all properties for importing.
    The datum status values to be exported. Often you use the All Status button to select all status values for importing.
    Buttons for:
    • All Entities: selects all entities of the currently displayed entity type
    • All Props: selects all properties of the currently displayed entity type
    • All Status: selects all status values of the currently displayed entity type
    • Select Entity: use the Find Entity dialog to find an entity by its name or other attributes
    • Clear Entities: deselects all entities of the currently displayed entity type
    • Clear Props: deselects all properties of the currently displayed entity type
    • Clear Status: deselects all status values of the currently displayed entity type
    • Rename: enables you to rename entities before they are imported into the current knowledge base. See documentation on the Import Renames Dialog for details.
    • Select Entity: enables you to select an entity by matching a part of its name.
    • Bookmark: use a bookmark to select entities
    Import Options: provides several options for how imported values will be added to the current knowledge bases. Selecting an option displays the option's documents in the accompanying text control.
    Export: press this button to begin the import process
  5. Press the Browse button to select the database file from which the imported values will be read.
  6. Click on the Entity Type combobox and select the Chemical entity type.
  7. Select one or more chemicals from the Entities list. Use the Select Entity or Bookmark buttons to facilitate your selection. You can also press the All Entities button to select all displayed entities for import.
  8. Select one or more properties from the Properties list. You can press the All Props button to select all displayed properties for import.
  9. Select one or more status values from the Status list. You can press the All Status button to select all displayed status values for import.
  10. Repeat the selection steps for the Reference and Technique entity types.
  11. Finally press the dialog's Import button. Cranium or Synapse will read physical property data, physical property estimates and estimation techniques parameters from the entered DIPPR database and write these values into the current knowledge base.
Example File

The following example database was contains seven chemicals (acetic acid, cyclohexanol, ethanol, ethyl acetate, n-hexane, toluene and vinyl chloride) and several estimation technique parameter sets. You can use this example database to experiment with Cranium's and Synapse's import capabilities. (See the warning at the top of this page.)

Example File Description
Dippr01ImportDB.mdb A Microsoft Access database file containing values for physical properties and estimation technique parameters.
Related Documentation
Topic Description
Estimating Chemical Properties a short video demonstrating how to estimate physical properties using either Synapse or Cranium.
Getting Started using Cranium provides a quick tour of Cranium's capabilities including a discussion of structure editing.
Chemicals Chapter the chemicals chapter contains numerous sections for entering and displaying data and estimates including the chemical structure section.