From XMS Wiki - http://wikis.aquaveo.com/xms/
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
|
