Best Way to Get Data From .csv File Into a Process?

追蹤

Loren Bratzler

• 2020年01月16日 13:48

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?

0

• 

  Loren Bratzler

  • 2020年01月22日 21:07

  Giving this a bump.  Anybody have any suggestions on a good way to get .csv data mapped into a process?  I would really like to learn more about the Excel Read activity as well but I don't seem to be understanding how to make it work.

  0

  評論操作 永久連結
• 

  sysberry GmbH

  • 2020年01月22日 22:18

  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

  0

  評論操作 永久連結
• 

  Loren Bratzler

  • 2020年01月23日 14:20

  Alexey,

  I had thought about using PowerShell but I'm not sure I understand how that would work.  When you say "output it to AgilePoint", what do you mean?

  Loren

  0

  評論操作 永久連結
• 

  sysberry GmbH

  • 2020年01月23日 14:31

  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

  0

  評論操作 永久連結

請登入寫評論。