I've had this problem many times with importing single donations, and in the past, I've had to just enter gifts manually. IOM imports only a few rows before it gives up and doesn't import the rest of the file. A batch for the gifts is created but shows only a portion of the actual import file. There is nothing obviously wrong with my file, as far as I can tell. Please help me find a solution!
The Error log looks like this:
IOM Version: 126.96.36.199 RE Version: 792.5508.6
Profile: MASTER Gift Entry
REImport Error File
Import File: S:\DSLRF Development\Giving\Annual Giving\FY2015\Gifts\8 - February\02-02-15.csv
Master ID Source: Raiser's Edge
Line 1: Required Field Missing: Org Name [Object: 'CRecord', PK: '?', Import ID: '?', Desc: '?', Field: 'Org Name'] -->BBREAPI.CRecordClass.Save()-->ImportOM.CImport.#=qvi8srAEGr70pFQ7Qsq$RlsEX_Cbc8BLP0sNGoKPcJRs=(Int32 #=qh_vIIGOA0WrRoP0S$ObdoA==, Int32 #=qeWLqhR20wBu0bIyRTCPQRg==, ArrayList& #=qskis3bRdKcZ11qtMw1ZKVSHas6qemJs9_dnbQWjCMPs=)-->ImportOM.CImport.Process()
Line 11: Error saving batch on data row # 11. Error = 'General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric.