New to creating ProcessFlows. I created a flow that has three queries, the result of which I can use MsgBuilder and an Email node to send the results via e-mail. I am trying to figure out how to send the results to a csv file. I have tried using the file access node 'write to file' but my results come back on one line. For example if I am returning ID and Name into a txt file, I want to see: ID,Name 1,Tom 2,Mary What is being written to the file is: 1,Tom,2,Mary Can anyone po...

We're just starting our PFI-to-IPA upgrade project.  We're going from a local AIX PFI installation to a remote Windows IPA installation.  LSF is still on AIX/DB2. In PFI ScanFileClient. when the 'batch' option is set to true it passes the fully qualified path for the trigger file as '_inputData'. In IPA File Channel Receiver, when the 'Data' option is set to 'File Name' it only passes the file name as '_inputData'.  It doesn't include the full path. Is there a setting that can be changed to m...

We are experimenting with creating our own custom java trigger API for Infor Process Automation (as described in the 'Creating a Custom Java Trigger API for Infor Process Automation' section of the Landmark InfoCenter). We've been able to use the brief example in the InfoCenter to create a proof-of-concept custom java trigger API, but now we want to take it to the next level. We want to be able to set and pass the flow name/value pairs, set category keys and category values as well as the input...

I need to access a file in IPA and check for it's last modified date. Based on the modified date I'd perform different options. What's the best way to access the modified date of the file

I have a need to schedule a IPA flow to run every 15 minutes. Simple flow that checks for some condition and does an AGS call to a GL Screen to change status, Most of the time it will just kick off, find condition not met and end. The sysadmin is concerned that just running it 96 times daily and the WU's created and other overheads will bring the landmark server to its knees. V10. Anybody does this kind of high frequency scheduling Thanks.   Ragu

Does anyone know what file is being accessed by the method getRMQuery   Thanks, Ludy

We have an approval process sending duplicate email notifications to all users through the User Action node.  We checked the User Configuration and confirmed the users are not duplicated in there.  Any ideas on how to stop/prevent this   Thanks!

I have a New Hire process flow that uses PA31 as one of the Lawson activity Nodes.  The data being processed comes from a flat file and occasionally contains French characters.  When I review the log from the work unit I can follow the flow and see where the French character is displaying correctly right up to the point where PA31 stores the data.  Here is the AGs call: https://lawsonsitapp10.gfs.com with string _PDL=S100&_TKN=PA31.1&_EVT=ADD&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&APL-COMPANY=1&AP...

Does anyone have a simple flow to determine when an employee last signed into the Lawosn application (that they would be willing to share as a ample/point of reference) At this time of year, we get inundated with numerous help desk calls that users are unable to log into Lawosn. Often times ,we investigate, find nothing wrong with their profil and leave messages for the user to contact us back. However, they frequently do not respond, thereby leaving us to waste our time chasing them down befo...

What database/table is the PFI Schedule details stored in  Looking to do a quick dump as a reference using SQL if possible but cannot seem to locate the table where this information is stored.   Thanks!

Any ideas or suggestions are appreciated.

Whenever I attempt to configure an M3 Transaction node in the Process Designer application, I am given an error upon clicking 'Build' in the properties pane.    After clicking OK the M3 Program Query Wizard does launch, but there are no M3 programs/transactions available to choose from. The program should have a list of available APIs, and when selected the available transactions for the selected program should populate.  Here is the console

I am new to IPA and javascripting but so I was wondering if anyone can help me on how to create a fixed length field for use in an Assign node.  I have a field that can vary in length that I need to include it in a flat file interface I have been able to use 'addTrailingSpaces' but this wont work when the data in the field are different lengths.  Probably an easy solution but I cant seem to find anything that works...Thanks in advance for any assistance you can provide!

We had a custom approval flow created for our RQC approvals.  Users typically click a link in a notification email that launches the S3 Portal application for them to view their inbasket.  After approving a requisition, occasionally the screen will revert to the users task list and what they call 'nonsensical' data.  They are unable to easily get back to their inbasket to approve additional requisitions and is causing some confusion.  Has anyone else had this occur  Trying to determine if there...

Anyone have the latest IPA install guide  Infor Extreme is useless for finding documentation. I'm really looking for the list of Infor provided IPA flows and their descriptions.  I'm thinking I've seen them in the install guide.

Hi all,   Hopefully this isn't a duplicate as I've been looking all over for an answer to this.   I've been working with a Multi-Tenant instance of LTM.  If you're not aware, in this configuration, you're not able to use the SQL Query node to retrieve information from the database.  This is posing a bit of a problem when attempting to get at the audit data behind the Employee record.   In short, I'm attempting to get when the Relationship Status and Work Type change on the Employee (Resour...

I'm looking to create a list of our active ProcessFlows and the node types utilized in each flow - or a list of unique node types used in each flow. I was thinking of using a Landmark transaction to find a list of active flows and the current version, a second Landmark node to query the version to pull the FlowXML. Not sure how to parse the xml to leave me just with a list of the node types. Any ideas Thanks Joe

Is it possible for a User Action node notification message email to include a file attachment

Hello, I query a table and add values to a Message Builder array (var1) then run another SQL to check if the value is part of 'var1'.   I'm using a Branch to determine if I need to add or remove Security access. My branch condition is    var1.includes(SQLQuery8410_POSITIONCODE);    The problem is it skips it, even if the POSITIONCODE is in the var1 array.   Any ideas how I can tackle this   Thank you!

I am looking at ways to loop through the content from an S3 report such as BN101 and then to perform an action on each record.  One way is to use bldxffiles to turn it into a pipe-delimited csv and then iterate through that.  While that will work, I want to see if anyone has instead converted a report to XML and then used the For Each to iterate through the nodes successfully.  I attempted it earlier today, and ran into issues first because there aren't any published schemas for the report xml (...

Has anyone used the Data Transformation node in IPA...WE are trying to figure out the data transformation node mapping file....

Hello,   I am working on a flow in IPA for Leave of Absence Processing.  In the flow there is a User Action Node where the end user choose one of the following actions:   Employee Returned from Leave Employee Failed to Return (Terminate) Extend Employee Leave I need a way to get the effective date of the action, but this may not be the same date as when the User Action was completed.  Lawson recommended having the end-user put in the date as a message on the action, which I have formatted...

We recently upgraded to v11 Landmark (v10 LSF) and we want to revisit the proxy functionality now that it will proxy tasks rather than roles.  One concern that has come up is if someone were to assign a proxy to someone who is not of the appropriate leadership level (i.e. a Director setting up a manager under them as a proxy).  One way I was thinking to avoid this would be if I could trigger a flow when someone creates a proxy record that would check if the person is of the appropriate level, an...

Hello,   I am working on a flow that is triggered from LP51.  I am running into an issue though if there are multiple people that have the leave in a pending status.  For example I have an employee EE 202065 that has a personal leave entered, but the flow has stopped on a User Action Node to determine the employee's eligibility.  Then I put in a leave request for EE 200367 (myself), however, when the flow runs it is pulling the employee with the higher number.  I could add some Lawson Transa...