Need to txt appt reminders from PC. What app/services have you used?
-
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@Pete-S said in Need to txt appt reminders from PC. What app/services have you used?:
Seems ridiculous to have a person doing that manually each day.
Better to have someone make a script or something. Even if the management software can't do it, there is a 97.4% chance that the management software is using a database. The script could pull the appoinments directly from the database and send them as SMS.
Yep. We're trying to get access to the SQL data for queries, but it is a slow and difficult task.
Is that on your db server, or is it locked up somewhere?
-
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
A little more research leads me to believe I should be able to find a small utility to do what I want through a VoIP provider like Skyetel or Twillio, or voip.ms, etc
Those will make the outbound connections, sure. But that doesn't solve anything, we assumed you had that portion before. The pieces you need are...
- Something to generate the event.
- Something to send it out.
-
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@Pete-S said in Need to txt appt reminders from PC. What app/services have you used?:
Seems ridiculous to have a person doing that manually each day.
Better to have someone make a script or something. Even if the management software can't do it, there is a 97.4% chance that the management software is using a database. The script could pull the appoinments directly from the database and send them as SMS.
Yep. We're trying to get access to the SQL data for queries, but it is a slow and difficult task.
Probably not too difficult. Usually you can gain access to the database if you have root/administrator rights on the computer it is running on.
What OS and SQL database are we talking about?
-
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
I think we'd need to start from the system that they need to tie to. Using what can it initiate this? Like does it send an email? Providing an SMS service for this might be moot if the software can't talk to it.
"So they are going to dedicate a person to sending txt appt reminders every day."
Their software doesn't do it, or anything like it.That's going to be a problem. I'd start there. You need a way to generate the communications before a way to transfer it.
Not for this approach. They are dedicating a person to do that part manually.
-
@Pete-S said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@Pete-S said in Need to txt appt reminders from PC. What app/services have you used?:
Seems ridiculous to have a person doing that manually each day.
Better to have someone make a script or something. Even if the management software can't do it, there is a 97.4% chance that the management software is using a database. The script could pull the appoinments directly from the database and send them as SMS.
Yep. We're trying to get access to the SQL data for queries, but it is a slow and difficult task.
Probably not too difficult. Usually you can gain access to the database if you have root/administrator rights on the computer it is running on.
What OS and SQL database are we talking about?
I need a utility to get this happening before I start a development project.
Have you used one? and what are your thoughts on it? -
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
What services/app have you used, and did you like it?
Let me explain better.
Today's task is to find a simple user interface to allow sms through a voip provider.
I prefer two way sms'ing, but it is not mandatory. -
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
I think we'd need to start from the system that they need to tie to. Using what can it initiate this? Like does it send an email? Providing an SMS service for this might be moot if the software can't talk to it.
"So they are going to dedicate a person to sending txt appt reminders every day."
Their software doesn't do it, or anything like it.That's going to be a problem. I'd start there. You need a way to generate the communications before a way to transfer it.
Not for this approach. They are dedicating a person to do that part manually.
But isn't the point to replace that person?
-
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
What services/app have you used, and did you like it?
Let me explain better.
Today's task is to find a simple user interface to allow sms through a voip provider.
I prefer two way sms'ing, but it is not mandatory.Oh, that's SO easy. Just use Textable.
-
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
What services/app have you used, and did you like it?
Let me explain better.
Today's task is to find a simple user interface to allow sms through a voip provider.
I prefer two way sms'ing, but it is not mandatory.Oh, that's SO easy. Just use Textable.
why pay for a service when he can do it via email?
-
@Dashrender said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
What services/app have you used, and did you like it?
Let me explain better.
Today's task is to find a simple user interface to allow sms through a voip provider.
I prefer two way sms'ing, but it is not mandatory.Oh, that's SO easy. Just use Textable.
why pay for a service when he can do it via email?
Assuming that you always can, and you can't. So if you are okay with "sometimes", then yes.
-
@scottalanmiller Perfect! Except for those prices! Ugh! Might be our only option.
-
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller Perfect! Except for those prices! Ugh! Might be our only option.
Works really well, at least
We pair it with Skyetel around here.
-
Is it really that expensive? Even at $199.99/month that doesn't sound unrealistic compared to the cost of having to pay someone to do this by hand.
-
@DustinB3403 said in Need to txt appt reminders from PC. What app/services have you used?:
Is it really that expensive? Even at $199.99/month that doesn't sound unrealistic compared to the cost of having to pay someone to do this by hand.
Textable IS for someone doing it by hand!
-
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller Perfect! Except for those prices! Ugh! Might be our only option.
Works really well, at least
We pair it with Skyetel around here.
Oh! Maybe I am looking at the wrong Textable, I didn't see where you can use your own sip provider.
-
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller said in Need to txt appt reminders from PC. What app/services have you used?:
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
@scottalanmiller Perfect! Except for those prices! Ugh! Might be our only option.
Works really well, at least
We pair it with Skyetel around here.
Oh! Maybe I am looking at the wrong Textable, I didn't see where you can use your own sip provider.
Right - I'm confused what Scott means by pairing it with Skyetel? to what end? The prices on Textable all say include 1 number or more
-
Well, this is depressing. You'd think they'd at least give me a list of non saturated area codes to choose from!
-
If doing manually, first have the "admin" use this website to determine the email to SMS address for the cell phone number in question:
https://freesmsgateway.infoThen compose an email using the above info.
-
@JasGot said in Need to txt appt reminders from PC. What app/services have you used?:
Well, this is depressing. You'd think they'd at least give me a list of non saturated area codes to choose from!
HA! Every Area Code in my state is saturated....
-
@JasGot what state are you in?
