WorkManager Category Code list print out process

1. From WM main Editor window, go to the Extras menu and open the Admin window.
2. Within the Admin window, under the Query menu, select Show and then LBNL CATEGORY CODES Leave this window displayed for later.
3. Go back to the WM main Editor window, to the Extras menu and open the Command line window.
4. In the command line window, type LTAB_TO_CSL and hit return. (This command is used to save out a logical table to a comma separated list file.)
5. At this point, WM is asking you which logical table you want to save. Click anywhere in the previously displayed Query window to identify that logical table.
6. Now WM asks for a file name for where you want to store the CSL file. Provide the filename in quotation marks and use a ".csv" file name extension. CSV stands for comma separated values which the same thing as a CSL file. We use CSV because Excel likes it. For example:

   	"C:\filename.csv"
   

   This creates a file at the root level of the C: drive, with a .csv extension.
7. This type of file can be double-clicked which will load it directly in MS Excel. Once the file is opened in Excel, format it for general use:
   • Remove duplicated top line: select top row and delete.
   • Expand column spacing: select all by clicking in the upper most left square, then double-click on the separator between columns A and B in the header of the first row.
   • Set the category codes format: select columns B and C and use the Format menu, then select custom. Specify "00" for the format specification of the numbers to be displayed. This causes single digit numbers to be padded with leading zeros (e.g. 1 displays as 01).
   • Delete columns as desired.