   |
|
Input Tools - Flat File Import Tool
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
Works with other Tools
These are other Tools that this Tool will interact directly with whether by exposing information to it or consuming information from it.
- Call Procedure
- Format as Text
- Format as HTML
- Run Crystal Report
- File Transfer (FTP)
- Save as File
- Run Program
- Call COM Object
- Run VB Script
- Decision
- Data Filter
- Recordset to XML
- XML to Recordset
- Send SMS (M:Science)
Dependencies
These are other products, technologies, protocols or systems that are required for the tool to work.
- None
Consumes
Objects that the Tool consumes that are exposed by other actions. Match these with `Exposes' in other Tool specifications.
- File name and path
- Flat Files (delimited or fixed width) on disk
Exposes
Objects that the Tool exposes that can be utilised by other tools. Match these with `Consumes' in other Tool specifications.
- File name and path
- File properties
- XML Documents - Hierarchically structured information
- Recordset - Information Structured into Columns and Rows