Looking for the best way to combine records using IPA v11 with LSF v10 –on premise I have an Inbound delimited file with 65 fields.  I only use around 20 fields.  The records are in no particular order, usually less than 50 records. I need to combine the records that have the same number in field-11 (F-11).  There are only 4 fields that have different data if F-11 matches. My preference is to create array fields, for the 4 with different data and combine the matching records into one wi...

Hello and Happy Friday, everyone! I am trying to import data from the csv file (no delimited comma, just the regular csv file) to an external Oracle db table by using the DataIterator with the Reading by File and Reading by File but it takes so long like 45 minutes for just 800 records vs a 2 min in SQL Developer to finish. Can someone please advise if there is a better way to do the import beside the DataIterator thing Thanks in advance.

Hi Team, Need your expert advice  I have to read multiple files from a FTP server directory update the data in file and append it in once file. I have used FTP node to get the file in Server and then use file access node to read the file in memory and then use Data Itarator to read each line content and replace some content using java script,but how can we read all file from a directory as we have to give name path in FTP. i have to read all .ord file fron directory. I am using Infor...

Lawson environment 10 LSF on one windows 2012 VM and Landmark on another windows 2012 VM.  IPA (Processflow) running on the Landmark VM.  Using designer 10.1.1.48 and using the SysCommand node to run a COPY or MOVE command.  The flow works fine if the source and destination for the file location is either the C or D drives of the LSF server (D is where LSF is installed).  But if we want IPA to move the file to a network location it fails, even if we map a network drive on the server (K).  Can co...

I should be alittle more specific... I'm having difficulties narrowing down documentation(purpose and necessity) for this table. We have migrated over the years from being a lawson core user of workflow in which we used tasks and approvals.  Back then if a user was not defined in the PfiUserProfile table they had no access to inbaskets, approvals, etc.  Over the next several years we migrated our inbaskets and approvals over to landmark.  We are now migrating up into the OS system and have chang...

Our requirement is to update JobRequisitions if certain fields change on the Position.  One of the fields to be updated is Description. In this example, the Position.Description is Post Graduate  Year 3&4 When attempting to update via a landmark node, the resulting JobRequisition.Description value is 'Post Graduate  Year 3 According to the Landmark node documentation, special characters need to be preceeded by a backslash.  We've attempted every variation we can think of and none seem t...

I know you get at the alternate rates using a button on hr11 to go to hr14. If I need to alter rates in a flow, how do I format the ags To call hr14

Infor recently instituted a 1 GB memory limit warning message on Cloudsuite MT that comes as a error in the workunit logs.It has then been hastily updated to 100 GB but it is impacting flows that are used as extract flows out of  Landmark.   Ways to reduce the memory load other than reducing the number of assign nodes and writing to messagebuilder and then ftping to file at every 100 records or so. The memory consumed in Landmark calls is huge. any way to reduce that

We have flows that send out emails with buttons, so users can approve/reject without logging on to Lawson. Has been working for many years. Recently, the site changed their authentication from SAM to UPN. This seems to have broken something. Users are now forced to login to Lawson to take action. The system property 'emailActionAuthenticationRequired' was not there. tried creating it and setting it to true/false. No effect. One theory floated is that the email server still uses SAM auth...

Any suggestions as to how to trigger the IPA after PR140 I could add a WebRun node with PR140 submission, but wanted to see if you all know of other options. No Design Studio, and we are on a Single Tenant, Hybrid instance of S3

We use LBI dashboards for ESS functions.  During the 2 days of payroll processing we need to disable/hide the direct deposit bookmarks.  What I'd really like to do is swap for a flat page that says something about calling the payroll department or wait until Thursday.  I know folks disable different forms/tokens during their payroll processing.  What is the best way to handle  Can I use a flow to swap the 2 pages out during those days TIA - Karen

Hello, is it possible to construct a automation workflow in lawson Infor Process designer (IPD) for disabling the employees from Active Directory when they get disabled from Infor

I have a fairly simple flow.  A user places a file in a specific location - a File/Channel in Rich Client detects the file, passes it to the LSF server and then a Lawson job is kicked off (via webrun node) to process the file.  It's a CSV file with vendor numbers - the batch program they are being passed to is doing an invoked of AP10 to inactivate the vendors. I ran it with 10 records, 100 records and 1000 records and it worked perfectly.  I then decided to drop 50,000 records in the.  The j...

I need to pass a list of employee status codes into the flow and put them in a simple array. From the log: FromStatusCodes = A1,A2,A3,A4,A5,A6,A7,A9,MD,ML,RW,WC - this list was hard coded in the start node of the flow ['A1','A2','A3','A4','A5','A6','A7','A9','MD','ML','RW','WC'] - field is defined as array   testInt1 = A2 - from FromStatusCodes[1]; ToStatusCodes = ['A8','SV'] - this list is coming from rich client - field is defined as string testArray = [Ljava.lang.Object;78d48440...

Below is from Log file with LM Admin error message.  Cannot find info on errorCode = 32.  Infor Support has not provided solution yet.  Your assistance is much appreciated. - Scott Kelley        ImportData_errorCode = 32      ImportData_informationCode = 0      ImportData_returnMessage = Landmark Admin ImportData: Command dbimport failed with error com.lawson.bpm.coreutils.PFIException: Landmark Admin ImportData: Error file: error      ImportData_outputData =       Landmark Admin...

I have a custom batch program submitted through IPA in webrun node.  The custom program displays total records processed and errored in joblog output in job scheduler.  Is there a way to capture that and include in an email to the users (email node is part of the flow already)  TIA

How do you get employee audit records into IPA if you are on MT We need to check each employee if he was full time at any point in the year to check if he is eligible for benefits. What is the best way to get all employee audit records for a particular employee in IPA for things like relationshipstatus, payrate , hourly or  salary or SSN for a full year. I am not looking at as of date  values . i am looking for all  audit records in a calendar year for an employee for particular fields.

As part of our migration to Cloudsuite we need to convert a 4GL program that reads a CSV file, sorts it by certain fields like company and accounting unit and then passes the summarized data for that company and accounting unit etc as journal entries into Cloudsuite. This was very simple in 4GL but not sure how to do this in IPA. Any other way using a Infor provided tool that can do this like application studio or birst is also welcome.

Has anyone used an IPA to check an email box, read subject and/or body, and process an attachment (save it to a file server) Microsoft publishes the service reference (example below). https://docs.microsoft.com/en-us/ex...achmentids IPA/IPD 10.1; S3 applications We are currently doing this with a .net application.  The business requirements are changing for 2020 so I have to touch the .net application.  If I could move the whole process to IPA that would be much better.  If you'v...

I need some advice on the best way to send an individual email to multiple people with different data. Info: IPA triggered when receive a file. Comes multiple times a day. Has less then 50 records. Each file will contain multiple records for the same SA, however the file is in a random order.  I need to send One email to each SA containing information about each record processed for them.  The email can be sent for each file or once a day. I've consided:  1. creating an array for unique ...

I have a very simple Lawson Query to look up a code I'm providing and see if it exists on the PA16 for specific user.  I send the company, employee, and code and it mostly works fine.  Unless there is a space in the code (ie: A SECADM).  The lawson query wants to send the look up request as 'ASECADM' instead of the space.  I've validated the node works without a space. I've validated that the record I'm using DOES have the A SECADM code.  I've tried using 20 and the node comes up with 2520.  ...

How do we create a lookup table in IPA I am basically trying to store a cross reference between GHR and S3 employees for the 100 odd employees that have different values in GHR for a multitude of flows that we already developed over S3 HR. Basically I plan to store the pfixrefvalue in a Javascript array and then refer that rather than making a landmark transaction call again and again. However I need to store both company and employee fields as an index in the array. Any ideas. Is object ...

Hi  We have a requirement where the user may require to dynamically reassign a pending user action to another user. We are already using the TimeOut functionality to reassign after 3 days but that is also predefined users or tasks. Is there a way a user can be passed as a variable value to a useraction.  I was thinking if it would be possible to send the user actor name as the value in reason comments and pass it as a value in next useraction node which will be used to reassign to their se...

We want to add 'Receipt Inspection Entry' URL link to UserAction 'Notify' email, and have fields: Company, Receiver , Inspection Date  populated when User clicks on URL link. Want to add to UserAction on 'Notify' email.  We are on CloudSuite v11.  Anybody know how to do this   Thanks for your assistance.

Hello, I need to create a PF to update the date fields for a job. I have a Lawson Transaction Node to Inquire on the job and an XML Node to parse the output from it so I can get the current settings. I do not have an XSD. I noticed some of the fields have a dash in the name and I'm having a problem when trying to assign the value to a variable. Fields without a dash return a value. For example, XML9300_output.AR580[0].COMPANY, returns the Company. When trying to get the process level using XML9...