Wavetronix Command Translator (CMD-DT) - User Guide - Manual (Page 114)

CHAPTER 10 • TASKBUILDER ACTIONS 113
Note
In version 1.0 of TaskBuilder, only Collector traffic 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 traffic data schema using other techniques, this action
will fail.
The Data-to-3 Card action has the following properties:
˽ File Operation (Choice) – The File Operation property allows you to select from the
following options when creating a text file:
• Append – The new data will be added to the end of the existing 3 Card file without
overwriting it; a new text file will be created if one does not already exist.
• Overwrite – The new text file will overwrite any previous text file with the given
filename on the system; a new text file will be created if one does not already exist.
• Sequential – The new text file will add a timestamp string to the end of the given
filename, allowing new files to exist along-side old files. Each file will have its cre-
ation time and date marked in the filename for easy reference.
˽ Aggregation Type (Choice) – The 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) – The State property allows you to choose the state in which the sensors
are located using the 3 Card state code. The options are the 50 US States, the District of
Columbia, Puerto Rico and the ten Canadian provinces.
˽ Mapping (Value—Map) – The 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
The XML-to-Data action creates a dataset in memory from the contents of an XML file
(see Figure 10.7). The schema of the resultant dataset is the same as the XML schema of the
source file.