File Routing Based on a record’s Success or Failure

The latest version of IMan has been enhanced so the File (and FTP) tasks to support expando fields. This means you can refer to a field in your dataset from within the File task options, and because of this you can now conditionally ‘route’ files.

Steps

In the Read transform of the integration include the field SYS.INPUTFILE.

Split the dataflow into two and place a filter transform on each branch and then add a File task to each Filter transform using an expression to filter the success and failed transactions, creating Success and Fail branches.

Route the SYS.INPUTFILE field (or the field containing the field name) to each of the File tasks so that it can be referenced.

File Task Setup

The Source File field now refers to the field from the read transform; and because it’s an expando it needs to be fully referenced with the record id and field name.

Another improvement to the File task is the Source Directory no longer requires populating if the Source File is rooted i.e. it is a full path, not just part of the name.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close