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

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

We are working on a new interface where the vendor provided a REST API. Is it possible to interact with a REST API through an Infor Process Automation We typically deal with flat files, this is our first project using the REST API. We will basically need to pull some data through the API, do an AGS call to load the data into a PA52 action, and then post some data back through the REST API. Any guidance would be appreciated.

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

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

Hello All, On the SQLQRY node there is a checkbox for "Generate CSV from resultset (This will skip SQL Looping)". This feature seems to work for me until at some point I believe the resultset is too large. For example, I have an IPA that saves a CSV file to a local folder. The process runs fine daily and we don&39;t have any issues with it. If I try to expand the range of the query within the node to find more data, it fails. It ran fine for 2136 rows, but failed at 7713. When I...

I have a request from our Material Dept.  "Looking to see if an IPA flow can be created that upon receipt of a patient chargeable item on a line in a PO, if a print file can be sent to the Zebra printer to automatically print the yellow charge sticker. Receipt can be done on a MSCM handheld or on the PO30"    We currently have the Gen_PORecieve trigger on and filter for tissue items that are received, so I know I can trigger a work unit and I can query to see if it is...

Is IPA capable of leveraging Sharepoint as a file share We have pdf forms that we want to route for approval - but these forms themselves need to use something like Docusign or Fill & Sign and cummulate signatures and edits.  All our current solutions would be download and then upload an edited copy.  We only want to keep the one and overwrite it as we go. If we store this on Sharepoint - can the IPA do the "Checkout/Checkin" steps and keep the attachment URL on th...

After FTP node transmits file, Line Carriage returns (CR) are missing.  Why Each line has a "\n"  (i.e. CR) appended to the end.  FTP is using a SFTP connection.  How can we keep (CR) on each line   Thanks.

I&39;m populating a message builder and later writing those records to a file.  I have no problems in the IPDesigner.  However when the process runs from the server the first line in the file does not come from the message builder.  It is: com.lawson.bpm.processflow.workFlow.flowGraph.FgaMsgBuilder1028d654  and then I see all the records from the msg builder.  This is a new issue to v11  Any idea how to get rid of it

We have a flow that looks for a file and then does various things to it.  We need to figure out a way to stop the flow/work unit created if it is unsuccessful after 4 days.  Is there a way to do this in either the flow or the schedule  I haven&39;t been able to find something that will work.  Thanks for your help!

  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&39;t work on the server side.  But I&39;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...

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&39;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 t...

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&39;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 <jobNumber> 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...

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&39;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&39;t all...

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