PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/09/2020 2:38 PM by  Todd Mitchell
IPA - reading CSV file
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Scooter
Private
Private
Veteran Member
(160 points)
Veteran Member
Posts:74


Send Message:

--
01/09/2020 12:17 PM

    Can IPA read a CSV file from a laptop C: drive?   We are on Cloud v11.

    Or, must CSV file reside in another directory? Landmark?

    Thanks.

     

    Ragu Raghavan
    Private
    Private
    Veteran Member
    (1113 points)
    Veteran Member
    Posts:387


    Send Message:

    --
    01/09/2020 12:56 PM
    I have run flows from the Designer and processed files on the laptop. However when run from the rich client, how will it know that the folder (for eg. c:\myfolder) you are referring to is on the laptop and not on the LM server?
    Scooter
    Private
    Private
    Veteran Member
    (160 points)
    Veteran Member
    Posts:74


    Send Message:

    --
    01/09/2020 1:52 PM
    We are running flow from IPA Designer, i.e. "local" processing.
    Running from Rich Client, IPA would not have access to C:\ drive.
    Files must be on Landmark.
    Anyone please correct me if above statements are incorrect.
    Todd Mitchell
    Senior IT Specialist
    Gordon Food Service
    Veteran Member
    (207 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    01/09/2020 2:06 PM

    The files that IPA are processing do have to be on the Landmark server.  However, I utilize file channels which can pick up (we use sFTP) files from a non-Landmark server and then process them.

    Scooter
    Private
    Private
    Veteran Member
    (160 points)
    Veteran Member
    Posts:74


    Send Message:

    --
    01/09/2020 2:23 PM
    Todd, can you explain File channels and use of sFTP?
    Are you using SysCmd node to execute sFTP command that retrieves the non-Landmark file?
    Todd Mitchell
    Senior IT Specialist
    Gordon Food Service
    Veteran Member
    (207 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    01/09/2020 2:38 PM

    Within Rich Client, Under Proces Flow Administration, there is the ability create/maintain File Channels (Channels Administrator).  We use the File Channels portion of that.  The file channel itself does not utilize the SysCmd per se, WIthin the setup, you give it the Host, Path, username and password.  Then you give it a File Channel Receiver -- here is where you tell it what IPA flow you want it to execute when it finds a file that matches the criteria specified.

    Within the File Channel process, IPA actually "picks" up and removes the file from the host.  

    You are not authorized to post a reply.