SMS:File Import Wizard Supported File Formats: Difference between revisions

From XMS Wiki
Jump to navigationJump to search
(No difference)

Revision as of 19:58, 1 June 2009

The following types of data can be imported into SMS via the File Import Wizard.

  • 2D Scatter Set Vertices
  • 2D Mesh Nodes
  • Feature Points
  • Observation Data
  • Wind, Wave, Water level

A description of the fields (columns) that SMS recognizes when importing text files is provided in the tables below.

2D Scatter Vertices

Field Type Required Comments
X
Number
yes
X-location
Y
Number
yes
Y-location
Pt Name
Text
no
Vector X
Number
no
Used in conjunction with Vector Y Field
Vector Y
Number
no
Used in conjunction with Vector X Field
Vector Magnitude
Number
no
Used in conjunction with Vector Direction Field
Vector Direction
Number
no
Used in conjunction with Vector Magnitude Field
Scalar Data
Number
no
Breakline
Text or Number
no
See Scatter Breakline Options for a discussion of Breakline Delimeters
EXAMPLE
"id" "x" "y" "xylene" "toluene 0.0" "toluene 2.0"
"OW-21" 32.4 5234.3 300 999 999
"0W-22" 93.4 5832.3 84 398 401
"0W-23" 83.3 8438.2 89 47 52

2D Mesh Nodes

Field Type Required Comments
X
Number
yes
X-location
Y
Number
yes
Y-location
Z
Number
yes
Z-location
EXAMPLE
"x" "y" "z"
32.4 5234.3 12.34
93.4 5832.3 13.47
83.3 8438.2 21.54

Feature Points

Field Type Required Comments
Name
Text
no
X
Number
yes
X-location
Y
Number
yes
Y-location
Z
Number
yes
Z-location
EXAMPLE
"name" "x" "y" "z"
"Pt. 1" 32.4 5234.3 12.34
"Pt. 2" 93.4 5832.3 13.47
"Pt. 3" 83.3 8438.2 21.54

Observation Points

Field Type Required Comments
Point Name
Text
no
X
Number
yes
Y
Number
yes
Z
Number
no
Measurement
Text
no
Measurement name. Multiple measurements allowed.
Interval
Number
no
EXAMPLE
"name" "x" "y" "z" "hd" "int"
"OBS_Q5" 23.3 44.2 32.2 567.5 1.2
"OBS_Q6" 83.3 84.3 32.2 555.3 1.4
"OBS_Q7" 85.3 39.3 33.2 999 0

Wind, Wave, Water level

Field Type Required Comments
Date/Time
Number/Number
yes
Date
Number
yes
Time
Number
yes
Primary Height
Number
yes
Used in conjunction with Primary Period & Direction Field
Primary Period
Number
yes
Used in conjunction with Primary Height & Direction Field
Primary Direction
Number
yes
Used in conjunction with Primary Height & Period Field
Secondary Height
Number
no
Used in conjunction with Secondary Period & Direction Field
Secondary Period
Number
no
Used in conjunction with Secondary Height & Direction Field
Secondary Direction
Number
no
Used in conjunction with Secondary Height & Period Field