Data sheet and data list basics - Integration - Update 44 - Help - Hexagon

Integration Help

Language
English
Product
Integration
Search by Category
Help
Smart 3D Version
12.1 (2019)
Smart Construction Version
2019(7.0)
SmartPlant Foundation / SDx Version
10
Smart Electrical Version
2019 (9.0)
Smart Materials/Smart Reference Data Version
2020 (10.0)
Smart P&ID Version
9 (2019)
Smart Review Version
2020 (15.0)
Smart Engineering Manager Version
10 (2019)
Smart Interop Publisher Version
13.1 (2019 R1)
Smart Isometrics Version
7.0(2019)
Spoolgen Version
9.0(2019)

The following table provides information about the icons that are part of the data sheets and data list functionality.

Template icon

Details

DataListShowHistory

Show History displays the changes made in the current edit session. Changes are indicated by a red triangle in the upper-right corner of a cell. Rest the cursor over the triangle to view changes.

DataListProperties

Properties expands the task pane and displays the properties for the active cell.

DataListNewButton

New creates a new object in a data sheet or data list.

DatasheetDelete

Delete deletes an object from a data sheet or data list.

datasheetrelate

Relate searches for similar objects, adds them to the data list, and relates them to the parent object.

DataListSave

Save saves changes to the online data sheet or data list to the SmartPlant Foundation database. You cannot save when you are editing offline. To save an offline data sheet or data list, click File > Save in Microsoft Excel.

  • You can change the transparency level of the task pane by using the Opacity control below the properties display.

  • To move the task pane, click the logo and drag it to another position.

  • In SmartPlant Foundation Desktop Client, click Find > Data sheet Documents to find data sheet documents.

  • Do not use special characters in mapped property names. Special characters include: | . - ! ? + ' % , ; & ~ * < >.

Adding values to data sheets

  • Properties with defined enumerated lists display as a list of values that you can choose. Click the box, and then select the correct entry from the list.

  • Depending on how the data sheet template was configured, you can define the unit of measure (UOM) for the entire row by entering a value in the Units column, or you can define a unit of measure for any particular value.

  • For options that require a UOM, select the UOM from the list first, and then provide the applicable value.

  • The data sheet can be configured to use a group of radio buttons for enumerated properties rather than a list.

  • For options that require text, click the box, type the appropriate text, and then press ENTER.

Adding values to data lists

  • Properties with defined enumerated lists display as a list of values that you can choose. Click the box, and then select the correct entry from the list.

  • Option buttons are supported in the spreadsheet. The data list can be configured to use a group of option buttons for enumerated properties rather than a list.

  • For options that require text, click the box, type the appropriate text, and press ENTER.

  • For options containing a list, click the box, and then select the correct list entry.