iMIS Desktop Utilities menu

The commands on the Utilities menu help you maintain and monitor reports, tables, and data that are used throughout iMIS.

Note: Be aware that, as functionality moves to .NET, many of these utilities are being replaced by and incorporated into DB Repair and DB Upgrade, which are available from your iMIS program group.

The Utilities menu is only available from iMIS Desktop.

Report Specs

Opens the Report Specifications window, where you can copy and modify standard reports.

Update Standard Tables

Updates standard report specifications.

SQL Query

Opens the SQLQuery window, where you can enter and execute SQL commands.

Reports and Queries…

Opens the System Reports and Queries window, where you have access to SQL scripts that can be run to manipulate your iMIS data.

Drop Table_Specs

Refreshes table cache to run faster queries.

Run

For developers: Executes an iMIS procedure.

Open Application

For developers: Opens a different Omnis library.

Data Transfer Utility

Opens a sub-menu of the following items, which appear only if licensed:

• Export Utility – opens the Export Utility window
• Import Utility – opens the Import Utility window
• Export to ProSort – opens the ProSort Exports window