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

APPENDIX 149
2 Drag DB, Data, and XML to the main task window. Create actions according to the
pattern below:
Figure A.6 – Database-to-XML
3 Fill in the properties for each of the components and actions; the Data component has
no properties.
4 Save the task.
Note
This will copy all columns and rows of data from the source table into XML.
Below is a list of more complicated queries:
˽ Including only certain rows or certain columns in the XML file
˽ Renaming columns to prevent duplicates or to conform to other specifications, etc.
˽ Including data from more than one table in the XML file
In the above situations, the task will need to make use of the SQL Query property of the DB-
to-Data action. Create a file containing a SQL statement that creates the data set and assigns
it to the SQL Query property (see appendix). Save and run the task.
Email
Any file created by a task in TaskBuilder (XML, HTML, PDF, Excel, 3 Card or Text) can be
emailed automatically as part of the task by adding an Email component after each file with
an action between them (see Figure A.7).
Figure A.7 – File to Email
You can send multiple files to the same email address (see Figure A.8).