Reading a File in IPA Case Study

By: David Williams
Date: October 16, 2013

Recently a client of ours was having a problem reading a file with the Data Iterator – for some reason it couldn’t “see” the file. They were able to use the File Access to check that the file existed – and it did – but the DI couldn’t see it for some reason.

While they continued to work on a resolution to the DI issue, I suggested another way to approach the overall design. Why not, I asked, read the file with the File Access node?

The File Access doesn’t just check for a file or delete a file, it can actually bring the whole file into IPA. From there you can simply set your Data Iterator to parse the data (FileAccess8960_outputData) the same way you would if you were reading the file from the server.

I’m happy to say that this approach worked, and that it might have another advantage. Now instead of reading each line of data from the server, the File Access allowed them to load the whole file once and then process it within the flow.

David Williams, Principal Consultant

Our Headquarters

Avaap USA, LLC
510 Thornall Street, Suite 250, Edison, NJ 08837

Phone: 732.710.3425
Fax: 732.243.9550

Avaap Midwest 
6 West Fifth Street, 8th Floor, St Paul, MN 55102

Avaap Chicago 
70 W Madison Street, Suite 2610, Chicago, IL 60602

Global Center of Excellence Chennai
Chennai ONE, IT SEZ, Upper Stilt, Pallavarm-Thoraipakkam, 200 ft Road, Thoraipakkam, Chennai 600096. India

Global Center of Excellence Pune
Work Lab 2.0 5512, Ganeshkhind, Aundh, Pune 411007. India

Avaap UK
Stanmore House 64-68 Blackburn Street Radcliffe, Manchester M26 2JS. England

Avaap Spain
Antonio Machado 78, Australia Building 1-A3, Viladecans, Barcelona 08840 Spain

Avaap Amsterdam
Keizersgracht 62-64 Amsterdam, Netherlands 1015CS

Technical assistance for Avaap Managed Services and Product customers: