I upgraded to 18.104.22.168. The 1st 2 profiles I tried worked fine. On the 3rd, I received the following exception for every line of the file:
Line 1: An exception occurred in the Duplicate Search: Error 5.2: Line 48: Incorrect syntax near '('.Incorrect syntax near the keyword 'AS'.
Line 2: An exception occurred in the Duplicate Search: Error 5.2: Line 48: Incorrect syntax near '('.Incorrect syntax near the keyword 'AS'.
In the Configuration file, on the Duplicate Search page, I checked "Perform a duplicate search when a record cannot be matched by ID". The search method I chose was "Search for non-constituent spouse record match".
This is kind of a funky file but it worked with the prior version of Import-O-Matic. I'm importing donors without a ConsID & without a real name who may or may not be in the database. These are people who filled the empty bag we left on the porch with GIK. All we have is an address. Therefore they're all going into the database as Mr. Unknown.
Has anyone else encountered such a thing?