The Lawson database relationships are stored in the GEN database. Foreign key constraints are not actually added to the database tables. So, to see what these relationships are, you can query the GEN data. The primary relationship information is stored in FILEREL. Then, to get the fields that are used in the relationship you’ll need to join FILRELFLD and FILEINDFLD. FILERELFLD contains the primary field names, and FILEINDFLD contains the foreign field names. The below query is a sample run against a SQL Server database for a data area called “TEST”.
SELECT RTRIM(FILEREL.FILENAME) PARENT_FILE,
RTRIM(FILEREL.RELFILE) CHILD_FILE,
REPLACE(RTRIM(FILERELFLD.FRFLDNAME), ‘-‘, ‘_’) PARENT_FIELD,
REPLACE(RTRIM(FILEINDFLD.FLDNAME), ‘-‘, ‘_’) CHILD_FIELD
FROM FILEREL INNER JOIN
FILERELFLD ON FILERELFLD.FILENAME = FILEREL.FILENAME AND
FILERELFLD.RELNAME = FILEREL.RELNAME INNER JOIN
FILEINDFLD ON FILEINDFLD.FILENAME = FILEREL.RELNAME AND
FILEINDFLD.INDEXNAME = FILEREL.INDEXNAME AND
FILEINDFLD.FLDNBR = FILERELFLD.FLDNBR INNER JOIN
FILEDEF ON FILEDEF.FILENAME = FILEREL.FILENAME
WHERE FILERELFLD.FRFLDNAME <> ‘ ‘ AND
FILEREL.PRODUCTLINE = ‘TEST’
10 technology trends that will impact our lives in 2020
NewsThe start of the new decade has a slew of technological advancements and changes that will influence our lives. Anis Uzzaman of Pegasus Tech Ventures shares an article on VentureBeat of the top trends we will most likely see that will impact our lives in 2020.
We’re heading into the next decade with a handful of technologies that will impact us and change the world. There is no doubt that 2020 will be a time of innovation and better leveraging of technology.
For Full Article, Click Here
Triggering an IPA Process Manually
Articles, Frontpage Article, NewsTo trigger a process manually, you first have to set up a trigger. From Rich Client, navigate to Start > Process Server Administrator > Scheduling > By Process Definition. Click Actions > Create to create a new trigger. For Process Name, select the IPA process that you want to run. Enter a descriptive Work Title (the trigger will fail if it doesn’t have a Work Title). Click Save. Then, click Actions > Start. Check the Work Unit log to see that your process has run! If you want to delete your trigger, you will first need to delete the work units associated with it.
Can’t Miss ERP Trends for 2020
NewsEnterprise Resource Planning (ERP) software has evolved and adapted to the ever-changing business needs, customer demands and enterprise innovations. Solutions Review has highlighted some major trends we should take note of in 2020.
For Full Article, Click Here
Activating Landmark Time Zones in Configuration Console
Articles, Frontpage Article, NewsTo activate the time zones available in your Landmark applications, from the GEN data area, go to Start > Configure > Application. Under “Data Area” in the left panel, select “Time Zones”. Find the Time Zone(s) that you want to activate, and double-click to edit. Set the “In Use” flag. Now that Time Zone will be available to select in your Landmark applications.
Top retail technology stories of 2019
NewsRetail technology has made great strides in 2019. Computer Weekly shares what technologies that retailers were rushing to adopt how consumer behavior is changing. In an attempt to deal with today’s fickle’s customers, retailers have been implementing modern technologies to cater to shopper habits. Experimentation with different technologies, data, artificial intelligence (AI), virtual reality (VR), augmented reality (AR), and mobile applications have made huge impacts in the industry. Some of the top trends in retail technology this year include:
To read the full list of trends, refer to the link below and read the full article on Computer Weekly.
For Full Article, Click Here
Landmark Application Configuration Overview
Articles, Frontpage Article, NewsThe Landmark Configuration Console allows you to effect system-wide changes with no downtime for your users. You can personalize your Landmark applications in a multitude of ways:
The Infor-delivered role what will allow users to access Configuration Console is GlobalUIConfigAccess_ST. The role that will allow users to access Security Configuration is SecurityConfigAccess_ST.
IBM announces battery technology breakthrough
NewsA breakthrough in battery technology has happened for IBM research. According to Tech Republic, this new technology – which is said to potentially make lithium-ion batteries obsolete – can charge incredibly quickly, has low flammability, contains no heavy metals, and is more environmentally friendly than current battery technology. Battery performance complaints aren’t anything new, but there was still the need to improve the technology. Though IBM is keeping private about this new breakthrough, it’s safe to say that it will be a real game changer in the tech space. The article on Tech Republic shared that the three components of IBM’s newest battery can all be extracted from sea water, which means the environmental damage from, and humanitarian cost of, mining heavy metals for batteries could be eliminated and reduce costs. Other known details of the new technology are:
For Full Article, Click Here
Use IPA FTP Node to Transfer Multiple Files
Articles, Frontpage Article, NewsWhen you are using IPA to transfer files, there may be some cases where you need to pick up multiple files, or where you need to get files for which you only know a partial name (such as a file that contains a date/timestamp). To get multiple or masked files, you can supply an asterisk (*) in the filename as a wildcard. Then, the destination file should actually be a directory name (of a directory that exists). All files that are picked up in the FTP process will be placed in that directory, and you can use them from there.
Get Database Relationships from GEN
Articles, Frontpage Article, NewsThe Lawson database relationships are stored in the GEN database. Foreign key constraints are not actually added to the database tables. So, to see what these relationships are, you can query the GEN data. The primary relationship information is stored in FILEREL. Then, to get the fields that are used in the relationship you’ll need to join FILRELFLD and FILEINDFLD. FILERELFLD contains the primary field names, and FILEINDFLD contains the foreign field names. The below query is a sample run against a SQL Server database for a data area called “TEST”.
SELECT RTRIM(FILEREL.FILENAME) PARENT_FILE,
RTRIM(FILEREL.RELFILE) CHILD_FILE,
REPLACE(RTRIM(FILERELFLD.FRFLDNAME), ‘-‘, ‘_’) PARENT_FIELD,
REPLACE(RTRIM(FILEINDFLD.FLDNAME), ‘-‘, ‘_’) CHILD_FIELD
FROM FILEREL INNER JOIN
FILERELFLD ON FILERELFLD.FILENAME = FILEREL.FILENAME AND
FILERELFLD.RELNAME = FILEREL.RELNAME INNER JOIN
FILEINDFLD ON FILEINDFLD.FILENAME = FILEREL.RELNAME AND
FILEINDFLD.INDEXNAME = FILEREL.INDEXNAME AND
FILEINDFLD.FLDNBR = FILERELFLD.FLDNBR INNER JOIN
FILEDEF ON FILEDEF.FILENAME = FILEREL.FILENAME
WHERE FILERELFLD.FRFLDNAME <> ‘ ‘ AND
FILEREL.PRODUCTLINE = ‘TEST’
4 Ways To Make Strong Connections As A Remote Worker
NewsIn this digital age there are a great amount of people who are able to work for a business remotely. Working remotely can be a nice perk but also very difficult. There are some factors to this job type that you can control and others not so much. Chris Kaundart at Trello shares a few habits and tips for those of us who telecommute to work.
While it’s becoming more and more of a norm for telecommuting and working remotely, we shouldn’t take the human relationships aspect out of businesses. With Chris’ tips mentioned above, you can still be very present in your company’s work culture and forge relationships with your remote co-workers.
Original post by Chris Kaundart at Trello
For Full Article, Click Here