/
Installing and Connecting Infor Spreadsheet Designer Excel Add-In
Installing and Connecting Infor Spreadsheet Designer Excel Add-In
Infor Spreadsheet Designer for Microsoft Excel can query, view, update, and delete data from the Infor Landmark system.
You can map business classes and actions from the Landmark application database and work with that data in Excel. Mapping creates a link between the mapped classes and actions and Excel. A map you create becomes part of the workbook. If you make changes to the data in Excel, you can send your mapped data back to the Landmark application database.
You can also run a query of Landmark application data and view and analyze your list of records in Excel. This lets you make use of Excel's powerful reporting features. You can save searches and folders that you use frequently so you do not have to create them each time you run a query. For example, you can create a query and map a list and a set of related fields to a worksheet. The worksheet then represents the new data list. You can also map data from a business class and related fields to a worksheet; the updated worksheet is then used to create, update, or delete the business class data. When data is mapped to a worksheet, it is saved in an Excel workbook and the worksheet is connected to the originally mapped data.
Installation
This will automatically download and install all prerequisites and clean up the ClickOnce cache and ISD registry entries from previous installations.
Close Microsoft Excel
Open a browser and navigate to:
https://ssdprd-law-lm01.cloud.infor.com:1443/xmlhttp/landmark/ISDInstall.htmlIn the command prompt, navigate to the location where you have downloaded setup.bat and run it
Configuring ISD in MS Excel
Launch MS Excel
Click the “Infor” tab at the top ribbon menu
Paste the Server URL you need to access:
PRD Lawson: https://ssdprd-law-lsf01.cloud.infor.com
PRD Landmark: https://ssdprd-law-lm01.cloud.infor.com:1443
TRN Lawson: https://ssdtrn-law-lsf01.cloud.infor.com
Related content
Lawson
Lawson
Read with this
Installing and Connecting Lawson Excel Add-Ins
Installing and Connecting Lawson Excel Add-Ins
More like this
Browsing requirements for Lawson
Browsing requirements for Lawson
Read with this
Accessing and Saving the Power BI Position Control Report
Accessing and Saving the Power BI Position Control Report
More like this
Logging into Infor Lawson
Logging into Infor Lawson
Read with this
Extracting data to Excel in FinfInfo applications
Extracting data to Excel in FinfInfo applications
More like this