SMS:File Import Wizard

Step 1 of the Text Import Wizard – File import options

Step 2 of the Text Import Wizard – File format

SMS can import many files generated by other software in their native format. Refer to Importing Non-native SMS Files for a list. For files that are not included in the list, SMS provides the Text Import Wizard.

The Text Import Wizard enables users to import many different types of data into SMS. The Text Import Wizard is initialized by selecting a *.txt file in the Open command from the File menu. The wizard has two steps:

Step 1 – Delimiting Columns

The first step in the wizard delimits the data into columns. The following options exist to delimit the data:

• Delimited – For the Delimited option, typical delimiters are included as well as an option to specify a delimiter.
• Fixed Width – Columns can be specified with a fixed width by clicking on the ruler bar or the window with the data. Break lines can be dragged, and they can be deleted by double-clicking on the break line or dragging them off the screen.

Specify the starting row the data will be imported at. If the data has a row of headings, indicate such and SMS will use the headings in the next step to determine what kind of data each column represents.

Step 2 – Assigning Column Types

The first 20 lines of the file are displayed in a spreadsheet according to the file outline specified in step 1. This step decides what kind of data to be imported (see Supported File Formats). A "no data flag" can be specified for the file. This is a number that, when encountered in the file, tells SMS to mark the value as "NULL" or "no data". For example, a water surface elevation dataset would assign a no data flag to dry nodes.

The data in the columns are identified by selecting the type in the combo box at the top of each column in the spreadsheet. If a row of headings exists, SMS will automatically select the proper type if it recognizes the heading. Otherwise they are Not Mapped by default. The available column types changes depending on the SMS data type selected. Certain column types must be mapped for each file format before progressing to the next step in the wizard. The name of each column is changed by editing the Header cell.

Mapping Options

When reading in a scatter set or mesh data, the following mapping options are available:

• Triangulate data – Triangulates the scatter vertices / mesh nodes
• Merge duplicate – Merges duplicate scatter vertices / mesh nodes based on the specified tolerance
• Delete long triangles – Deletes scatter triangles with an edge length longer than the specified edge length
• Append mesh – Appends the mesh nodes to the existing mesh

Filter Options

When importing a scatter set, pressing the Filter Options button will open the File Import Filter Options dialog. The filter options are useful when reading scatter sets that are too large for SMS to successfully read in. Once the scatter set has been read into SMS, the more sophisticated normals filtering algorithm can be used.

Additional Options

After the data have been imported, the coordinate transformation tools can be used to transform and translate the data.

Related Topics

• File Formats