Format Tools

Consumes and formats information of one type and then exposes that information as another type to other Tools.

Format Tools - Format as Text

The Format As Text Tool is used to create a Task Step that creates single or multiple textual documents, primarily utilising information provided by Input Tools such as the Database Query (ODBC) Tool and requires no global settings.

Format Tools - Format as HTML

The Format as HTML Tool is used to produce single or multiple HTML documents, primarily utilising information provided by Input Tools such as the Database Query (ODBC) Tool. It is possible to create new HTML pages within the interface or import pages that have already been created elsewhere. The Tool uses merge fields to merge data objects into the document and/or insert tabulated data from a source to produce dynamic documents such as order acknowledgements, statements, intranet or web site content or summary reports. These HTML documents can then be delivered using many of the Output Tools.

Format Tools - Run Crystal Report

The Run Crystal Report Tool is used to automate the running of Crystal reports. The Tool can be used to run a report one or many times and allows the use of dynamic data to set report parameters at run-time. The dynamic data could be from an Input Tool such as Database Query (ODBC) whereby the Crystal report could be run once for each row exposed by the query action. For example this could be running a statement for each of a list of customers or producing an order acknowledgement for each of today's orders. The documents then exposed can be delivered by other many of the Output Tools. Utilise new or existing reports designed within the Crystal Reports environment.

Format Tools - Run MS Word Merge

The Run MS Word Merge Tool is used to create a Task Step that creates single or multiple documents in common Microsoft Word formats containing merged data. The Tool requires no global settings.

Format Tools - Create Workflow Job

The Create Workflow Job Tool is used to create a Task Step that dynamically Creates Workflow Jobs. A Workflow Step dynamically generates one or any number of web page(s) containing fields for completion by recipients and publishes them to a web site folder on a specified web server. Each of these web pages is called a Create Create Workflow Job and can be assigned for completion to any number of recipients.

Format Tools - Recordset to XML

The Recordset to XML Tool is used to create a Task Step that converts recordsets produced by other tools such as the ODBC query into XML documents either for use in other tools such as connector tools feeding other systems or saving to file for consumption by another system. Multiple recordsets can be included in a hierarchical XML document.

Format Tools - XML to Recordset

The XML to Recordset Tool is used to create a Task Step that converts XML produced by other tools such as connector tools feeding other systems into Recordsets for use in the many other tools which consume recordsets for uses such as powering alerts via fax/email/sms, create reports, power a workflow, perform FTP transfer, etc.