We have to create a positive pay file process flow rather quickly. I'm still learning the complicated pieces of IPA and wondering if anyone had this flow or parts of it already created and were willing to share? Or some advice on the best ways to create the different pieces (see below).
Thanks - Joan
Some additional information/questions: Our current production flows are inbound into Lawson, so what is the best way to get data from Lawson if a Service/trigger does NOT already exist? The user will run the PR170 and create the csv file containing the data I need for the flow.
We will also be creating a positive pay file from CB170 or AP265, haven't decided which process to use.
The outbound file to our bank is a fixed width file with header, detail and trailer records. I'm assuming a message builder that reads the header record first all the details and then the trailer record. (Creating a header/trailer file is much easier in IPA then it ever was when I wrote interfaces ;-) but I'm open to suggestions.
Any tips on fixed width fields? Assuming I need to define each field.
Thanks for any insight you share.
A File Channel is what I thought would be best. I haven't gotten far enough to worry about the timing. I know it will be an issue but figured I could put a wait node in the flow or something along those lines. My problem with the File Channel is that I need to pick up ANY file in a specific directory and IPA doesn't like wildcards very much. We've used them in other File Channels but the beginning of the filename is always the same. In my case it will not be the same name. Even if we made a naming convention part of the process/procedure our users wouldn't always do it.
Another idea was to create a trigger when the PR170 was processed. We've created custom forms in Lawson, so I have someone who knows Design Studio(?) But of course the documentation to create a trigger doesn't exist, it just says that you can. I've played with it, but I'm not the System Admin so some of the information I'm not sure about and/or I keep finding more layers to the Service and don't know what really needs to be completed and what doesn't.
Does anyone know if there is documentation to create a trigger/service def, etc. or do you have the steps or list of items that need to be created or modified? My system admins will help me set it up if I knew exactly what needed to be set up.
My Solution: I did get the File Channel/Receiver to work. My process flow starts with a File Access Node to our LSF (Lawson) server, which is different than our IPA/Landmark server.
1. The system configuration for LSF/file access is set up as a remote with the http:\\win1461.ghxyz.com
a. The file access node is using this config.
2. The File Channel is set up as Local with the directory path \\win1461\directory1\dir2\... (even though the Landmark server is on \\win1462)
3. The Receiver is set up with File Name is * (because I want all files in the directory) and the Data field dropdown is File Name.
4. In the process flow the File Access Node is using variables that are created in the work order.
a. ProcessedFileDirectory and FileName
b. The variables do not show up in the Ctrl-Space list. You have to type them in the way they look in the Work Order Variable tab.
c.
d. Note that the File Access Node is using the Processed directory and Not the Monitor directory, because as soon as the File Channel sees a file to process in the Monitor directory it is moved to the In progress directory.
5. The process flow needs to determine file type before it starts the data iteration, which is why I am keeping the file access node, and having the File Name sent via the Channel/work order instead of the File Data, etc…
6. Note: There are some instructions on setting up a File Channel in the “Infor Process Automation Administration Guide”
A couple of concerns/questions. #2 above, what issue can this cause (or what should I look for)? Since the LSF server is not the same as the Landmark server, hence it’s not really Local. Also, I wanted the In Progress directory to be on the Landmark server instead of the LSF server, but I couldn’t get the directory to work. I think I read this could improve processing time and avoid losing the file due to connection issues.
I can’t test the timing of the File being created and the File Channel trying to move it, until next week, so there might be some issues with The file channel, which looks every 10 minutes trying to move the file to In Progress directory prior to the file being finished writing.
yep... Thanks.