FSM Connect - Folder Listener for .csv and update Primary Table

Update 

I think I have figured this out.

When the monitor engine picks up the file, I have set-up a Process ID to set the value on INVOICE_STATUS via a Business Rule. The CSV Integration Map runs it through and ‘On Transaction Validation’ runs an Explicit Call Value BR to update the Invoice Status.

Maybe that’s wrong but at least I now have it working.

Ideally on an inbound integration it would have been great to specify your own columns and data to update. Maybe there is a reason for that, any feedback would be greatly appriciated.

Cheers Ady

Hi @Lee Pinchbeck,

To be honest I had tried a number of things.

One where the mapping was like the above thinking the update process would inherit the value set against Invoice Status, but not extracting any data from the .csv for the column.

I have now been able to achieve what I need by triggering a BR from the integration, but I was hoping the simplistic approach above would have worked. I hope I have explained it ok.

Ady

Hi @Lee Pinchbeck 

Thanks for coming back to this.

The file itself is being generated by FSM, and I am posting that into a middle layer connected to SAGE. That program is then moving the files to a ‘Posted’ or ‘Failed’ folder. Therefore the file being picked up by the listener is the same as I am posting. But I am using the folder location it drops into indicate if it’s been successful or not.

I hope that makes sense. But I would have liked to configure a column / value within the .csv maps to handle column updates

Ady