ConnectAll - Flat File adapter Advanced Properties

Products

• ConnectAll SaaS
• ConnectALL
• ConnectAll On-Prem

Issue/Introduction

Created a new Flat File connector in ConnectAll.  It connects successfully.

According to the TechDoc, the next step is to set some values in the Advanced Properties. But this is not very clear. What values should we put in Property Key and Property Value?

Can you please clarity and maybe include an example with screenshot of file path and file names and where to put them in ConnectAll?

Environment

3.7.x

Resolution

Reference - ConnectALL Flat File Adapter

To answer the specific question around advance property setup for Flat File Connection created in ConnectALL, we need this property(dataload.filepath) added to the Flat File connection in order to point to the base directory in SFTP to be able to use in automation.

In below screen capture Propety Key refers to the property(dataload.filepath) that ConnectALL will understand if for a Flat File connection and Property Value is the base location on your SFTP server. 

Now, the base location/directory in Property Value acts as root directory and it's sub-directory is where ConnectALL expects an input file for Flat File Adapter to be used in an automation.

For Example-

• If you want to use file ../ConnectALL/FF/2024/data.csv in an automation, you need to set Property Value to /ConnectALL/FF
• If you want to use file ../ConnectALL/FF/2024/01/data.csv, then you need to set Property Value to /ConnectALL/FF/2024

So, basically, you don't need to mention the directory where your file is but the parent of that directory.