IPA - reading CSV file

 5 Replies
 2 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Scooter
Veteran Member
Posts: 83
Veteran Member

    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
    Veteran Member
    Posts: 476
    Veteran Member
      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
      Veteran Member
      Posts: 83
      Veteran Member
        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
        Veteran Member
        Posts: 87
        Veteran Member

          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
          Veteran Member
          Posts: 83
          Veteran Member
            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
            Veteran Member
            Posts: 87
            Veteran Member

              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.