Skip to content

StateDMI / Command / FillCULocationsFromList

Overview

The FillCULocationsFromList command (for StateCU) fills missing data in existing CU Locations by reading information from a delimited file.

Command Editor

The following dialog is used to edit the command and illustrates the command syntax.

FillCULocationsFromList

FillCULocationsFromList Command Editor (see also the full-size image)

Command Syntax

The command syntax is as follows:

FillCULocationsFromList(Parameter="Value",...)

Command Parameters

Parameter             Description Default          
ListFile Path to the delimited list file to read. None – must be specified.
IDCol The column number (1+) containing the CU Location identifiers. None – must be specified.
LatitudeCol The column number (1+) containing the CU Location latitude. If not specified, the previous value will remain.
ElevationCol The column number (1+) containing the CU Location elevation. If not specified, the previous value will remain.
Region1Col The column number (1+) containing the CU Location Region1. If not specified, the previous value will remain.
Region2Col The column number (1+) containing the CU Location Region2. If not specified, the previous value will remain.
NameCol The column number (1+) containing the CU Location name. If not specified, the previous value will remain.
AWCCol The column number (1+) containing the CU Location AWC. If not specified, the previous value will remain.
IfNotFound Used for error handling, one of the following:
  • Fail – generate a failure message if the ID pattern is not matched
  • Ignore – ignore (don’t generate a message) if the ID pattern is not matched
  • Warn – generate a warning message if the ID pattern is not matched
 Warn

Examples

See the automated tests.

Lines starting with the # character are treated as comments. If the first line’s values are surrounded by double quotes, the line is assumed to indicate column headings.

An example list file is shown below, which provides elevations for key locations:

#WDID/NAME/Elevation(ft),,
0100501,EMPIRE DITCH,4543
0100503_D,RIVERSIDE CANAL,4533
0100507_D,BIJOU CANAL,4495
0100511,WELDON VALLEY DITCH,4405
0100513,JACKSON LAKE INLET DITCH,4460
0100514,FT MORGAN CANAL,4347
0100515,UPPER PLATTE BEAVER CNL,4289
0100517,DEUEL SNYDER CANAL,4310
0100518,LOWER PLATTE BEAVER D,4247
0100519_D,TREMONT DITCH,4243
0100520,GILL STEVENS DITCH,4224
...

Troubleshooting

See Also