Seam Import Workbook - Intergraph Smart 3D - Help

Intergraph Smart 3D Molded Forms

Language
English
Product
Intergraph Smart 3D
Subproduct
Molded Forms
Search by Category
Help
Smart 3D Version
12 (2018)

An Excel workbook must have specific formatting to import design seams. The stiffener import-export format.xls workbook is provided as a template of the format needed for each seam type. The workbook is delivered to the [Product Folder]\MoldedForms\Data folder. Configuration and Summary worksheets in the workbook are provided only for information, and are not required for import.

Each worksheet represents a type of seam and the attributes of the seam. When a seam has been imported into the model, it is like a seam of the same type created using the command in the software. Attributes on a worksheet correspond to attributes on the Properties dialog or attributes created using a control on the software ribbon.

Multiple seams of the same type may be defined on each worksheet. Each seam definition must end with a Finish row. Multiple worksheets may be defined in the same workbook.

Sections common to all worksheets:

Header-main section

Contains attributes equivalent to using the Main Tab (Seam Properties Dialog) of the profile ribbon.

Name

Name (Main tab)

Type

Type (Main tab). Type DesignSeam.

Header-Bound section

Contains attributes equivalent to using the Boundary Methods step of the profile ribbon.

Boundary 1

Name of the first boundary object. If the boundary is a grid plane, define the name using the grid plane name format, below.

Boundary 2

Name of the second boundary object. If the boundary is a grid plane, define the name using the grid plane name format, below.

Ambiguity

Defines whether the boundaries create an ambiguous solution, equivalent to using the Solve ambiguous boundaries step of the profile ribbon. Type True or False.

The hull is the most common boundary to create an ambiguous solution.

AmbiX

X-coordinate on the selected solution.

AmbiY

Y-coordinate on the selected solution.

AmbiZ

Z-coordinate on the selected solution.

Intersection worksheet:

The section order is: Header-Main, Header-Bound, Header- Intersect, and Finish.

Header-Intersect section

Contains attributes equivalent to using the Seam by Intersection Command .

Method

Type Coincident. This is the required value.

Object

Grid plane used to create the landing curve. Define the name using the grid plane name format, below.

Offset

Type 0. This is the required value.

Offset worksheet:

The section order is: Header-Main, Header-Bound, Header- Offset, and Finish.

Header-Offset section

Contains attributes equivalent to using the Seam by Offset Command .

BaseCurve

Base curve definition. If the base curve is defined by a grid plane, define the name using the grid plane name format, below.

Offset

Specifies the offset value for the landing curve from the base curve.

OffsetMethod

Specifies the method used to offset the landing curve from the base curve. Type Girth, Vertical, Transverse, or Longitudinal.

Projection worksheet:

The section order is: Header-Main, Header-Bound, Header- Project, and Finish.

Header-Project section

Contains attributes equivalent to using the Seam by Projection Command .

SketchPlaneMethod

Sketch plane method used. Type Coincident or Offset. Other sketch plane methods, such as Angle from Plane, Plane by Point & Vector, Plane by Three Points, and Plane by Vectors Normal, cannot be used for import.

Offset

Offset value for the sketch plane if the Offset SketchPlaneMethod type is used. Type 0 if the Coincident SketchPlaneMethod type is used.

Object

Grid plane or object used to create as the sketch plane. If the object is a grid plane, define the name using the grid plane name format, below.

FileName

Type the fully qualified path and the .sha file name containing the sketch curve. If the .sha file is in the same folder as the import workbook, then only the file name is required.

Table worksheet:

The section order is: Header-Main, Header-Bound, Header- Table, Header-IntPlane, and Finish.

Header-Table section

Contains attributes equivalent to using the Stiffener Profile System by Table Command and the Landing Curve Table Dialog.

LCNumber

Sequential number for a point on the landing curve.

PointType

Type Definition or Knuckle.

IntTab.Object

Intersecting object that helps to define two coordinate values of the landing curve point.

X-Reference

X-coordinate of the landing curve point. Type 0 if the coordinate is derived.

X-Offset

Offset value form the X-reference. Type 0 is there is no offset.

Y-Reference

Y-coordinate of the landing curve point. Type 0 if the coordinate is derived.

Y-Offset

Offset value form the Y-reference. Type 0 is there is no offset.

Z-Reference

Z-coordinate of the landing curve point. Type 0 if the coordinate is derived.

Z-Offset

Offset value form the Z-reference. Type 0 is there is no offset.

DerivedCoord

Type X, Y, or Z for the derived coordinate.

Header-IntPlane section

Contains attributes equivalent to using the Intersection Plane option of the Stiffener Profile System by Table Command . This section is optional and is used when the coordinates of only two points are known for a landing curve on a plate system with curvature. See Landing Curve Table Dialog.

BasePlane

Grid plane in which to measure the angle used to define the intersection plane. Define the name using the grid plane name format, below.

NormalToPlane

Normal to Base Plane. Defines whether the intersection plane is oriented normal to the base plane. Type True or False.

MeasureFrom

Defines the plane from which to measure the angle used to define the intersection plane. Type Horizontal or Vertical.

IntPlaneAngle

Angle. The angle of the intersection plane, measured from the Horizontal or Vertical plane.

Configuration worksheet:

Date

The date on which the export was performed. This field can be blank for import.

IntelliShip Version

The version of software from which the export was performed. This field can be blank for import.

User

The name of the active user. This field can be blank for import.

ModelDB

The name of the model database. This field can be blank for import.

CatalogDB

The name of the catalog database. This field can be blank for import.

PlateSystem

The plate system name. This field can be blank for import.

Number Exported

The number of stiffeners included in the export. This field can be blank for import.

CoordSystemSepa

A coordinate system separator character that is not part of the coordinate system or reference plane names.

Use the same character throughout the workbook. "@" is recommended.

Do not use the backslash character. ("\").

Distance Unit

This unit can be meters (M) or millimeters (MM).

Angle Unit

This unit can be Degrees or Radians.

Grid Plane Name Format

If an object is a grid plane, define the name by typing the coordinate system, a coordinate system separator character, and the grid plane name. For example, CS_O@L-21.

Choose a coordinate system separator character that is not part of the coordinate system or reference plane names.

Use the same character throughout the workbook. "@" is recommended.

Do not use the backslash character. ("\").

See Also

Import Seams Command (File Menu)
Import stiffener or seam data