Community
Showing results for 
Search instead for 
Do you mean 
Reply

Importing large queries into ACT?

New Member
Posts: 3
Country: USA

Importing large queries into ACT?

We are running Contact queries based on zip code proximity  

E.g.  if we run a Google map search for all zip codes within 10 miles of 77057, then we get, say, 200 zips codes.  We then want to run a query of all contacts w/in those zip codes to get a call list.  Unfortunately we have to enter all 200 zips since they are not necessarily contiguous.  We have tried shortening the query by doing things like “ >= and <= “ etc. but it’s still a huge task entering that query to the ACT query box.  We’ve tried to change a previous queries in excel and then  rename to a .QRY file but it does work.    Anybody have any ideas or solutions?  Thanks

Bronze Contributor
Posts: 955
Country: Australia

Re: Importing large queries into ACT?

The only way would be to get someone to write you an application to paste in your query as there is no facility as far as I know to put in a query externally.

 

I have done something similar for a client by taking a list and scheduling a follow up call for a weeks time in groups of 5 to each user for 150 contacts and then completing the mail merge.

 

Let me know offline if you wish to pursue

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.
Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Importing large queries into ACT?

In ACT! the zip code field is alpha-numeric so a much simpler query which can be done from the zipcode field is starts with. The first three numbers in the zip code are the regional designation. The last two are local post offices.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 3
Country: USA

Re: Importing large queries into ACT?

Hey Roy,

 

Thanks for the response.  It doesnt appear that the 1st 3 numbers gives us good enough resolution on the query but it was worth a try

New Member
Posts: 3
Country: USA

Re: Importing large queries into ACT?

I was actually hoping for a way to develop/build  a query in another application (like excel or access) that can be saved as a ACT query and then run as normal  saved "Advanced"query.   The way ACT forces you to build the query is painful for large queries. 

 

Thanks for the response.