How to Run Report for Kari’s Org Chart

This process outlines the steps to export Lawson data used for Kari's Org Chart

Run & export the STAFFSUPER report in Lawson

Use WinMerge to highlight changes or updates in data

Run & export the STAFFSUPER report in Lawson

In Lawson, search for HR170

Select SCROSTER for Job Name, then click Inquire

Under Parameters, choose 'today' for As of Date (keyboard shortcut: 't')

Click Change

Click Submit (x2)

Click Print Mgr

Double-click STAFFSUPER

Click Create CSV File

Remove all columns except for the 4 below; sort by Employee (#)

Save as CSV (save to your desktop is fine)

Find the last CSV file and ensure the data is in the same 'shape' and format as the current data - save it in the same place as the new file

Select both the new and old CSV (Ctrl key) and right click, then choose WinMerge

WinMerge then opens - Click on Tools, then Generate Report, and save the report as an HTML file

The HTML report file opens in internet browsers and shows the user the discrepancies: