Most Recent Posts
Search for never seen patients
by AaronWay - 05/21/2025 9:52 PM
Version 12.3 release notes
by imcffp - 05/21/2025 1:19 PM
Eligibility Failures - ACPM
by tcosta - 05/19/2025 3:16 PM
AC Version 12.3
by ChrisFNP - 05/17/2025 12:59 PM
No refills on Schedule 4 Meds
by koby - 05/06/2025 9:24 AM
Fixing PRESCRIPTION DRUG MONITORING in Windows 11 Pro
by VTWilson - 05/01/2025 12:55 PM
Member Spotlight
DCubed
DCubed
Baltimore
Posts: 679
Joined: February 2011
Newest Members
It's me, Paradise Family, MedCode, MZ Medical Billi, girlfromwebpage
4,593 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#46012 06/14/2012 11:49 AM
Joined: Jun 2010
Posts: 136
Member
OP Offline
Member
Joined: Jun 2010
Posts: 136
Does anyone know how to run a report on how to export the patient cell phone numbers in a bulk file ?
When I export patient data, I only seem to get the main telephone number.
We want to sent text message reminders.


Roger
Working Hard for the children in the community.
Joined: Jul 2010
Posts: 869
Member
Offline
Member
Joined: Jul 2010
Posts: 869
I would contact Tech support, I'm sure they can help you


Marty
Physician Assistant
Fullerton, CA
Joined: Jun 2010
Posts: 136
Member
OP Offline
Member
Joined: Jun 2010
Posts: 136
Very difficult to get a hold of Tech support these days.


Roger
Working Hard for the children in the community.
Joined: Jul 2010
Posts: 869
Member
Offline
Member
Joined: Jul 2010
Posts: 869
Try pinging them online. I have an easier time getting a hold of them online than emailing or calling.

http://amazingcharts.com/support/help-me-now/
Chose Live Chat/start session


Marty
Physician Assistant
Fullerton, CA
Joined: Sep 2009
Posts: 2,986
Likes: 5
JBS Online Content
Member
Online Content
Member
Joined: Sep 2009
Posts: 2,986
Likes: 5
NY2,
Could you tell us more about your plans? Will this be an automated process? Have you purchased some texting software? How do you forsee it working? (Also follow-up on what you hear from AC support).
Thanks.


Jon
GI
Baltimore

Reduce needless clicks!
Joined: Feb 2011
Posts: 679
Likes: 1
Member
Offline
Member
Joined: Feb 2011
Posts: 679
Likes: 1
I use a service called Call Em All.
You can export phone numbers as Excel spread sheet from AC and then send automated voice or text messages.
I can demonstrate it for you at our next meeting if you are interested, Jon.


Donna
Joined: Sep 2009
Posts: 2,986
Likes: 5
JBS Online Content
Member
Online Content
Member
Joined: Sep 2009
Posts: 2,986
Likes: 5
Yes, Donna! Please add that to the agenda.


Jon
GI
Baltimore

Reduce needless clicks!
Joined: Jun 2010
Posts: 136
Member
OP Offline
Member
Joined: Jun 2010
Posts: 136
I previously used PHONETREE with my old PM software. I am now checking new services. Since I deal with young parents, many of them are always holding their cell phones, so using an automated service to remind them of their appointments is really cheap and easy to do.
AC does not seem to export those cell phone #s in any files. These web based services can send out text reminders to reduce no-shows. We are currently using CALLFIRE for voice calls, but I am not fully happy with their service.


Roger
Working Hard for the children in the community.
Joined: Apr 2010
Posts: 1,546
Likes: 1
Member
Offline
Member
Joined: Apr 2010
Posts: 1,546
Likes: 1
I see the same issue. I can get the cell phone column to show up by doing a search on it, and get a list of names, but the value for the cell phone does not show... only the search criterion shows, like "does not equal 111111111". The wildcard does not work either.. it demands a numeric value. A similar search does seem to work for home phone numbers, however.

I have previously found that not all fields in every AC table are available for searching, and I don't understand why. It seems as easy to make each field searchable as to exclude it, and eventually someone will have a need to search on almost any given field. The beauty of a database is that it should be easy to make this happen.

In the SQL based databases I have written, this would probably represent a simple error in the formatting of the field in an output form, and would be fixed with a single mouse click by the programmer. It does have to rise to the top of the programmer's "to do" inbox, however. Your need is important and reasonable. Please let us know what AC has to say when you contact them.


David Grauman MD
Department of Medicine
Commonwealth Health Center
Saipan, Northern Mariana Islands
Joined: Feb 2011
Posts: 679
Likes: 1
Member
Offline
Member
Joined: Feb 2011
Posts: 679
Likes: 1
For my needs, I have always exported home phone numbers which works fine.

Until the time when AC might fix this, I suppose you could work around by it entering the cell numbers in the home field and vice versa if you want to export the cell numbers.


Donna
Joined: Dec 2009
Posts: 1,197
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,197
Likes: 8
We use SQL Server Integration Services to find all appointments in the scheduler that are coming up in two days and send those appointments to Televox (housecalls) so they can do patient reminders. It's completely automated.

For those of you who need to do some type of phone number export out of Amazing Charts, I can't say my solution would be right for you, but perhaps there is a conversation to be had.

At this point, I'd welcome input from Indy, Bertimus, or Sandeep.

JamesNT


James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net

Moderated by  DocGene, Wendell365 

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 57 guests, and 21 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
tcosta 2
imcffp 2
JBS 2
Top Posters
Bert 12,874
JBS 2,986
Wendell365 2,366
Sandeep 2,316
ryanjo 2,084
Leslie 2,002
Wayne 1,889
This board is dedicated to the memory of Michael "Indy" Astleford. February 6, 1961 -- April 16, 2019




SiteLock
Powered by UBB.threads™ PHP Forum Software 7.7.5