Documentation
Documentation

Troubleshooting iImport

Do the following if these scenarios come up:

I am getting a runtime error when I select my spreadsheet. I have a column in my spreadsheet called “iMIS ID.”

You cannot have a column header called “iMIS ID.” Please rename to something else and the import should work.

iImport automatically runs with elevated rights. You have a user that does not have 'admin' rights to their PC (or Terminal Server), and therefore iImport does not run for them.

There is not a way around having iImport run with 'Run as Administrator' rights – but there IS a workaround for when a user does not have such rights themselves. The below steps will allow a standard domain user account to run an application as local administrator. Create a shortcut that uses the run as command with the /savecred switch, which saves the local admin password.

📘

Note

A network Admin will need to assist with these steps.

Enabling the built-in Administrator account

You must first enable the built-in Administrator account by doing the following:

  1. Search for Command Prompt in the Start menu.
  2. Right-click the Command Prompt shortcut.
  3. Select Run as administrator.
  4. Run <net user administrator /active:yes> in the elevated Command Prompt.

Creating a password for the Administrator account

Next, create a password for the Administrator account by doing the following:

  1. Open the Control Panel.
  2. Click User Accounts and Family Safety > User Accounts.
  3. Select the Manage another account link in the User Accounts window.

Creating the shortcut

Create the shortcut by doing the following:

  1. Right-click the desktop and click New >Shortcut.
  2. Enter <runas /user:ComputerName\Administrator /savecred "C:\Path\To\Program.exe"> into the box that appears.
  3. Replace ComputerName with the name of your computer and C:\Path\To\Program.exe with the full path of the program you want to run.

Customizing the shortcut

Next, customize the shortcut by doing the following:

  1. Enter a name for the shortcut.
  2. To select an icon for your new shortcut, right-click it and select Properties.
  3. Click the Change Icon button in the Properties window

Saving the credentials

Lastly, do the following to save the credentials:

  1. The first time you double-click your shortcut, you'll be prompted to enter the Administrator account's password, which you created earlier.
  2. This password will be saved – the next time you double-click the shortcut, the application will launch as Administrator without asking you for a password.

iImport errors out when trying to update or insert certain fields in iMIS.

Resolution: Check to see if there are any custom triggers associated with any of the tables (especially Name, Name_Address, and Usermain).  The below script, which can be ‘copy & pasted’ directly into SQL Mangement Studio, will list out all triggers that do not begin with ‘ASI’.

Most error messages in the import log are descriptive.  The Membership Import Tool follows iMIS rules for records on import.  Therefore,you must define valid values for such things as member types.  It is also important that you map fields to the correct corresponding fields in iMIS.  Refer to the iMIS database schema to confirm mapping locations.

Unable to set Solicitor ID

Due to iMIS API Limitations, many fields in Name_FR are not available in iImport. Consider upgrading to iDMS:  https://www.csiinc.com/iDMS

📘

Note

If you have any issues with iImport, please contact support. Tickets are normally responded to within 1 to 2 business days after they are submitted.