Excel, File name placeholders – Wavetronix Command Translator (CMD-DT) - User Guide User Manual
Page 104
CHAPTER 9 • TASKBUILDER COMPONENTS 103
Note
In the current version of TaskBuilder, only a specific set of Data components can be
converted to 3 Card because it is such a strictly defined format. Currently, only Data
components created from Collector traffic data tables or XML files are eligible for 3
Card conversion. For other data types the task must be designed to translate the
source data into the required Collector format through a specialized Database-to-
Data conversion or an XML-to-XML conversion.
Figure 9.8 – 3 Card Component
The 3 Card component has the following properties:
˽
File Name (Value—Filename) – The File Name component allows you to enter a name
for the 3 Card file. You can also use a placeholder for the file name (see the File Name
Placeholders section in this chapter). The 3 Card file will be created on the file system
if it doesn’t already exist; it will be overwritten if it already exists.
Excel
The Excel component represents a Microsoft Excel spreadsheet file (.xls, .xlsx).
Figure 9.9 – Excel Component
The Excel component has the following properties:
˽
File Name (Value—Filename) – Represents the file name for this file. You can also use
a placeholder for the file name (see the File Name Placeholders section in this chapter).
File Name Placeholders
All components that have a file as an output can use placeholders in the file name. The avail-
able placeholders are [date], [time], [datetime] and [dayofweek]. Once the task is executed,
these placeholders will be replaced with the appropriate values (see Table 9.1). Here are