ImportOmatic Errors/Issues

Error: Type Mismatch --> BBREAPI.CGiftClass
Product: ImportOmatic Description: This solution describes how to resolve the error: Type Mismatch --> BBREAPI.CGiftClass Environment: All Version: All...
Wed, Apr 14, 2021 at 9:10 AM
Error: Required Field Missing: Constituent Code
Product: ImportOmatic Description: This solution describes how to resolve the error: Required field missing: Constituent Code Occurs when IOM is trying t...
Mon, May 22, 2017 at 5:52 PM
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.
Product: ImportOmatic Description: This error occurs when there is either text going into a numeric-only field, or numbers going into a text-only field for a...
Mon, May 22, 2017 at 6:22 PM
Error: Bank 'xx' with Branch Name 'yy' Does Not Exist and Profile Settings Do Not Allow for New Banks to be Created
Product: ImportOmatic Description: This solution describes how to resolve the error Bank 'xx' with branch name 'yy' does not exist and p...
Mon, May 22, 2017 at 6:23 PM
Import Processing Appears to Freeze
Product: ImportOmatic Description: While importing, the process will freeze at a certain record.  Environment: All Version: All Answer: During a duplicat...
Mon, May 22, 2017 at 6:32 PM
Error: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause
Product: ImportOmatic Description: This solution discusses how to resolve the error: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM claus...
Mon, May 22, 2017 at 6:46 PM
Why Does My Import Data File Keep Disappearing After Importing / Unable to Find Import Data File After Importing
Product: ImportOmatic Description: This solution discusses how to locate an import file that is being renamed after the importing process Environment: All...
Wed, Apr 24, 2019 at 2:10 PM
Attribute Description is not Importing to the Record
Product: ImportOmatic Description: This solution discusses how to troubleshoot an attribute description that will not import Environment: All Version: All A...
Mon, May 22, 2017 at 6:57 PM
Records Are Not Showing Up or Appearing in the Output Query
Product: ImportOmatic Description: This solution discusses why records that successfully processed may not show up in the output query Environment: All Versi...
Tue, May 23, 2017 at 1:30 PM
Error: Object Reference Not Set to an Instance of an Object
Product: ImportOmatic Description: Object reference not set to an instance of an object. -->#=q$Lnpongm9GQAE5I$f_x9EE5KJEjVOBvYWf0NTA42dOI=.#=qLUNPyntkY...
Tue, May 23, 2017 at 1:32 PM