How do I use the FTP node in IPA I'm not finding the place for FTP URL ,USER and password etc

Hello All, I need to write a sql query to list of all work units that have been ran on the system (those that are shown in the Work Units, Rich Client tool) including all status of Completed, Failed, Cancelled, etc. Can any one please advise which database tables that I can use for this query Thanks in advance. Han

I have a Process Trigger created for an Process Flow with 2 date trigger variables. I am trying to schedule this IPA to run everyday. I want the date variables to dynamically populate with the respective date of the day it is running. For example, if it kicks off today the 2 trigger variables should be today's date, tomorrow it should be tomorrow's date and so on and so forth. Attached is the image of what I am trying to do. What should I put in the value of the Trigger variables CheckBeginDate ...

I am trying to find an easy was that a user can easily pass 3 dynamic parameters to a Process flow and initiate the process.  I created jobs before that wait for a file and then read it, but I would like to do it from a custom Form if possible.  I'm not finding what I need so far.  Any ideas

Hello everyone, I am trying to create an IPA flow that generates an output as the 'delimited text' output file (as shown below) but keep having an issue of it does not spool the output file even thought it said so in the log file. Sample Delimited text which begin and end of each with double tildes (~~) and separate each column with the pipe (|):  ~~ContractNumber|ContractName|Location~~ Does any one know if this possible to get done in IPD version 10.1.1.78 Here is how I di...

We Designed a Process Flow that has a Submitter and an Approver.  Sometimes, one of the users go on Vacation so I create a Proxy User for the person going on Vacation.  However, when running the Process Flow, the email that states that 'this needs to be approved' goes to the person on vacation not to the Proxy User.  Same thing for submitting a file to be processed by the processflow (workflow).  Any emails that would go to the Submitter should go to the Proxy user but they s...

We have a workflow that has a submitter and an approver.  Instead of me being the submitter and approver, I made a proxy user for both.  The file was submitted and goes through the workflow.  The proxy user gets the file in his inbasket to approve or reject but I am getting the email not him.  Is there something we must do in order for him to get the email instead of me  We want to use this feature for when people are on vacation or out of the office for an extended per...

I have setup the users Filters in IPA so that the Filter Values correspond to 'Submitter' and and 'Approver' that will get emailed.  Currently I set the oCatValue to the Filter Value and get back the Email addresses associate with the users with that Filter Value. The requirements want us to allow multiple Filter Values, so I would like to do something like oCatValue = '3602402355,3601403355' where 3602402355 and 3601403355 are different filter values and get back all emails for users...

A file gets created on a completely separate server. I do work with the file, then I need to delete it from the remote server . . . Im using the File Access node to delete it, but it is not finding the path, actually doesnt even find the server. I have the server, user and password already in Richclient (sys config) under the FileTransfer tab (don't see spot to create one under FileAccess tab).   Any Help

Hello All, I am working on a project that requires an IPA to send query results to a format of delimited text file (*.txt) which use special characters like (|,~, ^) to separate each record. Can any one please advise on how it can be done in IPA (IPD Designer CU70) Thanks in advance, Han

Anyone using IPA to do validation of address USPS has an API that allows the use of XML calls and returns address validation through their API.  Was wondering if anyone has done this.   Dave

I am developing a IPA workflow to import data from a spreadsheet and then create Lawson Transactions from each record in the spreadsheet.  I am using a double dimension array in javascript to store the lines and columns from the spreadsheet before I validate and then import the data with Lawson Transaction nodes.   When I run the process on the development server, it runs fine and the Transaction nodes insert the data in the database with no errors.  When I deploy to the develop...

I am in the process of modifying some flows and converting the CGI getattachment processing to the ListAttachments service.  I am having trouble getting the ATTACHMENT-NAME and ATTACHMENT-TEXT values.  I am able to access orther values such as LIST numRecords value.  I took a XML file returned from a call to the service in a browser and created an .xsd file from it.  I don't know if the issue I am having is with the xsd or how I am trying to access the values in the flow.&nbs...

Hello, I have been looking and trying everything I have found but still can not get past the Ok to continue prompt. Is there documentation somewhere on these for each form My AGS call to update the STUDENT flag to N _PDL=HRDEV&_TKN=HR13.1&_EVT=CHG&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=C&EMD-COMPANY=15&EMD-EMPLOYEE=123456&EMD-SEQ-NBR=2&EMD-STUDENT=N&VERIFY-DATE=&EFFECT-DATE=20181210&CREATE-TRANS=N&_DELIM=09&_OUT=XML&_EOT=TRUE I'm...

For my current client, I have been requested to extract employee termination history to show why the employee was terminated.  I can easily do this in S3, but I am not sure where to look in the Landmark database.  Can anyone point me in the right direction  In S3, the reason code I need was stored in the PERSACTHST table.  I am hoping there is an easy way to extract the data I need out of the Audit Log.

I am trying to update BN32.1 lines but it always wants to update line 1. The query brings back the DC plans that do not have a stop date for terminated employees. Is there a way to determine what line a record is on  In my example I have Benefit Type = DC and in the form the inquire brings back 3 lines, a DC04, DC02 and a DC05. My transaction string is as follows and I'm guessing I need to do something on the highlighted entry below _PDL=&_TKN=BN32.1&_EVT=CHG&_RTN=DATA&_...

I have an automated flow to disable my users but I am stuck on the process to remove the Requester Identity.  I currently am trying to use a Resource Update node, but it deletes the entire user profile.  Any help is truly appreciated!!

  I have created a custom design studio page for inbasket display exec, the page shows up fine in user's task, but it also displays the Lawson grey ribbon as well with options of Help and User's preferences. Is there way to hide this ribbon, see attaché screen shot... Thanks  

Goal  - Capture employee changes from Lawson and update AD attributes with new changes, such as phone number/Manager's info/Activate/Deactivate user. I am planning to read HRHistory table to capture the changes at end of the day into CSV file, then  update AD with new information. Is it possible to use sycmd node to run power-shell script to update AD    

We have a system command node configured to invoke Windows PowerShell on the application server and run a PowerShell script file.  We need to use the PowerShell Active Directory module to update Active Directory. Currently pfuser is the account that can update Active Directory.  The system command node runs as Lawson so we get a security violation when the PowerShell script runs.  Can the system command node be configured to run as a different user  Configuring the Sys Cmd t...

I'm using the data interator to input a file.&160;&160; The file is comma seperated.&160; The fields are 'Name', 'ID', 'Email','Company', etc. I have four variables, varName, varID, varEmail, varCompany What I want to do is simply loot is through the file and assign each of the fields to its corresponding variable in an assignment node that is nested within the data iterator loop.&160; I do not want to have to read the whole line into one variable and then use code to parse the line into i...

Hello,   I am working on a flow that is triggered from LP51.  I am running into an issue though if there are multiple people that have the leave in a pending status.  For example I have an employee EE 202065 that has a personal leave entered, but the flow has stopped on a User Action Node to determine the employee's eligibility.  Then I put in a leave request for EE 200367 (myself), however, when the flow runs it is pulling the employee with the higher number.  ...

Hello,   I am working on a flow in IPA for Leave of Absence Processing.  In the flow there is a User Action Node where the end user choose one of the following actions:   Employee Returned from Leave Employee Failed to Return (Terminate) Extend Employee Leave I need a way to get the effective date of the action, but this may not be the same date as when the User Action was completed.  Lawson recommended having the end-user put in the date as a message on the action, wh...

We recently upgraded to v11 Landmark (v10 LSF) and we want to revisit the proxy functionality now that it will proxy tasks rather than roles.  One concern that has come up is if someone were to assign a proxy to someone who is not of the appropriate leadership level (i.e. a Director setting up a manager under them as a proxy).  One way I was thinking to avoid this would be if I could trigger a flow when someone creates a proxy record that would check if the person is of the appropriate...