Export data with the Logsheet Data Extractor

Note: To access and use the Logsheet Data Extractor, your computer must be on the same network as the Production Accounting Database Server.

Activity Steps

  1. Open the Logsheet Data Extractor file from its saved location.
  2. Select the Control worksheet tab.

    Note: If the Production Accounting configuration has changed, click Refresh Lists to update the list of logsheets that can be selected for export.

  3. Select the Environment from which to extract data.
  4. To define a date range, enter the Start Date (>=) and End Date (<).
  5. Select the Logsheet from which to extract data. You can select multiple logsheets.
    1. To select multiple consecutive logsheets:
      1. Click the first logsheet.
      2. Press and hold down the Shift key.
      3. Click the last logsheet.
    2. To select multiple non-consecutive logsheets:
      1. Click the first logsheet.
      2. Press and hold down the Ctrl key.
      3. Click each of the other logsheets.
  6. Click Export.

    The data is extracted and displays on the ExportedData worksheet. If you selected multiple logsheets, all data displays on the same worksheet. Each logsheet is identified by its SetID.

    Note: To export more logsheet data, repeat steps 2-6. Each time you export, the data on the ExportedData worksheet is replaced. Copy data you want to preserve to another sheet or file before you export again.