Automate CSV file Processing

 12 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
nlmoran
Veteran Member
Posts: 53
Veteran Member

    I am creating a  custom CSV file via a batch program

    Other than scheduling the Flow to read the file

    How can I automate the Flow?

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
      You can use a "listener" program to detect when the file is created and then a web call to trigger your flow.
      David Williams
      John Henley
      Posts: 3353
        To do that you'd need the ScanFile client which comes with ProcessFlow Integrator and BCI.
        Thanks for using the LawsonGuru.com forums!
        John
        nlmoran
        Veteran Member
        Posts: 53
        Veteran Member

          I have Process Flow Intergrator 9.04  PF Admin Book

          Does not tell me Much on how to set up  ScanFile Client.

          within  Process  Flow?.

          Thanks

           

           

           

          Sam Simpson
          Veteran Member
          Posts: 239
          Veteran Member
            Have you done or created a ScanFileClient procedures in 803?
            Sam Simpson
            Veteran Member
            Posts: 239
            Veteran Member
              Have you done or created a ScanFileClient procedures in 803 before?
              David Williams
              Veteran Member
              Posts: 1127
              Veteran Member
                There are different listener programs so I'm not sure you have to use the ScanFile Client. I haven't done anything with it as yet. Is it available with PFI or only BCI?
                David Williams
                John Henley
                Posts: 3353
                  Posted By ConsultDavidW on 9/30/2008 9:58 AM
                  There are different listener programs so I'm not sure you have to use the ScanFile Client.
                  The only real "listeners" that I'm aware of that come with ProcessFlow are the ScanFileClient and the MQ client (if you use IBM MQSeries messaging). The other "clients" would all be "passive", in that you would need some way to trigger/kick them off. David, what other listeners are you talking about?
                  Posted By ConsultDavidW on 9/30/2008 9:58 AM
                  I haven't done anything with it as yet. Is it available with PFI or only BCI?
                  ScanFileClient is only available with PFI or BCI.
                  Thanks for using the LawsonGuru.com forums!
                  John
                  nlmoran
                  Veteran Member
                  Posts: 53
                  Veteran Member
                    I am trying to determine How the flow will get the Path for the file when running on server.
                    I am using ScanFileCLient with Batch=TRUE and 2 Dataltertor in the Fow
                    John Henley
                    Posts: 3353
                      When BATCH=TRUE, path & filename are passed into the flow in the < ! _inputData > variable.
                      Thanks for using the LawsonGuru.com forums!
                      John
                      KK - Infor
                      Veteran Member
                      Posts: 61
                      Veteran Member
                        Here is a working ScanFileClient cfg

                        ScanFileClient -Procedure FlowName -ScanDir /u02/xxx/yy/m008 -Extension .csv -Batch TRUE -ErrorLogFile /u02/app/lawtest/app/system/ScanFileClient.err


                        And to begin with, first thing I would do is to display the value of teh in an Email node to check whether the path is coming in correctly.

                        If you are not getting any workunit, try running the smoke tests. They are in the Admin guides!

                        Hope this helps!
                        nlmoran
                        Veteran Member
                        Posts: 53
                        Veteran Member
                          My Flow works fine on the Server with Path coded In InputFile of the DataIterator.
                          I assume I put in place of path.?


                          I have learned alot from your Articals on Plfow 9.0 They have been a big help this learning process.

                          John Henley
                          Posts: 3353
                            Yes. Replace your hard-coded InputFile with < ! _inputData > [without the spaces]
                            Thanks for using the LawsonGuru.com forums!
                            John