Wavetronix Command Translator (CMD-DT) - User Guide Manual de usuario descargar pdf (Pagina 114)

CHAPTER 10  TASKBUILDER ACTIONS 113

Note

In version 1.0 of TaskBuilder, only Collector trac data tables can be converted into 3

Card format. If the Data component is not taken directly from a Collector database,

or converted to the Collector trac data schema using other techniques, this action

will fail.

e Data-to-3 Card action has the following properties:

 File Operation (Choice) – e File Operation property allows you to select from the

following options when creating a text le:

 Append – e new data will be added to the end of the existing 3 Card le without

overwriting it; a new text le will be created if one does not already exist.

 Overwrite – e new text le will overwrite any previous text le with the given

lename on the system; a new text le will be created if one does not already exist.

 Sequential – e new text le will add a timestamp string to the end of the given

lename, allowing new les to exist along-side old les. Each le will have its cre-

ation time and date marked in the lename for easy reference.

 Aggregation Type (Choice) – e Aggregation Type allows you to select from the fol-

lowing options when compiling the volume data:

 By Lane – Each lane is compiled into a separate line of data.

 By Sensor – All lanes of each sensor are compiled into a single line of data.

 State (Choice) – e State property allows you to choose the state in which the sensors

are located using the 3 Card state code. e options are the 50 US States, the District of

Columbia, Puerto Rico and the ten Canadian provinces.

 Mapping (Value—Map) – e Mapping property allows you to map the source col-

umns within the dataset to the table columns inside the destination database. To edit

mapping, click the Edit button on the Mapping property box and this will open the

Mapping sub-window (see Chapter 11). If the database connection parameters are not

inputted correctly before clicking the Edit button, a sub-window will inform you that

the parameters are incomplete and a connection to the database could not be made.

XML-to-Data Action

e XML-to-Data action creates a dataset in memory from the contents of an XML le

(see Figure 10.7). e schema of the resultant dataset is the same as the XML schema of the

source le.

1 2 ... 109 110 111 112 113 114 115 116 117 118 119 ... 155 156

Sin comentarios

Wavetronix Command Translator (CMD-DT) - User Guide Manual de usuario Pagina 114