Best Way to Get Data From .csv File Into a Process?
We have an integration process we are working on where a .csv file will be dropped into a folder. We will use an event monitoring service to kick off our AgilePoint process when the file is dropped into the folder.
When the process starts, the first thing I need to do is get the data from the .csv file mapped into process variables. What is the best way to do this?
I have tried looking at the Excel Read activity but I have never been able to get it to work and the documentation on it is horrible:
https://documentation.agilepoint.com/00/appbuilder/cloudenvInstructionsExcelReadDocument.html
What other ways could I get the data from the .csv file into my process?
-
Hi Loren,
With Excel Read you won't get to a result. I would suggest 2 ways:
1) with PowerShell read the file and output it to AgilePoint, then in AgilePoint you could map it the data to variables
2) write a webservice, that will read the csv and then call this webservice from AgilePoint.Regards,
Alexey -
Loren,
with PS you can read the file with script and give the output to AP. I am not sure, if this outpu can be organized as object, but it can be definetely organized as string. If you have this string in AP variable, you could use RegEx for splitting the data to rows and columns, that could be then mapped with controls in AP. Do you understand the idea?
Alexey
Please sign in to leave a comment.
Comments
4 comments