Using SQL Update (as well as the SQL Query) nodes require locating/downloading and then installing/configuring JDBC drivers for your desired database(s) (e.g., Oracle, SQL Server, DB2, etc.) on your development workstation as well as your Lawson LSF9/ProcessFlow Server. You will also need some knowledge of JDBC connection string syntax. None of this is well-documented by Lawson (nor is configuration support provided by GSC). Here are instructions for installing/configuring MSSQL JDBC for Proc...

We currently have employee pictures in jpg format stored in a file system directory that are created by our employee badge system.  I am attempting to attach these picture to the employees in Talent Management using the Landmark node in Process Automation.  Here is the Landmark transaction string I am using. _dataArea='ltmtest' & _module='hr' & _objectName='Employee' & _actionName='Update' & _actionOperator='NONE' & _actionType='CreateUpdateDelete' & _pageSize='30' & _effectiveDate='20140924' &...

Is it possible to set-up a JDBC connection from an IPA JDBC Driver: jdbc:odbcriver={Microsoft Access Driver (*.mdb, *.accdb)} Database URL: jdbc:odbc://C:\users\karen.sheridan\access\nonemployeeproject\;DatabaseName=nonemployee.accdb I know this won't work on the server side.  But I'm not getting pasted the driver set-up. Test Connection error message: SQL Test Connection: JDBC Driver jdbc:odbcriver={Microsoft Access Driver (*.mdb, *.accdb)} not found in classpath. Please a...

Hi I am new to Lawson! I wrote couple interfaces using COBOL, now I am learning IPA and would like to some assistance how I should read a .CSV file and pars/contact (data manipulation) to create a output file that will feed into database. Any help greatly appreciated. Thanks Jay

Is there a way to define a Report Distribution group to a batch job created using IPA Activity Node LWSNTXN (Lawson Transaction)

Hello everyone, I am trying to change the default file locatoin for PR170 which is (/work directory). I have used jobdef in LID to define a path under (External Name like d:/lsenv/law/lsapps/work/pr170pospay/) but the file keeps going root of work folder. I would eventually have a file channel scan file but I dont want to point File channel to work folder.  Any suggestion would be appreciated. Tx

Which tables do I use  I found the PFIWORKUNIT and can filter on Req Approval with Statuse codes, but how can I link the Approvers  for Approver 1 and Approver 2 and who approved these or denied

We have an IPA that is triggered from a mashup that will timeout after 3 minutes in M3/Smart Office, but the process itself will still run on the IPA Server and finish it's tasks. Is there a setting in Smart Office / M3 where we can increase this timeout time

I have a flow that gets a list of files from a directory.  I then use a For Each along with a Read File to loop through those files.  Within that, I have a Data Iterator when I read through the line in the file looking for specific text.  My issue is, when the Data Iterator process is completed and I go out and get the next file, do the Read File and then Iterate through the lines again, the recordNumber is at whatever it left off at from the previous file.  How do I get it to start a 1 when I g...

I am pulling a datetime string from a text file report in the format of 'Mon Feb 11 11:20:09 2023'.  From this I need to create a separate date string of mm/dd/yyyy and a separate time string of HH:MM:SS 24 hour format.\ The closest I've been able to is using: toLocaleDateString = February 11, 2023 toLocaleTimeString = 11:20:09 AM CST

I created an IPA that monitors for specific system account jobs and attempts to recover them if they go into recovery. It seems to work fine in our Test environment, but in Prod I receive a 'Security Violation'. To recover the job, I am using a System Command node with the jqaction -R command. The System Command node runs as user lawson. The Command error output is 'Security Violation'. The return message is 'System command error: command returned error code 1'. Where can I look to ver...

We are moving from Lawson 10 to Infor Cloudsuite.  In the past when Landmark changes, we had to install a new version.  I heard that a new version will be loaded.  I remember Rich Client worked that way.  Is that correct In the past, I had to install Strawberry Perl.  Is that still the case

Anyone have success with IPA and adding distribution records. I have the node setup and the fields all set via SQL. The first record will add just fine, however the second will error (AGS) with 'Distribution Code Already Exists'. I know the method is 'ADD' and unlike excel upload there is no 'ADD then Change'.  Anyone have correct methofd for doing this

Has anyone had success with IPA and updating security such as deleting the REQUESTER identity for requesters I'm using a resource query node to pull users that are disabled in Security. Next I have a Resource Transaction node set up which deletes the REQUESTER identity for users that are disabled. It works correctly as it is going through and deleting the identity ( REQUESTER identity field is no longer populated in Security) however the idenity becomes orphaned and the system won't allow us to...

Anyone have a sample config for setting up a JDBC connection to MS-Access that they'd be willing to share Is that even possible

Currently, when we trigger a process from a mashup deployed to Smart Office/M3, we get a message formated like this regardless of the outcome of the process: 'The server returned no data' and an exclamation point icon. There are ways to format messaging within Mashups events on MessageBoxControl by setting the TargetKey Parameter to 'MessageType' and Parameter Value to Question, warn, error, or Success. You can also set the Header, and text of the message. However, we can't find anything ...

Hello guyz I am trying to write an IPA to attach pdf documents to employee rercord in GHR. It looks like data is sitting in a EmployeeDocument business class. Please see copy and paste from LMK node below. I am passing file locatoin but system is just attaching a blank pdf and not actaully uploading from an actual file location. Any help will be appreciated. tx

New to the IPA world and was wondering, can an IPA execute a Job that is setup currently in Jobdef If yes, how do you do this Thanks!

Hello everyone, I am new to creating XML files and trying to work with XML node in IPD 11.0.52. I am trying to created loaduser.xml since we can no longer use CSP to upload a CSV file to setup LSENV identity. I am not sure what to put into 'Append output to' screenshot below. I was wondering if someone could upload a sample IPA that creates an XML file.

We're facing a situation where we need to update the PR160 PMTOUT file. However, I prefer not to customize the PR160. Instead, I'd like to execute the IPA after PR160 completes successfully. Is there a way to trigger an IPA from within PR160 How do I execute the IPA from batch program.

I'm looking for how others are performing a conversion of a UTC Date (or any time zone date) to EST Date in Javascript. The requirement is to have a date/time specifically in EST timezone to write to a user business class/field. I'm developing a IPA in Cloudsuite and at this time we are unable to have the Default Coroporate or System time zone changed to EST.  I've already looked at a few other ways of doing this, specifically: intlDateObj = new Intl.DateTimeFormat('en-US', { ...

Getting this error when my IPA gets to the second iteration of a Landmark Transaction.  I am iterating through 6 records and it only does it on the second pass. Error executing iteration loop java.lang.NullPointerException: Cannot invoke 'com.lawson.bpm.landmark.LandmarkAdapter.getPageSize()' because 'this.bean' is null

documentation I can find has values for this field  as 01 thur 08,  and 29 does anyone have an updated list of  values        am seeing values of 25, 26, 27 and 28   thanks. je

When a buyer has an invoice cost message where the PO line is tied to an agreement they forward it to the agreement admin.  I'm looking to see if anyone has an IPA flow that automatically looks for those cost messages on contract and forwards them to the agreement admin.  This would save the buyers a lot of time.

Hello everyone, I was wondering if there is a way to retrieve GUID from InforOS.