SMS:File Import Wizard Supported File Formats

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

• 2D Scatter Set Vertices
• 2D Mesh Nodes
• UGrid
• 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

UGrid Points

Field	Type	Required	Comments
X	Number	yes
Y	Number	yes
Z	Number	no	Point Zs are set to 0.0 if omitted
Dataset	Number	no	Any number of steady-state or transient datasets can be imported. When importing transient datasets, a dataset name and a time step must be specified for each transient column. Names and time steps are entered into the header row, separated by a vertical slash using the following format: "Name|Timestep". For example, "Dataset1|January 1, 1900". All time steps of a transient dataset should be given the same name.

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

PTM Trap Output Data

Field	Type	Required	Comments
Step	Number	no	Time step index of an entry event for a trap
Date	####/##/##	yes	Date of an entry event - must have a year, month and day
Time	##:##:##.####	yes	This column must have hour, minute and second of the entry event
Particle	Number	no	This column could be used to reference other PTM output files. Not used in import wizard
Trap	Number	yes	Defines which trap this parcel entered
Value column	Number	no	This is an optional column. There may be more than one.
Filter column	Number	no	This is an optional column. There may be more than one.

See PTM Trap Output for more information on reading PTM trap output files.

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

Related Topics

• File Import Wizard
• Data Acquisition