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
• 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

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