Re: WEB400 Digest, Vol 13, Issue 426

Send WEB400 mailing list submissions to
web400@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/web400
or, via email, send a message with subject or body 'help' to
web400-request@xxxxxxxxxxxx

You can reach the person managing the list at
web400-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of WEB400 digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. Send email as a text to cell phone (Roger Harman)
2. Re: Send email as a text to cell phone (Rob)
3. Re: Send email as a text to cell phone (Roger Harman)
4. ODBC_EXECUTE (Alejandro Olvera)
5. Re: Send email as a text to cell phone (Don Cavaiani)
6. Re: Send email as a text to cell phone (Tim Brown)


----------------------------------------------------------------------

message: 1
date: Thu, 10 Dec 2015 22:46:05 +0000
from: Roger Harman <roger.harman@xxxxxxxxxxx>
subject: [WEB400] Send email as a text to cell phone

As a side project, I'd like to investigate sending some notifications to
sales reps via text message. ?Currently, we send emails.

Any recommendations for a source/api to retrieve the carrier for a given
number? ?I've seen a couple via Google but wondering if anyone has
real-world experience with this.

It has to be a VERY low (or no) cost implementation - at least for now.
No commercial products. ?

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
?
?


------------------------------

message: 2
date: Thu, 10 Dec 2015 17:03:42 -0600
from: Rob <rob.couch@xxxxxxxxxxxxxx>
subject: Re: [WEB400] Send email as a text to cell phone

Roger,

I am not in my home office... but I can tell you that Twilio will
allow you to sms for like .002 cents... yes... that is two tenths of a
penny.

If I was in my home office, I had another api for a company that
would translate the number to a provider. then you can email for free
after the first use. I think it was a few pennies or less per number.
They are considered to be a SMS Gateway.

I know Twilio uses a escrow system, you charge it up and recharge
when the bucket runs low.

Twilio can do many many things... I also use it along with OpenVBX
to run a phone system for a small office.

https://www.twilio.com/

After a quick google... TextMagic is the SMS Gateway... I think
TextMagic is who I used.

But then you have to match the Carrier String to that in a table you
keep that matches Carriers to domain names...

Such as "T-Mobile" to "tmomail.com"

If you know the Carrier, which if it is a controlled group, get the info
up front when you get the cell number. some carriers it is as simply as
number@xxxxxxxxxx. Others have number prefixes or suffixes. You can
google each carriers policy on sending an email to an sms text message.

Hope that helps...


On 2015-12-10 16:46, Roger Harman wrote:

As a side project, I'd like to investigate sending some notifications to

sales reps via text message. Currently, we send emails.

Any recommendations for a source/api to retrieve the carrier for a given

number? I've seen a couple via Google but wondering if anyone has
real-world experience with this.

It has to be a VERY low (or no) cost implementation - at least for now.

No commercial products.

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



------------------------------

message: 3
date: Thu, 10 Dec 2015 23:39:30 +0000
from: Roger Harman <roger.harman@xxxxxxxxxxx>
subject: Re: [WEB400] Send email as a text to cell phone

Thanks Rob. Twilio is one that I saw.

For now, I think I can work in a pretty controlled environment -
5555555555@xxxxxxxxxxxxx as the phones should be company issued. Just
thinking down the road that (hopefully) the usage of this may really
explode. I think the sales team will love it. If so, a subscription
service becomes more viable.

Need to talk to our telephone switch guy to see if I might be able to
interface with that directly or thru some PC intermediary and just send the
message.

________________________________________
From: WEB400 <web400-bounces@xxxxxxxxxxxx> on behalf of Rob <
rob.couch@xxxxxxxxxxxxxx>
Sent: Thursday, December 10, 2015 3:03 PM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Send email as a text to cell phone

Roger,

I am not in my home office... but I can tell you that Twilio will
allow you to sms for like .002 cents... yes... that is two tenths of a
penny.

If I was in my home office, I had another api for a company that
would translate the number to a provider. then you can email for free
after the first use. I think it was a few pennies or less per number.
They are considered to be a SMS Gateway.

I know Twilio uses a escrow system, you charge it up and recharge
when the bucket runs low.

Twilio can do many many things... I also use it along with OpenVBX
to run a phone system for a small office.

https://www.twilio.com/

After a quick google... TextMagic is the SMS Gateway... I think
TextMagic is who I used.

But then you have to match the Carrier String to that in a table you
keep that matches Carriers to domain names...

Such as "T-Mobile" to "tmomail.com"

If you know the Carrier, which if it is a controlled group, get the info
up front when you get the cell number. some carriers it is as simply as
number@xxxxxxxxxx. Others have number prefixes or suffixes. You can
google each carriers policy on sending an email to an sms text message.

Hope that helps...


On 2015-12-10 16:46, Roger Harman wrote:

As a side project, I'd like to investigate sending some notifications to

sales reps via text message. Currently, we send emails.

Any recommendations for a source/api to retrieve the carrier for a given

number? I've seen a couple via Google but wondering if anyone has
real-world experience with this.

It has to be a VERY low (or no) cost implementation - at least for now.

No commercial products.

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.



------------------------------

message: 4
date: Thu, 10 Dec 2015 15:35:04 -0600
from: Alejandro Olvera <alolvera@xxxxxxxxx>
subject: [WEB400] ODBC_EXECUTE

Does any one here know a work around or the PHP function to retrieve an
output
variable from a IBMi stored procedure.
I'm using Ubuntu UnixODBC and PHP5.

Here's an example of my php code.

$qry = "call storedproc(?,?,?,?,?,?);

If($stmt = odbc_prepare($conn, $qry));
$success = odbc_execute($stmt, array($i1, $i2, $i3, $i4, $i5, $o6));
//after this executed the $o6 string variable is empty.
if($success){
//I tried odbc_result and odbc_result_all and I'm still not getting any
results

}

FYI my sixth parameter in IBMi stored procedure is set to INOUT and I can
see the value returned back when I debug the job.


Any ideas would be appreciated.

Thanks in advance


------------------------------

message: 5
date: Thu, 10 Dec 2015 23:00:16 +0000 (UTC)
from: Don Cavaiani <dcavaiani@xxxxxxxxxxxxx>
subject: Re: [WEB400] Send email as a text to cell phone

Here's some:

@vtext.com - @txt.att.net - @email.uscc.net (Verizon, ATT, USCELLULAR in
order)

Don Cavaiani
--
A person who has let go of his or her ego ?leaves no trace?. Such a
person does not trigger anger in others.

http://ronrolheiser.com/displacing-ego-and-narcissism/#.VljhvtirTIU

------------------------------------
All your ways may be straight in your own eyes,
but it is the LORD who weighs hearts.????Proverbs 21:2

--------------------------------------------
On Thu, 12/10/15, Roger Harman <roger.harman@xxxxxxxxxxx> wrote:

Subject: [WEB400] Send email as a text to cell phone
To: "Web Enabling the IBM i AS400 and iSeries" <web400@xxxxxxxxxxxx>
Date: Thursday, December 10, 2015, 4:46 PM

As a side project, I'd like to
investigate sending some notifications to sales reps via
text message. ?Currently, we send emails.

Any recommendations for a source/api to retrieve the carrier
for a given number? ?I've seen a couple via Google but
wondering if anyone has real-world experience with this.

It has to be a VERY low (or no) cost implementation - at
least for now.???No commercial products. ?

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on
Power
?
?
--
This is the Web Enabling the IBM i (AS/400 and iSeries)
(WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.


------------------------------

message: 6
date: Fri, 11 Dec 2015 01:17:58 +0100
from: Tim Brown <tim.bronski@xxxxxxxxx>
subject: Re: [WEB400] Send email as a text to cell phone

I don't think you can get cheaper than Twilio. At .0075c a message! I know
you said you weren't looking for a commercial product but we (Arpeggio)
have a Twilio product that can have you sending messages in less than 10
minutes and it's really inexpensive. At the very least you can try it out
and see if Twilio works for you. You can use it to receive messages and
make text to voice calls too. Its all IP based so no extra hardware.
On Dec 11, 2015 00:39, "Roger Harman" <roger.harman@xxxxxxxxxxx> wrote:

Thanks Rob. Twilio is one that I saw.

For now, I think I can work in a pretty controlled environment -
5555555555@xxxxxxxxxxxxx as the phones should be company issued. Just
thinking down the road that (hopefully) the usage of this may really
explode. I think the sales team will love it. If so, a subscription
service becomes more viable.

Need to talk to our telephone switch guy to see if I might be able to
interface with that directly or thru some PC intermediary and just send

the

message.

________________________________________
From: WEB400 <web400-bounces@xxxxxxxxxxxx> on behalf of Rob <
rob.couch@xxxxxxxxxxxxxx>
Sent: Thursday, December 10, 2015 3:03 PM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Send email as a text to cell phone

Roger,

I am not in my home office... but I can tell you that Twilio will
allow you to sms for like .002 cents... yes... that is two tenths of a
penny.

If I was in my home office, I had another api for a company that
would translate the number to a provider. then you can email for free
after the first use. I think it was a few pennies or less per number.
They are considered to be a SMS Gateway.

I know Twilio uses a escrow system, you charge it up and recharge
when the bucket runs low.

Twilio can do many many things... I also use it along with OpenVBX
to run a phone system for a small office.

https://www.twilio.com/

After a quick google... TextMagic is the SMS Gateway... I think
TextMagic is who I used.

But then you have to match the Carrier String to that in a table you
keep that matches Carriers to domain names...

Such as "T-Mobile" to "tmomail.com"

If you know the Carrier, which if it is a controlled group, get the info
up front when you get the cell number. some carriers it is as simply as
number@xxxxxxxxxx. Others have number prefixes or suffixes. You can
google each carriers policy on sending an email to an sms text message.

Hope that helps...


On 2015-12-10 16:46, Roger Harman wrote:

As a side project, I'd like to investigate sending some notifications

to

sales reps via text message. Currently, we send emails.

Any recommendations for a source/api to retrieve the carrier for a

given

number? I've seen a couple via Google but wondering if anyone has
real-world experience with this.

It has to be a VERY low (or no) cost implementation - at least for now.

No commercial products.

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

------------------------------

Subject: Digest Footer

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) digest
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.



------------------------------

End of WEB400 Digest, Vol 13, Issue 426
***************************************