Automate CSV file Processing

 12 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
nlmoran
New Member Send Private Message
Posts: 0
New 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 Send Private Message
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
Send Private Message
Posts: 3351
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
New Member Send Private Message
Posts: 0
New 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 Send Private Message
Posts: 239
Veteran Member
Have you done or created a ScanFileClient procedures in 803?
Sam Simpson
Veteran Member Send Private Message
Posts: 239
Veteran Member
Have you done or created a ScanFileClient procedures in 803 before?
David Williams
Veteran Member Send Private Message
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
Send Private Message
Posts: 3351
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
New Member Send Private Message
Posts: 0
New 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
Send Private Message
Posts: 3351
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 Send Private Message
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
New Member Send Private Message
Posts: 0
New 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
Send Private Message
Posts: 3351
Yes. Replace your hard-coded InputFile with < ! _inputData > [without the spaces]
Thanks for using the LawsonGuru.com forums!
John