Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
LindseyC
Past 24 Hours:
0
Prev. 24 Hours:
4
Overall:
5183
People Online:
Visitors:
166
Members:
1
Total:
167
Online Now:
Kara Jordan
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Forums
Integration / Customization
Forum:
IPA/ProcessFlow
Search this forum:
163 Subscribed to this forum
Page 2 of 48
<<
<
1
2
3
4
5
>
>>
Topics
Replies
Rating
Status
Views
Subscribers
Last Post
Attaching Employee Pictures using Process Automation
Started by
DanB
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=...
11
26246
5
by
Vlad Alcasid
6/3/2021 1:55 AM
File move/copy from within IPA (Processflow)
Started by
SWilkins
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...
5
17787
1
by
Debra
1/14/2021 4:11 PM
REST Calls in Infor Process Automation
Started by
Ethan
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.
7
35628
3
by
LauaLuau
5/3/2021 6:20 PM
Import data from CSV file to an external Oracle table
Started by
HDAustin13
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.
11
15644
2
by
HDAustin13
2/3/2021 1:59 PM
Reading ,Update & append files from FTP
Started by
Ashish
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...
5
15518
0
by
Ashish
1/29/2021 1:34 PM
combining records from file
Started by
Joan Herzfeldt
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...
1
14225
1
by
Ragu Raghavan
2/12/2021 2:41 PM
SQLQRY node issues creating a CSV
Started by
LawnsonGuy
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...
0
3178
0
2/26/2021 4:57 PM
Can IPA send to a Printer??
Started by
Joan Herzfeldt
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...
1
14233
1
by
Ragu Raghavan
3/12/2021 4:34 PM
IPA with DocuSign/Fill & Sign
Started by
Kat V
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...
0
3025
0
3/17/2021 5:47 PM
FTP node and carriage returns
Started by
Scooter
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.
2
14146
0
by
Scooter
3/29/2021 3:31 PM
Write File adding extra record
Started by
Joan Herzfeldt
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
1
13304
1
by
Ragu Raghavan
4/15/2021 6:36 PM
Terminating Pflow after a certain amount of time
Started by
Debra
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!
2
13923
1
by
Debra
4/21/2021 6:53 PM
JDBC MS Access from IPA
Started by
Karen Sheridan
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...
1
10200
2
by
David Williams
12/6/2021 4:28 PM
Sample CSV flow for IPA
Started by
Jay
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
2
11429
0
by
Ragu Raghavan
12/22/2021 7:07 PM
How to assign a DistGrp using IPA
Started by
Jerry
Is there a way to define a Report Distribution group to a batch job created using IPA Activity Node LWSNTXN (Lawson Transaction)
13
14796
2
by
Jerry
1/17/2022 3:32 PM
PR170 file locatoin
Started by
adnan512
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
6
14960
1
by
adnan512
5/1/2022 1:02 PM
SQL query to pull Reqs and who Approved them
Started by
twinsmomma
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
1
5620
0
by
Jay S
8/31/2022 6:04 PM
IPA Timeout error
Started by
ScottCT
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
0
1905
0
9/1/2022 5:02 PM
Data Iterator reset
Started by
Bill Brennenstuhl
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...
3
4256
1
by
John Henley
2/28/2023 2:02 PM
Datetime Conversion
Started by
Bill Brennenstuhl
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
1
7996
0
by
John Henley
2/28/2023 2:05 PM
Recovering an S3 Job With IPA
Started by
LawnsonGuy
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...
0
1280
1
5/23/2023 3:18 PM
IPD Installation
Started by
ALB
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
2
2579
0
by
John Henley
6/29/2023 7:25 PM
IPA and AP05.3
Started by
Randy
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
3
4767
0
by
Randy
9/20/2023 1:21 AM
Resource Transaction Node to Delete REQUESTER Identity
Started by
JoseLuis
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...
0
1316
1
1/1/2024 6:57 PM
IPA and MS-Access DB
Started by
Greg Moeller
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
1
1972
1
by
ScottCT
1/8/2024 6:16 PM
To join the discussion you need to
register
first. (Registration is free!) If you are already a registered user please
login
to join the discussion.
Page 2 of 48
<<
<
1
2
3
4
5
>
>>
General
--Dealing with Lawson / Infor
--SOx Compliance
--Career Development
--Staffing
--Hosting / Cloud
--User Group Announcements
Infor / Lawson Platforms
--Lawson Landmark
--S3 Systems Administration
----S3 Security
--M3 Application Foundation
--M3 Workplace Foundation
--Infor CloudSuite
User Experience
--Lawson Portal
----Lawson Design Studio
--Lawson Smart Office
----Mashup Designer
--Infor Workspace
--Infor Social Space
--Lawson Add-Ins for Microsoft O...
--Mobility
--Lawson Enterprise Search
Integration / Customization
--IPA/ProcessFlow
--Infor ION
--S3 Interfaces/Conversion
--S3 Customization/Development
--S3 Application Upgrades
Human Capital Management
--Lawson S3 HR/Payroll/Benefits
--Infor Global HR (GHR)
Financial Management
--Infor CloudSuite Financials
--Lawson S3 Financials
--Lawson M3 Financials
--Infor FMS
--Lawson Services Automation (PS...
--Lawson Budgeting & Planning
Expense Management
--Infor Expense Management
--Lawson Time & Expense
Enterprise Resource Planning & Manufacturing
--Lawson S3 Procurement
--Lawson M3 Manufacturing Operat...
--Infor ERP (Syteline)
Supply Chain Management
--Infor SCM
--Lawson S3 Supply Chain
--Lawson M3 Supply Chain
Enterprise Asset Management
--Infor EAM
--M3 Enterprise Asset Management
Performance Management
--Lawson Business Intelligence/R...
----Smart Notification
--Lawson M3 Business Performance...
--Lawson Opportunity Analyzer
Lawson Healthcare
--Cloverleaf
--Lawson MediSuite
--Analytics for Healthcare
Job Fair
--Positions Available
--People Available
LawsonGuru.com
--LawsonGuru.com Support