Writers¶
The writer transforms have the ability to export an IMan dataset to a specified file, Url, or database.
These are highly flexible and customisable transforms, which are able to support hierarchical data, and export data in a variety of forms:
CSV Writer¶
For the ability to write a Character Separated Value file.
Database Writer¶
To insert or update records in any ODBC or OleDB compliant database.
Excel Writer¶
Excel spreadsheets, with potential for formatting when presentation is important, see .
Fixed Width Text Writer¶
To create a Fixed Width Text file.
Form URL Writer¶
To post url encoded key/value pairs, including multi-part requests.
JSON Writer¶
To write JSON data to either an HTTP Url or to a file.
Redirect Writer¶
Provides the capability to send 301 or 302 redirect responses to any WebAPI request.
XML Writer¶
For more information about using XPath expressions to generate XML files.
Any Writer > Audit¶
Auditing & Error Handling¶
If a writer encounters an error, it will stop completely.
Supported Counters¶
- PROCESSED
- Incremented for each record being written.
Error Handling¶
Any errors, irrespective of the ‘Action on Transform Error’ setting will cause the transform to abort.