-- Reference --

IRIS Accounts Production Import dialog fields

Field Description
Please select a ClientID

The client ID for the file being imported. You can view the list of clients by clicking List Clients.

If you do use List Clients, make sure that the Server, User ID, and Password fields are entered correctly.

4-digit year

The 4-digit year that corresponds to the data you are importing.

Prior Year Data

This imports prior year balances into Working Papers.

Note: Any existing prior year data will be overwritten. To leave existing prior year balances untouched, leave the check box empty.

Use .MDF database file

This will import the database file directly from the SQL server.

For more information, see the Notes section below.

Import as yearly file This imports the data as yearly.
Include 'No Description' accounts This option will allow you to import accounts for which there is no description. If you do not select this check box, these accounts are deleted on import.
Pad account number with zero The account numbers will be padded with a leading zero if this option is selected.
Server The name of the SQL Database server.
User ID/Password The login and password for the server.
  • Select the Use .MDF database file option if you do not have IRIS Accounts Production installed on your computer. The IRIS.mdf file will be automatically attached to the SQL server and data will be read through the SQL server database. Thus, you need to specify the path to the IRIS.mdf and IRIS_log.ldf files in the SQL server database.
  • Do not select the Use .MDF database file option if you have IRIS installed on your computer since the import will connect directly to the database in this case. However, if you would like to import an IRIS.mdf file created from a version of IRIS other than the one currently installed, see here.