Run the query

  1. Choose Tools → Queries.

    The Queries dialog box appears.

  2. Expand Staff, Activities and Training Queries → Staff Activity Queries.
  3. Select Export ISO Activity User Fields, and then click Run.

    The Query - Export ISO Activity User Fields dialog box appears, displaying the results of the query.

  4. Click Options, and then choose Print or Output to.

    The Output Query To dialog box appears.

  5. Under Select Output Type, select Other File Type.

    The dialog box refreshes, displaying options for saving the query to this type of file.

  6. From the menu under Other File Type, select ASCII File (Comma-Delimited).
  7. In the field next to File, type C:\ISO_ACT.TXT

    Caution: The file must be saved to this location and with this file name, as the import definitions depend on this path and file name.

  8. Click OK.

    A confirmation dialog box informing you that the file has been created appears.

  9. Click OK.
  10. In the Query - Export ISO Activity User Fields dialog box, click Close.
  11. In the Queries dialog box, click Close.
  12. Continue with Import the data.