Excel, File name placeholders – Wavetronix Command Translator (CMD-DT) - User Guide User Manual

Page 104

Advertising
background image

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

Advertising