Exporting records

You can extract information from the database without making an external connection by exporting records from Item Harmony to a file. The export file can hold up to 64,000 records and can be viewed using Microsoft Excel.

To export records:

  1. Open the page from which to export records.
  2. Click the List View tab.
  3. Select the Dataspy that you want to run.
  4. Click the Run button.
  5. Click Save Grid To Excel button in the upper right corner of the page. The system opens a new browser window and displays the File Download dialog box.
  6. Perform one of these steps:
    Option Description
    Save To save the export file, click Save.
    Open To view the records in spreadsheet format, click Open. Once opened, you can use File > Save As to save the spreadsheet as an .xls file.
    The system exports the results of the last Dataspy query performed, even if you are not currently viewing those records because you have cleared the page or because they exceed the limit of what can be displayed on the grid.