How do I get the contact detail printed out. Let's say I wanted to extract all of the addresses, phone number and emails for a campaign?

Posted on: 6/22/2017 3:46:24 PM
Replied by : support@icaresoftware.com

Dear User,

You may use the Add Custom Report feature for this. Using the below query you may extract all addresses, emails, and phone numbers from iCare,

QUERY: 

" select distinct Childlastname+','+Childfirstname  as [Child Name],  Adultlastname+','+AdultfirstName as [Contact Name],case when  isnull(Address+' '+City+' '+StateOrProvince+' '+ga.PostalCode,'')='' then '--' else Address+', '+City+', '+StateOrProvince+', '+ga.PostalCode end as 'Address',isnull( SUBSTRING(isnull( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CellularPhone, '+', ''), '(', ''), ')', ''), '-', ''), ' ', ''),''), 1, 3) + '-' +SUBSTRING(isnull( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CellularPhone, '+', ''), '(', ''), ')', ''), '-', ''), ' ', ''),''), 4, 3) + '-' +SUBSTRING(isnull( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CellularPhone, '+', ''), '(', ''), ')', ''), '-', ''), ' ', ''),''), 7, 4),'--') as 'Mobile Phone',
isnull(ca.EmailAddress,'--') as 'Email Address'
from cr_child cc
inner join cr_childAdult cca on cc.child_id=cca.child_id and isnull(cc.RecordDeleted,0)=0
inner join Cr_adult ca on cca.Adult_id=ca.Adult_id  and isnull(ca.RecordDeleted,0)=0 and  isnull(cca.RecordDeleted,0)=0
inner join gn_Address ga on ca.Address_Id=ga.Address_Id "

Simply copy and paste this query in the Add Custom Report pop-up and click Test/Run Query. Click Export to print or export the data to your local storage.

Click here or below link to see the help article on using Custom Reports,

www.icaresoftware.com/support/customreport

We really apoplogize for the delayed response. Looking forward to for more opportunities 

Thank you,

iCare Support

Leave a Comment / Question

Copyright © 2024 Orgamation Technologies, Inc. All rights reserved.