Product: ImportOmatic
Description:
How to use DOS Command Prompts to initiate an immediate import
Environment: Not hosted
Version: All

Answer:

Answer:

To initiate an immediate import using the Scheduler, access a DOS prompt by running the Command Prompt program found under Windows Start>All Programs> Accessories. You may also type cmd in the Start>Run prompt.



To run an import from the command line, either change directories to the The Raisers Edge 7\Plugins folder or type the full path of the iom.exe executable (note: be sure to use double quotes if the path name contains any spaces):
C:"\Program Files (x86)\Blackbaud\The Raisers Edge 7\Plugins\iom.exe"

Once you press enter, you will receive a list of program parameters. Although it comes in the form of a list, you will use it to produce the command line prompt.



Program parameters are:

-p   Import Omatic profile ID
-f    Name of file to be imported; be sure to include the file extension
-u . Raisers Edge user name (be sure to use quotes around the name if it contains a space)
-pw  Raisers Edge user password
-pwe  Encrypted Raisers Edge user password
-d  Raisers Edge database number (this # is usually 50 for a sample db, 1 for a live production db or 2 for a copied production test db, see your Blackbaud account manager for help finding your db #)
-v  Display the progress bar during import (optional, but very helpful)

To run an import, define each parameter value as part of the program command. File names or paths that have spaces are surrounded by double quotes. For example, to import the file New Donors.csv into the sample database using the My Donors profile, the usage may be: 
“C:\Program Files (x86)\Blackbaud\The Raisers Edge 7\Plugins\iom.exe" -d=50 -u=Supervisor -pw=admin -p="My Donors" -f="C:\Users\sue\Documents\test files\New Donors.csv"

Be sure to type the command line in a single string. Do not include carriage returns.

The program confirms that the import is processing and displays the name of the import file. If the –v option is not used to display the progress bar, no other information is written to the screen. Once the import completes, the DOS prompt is displayed. Remember to check your logs folder for errors and exceptions. Rows requiring user interaction are skipped and written to an exceptions file. These can be imported later using the regular ImportOmatic process.