April 21, 2014
By Tim Kerian
If you’ve ever needed to update a large amount of information onto existing records – you may have been heard saying something like “There’s got to be an easier way!” Rather than spending your day manually typing in values and saving them, take a look at Infor Spreadsheet Designer.
This product is an Excel Add-In that can give you direct access to Landmark data, allowing you to seamlessly select and extract a large number of records into Excel and allow you to use Excel spreadsheet tools to update the information you need onto those records.
Is changing the data outside the application dangerous? Not with Infor Spreadsheet Designer. You’ll use your login to get the data, you’ll only have access to the data your able to see, and can only execute updates your user ID is allowed to perform. Once you’ve updated the records that you’ve extracted, this tool allows you to re-load those records into Landmark. The application edits will then be performed to insure all changes you’ve made are allowed – just as if the changes were being performed within the application. You’ll even be able to see the error messages the application would provide if any of those changes are not allowed.
The following video will show you a step by step example of extracting, modifying and uploading records from a Landmark database file using Infor Spreadsheet Designer.