ImportOmatic ← Knowledge Base All exception file data is in one column Profiles Missing from Configuration After Updating to IOM Version 3.2 Advanced Address Processing Form Shows 100 Point Match But Will Not Automatically Match On The Imported Address Fund, Campaign, Appeal, or Package Does Not Populate In RE Gift Batch Error: An Exception Occurred in the Duplicate Search: Error 5.2: The EXECUTE Permission was Denied Error: Required Field Missing: Organization Name Error: Required Field Missing: Last Name How to Import Assigned Solicitors How to Import Split Gifts Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT Statement Conflicted With the FOREIGN KEY Constraint "FK_TABLEENTRIES_1". How to importing recurring gift payments Error: An exception occurred in the Duplicate Search: Error 5.2: Timeout expired. Error: Object Reference Not Set To An Instance Of An Object When Creating A New Profile How to Import a Business Relationship as Primary and Mark the Address as Preferred Unable to Load Profile: The file specified does not exist Error: An Exception Occurred in the Duplicate Search: Error 5.2: Conversion from Type 'DBNull' to Type 'Integer' is not Valid Error: Duplicate Phone Types are not Allowed There are Two City Entries in Value Types Error: Unable to Save Profile: Relationship Information Provided but More Fields are Required for Matching Error: Unable to Save Profile: The Batch "Template" Does Not Exist or Was Deleted How to Import Volunteer Time Sheets How to Import Volunteer Medical Information and Special Needs How to Import Volunteer Mandate Information How to Import Volunteer Skills and Experience How to Import Volunteer Courses and Training How to Import Volunteer Checklist How to Import Volunteer Availability and Interests How to Import Volunteer Awards How to Import Volunteer Jobs How to Set the Query Category for Output Queries Error: Action Contact Import/Constituent ID is not Valid: x Error: Type Mismatch --> BBREAPI.CGiftClass Error: Invalid Institution ID: Institution ID Error: Invalid Transit/Routing Number: Transit/Routing no. Error: ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf3c Thread 0xf48 DBC 0x1cfbd024 Excel'. Error: ERROR  [Microsoft][ODBC Excel Driver] Syntax error in FROM clause How to Use the MasterID Excel File Error: Only a Sponsor Can Sponsor a Registrant Error: Required Field Missing: Date [Object: 'CNotepad'...] Error: Date to Cannot be Before Date From. [Object: 'CConstitAddress'...] How to Import Organization Relationships How to Import Individual Relationships The Advanced Address Processing Screen or AAP is Popping Up for Every Record With or Without a Zip +4, Including 100 - Point Match Addresses Aliases are Automatically Adding to Record without Being Mapped Records Are Not Showing Up or Appearing in the Output Query How to Import Gift Amendments How to Link an Existing Gift to a Membership How to Link an Existing Gift to an Event How to Link an Existing Gift to a Proposal New Address is Overwriting Previous Address Instead of Making it an Alternate Address Error: Unable to Save Profile: You Must Have a Gift ID Column in Order to Process Split Gifts Error: School ID is Required Shared .dll deployment Error Calling Omatic Service: Subscription Expired or Limit Reached Error: Proposal not Found on Record How to Link a Proposal to an Action Error: Required Field Missing: Status [Object: 'CMembershipCard'...] Error: Object Reference Not Set to an Instance of an Object Error: Error saving batch on data row # 1. Error = 'General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar value '-2147219858' overflowed an INT2 column. Use a larger integer column. Error: Invalid Attribute Type How to Match or Auto-Pick on Alias Error: Line 1: Number of Fields in This Data Row (XX) Does Not Match Number of Fields in the Profile (YY) How Does ImportOmatic Match to and Update Existing Education Relationships How to Copy the Constituent Address to a New Relationship Record Error: Unable to Save Profile: You Must Select at Least One Duplicate Search Auto Pick Option What is the Duplicate Similarity Score What is the Omatic Data and Address Service What are Special or Escaped Characters and How to Use Them to Import Notepad Data Error: Bank 'xx' Did Not Exist on the Constituent Record. Configuration Settings Do Not Allow for it to be Created How to Import a Gift Batch Number Error: Bank 'xx' with Branch Name 'yy' Does Not Exist and Profile Settings Do Not Allow for New Banks to be Created Error: Job Does Not Exist. 'xx' Error: Required Field Missing: Job Error: Unable to Save Profile: Gift Batch Number Can Only Be Mapped When Gifts are Not Being Imported into Batch Error: Invalid Code Table Entry: Description [Object: 'School ID'...] Error: Invalid Code Table Entry: Description [Object: 'CAttribute'...] How to Import a Solicitor to Actions What are the System Requirements for ImportOmatic? Error: Required Field Missing: Type [Object: 'CAction'...] Importing Participants as Non-Constituents and Matching on Full Constituents What is Included in the Summary Email From IOM When Import is Complete? How to Import Fund Relationships How Phone Numbers and Email Addresses Import How to Import to the Marketing Source Code Field of a Gift Record How to Import to the Bills and Coins Fields of the Gift Record When Using a Type of Cash How to Import Individual Constituent Names That Are Not Parsed Unable to Update Contact Type Field On an Individual Relationship to an Organization Record Unable to Update Import ID Appearing in the Bio Comparison Window What Are the Minimum RE Security Rights Required to Import via ImportOmatic Can A Volunteer Job Assignment Be Updated How to Import to the General Area of the Volunteer Tab How to Stop the Post Date from Defaulting to the Import Date Error: Required Field Missing: Type [Object: 'CNotepad'...] How to Mark an Education Relationship as Primary When an Education Relationship Already Exists on the Record Should I Delete A Gift Entered Previously to the Wrong Constituent Record Before Importing the Same Gift to the Correct Constituent Record How to Export a Dictionary What is the Naming Convention for the Files that ImportOmatic Can Output? How Do I Stop an Import Before it Finishes? Can I Re-start it Later? Addressee and Saluation Information in Virtual Fields Error: Unable to Save Profile: You Must Setup Email Settings in Order to Send a Summary Email How to Update the Birth Date Field For Existing Records How to Disable the Default Authorization Code in a Batch Created Via IOM How Do I Request New Functionality in IOM? How to Create a New Profile in ImportOmatic How to Delete a Profile How to Copy a Profile Regular Expressions (RegEx) in Dictionaries: How can I learn more? Do I Need a Constituent Identifier if I Have the Import ID of the Address/Action/Education Relationship That I Wish to Update? Proposal Matching Error: Invalid Program/Category Combination Specified Error: Required Field Missing: Campaign ID Error: Required Field Missing: Fund ID Error: Required Field Missing: Appeal ID Error: Data too long for field Max length = 60 for Org Name Can ImportOmatic Update Gifts? Error: No Record Could Be Found for the Specified ID: 'xx' Error: Unable to Save Profile: You Must Have At Least One Criteria Selected How to Import Gift Adjustments Error: Phone Type Exists on Record and Option to Add New Phone Types is Disabled How to Add a Constituent Code to New Records Only Does ImportOmatic Allow Record Updating How to Link Gifts to an Event as Registration Fees How to Map Gift of Membership Renewal Notice Send To Information and Special Message How to Add Country Table Values How to Automatically Add Packages to Appeals When Importing Gifts to Batch How to Get a Second ImportOmatic License Key for an Additional Production Database How to Check Boxes on a Constituent Record How to Match on Non-Constituent Participants Using the Duplicate Matching Screen How to Match to a Specific Existing Bank when Importing Bank Information on Gift Imports How to Remove Leading Zeros from Constituent IDs How to Map an Address/Phone Import ID How to Install ImportOmatic / IOM How to Locate the Latest Version of ImportOmatic Attribute with a Data Type of Constituent Name is not Importing Attribute Values Error: Line 1: Data Too Long for Field Max Length = 50 for Comments How to Add Address Attributes Error: Invalid Code Table Entry: GL Post Status How to Use a Batch Template for Gift Importing How to Make IOM Use the Default Batch Settings when Creating a Gift Batch Error: 'Univer' Already Exists. Please Use a Unique Short Description. Unable to Locate Gifts After Importing Error: Required Field Missing: Event ID How Do I Bring in New Birth Date Information Without Overwriting the Existing Information Before Previewing Why are Some of the Tabs Such as Gifts and Relationships Missing When I Open a Record From the Duplicate Search Matching Screen? Why are Other RE7 Workstations Locked Out When I Import Using Validation Mode? How to Import an Education Relationship Note How to Map Gift Benefits Attribute Description is not Importing to the Record How to Use Virtual Fields Error: Required Field Missing: Primary Salutation Error: Required Field Missing: Primary Addressee Error: Required Field Missing: Unit [Object: 'CParticipantFee'...] How to Import Registration Fees How to Import Participant Guests to an Event How to Import a Non-Constituent as a Participant to an Event How to Import Participants to an Event Error: Index was Outside the Bounds of the Array [CImport_Process_xx.x] What Do the Buttons on the Duplicate Search Matching Results Screen Mean? What Do the Buttons on the Advanced Address Processing Screen Mean? How to Edit or Delete a Value in a Dictionary How to Import Appeals Can ImportOmatic Alert About the Overpayment of a Pledge or Recurring Gift Unable to Import a Gift Type of "Pay-Cash" when Importing Pledge Payments How to Allow RE to Assign Constituent IDs Instead of Self Assignment through ImportOmatic Which Unique Identifiers Can be Used to Locate Existing Constituent Records through ImportOmatic How to Include the Current Date on a Column in the Field Map of a Profile How to Include the Current Date in a Virtual Field Why Does My Import File Keep Disappearing After Importing How to Map a Soft Credit when Importing Gifts Error: ERROR  [Microsoft][ODBC Excel Driver] Too few parameters. How to Update or Unmark the Deceased Flag on Constituent Records How to Map a Solicitor to a Gift Record Solicitor Processing Rules are not Adding the Solicitor on a Gift Record How to Remove Constituent Attributes Using ImportOmatic State Abbreviations for Dictionaries How to Mark Phone Numbers or Email Addresses as Do Not Contact How to Export Data in .CSV Format From Blackbaud Sphere What is the "Base File" in the ImportOmatic Profile and Can it be Changed? How to Apply Default Sets to ImportOmatic Imports Unable to Import to a Spouse Record Using the Spouse Import ID How to Identify Which User Last Ran an IOM Profile How to Identify Which User Created or Last Updated an IOM Profile Unable to Update Existing Constituent Records with a Default Set How to Prevent Other Users from Changing Mapping in Profiles How to Import to the Major/Minor Comments field of an Education/School Record How to Link Gifts to an Event as Other Donations How to Map Notepads .NET Framework Error: Unhandled Exception: Object Reference not Set to an Instance of an Object Error: Line 16: Number of Fields in This Data Row (XX) Does Not Match Number of Fields Profile (YY). Error: Unhandled Exception: The Specified Path, File Name, or Both are Too Long. Error: Unhandled Exception: The Parameter 'Address' Cannot be an Empty String How to Import Pledge Payments How to Import Pledges Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ConstituentATTRIBUTES_3". The conflict occurred in database "RE7", table "dbo.AttributeTypes", column 'ATTRIBUTETYPESID'. Unable to Access Plug-ins Error: Required Field Missing: Constituent Code How to Change the Default Error and Exception File Path How to Use the Solicit/Constituent Code Removal Character How to Map Attributes What are Address Processing Rule Options? How To Import Multiple Address Records How to Import an XML orJSON Profile How To Create a Dictionary What Are Some Commonly Used Regular Expressions? How To Add or Remove a Column Within an Existing Profile How to Create a Default Set within RE How To Automatically Add Table Values To Existing Tables During Import Processing How To Delete A Value From A Dictionary How To Turn On/Off Side By Side Comparison Utility For Bio Field Change Viewing How to Import Multiple Constituent Codes How to Always Add a New Address How to Promote a Non-Constituent Relationship to a Full Constituent Error: Object Reference not Set to an Instance of an Object Import Processing Appears to Freeze How to Export a Profile How Do I Find Training Videos for ImportOmatic? Error: DBTextStream Errors Occurs When Trying to Open or Run Profiles Where Do I Find the User Guide for ImportOmatic? List of Profiles is Out of Order How to share and link addresses from existing constituents to newly added constituents. Update existing address without overwriting any associated data Invalid date exception when importing with DonorDrive Connector How to Import an Organization Relationship and Update the Address on the Relationship Only How to Skip Rows that Contain Certain Values What does the PC column do in the IOM field map How to Proper Case incoming data How to Map an Alias What Fields Are Required to Create a Gift How to Import a Gift What is the "Test Code" button How to create an output query of an import Error: Failed to Create a Connection to the Database. Custom Database Connection Settings will be Required. Error: Unable to Save Profile: You Must Select the Duplicate Phone Type Attribute. How to Stop Renaming Processed Data Files Fields Missing When Importing Gifts to RE Batch Using a Batch Template Error: Required Field Missing: Author [Object: 'CNotepad'...] How to check or uncheck a checkbox How to Import Recurring Gifts How to Import the Same Address as an Alternate with a Different Type Without Overwriting the Existing Address How to Download a .msi File for Installation of ImportOmatic How to Get a Silent Switch for Installation of ImportOmatic Notification: This Version of ImportOmatic is Out of Date. The Most Recent Version is xx Error: A Duplicate Phone Number and Phone Type Exists Error: Field is Read Only: Currency Country Error: Unable to Set the Value Stored for Default - Email Type. The Value May Have Been Removed from or Made Inactive in RE. Error: Unable to Set the Value Stored for Default - Phone Type. The Value May Have Been Removed from or Made Inactive in RE. Error: Unable to Set the Value Stored for Default - Organization Address Type. The Value May Have Been Removed from or Made Inactive in RE. Error: Unable to Set the Value Stored for Default - Individual Address Type. The Value May Have Been Removed from or Made Inactive in RE. How to Import Attributes With the Same Category Multiple Times Without Overwriting the Existing Attribute How to Get a .MSI File for Installation and the Availability of a Silent Switch How to Filter on List Management Profiles Within the IOM Configuration List View How to Filter on Regular IOM Profiles Within the IOM Configuration List View How to Locate Exception Files Output from Imports How to Uninstall IOM / ImportOmatic How to Turn On the Diagnostic Performance Log in an IOM Profile How to Update the Relationship of a Relationship in the Same Import Pass How to Import Default Benefits for Participants or Guests How to Import Blank Values for Phone Numbers or Email Addresses How to Add Multiple Constituent and Address Attributes Error: The specified fund could not be found. The fund has either been deleted or you do not have rights to view it. How to Bypass or End the Duplicate Dictionary Value Error when Pasting Values into a Dictionary How to Copy a Dictionary How to Delete A Dictionary How to Import Memberships and Bypass the Interactive Membership Form How to Prevent New Phones/Emails from being Added as Primary in RE 7.95 Error: Source row 1 produced Excel error row 2: (error message) Error: Overflow -->BBREAPI.CGiftClass.Save Error: Control Failed to Load. Please check the GUID of the control against the tag attribute in the HTML Page How to Mark a Constituent Code as Primary Error: Profile Save Error: An Exception Occurred While Saving This Profile: "CommandConverter" is Unable to Convert 'Omatic.MVVM.Commands.RelayCommand' to 'System.String'.'.