Query incorrect after importing consent records

When importing consent records and ticking the option to create a query of imported records in the import summary tab, the query returns incorrect or no results.
Contact support and reference this article.

Steps to Duplicate

1. Go to Admin > Import > Constituent Consent > Import New Records
2. Include csv file to import
3. Check all import settings and validate
4. If no exceptions found, go to the Summary tab and tick the box for 'Create an output query of the records imported'
5. Go to the General tab and remove the tick from Validate data only
6. Click on Import Now
7. Save query when prompted
8. Consent records imported correctly
9. Open query saved from import and output constituent name and ID - note either no records found or incorrect records displayed


 Raiser's Edge

Was this article helpful?