by Mark Panger9. June 2014 16:20I frequently need to query for a list of voters/donors based on their Trail Blazer ID. Usually this information comes from an Excel spreadsheet that I have modified. Trail Blazer has no easy way to query a list of ID's and have the list returned.
Some time ago I created a tool that allows me do this. It will take a columnar list of ID's (usually copied from Excel) and turn them into a comma separated list that I can then paste into the SQL tab.
This is an advanced technique so only those who are willing to devote a little time to learn the process should proceed.
In the video below, I have created an example where I export data to an Excel file, add data to the file, and query for those records I updated in the spreadsheet. I have also placed the tool referenced in this video on our website.

Let me know if you find this useful.
50e41990-3517-46c2-ba89-9be9e587b4a8|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags: