tag:blogger.com,1999:blog-321374832024-10-08T21:25:49.279-04:00Consult David Wdavid@consultdavidw.comConsult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comBlogger109125tag:blogger.com,1999:blog-32137483.post-17833734936712573512023-01-26T06:43:00.001-05:002023-01-26T06:43:20.727-05:00 Configuration Console Field Mouse Over TextTo add mouse over text to a field follow the syntax belowContractorSubType mouse over text is "For_Travel_Nurse_\or_Visiting_Resident"Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-51203546322287710192022-04-14T07:08:00.000-04:002022-04-14T07:08:18.401-04:00Configuration Console TipsDifferent ways to use a Boolean Derived Field You may want to create a Boolean (true/false) derived field to define your multi-conditional criteriaYou can then use the criteria to determine whether or not to display a form section or to display an individual field -You can also use the criteria to add a field constraint -You can also use the criteria to restrict an Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-86204612973475970252022-04-07T09:17:00.004-04:002022-04-11T14:43:14.991-04:00Configuration Console TipsConstraint of values in a field's dropdown listYou can apply a constraint to a field's dropdown so a specific value is hidden on a form.By applying the constraint as shown, the 'WORKERS COMP' value will not be a valid selection for the user to select (on the form it is applied to), although it is a valid selection in the system.This type of constraint doesn't include theConsult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-14269875650343272282022-03-19T08:55:00.006-04:002023-03-22T15:18:25.420-04:00Configuration Console TipsForm ConfigurationsLayout single column - fields are presented in a single column two column - two fields are presented side by side two column distributed - two fields are presented spaced apart depending upon the width of the fields and formAdd a custom label to a field single column Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-9887073349195759622020-01-07T07:33:00.001-05:002020-01-07T07:33:16.248-05:00Infor GHR and ICIMS - Two Approaches to Integration
I have two difference clients using ICIMS for recruiting and integrating with GHR for onboarding new hires, processing rehires and performing transfers and promotions.
One client is processing a nightly pipe delimited file and the other is using API calls and checking hourly for new transaction data. I'm using IPA to process both integrations.Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-82109246088200999832019-08-20T06:23:00.003-04:002019-08-20T06:23:27.165-04:00Where is the problem? Is it a bug?
I've been involved with a lot of implementations and upgrades over the years and I'm certain that every one of them had hit a snag at one point or another. Whether miscommunication, improper training, or technical issues, all of these needed one step to get to the solution - an evaluation of where the problem lived.
Not just what issue are we dealing with, but where is the actual problem?
Is Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-19756801318311580802019-05-05T09:36:00.001-04:002019-05-05T09:36:49.603-04:00Infor Federation Services - Lessons Learned, Mistakes Made
When the company I was with first implemented IFS we made a lot of mistakes, quite frankly because no one told us the right way to do it. We followed steps that seemed to make sense from past processes in the Infor Lawson world, but which didn't work well in this IFS, ION, & BOD world we were moving to.
Security Roles - we created all of the security roles (from Lawson, Landmark, GHR & Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-63494856109441713702019-04-29T10:20:00.003-04:002019-05-05T08:56:08.976-04:00Infor Federation Services - Logical ID for your Infor applications
Roles are associated to Logical IDs and Logical IDs are associated to the various Infor (and non-Infor) applications that you can access within Ming.le.
Within the Admin Settings menu, select the application to view and look for the Logical ID tied to that system.
Not just answers, providing solutions
Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-6578885648377065902019-04-29T10:09:00.000-04:002019-04-29T10:09:55.360-04:00Infor Federation Services - Are you a User?
We previously discussed Role Management but this time we're interested in User Management. Users are updated in the system(s) by the Security User Master (SUM) BOD but where do you maintain those users and their roles?
Within Ming.le you would access the User Management menu (click the Person icon in the upper right of your screen for the available menus).
Search for the User you Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-77587736999029234362019-04-21T12:26:00.000-04:002019-04-21T12:26:17.040-04:00Infor Federation Services - What Role will you play?
While security roles are stored in IFS, they are actually 'owned' by the systems they sync from.
Whether Landmark multi-tenant (MT), Landmark single tenant (ST), Lawson, EAM, Mongoose, etc. these systems own the roles and they send a Sync.SecurityRoleMaster BOD to IFS to create them.
You can create these roles in IFS, but that only confuses things when you later want to manage the roles Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-49331009098694706572019-04-01T11:48:00.002-04:002019-04-01T11:48:56.410-04:00Infor Process Designer - GLTRANS ObjID References
We had an interesting problem to solve which involved pulling data from the Lawson S3 GLTRANS table (based upon ObjID values). We wanted to pull 2000 records at a time and then trigger another instance of the flow to pull the next 2000, and so on, until all current records were captured.
We didn't want to work with two different versions of the flow, one with the beginning range value preset Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-72985487232334488982019-03-24T13:48:00.000-04:002019-03-24T13:48:09.462-04:00Infor Process Designer - JSON the Sequel
I showed you how to use the JSON Parser to parse your JSON data, but there is another way you can accomplish this using JavaScript in the Assign node.
Use the File Access to load the JSON file into memory and then an
Assign - JavaScript Expression - to cycle through to retrieve your input values
(which could then be written out to an export variable within the same
function).
x=Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-53245766959258944972019-03-24T08:22:00.003-04:002019-03-24T08:22:29.084-04:00Infor Process Designer - Don't fear JSON
A JSON file is similar to XML, but with more of a flattened design, not requiring as many tags to present the same data.
The JSON Parser node in IPA is designed to extract each line of data and create/assign the values to variables.
In the same way a MsgBuilder creates the variable on the fly, the JSON Parser will create variables.
First you have to specify where the line of data Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-3935702850326900542019-03-18T07:42:00.001-04:002019-03-18T07:42:53.265-04:00Infor Process Designer - Another look at your XMLBefore I got comfortable with the XML node I was shown another way to build out my XML data. This is also useful if you don't have access to the schema file.
You can use the MsgBuilder node to build a perfectly acceptable XML tagged structure.
Not just answers, providing solutions
Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-29084404274560489172019-03-18T07:01:00.001-04:002019-03-18T07:01:05.805-04:00Infor Process Designer - My Crazy XML Part 2
We previously discussed parsing with the XML node, this time we will discuss building an XML.
Set the XML node Action to Build XML Object and reference the Schema URL (or file path to the schema file).
Click the Build button and then assign the variables to the data elements. Variables in the XML node are wrapped in { } brackets.
Use the Ctrl + Spacebar shortcut toConsult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-66133491717706516902019-03-11T06:56:00.001-04:002019-03-11T06:56:05.924-04:00Southwest User Group Mega Meeting
If you're attending the Southwest User Group Mega Meeting in April, look for me as I present Integrating with ION on Tuesday morning @ 10:00 am.
https://lgug.workoutloud.com/Event/swug-lawson-user-group-mega-meeting-
Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-10170778582034458132019-03-11T06:42:00.000-04:002019-03-11T06:42:20.295-04:00Infor Process Designer - My Crazy XML (Part 1)
There are two functions you can perform with the XML node; you can parse an XML variable or you can build one. An XML document has a particular layout, with tags to identify the elements and values of the data you're passing back and forth.
IPA flows are actually saved in the XML format.
In order to read the XML file (loaded into your IPA flow as a variable), you have to first parse it.
Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-65239658793909370682019-03-03T18:49:00.001-05:002019-03-03T18:49:01.398-05:00Infor Process Designer - Another way to look at Files
In Landmark, click Start - Data - pfi - Business Classes and then select PfiFileStorage
You will actually see a listing of the files you've written to, or FTP'd to, the Landmark server. You can view the files and copy and paste the contents to your notes application. It is another way to 'look at your files.'
Not just answers, providing solutions
Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-54488078318659630412019-03-03T18:38:00.001-05:002019-03-03T18:38:06.040-05:00Infor Process Designer - What the FTP
We've covered the File Access, reading and writing to files on the Landmark server, but what do you do when the file is on another server? You can transfer a file from or to another server using the FTP node.
First set the source and destination file path and name (you can use a variable) and select whether the source file is on a remote server or the local server. If it is on a remote Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-7039651628542470392019-02-23T04:51:00.002-05:002019-02-23T04:51:41.025-05:00Infor Process Designer - How Common
It may just be my OCD, but I like straight lines in my flow. One easy way to make this happen is to click over to the Common tab on your nodes and set the X and Y coordinates for where it is positioned on your canvas.
Another feature of the Common tab is the Description text area. This is useful if you like to comment the use of the node. I've heard people complain that you Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-61735355380015082902019-02-23T04:39:00.003-05:002019-02-23T04:39:39.634-05:00Infor Process Designer - Did you get my Message?
The Message Builder node is used to build a string variable (which is declared within the MsgBuilder) and allows you to append to that same variable with another MsgBuilder using the same variable name.
You can also use the MsgBuilder within a query loop to build a larger message which contains your query results. The data automatically appends to the declared variable.
You don't have toConsult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-65970951538400618542019-02-17T08:34:00.003-05:002019-02-17T08:37:45.442-05:00Infor Process Designer - Say My Name
Each node contains two properties we haven't discussed previously - the ID and Name.
Each ID must be unique and no spacing or special characters are allowed. It is system generated but in many cases can be over written to make it more meaningful to you when you later reference it within the flow or log.
The Name doesn't have to be unique and, although it defaults depending upon theConsult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-50550616870991950522019-02-17T08:19:00.000-05:002019-02-17T08:19:37.256-05:00Infor Process Designer - The DataIterator (say that 3 times fast)
The definition of iterate is to 'perform repeatedly' and this looping node repeatedly performs a data read of either a file or data variable. The loop continues until it reaches the end of the file or the end of the data. You can set a maximum read iteration value.
The Input method is either a File where you enter the file path and name to iterate (loop) through, or Data where youConsult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-58796216629383585222019-02-11T05:37:00.001-05:002019-02-11T05:37:02.774-05:00Infor Process Designer - File Away with Me
The FileAccess node allows you to interact with files on the server; either reading, writing, appending, checking, deleting, or listing the files available.
The Connection information (for the server) is setup in the Landmark Configuration settings. Depending upon whether you are on premise, single tenant or multi tenant, you may access the Landmark server (only) or the Lawson serverConsult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.comtag:blogger.com,1999:blog-32137483.post-28794679999658325212019-02-07T09:12:00.000-05:002019-02-07T09:12:02.226-05:00Infor Process Designer - You've got Issues
You may notice these pesky error messages in the Process Issues listing or see the warnings on the properties of your nodes.
These signify that you need to take corrective action to eliminate potential issues. I say potential issues because there are two types of warnings. The red circle warnings are serious while the yellow triangle warnings are not.
We used to call these 'hard Consult David W LLChttp://www.blogger.com/profile/15600559773221718895noreply@blogger.com