Search this forum:
Search
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 1 of 1212345 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 2028 Views Parse the data from Web API    2028  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 2028
11/4/2020 4:48 PM
2 Replies and 14543 Views Use IPA to query IFS    14543  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 14543
by  AndyGJump to last post
9/16/2020 3:47 PM
11 Replies and 19841 Views LPA- Default work title for UA    19841  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 19841
by  B LedetJump to last post
8/10/2020 2:20 PM
2 Replies and 14811 Views Using Web Service in IPD 10.1.1    14811  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 14811
by  HDAustin13Jump to last post
3/3/2020 9:19 PM
10 Replies and 20156 Views Create export files from SQL code via IPA or crystal and LBI?    20156  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 20156
by  FireGeek21Jump to last post
1/25/2019 12:09 AM
5 Replies and 16297 Views IPA Batch Job Montioring after WebRun node kicks it off    16297  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 16297
by  dmcdougaldJump to last post
12/27/2018 2:23 PM
1 Replies and 14399 Views Email Node - High Importance Option    14399  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 14399
by  JimYJump to last post
6/29/2018 4:12 PM
2 Replies and 14774 Views Calling Jobrun.exe to submit jobs    14774  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 14774
by  Deleted UserJump to last post
3/12/2018 1:37 PM
1 Replies and 17324 Views FTP Node – Retrieve latest file from remote source folder    17324  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 17324
by  Kyle JorgensenJump to last post
2/20/2018 6:25 PM
1 Replies and 15304 Views Check If file directory exists, if does not exists create directory    15304  1 Started by  agersh Using V10 IPA is it possible to check if a network directory exits If the directory does not exist then create the directory on the network drive
1 15304
by  brox07Jump to last post
9/11/2017 8:07 PM
2 Replies and 15852 Views Convert TXT to PDF    15852  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 15852
by  PDJump to last post
5/19/2017 4:57 PM
9 Replies and 22241 Views javascript functions in processflow    22241  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 22241
by  Joan HerzfeldtJump to last post
8/16/2016 12:04 PM
5 Replies and 15959 Views Use Javascript to format Rate of Pay and FTE values from database table to include decimals    15959  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 15959
by  Dave CurtisJump to last post
7/28/2016 4:48 PM
3 Replies and 29067 Views Email Node - Include a picture in email content    29067  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 29067
by  Corvette JimJump to last post
6/1/2016 5:16 PM
1 Replies and 15342 Views Can Process Flow execute a Crystal Report and Print the report to a specific Network Printer.    15342  1 Started by  agersh Is it possible to create a process flow that would execute a Crystal Report located on our Lawson V10 LBI Server and instruct Crystal to printer the report to a specific network printer.
1 15342
by  Shane JonesJump to last post
5/10/2016 6:28 PM
2 Replies and 15789 Views Having trouble determining the HR15.1 PageDown AGS Call    15789  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 15789
by  agershJump to last post
2/2/2016 9:04 PM
9 Replies and 18423 Views Parse CSV Comma Delimited File with Quotes and Embedded Comma    18423  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 18423
by  GeoffTSJYJump to last post
8/4/2015 8:23 PM
1 Replies and 18313 Views ActiveX Component can't create object when trying to run wizard    18313  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 18313
by  WoozyJump to last post
7/1/2014 1:15 PM
23 Replies and 34308 Views Installing and Configuring MSSQL JDBC for ProcessFlow Integrator    34308  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 34308
by  masonpJump to last post
3/13/2012 3:07 PM
9 Replies and 24465 Views Someone - please share your PFlow Trigger form....    24465  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 24465
by  JeffRJump to last post
6/1/2010 4:13 PM
87 Replies and 61114 Views Migrating 8.0 Flows to 9.0    61114  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 61114
by  Shane JonesJump to last post
9/1/2009 5:58 PM
1 Replies and 3476 Views Datetime Conversion  3476  1 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 3476
by  John HenleyJump to last post
2/28/2023 2:05 PM
3 Replies and 2277 Views Data Iterator reset  2277  3 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 2277
by  John HenleyJump to last post
2/28/2023 2:02 PM
0 Replies and 1098 Views IPA Timeout error  1098  0 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 1098
9/1/2022 5:02 PM
1 Replies and 4868 Views SQL query to pull Reqs and who Approved them  4868  1 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 4868
by  Jay SJump to last post
8/31/2022 6:04 PM
6 Replies and 14227 Views PR170 file locatoin  14227  6 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 14227
by  adnan512Jump to last post
5/1/2022 1:02 PM
13 Replies and 14052 Views How to assign a DistGrp using IPA  14052  13 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 14052
by  JerryJump to last post
1/17/2022 3:32 PM
2 Replies and 10624 Views Sample CSV flow for IPA  10624  2 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 10624
by  Ragu RaghavanJump to last post
12/22/2021 7:07 PM
1 Replies and 9535 Views JDBC MS Access from IPA  9535  1 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 9535
by  David WilliamsJump to last post
12/6/2021 4:28 PM
11 Replies and 25481 Views Attaching Employee Pictures using Process Automation  25481  11 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 25481
by  Vlad AlcasidJump to last post
6/3/2021 1:55 AM
7 Replies and 34314 Views REST Calls in Infor Process Automation  34314  7 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 34314
by  LauaLuauJump to last post
5/3/2021 6:20 PM
2 Replies and 13326 Views Terminating Pflow after a certain amount of time  13326  2 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 13326
by  DebraJump to last post
4/21/2021 6:53 PM
1 Replies and 12716 Views Write File adding extra record  12716  1 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 12716
by  Ragu RaghavanJump to last post
4/15/2021 6:36 PM
2 Replies and 13524 Views FTP node and carriage returns  13524  2 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 13524
by  ScooterJump to last post
3/29/2021 3:31 PM
0 Replies and 2178 Views IPA with DocuSign/Fill & Sign  2178  0 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 2178
3/17/2021 5:47 PM
1 Replies and 13611 Views Can IPA send to a Printer??  13611  1 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 13611
by  Ragu RaghavanJump to last post
3/12/2021 4:34 PM
0 Replies and 2292 Views SQLQRY node issues creating a CSV  2292  0 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 2292
2/26/2021 4:57 PM
1 Replies and 13580 Views combining records from file  13580  1 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 13580
by  Ragu RaghavanJump to last post
2/12/2021 2:41 PM
11 Replies and 14960 Views Import data from CSV file to an external Oracle table  14960  11 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 14960
by  HDAustin13Jump to last post
2/3/2021 1:59 PM
5 Replies and 14720 Views Reading ,Update & append files from FTP  14720  5 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 14720
by  AshishJump to last post
1/29/2021 1:34 PM
5 Replies and 17140 Views File move/copy from within IPA (Processflow)  17140  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 17140
by  DebraJump to last post
1/14/2021 4:11 PM
2 Replies and 13941 Views PfiUserProfile in Landmark  13941  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 13941
by  DemiJump to last post
12/15/2020 2:36 PM
7 Replies and 14518 Views IPA v11 - Updating field with a value containing an ampersand  14518  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 14518
by  Orlando GrayJump to last post
10/21/2020 9:44 PM
6 Replies and 16945 Views alt rates  16945  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 16945
by  Ragu RaghavanJump to last post
10/16/2020 8:09 PM
6 Replies and 15841 Views IPA 1 GB memory limit error  15841  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 15841
by  RobertJump to last post
9/1/2020 9:20 PM
0 Replies and 1834 Views email authentication  1834  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 1834
8/26/2020 1:14 PM
8 Replies and 14580 Views Triggering WFWK after a PR140 job run  14580  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 14580
by  B LedetJump to last post
8/5/2020 3:19 AM
0 Replies and 1935 Views using a flow to change LBI bookmarks  1935  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 1935
8/4/2020 12:44 PM
2 Replies and 14154 Views Automation for disabling active Directory  14154  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 14154
by  Kristi_ANTHCJump to last post
8/3/2020 4:23 PM
2 Replies and 13588 Views Flow submitting a single job multiple times??  13588  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 13588
by  Karen SheridanJump to last post
7/30/2020 6:28 PM
2 Replies and 13402 Views Array values from Rich Client  13402  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 13402
by  Karen SheridanJump to last post
7/30/2020 2:28 PM
2 Replies and 13461 Views Error with Landmark Admin node  13461  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 13461
by  QuarantineJump to last post
7/28/2020 5:40 AM
2 Replies and 13423 Views Capture joblog in IPA for Email Node?  13423  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 13423
by  Karen SheridanJump to last post
7/8/2020 3:08 PM
3 Replies and 14449 Views MT IPA: Getting Employee Audit History in IPA  14449  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 14449
by  David WilliamsJump to last post
6/12/2020 12:58 AM
8 Replies and 16337 Views Sorting and summarising a csv file in IPA  16337  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 16337
by  QuarantineJump to last post
6/8/2020 1:29 PM
1 Replies and 13489 Views IPA Web Service to MS Exchange (Soap)  13489  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 13489
by  David WilliamsJump to last post
5/27/2020 7:22 PM
2 Replies and 13553 Views Data manipulation and Emails in IPA  13553  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 13553
by  Joan HerzfeldtJump to last post
5/18/2020 7:25 PM
4 Replies and 14261 Views Lawson Query doesn't like a space.  14261  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 14261
by  Joan HerzfeldtJump to last post
5/15/2020 7:09 PM
5 Replies and 14537 Views Best way to create a lookup table in IPA  14537  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 14537
by  QuarantineJump to last post
5/13/2020 8:49 AM
8 Replies and 16923 Views Dynamically assigning users to useraction  16923  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 16923
by  Bob CanhamJump to last post
5/6/2020 11:50 PM
0 Replies and 9615 Views Adding Form URL link in Email  9615  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 9615
5/6/2020 2:43 PM
10 Replies and 15971 Views XML Node parse and assign  15971  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 15971
by  David WilliamsJump to last post
4/27/2020 3:15 PM
4 Replies and 17214 Views IPA-REST API (web run)  17214  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 17214
by  Lan HenryJump to last post
4/24/2020 6:33 PM
6 Replies and 15876 Views ESS and IPA  15876  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 15876
by  thanefJump to last post
4/8/2020 10:06 PM
1 Replies and 15054 Views Encrypt a file in IPD flow  15054  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 15054
by  John HenleyJump to last post
4/3/2020 4:56 PM
6 Replies and 14501 Views Update configuration settings via IPD  14501  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 14501
by  FireGeek21Jump to last post
3/31/2020 5:39 PM
5 Replies and 14670 Views Javascript error .. invalid XML character  14670  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 14670
by  David WilliamsJump to last post
3/26/2020 6:55 PM
0 Replies and 2337 Views MA60.3 Transaction Query  2337  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 2337
3/2/2020 10:15 PM
7 Replies and 14203 Views Req Item Rec Service Definition  14203  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 14203
by  Joan HerzfeldtJump to last post
2/20/2020 3:22 PM
5 Replies and 15258 Views IPA - reading CSV file  15258  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 15258
by  Todd MitchellJump to last post
1/9/2020 7:38 PM
2 Replies and 14238 Views V11 Inbasket displays for User Actions  14238  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 14238
by  ScooterJump to last post
12/27/2019 2:29 PM
5 Replies and 16240 Views Array size limit  16240  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 16240
by  Ragu RaghavanJump to last post
11/29/2019 9:30 PM
1 Replies and 14642 Views Deleting UserIDs from Landmark Security  14642  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 14642
by  ScooterJump to last post
11/27/2019 4:05 PM
1 Replies and 14165 Views IPA performance  14165  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 14165
by  JimYJump to last post
11/22/2019 11:47 AM
3 Replies and 14618 Views WriteAttach via WebRun  14618  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 14618
by  TomEDJump to last post
11/21/2019 9:44 PM
9 Replies and 16690 Views Modifying Lawson Environment Info from a Flow  16690  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 16690
by  AdamJump to last post
11/20/2019 3:10 PM
0 Replies and 1524 Views Referencing Business Tasks in an IPA Flow  1524  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 1524
11/18/2019 7:09 PM
0 Replies and 2484 Views QUEUEDJOBS WebRun  2484  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 2484
11/13/2019 9:08 PM
3 Replies and 13803 Views Web Run Node - File Upload  13803  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 13803
by  David WilliamsJump to last post
11/8/2019 7:10 PM
2 Replies and 14534 Views Resource Update Node - Remove specific Role or Group  14534  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 14534
by  JimYJump to last post
10/21/2019 9:31 AM
1 Replies and 13967 Views Issue with JavaScript Date  13967  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 13967
by  David WilliamsJump to last post
10/15/2019 7:22 PM
2 Replies and 13472 Views Effective Date in a flow/form  13472  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 13472
by  weeoooohhhhJump to last post
10/11/2019 2:29 PM
7 Replies and 14711 Views Batch job monitoring with ProcessFlow  14711  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 14711
by  ScooterJump to last post
10/2/2019 6:22 PM
3 Replies and 14772 Views IPA and ADFS issues  14772  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 14772
by  Joan HerzfeldtJump to last post
10/2/2019 4:18 PM
10 Replies and 18221 Views Converting .prt file to Excel formats  18221  10 Started by  Scooter Thanks for your assistance.
10 18221
by  ScooterJump to last post
9/5/2019 1:06 PM
4 Replies and 14367 Views System Command node  14367  4 Started by  Scooter for example: cd /Lawson/ cp fileA fileB  
4 14367
by  steve fingerJump to last post
9/4/2019 1:05 PM
8 Replies and 15165 Views How do I update information on page 3 of HR15.1  15165  8 Started by  Todd Mitchell How do update an item on 'page 3', page down twice, of HR15.1. 
8 15165
by  David WilliamsJump to last post
8/21/2019 3:38 PM
5 Replies and 14697 Views Removing Identities with IPA  14697  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 14697
by  ScooterJump to last post
8/15/2019 8:29 PM
2 Replies and 14142 Views How to calculate last day of current month  14142  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 14142
by  ScooterJump to last post
8/14/2019 8:01 PM
5 Replies and 14558 Views IPA Data Iterator node cannot find input file.  14558  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 14558
by  ScooterJump to last post
8/13/2019 8:19 PM
0 Replies and 2142 Views IPA Email Node when SMTP Server is Unavailable  2142  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 2142
8/12/2019 9:12 PM
13 Replies and 15233 Views Records returned in IPA using lawson query node  15233  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 15233
by  steve fingerJump to last post
8/8/2019 11:28 AM
8 Replies and 15235 Views IPA - Webrun used to update Landmark  15235  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 15235
by  JimYJump to last post
8/8/2019 10:15 AM
2 Replies and 14318 Views Setting up IPA Service Process in new IPA environment  14318  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 14318
by  Kert490Jump to last post
7/31/2019 2:04 PM
0 Replies and 2243 Views powershell script vs for loop w/IPA nodes  2243  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 2243
7/10/2019 7:17 PM
1 Replies and 13627 Views Server Timed Out  13627  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 13627
by  steve fingerJump to last post
7/10/2019 2:30 PM
0 Replies and 2064 Views Updating PO20.2 using Transaction Node  2064  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 2064
7/8/2019 3:05 PM
0 Replies and 2617 Views Landmark transaction query results  2617  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 2617
6/20/2019 7:36 PM
9 Replies and 14926 Views Parsing CSV with double quotes  14926  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 14926
by  steve fingerJump to last post
6/18/2019 4:49 PM
0 Replies and 2261 Views Cannot activate or deactive a File Channel in Rich Client  2261  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 2261
6/1/2019 8:29 AM
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 1 of 1212345 > >>


RSS Feed Available