File Import Utility

XML DocumentImport
This tool allows XML files on disk (local or UNC) to be imported into TaskCentre. It can retrieve a specific file specified or from a previous step, or a wild carded file name. If a wild carded selection is made it will retrieve the oldest file first so can be used to process files in the order that they are created. When importing the file it will validate the file against a schema. This schema can be imported if it has been supplied, inferred from an XML file and if necessary manually modified to apply additional validation. An option is present to allow file properties to be extracted and for these to be used in subsequent steps in the task. The contents of the XML document imported can be consumed by other TaskCentre tools that consume XML such as connector tools, the XML to Recordset tool or Save as File.   Flat File Import The Flat File Import provide the ability to import flat files such as plain text or csv (delimited or fixed width), extract data from flat files and expose that information as either a recordset or XML for use in other TaskCentre BPM Tool, Import flat files types that have multiple record types i.e. orders and product lines within a single file and import flat files in sequence so that business applications are updated chronologically. Common commercial uses for the Flat File Import Tool may include: Integrate data that has been exported from one business application as a flat file to another business application e.g. ERP to CRM Integrate accounting or sales force spreadsheet data by event Integrate bank reconciliation data with your ERP solution Integrate CSV or Text files exported from courier systems Integrate sales data from ecommerce solutions or EDI gateways into primary business applications