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

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 ...

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 t...

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!

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

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

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 chang...

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.

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  Try...

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!

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 

Any ideas or suggestions are appreciated.

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!

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...

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&am...

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 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!

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...

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

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

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 

 When a user with their ID goes into Infor MyHR, she sees someone else's name and information and that person has a completely different ID. Terminated employee seems to be the thread, on all three cases thus far, the terminated employee ID has been the common thread......we just went live on cloud v10. How do I query the ERP (or IPA flow) to catch other records  

I am using a LwsnTxn and WebRun node for a PR295 job. I then reference the bldxffiles utility to convert the PR295.prt to a csv file. The csv is not being created because the .prop and .grp files are not being generated neither from the job or the utility. Might anyone be knowledgeable on how to generate the .prop and .grp files with the prt job or   I am using this command: bldxffiles -SCp 382396 D:\lsenv\law/print/INFORBC_382396/pr295-ju/1  PR295.prt     I am ...

I've got a custom htm form I am using for a customization. It's working. It's not a Design Studio form. Design Studio is not available on this environment.   So question, I've tried the 'normal' method of using the portalWnd.AGSPath in the call to WFWK, but, in the html form, it does not work. I've spent alot of time debugging why it won't work. There isn't any error messages, but the javascript function does not like the method of  var s = portalWnd.AGSPath .....   So qu...

IPD v11.0.1.43,  single tenant, cloud, SQL Server. A developer had created a SQL Procedure using the 'Create/Update SQL Procedure' option.  Now that proc is available to me in the 'Run SQL Procedure' option -> Select -> 'SQL Procedure Selector' window. Original developer then deleted that SQL node from his original flow.  The proc exists, but we don't have a copy of the original source. Is there any way for us to view the SQL behind that proc Does it actually create ...