|
|
|
|
|
0 Replies and 469 Views
Parse the data from Web API 469 0
Started by HDAustin13
Hello Everyone,
I am trying to parse the data from the vendor Web API to a csv file to insert into a database table by using Webrun node to connect to the Web API, JSonParser to parse the data, and JSonConverter to conver the JSon data to CSV but get stuck on configuring these nodes as I am not sure what should be correct to configure for these nodes.
Has anyone done something similiar to this Can you please share your experiences
Thanks in advance,
Han
&nbs...
|
|
|
|
0 |
469 |
11/04/2020 11:48 AM |
|
2 Replies and 1640 Views
Use IPA to query IFS 1640 2
Started by AndyG
Since IFS syncs with our 5 sub-domains, we would like to read/query the user information, to later use in the IPA.
Can IPA query IFS user information What node How Has anyone done this Thank you in advance.
|
|
|
|
2 |
1640 |
by AndyG 09/16/2020 11:47 AM |
|
11 Replies and 6162 Views
LPA- Default work title for UA 6162 11
Started by Lynne
Hi-
I need to modify some of the inbasket work titles and can't figure out where I can see what the default title is. If I look at the UA, work title, it is blank. But, when the inbasket generates there is a title that displays. Is there a default title that is used if you don't enter anything in the Work tab Work Title field of the UA node Thanks!
|
|
|
|
11 |
6162 |
by B Ledet 08/10/2020 10:20 AM |
|
2 Replies and 1734 Views
Using Web Service in IPD 10.1.1 1734 2
Started by HDAustin13
Hello,
I am trying to use the Web Service node in IPD 10.1.1 to connect to a web service but not sure on how to start.Does anyone have any guildeline on how to make it works If so, can you please share. Thank you in advance.
|
|
|
|
2 |
1734 |
by HDAustin13 03/03/2020 4:19 PM |
|
10 Replies and 6456 Views
Create export files from SQL code via IPA or crystal and LBI? 6456 10
Started by Joan Herzfeldt
I'd like to pick a few brains please. I'm trying to determine if IPA is a viable option for running SQL code and FTP'g the file or moving it to a directory. Most of my Lawson exports are created via a SQL View. So the next step just pulls the entire view (select * from LawsonView).
Currently in order to get the file into csv, tab, excel, etc... I have to create a crystal report and schedule it via LBI which exports it to a specific directory. My network team have t...
|
|
|
|
10 |
6456 |
by FireGeek21 01/24/2019 7:09 PM |
|
5 Replies and 2715 Views
IPA Batch Job Montioring after WebRun node kicks it off 2715 5
Started by Deb Roberts
When we kick off a batch job with the WebRun node in IPA, is there a way to delay the flow from moving to the next node until the job successfully completes Or do we have to use a Wait node and determine how long the job usually takes to run
Thanks in advance for your help!
|
|
|
|
5 |
2715 |
by dmcdougald 12/27/2018 9:23 AM |
|
1 Replies and 1570 Views
Email Node - High Importance Option 1570 1
Started by agersh
Does anyone know if the Email node for IP Designer V10.1.1.9.4205 provides an option to send emails as an High Importance email
|
|
|
|
1 |
1570 |
by JimY 06/29/2018 12:12 PM |
|
2 Replies and 2077 Views
Calling Jobrun.exe to submit jobs 2077 2
Started by Deleted User
Hi,
We can submit jobs via Webrun node in Process Flow which internally calls jobrun.exe to execute jobs. Can we call the jobrun.exe to execute jobs using our own written desktop application just like LID
|
|
|
|
2 |
2077 |
by Deleted User 03/12/2018 9:37 AM |
|
1 Replies and 3506 Views
FTP Node – Retrieve latest file from remote source folder 3506 1
Started by agersh
Using the FTP node I am trying to build a process that file transfers the latest file of a list of files located on a remote source folder. Has anyone written a process that searches a remote folder for that latest file then transfers the file using the FTP node
|
|
|
|
1 |
3506 |
by Kyle Jorgensen 02/20/2018 1:25 PM |
|
1 |
2283 |
by brox07 09/11/2017 4:07 PM |
|
2 Replies and 2832 Views
Convert TXT to PDF 2832 2
Started by PD
I have a formatted txt file that is converted to pdf using the bldxffiles utility, but the pdf does not look as nice as the formatted txt file. Can someone give me pointers on how to make that happen
I use a MsgBuilder node to create the file and tab is used for spacing.....see attached files for comparison
|
|
|
|
2 |
2832 |
by PD 05/19/2017 12:57 PM |
|
9 Replies and 8901 Views
javascript functions in processflow 8901 9
Started by Maynard F.
Hello. I would like to see some of the custom functions that PFI users have developed. Specifially, I am wanting a function that will format a numeric field into an alpha numeric field complete with currency sign, commas and a decimal point. Any other functions will be appreciated. Please reply or post the code and tell me where to find it. Thank you.
|
|
|
|
9 |
8901 |
by Joan Herzfeldt 08/16/2016 8:04 AM |
|
5 Replies and 3181 Views
Use Javascript to format Rate of Pay and FTE values from database table to include decimals 3181 5
Started by agersh
I am working on a ProcessFlow that uses an SQL Query Node to query the PERSACTION table. Two of the New_Value_ fields the query is referencing are the values for Rate of Pay and FTE. The values are stored in the table without decimals. For example Rate of Pay is stored as 000000000032050000 and FTE as 000000000000900000 . Using Javascript I am trying to find a way to format these values so that my ProcessFlow could use these values in their valid/correct decimal format.
A...
|
|
|
|
5 |
3181 |
by Dave Curtis 07/28/2016 12:48 PM |
|
3 Replies and 4852 Views
Email Node - Include a picture in email content 4852 3
Started by agersh
Is it possible to include a pictures/graphics in the email content area of the Email node I am assuming that the content type will need to ne HTML.
|
|
|
|
3 |
4852 |
by Corvette Jim 06/01/2016 1:16 PM |
|
1 |
2663 |
by Shane Jones 05/10/2016 2:28 PM |
|
2 Replies and 3287 Views
Having trouble determining the HR15.1 PageDown AGS Call 3287 2
Started by agersh
I am working on a process to delete specific User Fields (User Field Values) from an employee. Using the following HR15.1 ags transaction call I am able to inquire the first page of HR15.1 for the employee. But I seem to be unable to successfully build the ags call to PageDown to the next page of user fields.
&91;Inquire&93;
_PDL=PROD&_TKN=HR15.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=I&HEU-COMPANY=1&HEU-EMPLOYEE=299&HEU-EFFECT-DATE=&_DELIM...
|
|
|
|
2 |
3287 |
by agersh 02/02/2016 4:04 PM |
|
9 Replies and 5037 Views
Parse CSV Comma Delimited File with Quotes and Embedded Comma 5037 9
Started by agersh
Using the Data Iterator node I've been trying to figure out how I can parse the following CSV file/row, Comma Delimited with Quotes and Embedded Comma.
'1375','Annual','GRETA','GOLD','082189','Yes','REGINA','BRONZ','01/21/2014','BRONZ, REGINA;FRANKEN, JANET','TRANSCRIPTIONIST PATHOLOGY','12354','Yes','No','Yes','','','Submitted to HR','','','','2.03','01/21/2014','01/21/2014','0.00','0.00','0.00','','','01/21/2014'
Has anyone else come across this situation
|
|
|
|
9 |
5037 |
by GeoffTSJY 08/04/2015 4:23 PM |
|
1 Replies and 5558 Views
ActiveX Component can't create object when trying to run wizard 5558 1
Started by jocelyn
I've been using LPA for about a year now, and wanted to develop a new flow that includes a Lawson Transaction node. When I click 'Build' to build the transaction, I get the following error:
Run-time error '429': ActiveX component can't create object.
I've written flows before that utilize the Lawson Transaction and Lawson Query nodes and have used the Build wizards to create the transaction/query strings. Suddenly I cannot. However, the big...
|
|
|
|
1 |
5558 |
by Woozy 07/01/2014 9:15 AM |
|
23 Replies and 20789 Views
Installing and Configuring MSSQL JDBC for ProcessFlow Integrator 20789 23
Started by John Henley
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...
|
|
|
|
23 |
20789 |
by masonp 03/13/2012 11:07 AM |
|
9 Replies and 11685 Views
Someone - please share your PFlow Trigger form.... 11685 9
Started by Shane Jones
I am looking for a simple form that an HR user could access to trigger a processflow. I was going to just schedule the flow but they need to be able to trigger the flow their schedule. I do NOT want to give them access to Process Flow Administrator. I have heard others say that they have created a form that triggers a processflow. Is anyone willing to share their form (My other option is to create a flow that is connected to a PA52 action and then have the user enter a personnel action...
|
|
|
|
9 |
11685 |
by JeffR 06/01/2010 12:13 PM |
|
87 Replies and 47306 Views
Migrating 8.0 Flows to 9.0 47306 87
Started by Joe O'Toole
We have some flows written in designer V 8.036 and they reference RD30. Is there a migration utility to move these to LSF 9 and will it move the flows even though the RD30 logan objects no longer exist
|
|
|
|
87 |
47306 |
by Shane Jones 09/01/2009 1:58 PM |
|
5 Replies and 3185 Views
File move/copy from within IPA (Processflow) 3185 5
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 |
3185 |
by Debra 01/14/2021 11:11 AM |
|
2 Replies and 565 Views
PfiUserProfile in Landmark 565 2
Started by Demi
I should be alittle more specific... I&39;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...
|
|
|
|
2 |
565 |
by Demi 12/15/2020 9:36 AM |
|
10 Replies and 1116 Views
Import data from CSV file to an external Oracle table 1116 10
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.
|
|
|
|
10 |
1116 |
by HDAustin13 12/08/2020 12:40 PM |
|
7 Replies and 1439 Views
IPA v11 - Updating field with a value containing an ampersand 1439 7
Started by dcasper70
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&39;ve attempted every variatio...
|
|
|
|
7 |
1439 |
by Orlando Gray 10/21/2020 5:44 PM |
|
6 Replies and 3552 Views
alt rates 3552 6
Started by TommyT
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
|
|
|
|
6 |
3552 |
by Ragu Raghavan 10/16/2020 4:09 PM |
|
6 Replies and 1608 Views
IPA 1 GB memory limit error 1608 6
Started by Quarantine
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
|
|
|
|
6 |
1608 |
by Robert 09/01/2020 5:20 PM |
|
0 Replies and 430 Views
email authentication 430 0
Started by Ragu Raghavan
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 use...
|
|
|
|
0 |
430 |
08/26/2020 9:14 AM |
|
6 Replies and 9670 Views
REST Calls in Infor Process Automation 9670 6
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.
|
|
|
|
6 |
9670 |
by HDAustin13 08/19/2020 4:50 PM |
|
8 Replies and 1357 Views
Triggering WFWK after a PR140 job run 1357 8
Started by Preston Burdwell
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
|
|
|
|
8 |
1357 |
by B Ledet 08/04/2020 11:19 PM |
|
0 Replies and 531 Views
using a flow to change LBI bookmarks 531 0
Started by Karen Sheridan
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&39;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
|
|
|
|
0 |
531 |
08/04/2020 8:44 AM |
|
2 Replies and 1492 Views
Automation for disabling active Directory 1492 2
Started by Utsav
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
|
|
|
|
2 |
1492 |
by Kristi_ANTHC 08/03/2020 12:23 PM |
|
2 Replies and 661 Views
Flow submitting a single job multiple times?? 661 2
Started by LauraPat
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&39;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 rec...
|
|
|
|
2 |
661 |
by Karen Sheridan 07/30/2020 2:28 PM |
|
2 Replies and 629 Views
Array values from Rich Client 629 2
Started by Karen Sheridan
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 &91;"A1","A2","A3","A4","A5","A6","A7","A9","MD","ML","RW","WC"&93; - field is defined as array
testInt1 = A2 - from FromStatusCodes&91;1&...
|
|
|
|
2 |
629 |
by Karen Sheridan 07/30/2020 10:28 AM |
|
2 Replies and 629 Views
Error with Landmark Admin node 629 2
Started by Scooter
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: E...
|
|
|
|
2 |
629 |
by Quarantine 07/28/2020 1:40 AM |
|
2 Replies and 901 Views
Capture joblog in IPA for Email Node? 901 2
Started by LauraPat
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
|
|
|
|
2 |
901 |
by Karen Sheridan 07/08/2020 11:08 AM |
|
3 Replies and 1279 Views
MT IPA: Getting Employee Audit History in IPA 1279 3
Started by Quarantine
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 particul...
|
|
|
|
3 |
1279 |
by David Williams 06/11/2020 8:58 PM |
|
8 Replies and 1819 Views
Sorting and summarising a csv file in IPA 1819 8
Started by Quarantine
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.
|
|
|
|
8 |
1819 |
by Quarantine 06/08/2020 9:29 AM |
|
1 Replies and 663 Views
IPA Web Service to MS Exchange (Soap) 663 1
Started by Karen Sheridan
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 ...
|
|
|
|
1 |
663 |
by David Williams 05/27/2020 3:22 PM |
|
2 Replies and 816 Views
Data manipulation and Emails in IPA 816 2
Started by Joan Herzfeldt
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&39;ve consided:
1. creating a...
|
|
|
|
2 |
816 |
by Joan Herzfeldt 05/18/2020 3:25 PM |
|
4 Replies and 1054 Views
Lawson Query doesn't like a space. 1054 4
Started by Joan Herzfeldt
I have a very simple Lawson Query to look up a code I&39;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&39;ve validated the node works without a space. I&39;ve validated that the record I&39;m using DOES have the A SECADM code. ...
|
|
|
|
4 |
1054 |
by Joan Herzfeldt 05/15/2020 3:09 PM |
|
5 Replies and 1193 Views
Best way to create a lookup table in IPA 1193 5
Started by Quarantine
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 ...
|
|
|
|
5 |
1193 |
by Quarantine 05/13/2020 4:49 AM |
|
8 Replies and 2413 Views
Dynamically assigning users to useraction 2413 8
Started by Quarantine
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 t...
|
|
|
|
8 |
2413 |
by Bob Canham 05/06/2020 7:50 PM |
|
0 Replies and 8070 Views
Adding Form URL link in Email 8070 0
Started by Scooter
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.
|
|
|
|
0 |
8070 |
05/06/2020 10:43 AM |
|
10 Replies and 2241 Views
XML Node parse and assign 2241 10
Started by Steph76
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&91;0&93;.COMPANY, returns the Company. When trying to get the process lev...
|
|
|
|
10 |
2241 |
by David Williams 04/27/2020 11:15 AM |
|
4 Replies and 3028 Views
IPA-REST API (web run) 3028 4
Started by Lan Henry
Does anyone have an example of a WebRun node to NEOGOV Their setup is REST API. Content type is json. I&39;m trying to post department data to NEOGOV and not sure what info I need to include in the header box of the webrun node.
I&39;m fairlly new at this, So far I have them as individual line. Not sure if they are correct.
===========================
POST /request HTTP/1.1
Host: https://api.uat.neogov.org/rest/departments
Accept: ...
|
|
|
|
4 |
3028 |
by Lan Henry 04/24/2020 2:33 PM |
|
6 Replies and 2158 Views
ESS and IPA 2158 6
Started by thanef
We are LSF with IPA in Landmark.
We are testing some ESS Home Address Changes in our Test system. We are getting emails successfully sent to the email address listed on HS07.
HS23 has Process Flow enabled and html option. Where is the work unit I do not see it listed where our Work Units are for our scheduled IPAs.
|
|
|
|
6 |
2158 |
by thanef 04/08/2020 6:06 PM |
|
1 Replies and 1660 Views
Encrypt a file in IPD flow 1660 1
Started by HDAustin13
Hello All,
I need to encrypt an outgoing csv file with the PGP key the vendor provided in the IPD tool but not sure on how to start.
Does anyone have done that before If so, can you please share the guide or a sample flow.
Thank you very much in advance,
HDao
|
|
|
|
1 |
1660 |
by John Henley 04/03/2020 12:56 PM |
|
6 Replies and 1505 Views
Update configuration settings via IPD 1505 6
Started by Steph76
Hello,
I have a pf where with a starting payment number that I need to keep track of and increment each time the pf runs. I created a variable in my configurations on LM and I&39;m using a Landmark Transaction node to update it. I get the value of the configuration property and set it to a local value and increment by 1. Then I try to set the configuration property to the local variable value. I get the following error when trying to run it.
Activity Error com.lawson.rdtech.type.ViewExcep...
|
|
|
|
6 |
1505 |
by FireGeek21 03/31/2020 1:39 PM |
|
5 Replies and 1279 Views
Javascript error .. invalid XML character 1279 5
Started by Joan Herzfeldt
Error processing flow configuration: org.mozilla.javascript.EcmaError: TypeError: Character reference "&3" is an invalid XML character. (initJavaScriptContext1)
All of a sudden we are getting the above error in our TEST system for ALL of our process flows. (we are still on v10 IPA and Landmark and LSF.) I was testing something new and found the problem but it started on the 18th of March. Apparently we put a windows update, etc... in place that night. My SysA...
|
|
|
|
5 |
1279 |
by David Williams 03/26/2020 2:55 PM |
|
0 Replies and 1050 Views
MA60.3 Transaction Query 1050 0
Started by AC_Slater
I am currently running into an issue where the transaction node is not performing as expected for the MA60.3. I want to choose a specific receipt line item, mark it to be selected, and then perform the special action "Select".
Unfortunately, although the XML for the transaction query appears to reflect what I&39;m looking for it to do, the receipt line item remains unselected (does not have an "X" for the FC).
Admittedly, I haven&39;t had to utilize flag c...
|
|
|
|
0 |
1050 |
03/02/2020 5:15 PM |
|
7 Replies and 1454 Views
Req Item Rec Service Definition 1454 7
Started by Joan Herzfeldt
I&39;m trying to set up my first Trigger (previous ones have been set up by consultants). According to the "IPA Services for Infor Lawson Reference Guide (v10.0.5)" documentation the PO Receiving (PO30) has a trigger for each time a req line item is received. Service = Req Item Rec.
I set up the trigger (per instuctions) in Process Server Administrator -> Scheduling -->Service Triggers
I added my Process Definition &39;Receive_Req_Item&39; to the ReqItemRec Serv...
|
|
|
|
7 |
1454 |
by Joan Herzfeldt 02/20/2020 10:22 AM |
|
5 Replies and 1905 Views
IPA - reading CSV file 1905 5
Started by Scooter
Can IPA read a CSV file from a laptop C: drive We are on Cloud v11.
Or, must CSV file reside in another directory Landmark
Thanks.
|
|
|
|
5 |
1905 |
by Todd Mitchell 01/09/2020 2:38 PM |
|
2 Replies and 1649 Views
V11 Inbasket displays for User Actions 1649 2
Started by Scooter
On version 11, where are User Action inbasket display files (i.e. HTML, etc.) reside
Are they configured in Infor Rich Client If so, where
Do they reside on a Landmark drive if so, where
Thanks for your assistance.
|
|
|
|
2 |
1649 |
by Scooter 12/27/2019 9:29 AM |
|
5 Replies and 2216 Views
Array size limit 2216 5
Started by Ragu Raghavan
In my flow, I need to lookup a custom table outside the Lawson schema for each transaction. The SqlQry takes a long time. I wonder, if I can do a single qry at the beginning and load the results of the Sqlqry into an Array, avoiding the multiple lookups. Catch is that there are likely to be 50,000 records in the custom table. Will that cause the LM server to crash Are there any limits to how big the array can be Thanks.
|
|
|
|
5 |
2216 |
by Ragu Raghavan 11/29/2019 4:30 PM |
|
1 Replies and 1308 Views
Deleting UserIDs from Landmark Security 1308 1
Started by Scooter
We are creating a flow to delete User IDs from Landmark Security.
I'm building the code with Landmark Transaction Builder.
Does anyone know the 'Data area', 'Module', 'Object Name' values to use
Thanks.
|
|
|
|
1 |
1308 |
by Scooter 11/27/2019 11:05 AM |
|
1 Replies and 1595 Views
IPA performance 1595 1
Started by Thiago Corredor
Hello everyone !
Do you know how where can we check if exist any IPA running for more than 3 or 4 hours long
Some IPA tables or GRID can help
Thanks !
|
|
|
|
1 |
1595 |
by JimY 11/22/2019 6:47 AM |
|
3 Replies and 1781 Views
WriteAttach via WebRun 1781 3
Started by Steph76
Hello,
I'm trying to use a WebRun node in IPD to add an attachment to an invoice. I want to attach a URL. I tried following the documentation and other posts I saw, but I'm still having problem. When I set the content type to text/html the Work Unit shows as Completed in Rich Client, but the log shows this:
ERROR key='UNKNOWN_ERROR' level='1'
!&91;CDATA&91; An unknown error occurred. Please contact your system admin. &93;&93;
!&91;CDATA&91; Check IOS logs for details. &93...
|
|
|
|
3 |
1781 |
by TomED 11/21/2019 4:44 PM |
|
9 Replies and 3635 Views
Modifying Lawson Environment Info from a Flow 3635 9
Started by Deleted User
I've created a flow to build new Resource records for my portal users using the Resource Update node.&160; However, I don't see a way to update the Lawson Environment settings (as seen in LSA) from my flow --&160;specifically,&160;I need to update&160;the Data Area/ID field.&160; As a result, my newly defined user is unable to log in to portal until the Data Area&160;gets populated and causes a GEN\USER record to be created.&160;
Is there a way to add or update the Lawson Environment set...
|
|
|
|
9 |
3635 |
by Adam 11/20/2019 10:10 AM |
|
0 Replies and 1038 Views
Referencing Business Tasks in an IPA Flow 1038 0
Started by Tony
Hello, I was wondering if anyone has experience triggering a business task in a custom IPA flow. Specifically, I am looking to trigger the EMail Executor business task at the end of the flow, but to only process the emails that have gone into the 'New' status that same day. As context, I recently built a custom flow to trigger a 'reminder' action for our Health Module components but the emails are getting put into the 'New' status in the Email Queue. We've found that the temporary solution...
|
|
|
|
0 |
1038 |
11/18/2019 2:09 PM |
|
0 Replies and 1152 Views
QUEUEDJOBS WebRun 1152 0
Started by Scooter
I'm running a Webrun to return any job in 'Needs Recovery' status and want to know how to pull certain output fields, like jobOwner, jobName. How do I pull those 2 output fields from the Webrun Output results
Here's the Webrun code.
/lawson-ios/action/ListQueuedJobsfilter=jobStatus20EQ20needsRecovery
Below is Webrun Output results, i.e.
jobOwner='u0003035' token='BN320' jobName='BN320TEST' jobQueue='**********' jobStepType='application' jobNumber...
|
|
|
|
0 |
1152 |
11/13/2019 4:08 PM |
|
3 Replies and 1327 Views
Web Run Node - File Upload 1327 3
Started by Chad Dirst
We are successfully using IPA to call various REST API web services via the Web Run node. In one of the calls we need to transmit a file and am having issues getting this working. Has anyone had experience will successfully transferring files via an IPA Web Run node
|
|
|
|
3 |
1327 |
by David Williams 11/08/2019 2:10 PM |
|
2 Replies and 1775 Views
Resource Update Node - Remove specific Role or Group 1775 2
Started by Nabil
Hi All,
I'm trying to delete a specific Group from the existing list. I only want to delete 'Manager Self Serve' but instead it deletes all group the user has.
In the Group value, here is what I have:
|
|
|
|
2 |
1775 |
by JimY 10/21/2019 5:31 AM |
|
1 Replies and 1184 Views
Issue with JavaScript Date 1184 1
Started by tommyg-006
Good Afternoon All,
I am hoping somebody else has run into this issue before. I seem to be having with a JavaScript calculation in IPA. We are trying to take today's date (i.e 10/15/2019) and move it forward to December so the date range starts at 12/01/2019. However, when the script runs it returns a date of 00/01/2020. The script works for every other month in the calendar except for 12/1. Below is the script that we have in IPA:
Evaluating JavaScript ex...
|
|
|
|
1 |
1184 |
by David Williams 10/15/2019 3:22 PM |
|
2 Replies and 1038 Views
Effective Date in a flow/form 1038 2
Started by weeoooohhhh
Hey guys, so I need to obtain the Effective Date within the Transfer Flow. There is a caveat to this though. I have the node looking up the Effective Date variable from the PFIWorkUnitVariable table which works great. However, once the flow gets into the HROPs inbasket, they may end up changing the Effective Date at this point within the flow. Once that happens the PFIWorkUnitVariable table does not get updated with the new Effective Date so I can't re-look it back ...
|
|
|
|
2 |
1038 |
by weeoooohhhh 10/11/2019 10:29 AM |
|
7 Replies and 1939 Views
Batch job monitoring with ProcessFlow 1939 7
Started by Scooter
I'm creating a processflow to monitor Batch jobs completion.
Using SQL node to query 'GEN' table QUEUEDJOB.
When testing query, field STATUS returns values like &91;Bf106b0
First, is this correct table to monitor batch jobs
If yes, how can we determine if job went to recovery or completed successfully when
STATUS has values like &91;Bf106b0 What am I missing
Below job PA102 ...
|
|
|
|
7 |
1939 |
by Scooter 10/02/2019 2:22 PM |
|
3 Replies and 1338 Views
IPA and ADFS issues 1338 3
Started by Joan Herzfeldt
We just switched to ADFS and my IPA inbasket is requesting the user to Login again in order to see the detail of the requisition/workunit.
The User Action node is set up with a display type of HTML and uses File Id: recsum.htm (see attached print screen).
Where is the connections between the user who’s already logged in and viewing their inbasket (with the general information) to see detail.
My basic understanding is... the system is displaying the general detai...
|
|
|
|
3 |
1338 |
by Joan Herzfeldt 10/02/2019 12:18 PM |
|
10 |
3625 |
by Scooter 09/05/2019 9:06 AM |
|
4 Replies and 1402 Views
System Command node 1402 4
Started by Scooter
for example:
cd /Lawson/
cp fileA fileB
|
|
|
|
4 |
1402 |
by steve finger 09/04/2019 9:05 AM |
|
8 |
2475 |
by David Williams 08/21/2019 11:38 AM |
|
5 Replies and 1865 Views
Removing Identities with IPA 1865 5
Started by Scooter
We want to remove employee's Identities from Infor Rich Client.
Our test flow is removing the employee's userid and passwords from each Identity
but, the flow is not deleting the Identity name (e.g. SSOP) from Infor Rich Client when we view the employee, after flow is run.
We are using a WebRun node with code that works on our PROD environment.
What could be missing from our 'test' flow that stops it from deleting the employee's Identities
Thanks for your assistance. ...
|
|
|
|
5 |
1865 |
by Scooter 08/15/2019 4:29 PM |
|
2 Replies and 1293 Views
How to calculate last day of current month 1293 2
Started by Scooter
In processflow, we need the last day of current month.
This last day of month value will be used in batch pgm parm date, i.e. BN100, Thru-Date=20190831
Has anyone does this before Is there an Infor PF date function that can do this
|
|
|
|
2 |
1293 |
by Scooter 08/14/2019 4:01 PM |
|
5 Replies and 1448 Views
IPA Data Iterator node cannot find input file. 1448 5
Started by Scooter
IPA Data Iterator node cannot find input file. Need your assistance to identify issue with Data Iterator node.
Error message is 'File 'https://lawtestv10.dart.org/lawson02/univ2/dartipa/appload.CSV' does not exist.'
We've confirmed file (appload.CSV) exists on this directory (/lawson02/univ2/dartipa/ and server (lawtestv10.dart.org).
Below error message was copied from workunit log file:
Activity nameI1 id:1 started 08/12/2019 03:41:24.578 PM
Executing Data Iterator Activity DI1 ...
...
|
|
|
|
5 |
1448 |
by Scooter 08/13/2019 4:19 PM |
|
0 Replies and 1023 Views
IPA Email Node when SMTP Server is Unavailable 1023 0
Started by jmartin
We’ve had issues lately with our on-premises Exchange server and found that emails failed from IPA when SMTP was unavailable. We were hoping they would be able to queue... like magic. Unfortunately, we are unable to simply restart the work units to resend the email notifications.
How do you handle situations where the SMTP server may be unavailable but the jobs need to continue to run and emails need to send/queue
Do you setup an error conne...
|
|
|
|
0 |
1023 |
08/12/2019 5:12 PM |
|
13 Replies and 1981 Views
Records returned in IPA using lawson query node 1981 13
Started by steve finger
when i do a lawson query from IPA, when the number of records specified in the query string is reached (512 by default i believe), the query seems to 'skip' a large number of records before the next record returned by the query. for example...if the 'MAX' value is set to 512, the first 512 records are returned....then a number or records are skipped before the next record is returned.
pretend i'm querying the apvenmast... i have 10,000 vendors numbered sequentially from 1 to 10,...
|
|
|
|
13 |
1981 |
by steve finger 08/08/2019 7:28 AM |
|
8 Replies and 2020 Views
IPA - Webrun used to update Landmark 2020 8
Started by Scooter
I would have used Landmark Transaction node to update user's profile.
Not sure why previous developer coded like this. See below code string and this is only a small part of entire code string.
If anyone can explain why it was coded this way, please reply.
I don't see advantage and this code is very difficult to maintain.
WebRun Code (partial string) - code is executed from a WebRun node.
/scwebadminapp/ResourceManagementServletTASKTYPE=PROVISIONING&OBJECTTYP...
|
|
|
|
8 |
2020 |
by JimY 08/08/2019 6:15 AM |
|
2 Replies and 1307 Views
Setting up IPA Service Process in new IPA environment 1307 2
Started by Kert490
I set up the Infor Process in the Rich Client in the new environment exactly as it is currently setup in our production environment, but the form is unable to communicate with the Service I setup in the Rich client.
This is the error that is generated after I run the GL146 process from Lawson:
Processing GL146 - Batch Journal Control
java.lang.NoClassDefFoundError: com/lawson/bpm/eprocessserver/interfaces/mingle/MingleRequest
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.l...
|
|
|
|
2 |
1307 |
by Kert490 07/31/2019 10:04 AM |
|
0 Replies and 1045 Views
powershell script vs for loop w/IPA nodes 1045 0
Started by Joan Herzfeldt
I need some advice with a new IPA process We have Lawson S3 v10 and IPA v10.1.1.58 I am creating an IPA that automatically update the PA16 The file I'm receiving can not be sorted or changed before I get it. The records are random, meaning there are multiple PA16's to be updated for the same person, but the records are NOT grouped together they can be 3rd record, 12th record and 22nd record. I want to update Each Employee's PA16 screen once. So I need to order the file or loop through a...
|
|
|
|
0 |
1045 |
07/10/2019 3:17 PM |
|
1 Replies and 935 Views
Server Timed Out 935 1
Started by ScottCT
We get these time out errors on some of our processes, is there a way to increase the timeout time And which server would this setting be located, on the IPA or in M3
|
|
|
|
1 |
935 |
by steve finger 07/10/2019 10:30 AM |
|
0 Replies and 932 Views
Updating PO20.2 using Transaction Node 932 0
Started by AC_Slater
Good morning,
I am currently working on a process flow to update a single field on the PO20.2 (PCR-PO-USER-FLD-5) using the Lawson Transaction Node. My original thought was that I would be able to take the header information that is on the top of the PO20.2 screen to select the correct record and then perform a “C” FC on the form. I isolated all of the header fields (pcr-company, pcr-buyer-code, pcr-po-date, pcr-po-number, pcr-vendor, pcr-purch-fr-loc, pcr-lcatio...
|
|
|
|
0 |
932 |
07/08/2019 11:05 AM |
|
0 Replies and 999 Views
Landmark transaction query results 999 0
Started by mrabas
We are implementing GHR so I am starting to learn how to use the Landmark Transaction nodes to query data.
In S3, with a Lawson Query node we could access a specific row from a query like so:
EmpQry_3_EMPLOYEE
Which would return the EMPLOYEE field for the third result of the query. Accessing the results outside of the query loop allowed us to speed up the processing considerably.
Is there any way to access the full query results from the Landmark Transaction node...
|
|
|
|
0 |
999 |
06/20/2019 3:36 PM |
|
9 Replies and 1805 Views
Parsing CSV with double quotes 1805 9
Started by AC_Slater
Hi All,
I'm hoping someone else might have had to tackle a similar issue, and seeing as though my regex skills are pretty rusty, I thought I'd reach out.
I am currently using the Data Iterator to go through a CSV file to break up the file by line. Normally, I would use a second data iterator to go through and break up the fields by their delimiter, which is a comma, but unfortunately some of the fields have valid commas within their data:
For instance:
1234,Cake,,'Smith,John',,'Status:...
|
|
|
|
9 |
1805 |
by steve finger 06/18/2019 12:49 PM |
|
0 Replies and 1050 Views
Cannot activate or deactive a File Channel in Rich Client 1050 0
Started by LauraPat
I use File Channel/Receiver to initiate a process flow. It's been working fine until we had a problem with our system and the process hung due to bad data and an enormous file. To prevent it from kicking off again - I tried to deactivate the File Receiver. I didn't realize until now that the deactivation failed). I've tried to deactivate it again and I get an error that the receiver is not active. If I try to reactivate it - I get the error 'Receiver must be in activated failed or inactive or fa...
|
|
|
|
0 |
1050 |
06/01/2019 4:29 AM |
|
16 Replies and 2810 Views
Is this possible? 2810 16
Started by Ronnie
We currently have a server that has a scheduled task on it to run an executable. That executable takes files from one directory and moves them to another.
Is there a way that a process flow can be written that can take files and move them from one directory to another
I know there is a file access node that can be used to check a location to see if a file exists, but what about moving files
|
|
|
|
16 |
2810 |
by steve finger 05/29/2019 7:50 PM |
|
0 Replies and 1033 Views
LWSNTXN Node padding with '' 1033 0
Started by LauraPat
I have a process flow that is running a SQL query and the output from that query is the run group out of GLTRANSREL. I update the run group in my GL165 job through the LWSNTXN node, using that run group, and then the job is submitted via the WebRun Node. But when I update the job using the output from the query (which is in a string) - the run group in the job parameters is being padded to the right with '' instead of spaces so GL165 ends up not finding the run grou...
|
|
|
|
0 |
1033 |
05/22/2019 1:40 PM |
|
11 Replies and 3399 Views
Wondering your thoughts on IPA and Lawson 10 or Cloudsuite 3399 11
Started by Erik G.
Good Afternoon all,
My hospital moved from Lawson 9 to Lawson 10 late last year and we are having conversations with Infor about moving to Cloudsuite. Some of the things they have shown our materials and accounting staff revolve around using IPA which we don't currently use. And as you might have guessed, they loved what they see and they want it right now.
My question to all of you what are your thoughts on IPA
Are you using i...
|
|
|
|
11 |
3399 |
by David Tashima 05/03/2019 12:18 PM |
|
1 Replies and 1188 Views
WebRun example for SmartyStreets 1188 1
Started by Garry Ferwerda
Does anyone have an example of using a WebRun node with SmartyStreets street address API Is so would you be interested in sharing it
Thanks
|
|
|
|
1 |
1188 |
by Dave Curtis 04/24/2019 3:33 PM |
|
13 Replies and 2288 Views
PA52 - error pending action does not exist 2288 13
Started by PD
I first do a PA52 inquire and based on a condition then proceed to do a PA52 change which is to update the EFFECTIVE date. I get an error message 'pending action does not exist' while trying to do the PA52 change. Not really sure what that means....any ideas!
_TKN=PA52.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&PCT-ACTION-CODE=TERM&_HK&_IMMEDIATE_ACTION=1&PCT-COMPANY=0100&PCT_NEW_EFFECT_DATE=20190511&PCT-EMPLOYEE=382723&PC...
|
|
|
|
13 |
2288 |
by PD 04/22/2019 10:50 AM |
|
2 Replies and 1316 Views
Documentation 1316 2
Started by PD
I've been trying to code a process flow using LWSNTxn node to first delete a record and then add to PA52. Can someone please refer me to any available docs that might help me with this I feel like I am shooting in the dark and time is being wasted for something that should be straight forward....I think.
Thanks
|
|
|
|
2 |
1316 |
by Dave Curtis 04/19/2019 3:36 PM |
|
2 Replies and 1008 Views
Performing taks timeouts in separate flow 1008 2
Started by Gene B.
We are looking to create reminders and timeouts to auto approve certain personnel actions based on varying period end dates (dependent on process levels). So the timers in hours or days on the user action node would not be set at all.
So far, creating a flow to read PERSACTION and calculate when to send reminder emails works. In order to auto approve after a similar calculation I was going to use a call to PA53 to approve. That is still leaving the task in the users inbasket. How do I rem...
|
|
|
|
2 |
1008 |
by Gene B. 04/18/2019 10:35 AM |
|
1 Replies and 943 Views
LMTxn node - Updating user field 943 1
Started by PD
I need a bit of guidance on how to update the Alpha field in the USERFIELD_STORAGE table using a LMTxn. I am not exactly sure what _module, _objectname, _actionName and _actionType to select.
Thanks
|
|
|
|
1 |
943 |
by PD 04/18/2019 10:14 AM |
|
7 Replies and 1936 Views
Best way to format HTML email 1936 7
Started by Chris Beecy
I am wondering how other IPD developers format the HTML message of an Email node. I tried to create a formula/variable with to simulate a CSS style sheet but it 'sorta' worked but not completely. I have had luck using inline styles but that spreads the formatting around (as I build the message) AND cannot be reused. What I'm hoping for is a way to define a CSS Style Sheet in a variable (or global configuration) and reuse for all flows that need to send an email that conform to a single standard....
|
|
|
|
7 |
1936 |
by Chris Beecy 04/16/2019 6:36 AM |
|
0 Replies and 1110 Views
Error 143 on importdb in IPA 1110 0
Started by LauraPat
Anybody know what error code 143 is on importdb I can run the command from the command prompt and the data imports into GMDISTREL without issue. I can run other GMDISTREL files using the same PF and they load without issue using IPA. But I have a file that keeps throwing the 143 error through IPA but not when I run the importdb from the command line. Any ideas I've been struggling with this all morning. Thanks in advance - Laura
|
|
|
|
0 |
1110 |
03/12/2019 11:25 AM |
|
0 Replies and 1171 Views
How can we trigger the Employee ID auto number via IPA? 1171 0
Started by FireGeek21
We are working on implementing security automation for AD and other applications for contractors. They are not, at this point, being entered into LTM but for other reasons the organization would like to enter them into LTM. An option that is being pushed rather strongly is that the point of data entry for these contractors is external to LTM and that a data feed would be sent to LTM to update the 'employee table'.
My concern is how to get the employee number generated. Can the...
|
|
|
|
0 |
1171 |
03/01/2019 9:10 AM |
|
0 Replies and 1139 Views
Update HR155 strange error 1139 0
Started by Lance Jurgensen
I am running a flow that will update an employee group, I need to update the HR155 job prior to running it.
I get an error on field 'TC', but there is no error message.. Anyone seen this
&91;Debug - Feb 18, 2019 8:30:32 AM CST&93; Process resumed
Activity started: LwsnTxn6 (Run Id: 7)
S3 Transaction LwsnTxn6: Calling transaction server https://***redacted***.org:1443 with string _PDL=LAWPROD&_TKN=HR155&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&...
|
|
|
|
0 |
1139 |
02/18/2019 8:37 AM |
|
2 Replies and 1922 Views
Managing Flows --Release VS Restart 1922 2
Started by tambrosi
Hello All,
Have a question that I cannot find no doc on. When using the Info Rich Client, there is a Release and Restart option available. I am trying to find out what the Restart option would be used for.
IE: If a flow that has multiple nodes ends up failing for some reason, and goes to failed status, Will the restart pick up at the failed point or does it go back and execute the flow from the beginning
Thanks...
|
|
|
|
2 |
1922 |
by LisaC 02/13/2019 4:34 PM |
|
1 Replies and 1102 Views
SQL Transaction Node MERGE - Stopped Working 1102 1
Started by FireGeek21
We have a process flow whereby the final SQL Transaction seems to have stopped working. We can execute the UPDATE function via SQL Mgmt Studio but it will not function in the process flow. The flow doesn't have any errors in the log file. All columns are in the right order. I have replaced the node. I have rewrote the whole flow. Nothing seems to work.
Thoughts
MERGE dbName.dbo.tblTarget as T
USING dbName.dbo.tblSource as S
ON (T.PeopleID ...
|
|
|
|
1 |
1102 |
by FireGeek21 02/13/2019 3:58 PM |
|
6 Replies and 1716 Views
WFWK 1716 6
Started by ALW
How do I give a Lawson user access to the WFWK form I am a Lawson user with the Admin role and I can access the form without a problem. Another user who tries to access the WFWK for gets the following error:
|
|
|
|
6 |
1716 |
by edison 02/13/2019 11:43 AM |
|
5 Replies and 1306 Views
Running Stored Procedure From IPA 1306 5
Started by Rkapoor
I am trying to run the stored procedure using sql query node and selecting run sql procedure.
When I click on select button, it connects me to the sql server, all I see is user ids defined in that database, I don't see the list of Stored procedures. any suggestions why I can't see the stored procedures... I don't have access to sql server.
I can run the sql query on this sql server, no issue there.
I can run the stored procedure if I select type sql query,build, other(no...
|
|
|
|
5 |
1306 |
by Rkapoor 02/13/2019 11:06 AM |
|
9 Replies and 3487 Views
FTP node 3487 9
Started by Srini Rao
How do I use the FTP node in IPA I'm not finding the place for FTP URL ,USER and password etc
|
|
|
|
9 |
3487 |
by Jeremy 02/12/2019 8:22 PM |