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.

1. Close Microsoft Excel

2. Open a browser and navigate to:
   https://ssdprd-law-lm01.cloud.infor.com:1443/xmlhttp/landmark/ISDInstall.html

3. Download Infor Spreadsheet Designer Installer

4. In the command prompt, navigate to the location where you have downloaded setup.bat and run it

Configuring ISD in MS Excel

1. Launch MS Excel

2. Click the “Infor” tab at the top ribbon menu

3. Paste the Server URL you need to access:

   1. PRD Lawson: https://ssdprd-law-lsf01.cloud.infor.com

   2. PRD Landmark: https://ssdprd-law-lm01.cloud.infor.com:1443

   3. TRN Lawson: https://ssdtrn-law-lsf01.cloud.infor.com

Open