Sending SMSs using Delivery

Hi all,

I have a project to configure T24 to send transaction alerts/notifications to mobile phones using DELIVERY. Can someone send me any documentation on this or explain to me the basics.

We are running on R09, Unix AIX 5 and jBASE 5.

Regards
Concern

Concern,

Did u able to config the above modification??

Thanks,

I did this in R09 only once so sort of able to recollect what I did. May be i would have missed some steps. anyway try this and see if it works..



In the Customer Record(For Eg. Lets take 100724) you need to update the field SMS with a valid Mobile No and authorise it. Once authorised you will find a record in
DE.ADDRESS with ID as Eg. GB0010001.C-100724.SMS.1

Multivalue OUTWARD.CARRIER in DE.PARM I SYSTEM.STATUS with SMS also as one of the carriers.

Check if you have a record in DE.INTERFACE as SMSINTERFACE

Create a Record with ID as SMS in DE.CARRIER as shown below

CARRIER........... SMS

---

1. 1 GB DESCRIPTION. Standard SMS
2 ADDRESS........... SMS
3 FORMAT.MODULE..... XML
4 CARRIER.MODULE.... GENERIC
5 INTERFACE......... SMSINTERFACE

Create a REcord in DE.CUSTOMER.PREFERENCES with ID as CUSTOMER ID 100724

1.1 MESSAGE.GROUP Activity-Alerts ( This value comes from DE.MESSAGE.GROUP)

3. 1. 1 CARRIER..... SMS Standard SMS Carrier Definition
4. 1. 1 REQUIRED.... YES
5. 1. 1 ADDRESS..... 1
6. 1. 1 FORMAT...... 2
8. 1. 1 LANGUAGE.... GB
9. 1. 1 DE.PRODUCT.I GB0010001.C-100724.ALL.ALL

Give the DE.PRODUCT that best suits your statement that needs to appear via SMS.

You should find a jars folder under bnk.run directory where your T24 is installed. This contains the jars required for SMS , EMAIL and Secure message to be configured.

You need to register with a SMS gateway and get details like API ID , Username , Password , ProxyPort and ProxyHost details in the properties file and some in the .profile / remote.cmd to set the CLASSPATH accordingly.

The layout of how the SMS should look like should be set up in DE.FORMAT.XML file

The XML schema definitions are stored in a file called F.DE.XML.SCHEMA

If you input and authorise a contract it will store in an unformatted queue called F.SMS.OUT.LIST

You need to start the service BNK/SMS.OUT to send out the SMS to the specified mobile no in CUSTOMER record.

Hi Kripesh,

Thanks for the detailed walk-through. I will test it and advise on the out come but I think its works.

regards
Concern

Is this feature (Mobile Alert) availbale in T24 R06.

No. I think this feature came about only in the later part of R8. So test in R8 final builds of T24 or R9.000 GA or R10.000

There is no easy answer to this question.

One of the enterprise solution (where SMS volume can be huge) goes as follows:
You will need to contact the Cell service provider to open a port to their SMSC gateway server (of course with some charges). whenever you authorise a DELIVERY you will send the text string containing the recipients number to that SMSC server and the cell provider will broadcast this string as SMS to the user.

One of the low end cheap solutions (where sms volume is under 500 sms's):
Interface a mobile with any system and using any off the shelf java or .net libraries send automated sms's from that mobile by sending a callj request from the server to that PC.

Hi Kripesh,
Can you show me two files config for email and sms

Regards
Noname

Yes you can do that using either by using java third party components/SMS caster type softwares or by using software like EFS Lasernet . The first option requires development skills

Hi Kirpesh:

Thank you for your informative instructions.
We are running R09. However I simply could not find the SMS.OUT service. Could you give me a hint about it's location?

By the way, is there any other recommended way that can be explored for sending SMS and EMAIL for various alerts, triggers, debit can credit advice?

This forum's help is highly appreciated.

Thanks and regards,

Asif

Did you check in your TSS history file?

TSA.SERVICE SEE

SERVICE........... SMS.OUT ; 1

---

1. 1 DESCRIPTION.... DE FORMATTING SERVICE
3. 1 WORK.PROFILE... DE.FORMATTING.SERVICE USED FOR DE FORMATTING SERVICE
5 USER.............. INPUTTER EB-MISSING.RECORDþUSER
6 SERVICE.CONTROL... STOP
27 CURR.NO........... 1
28. 1 INPUTTER....... 558_TAABSUSER01
29. 1 DATE.TIME...... 16 JUN 11 15:50

---

Thanks a bunch Concern.

It seems the record has been reversed.

at the jshell ... if i do
>LIST F.TSA.SERVICE 'SMS,OUT'
I don't get anything

also if i do
>jshow -c SMS.OUT
I don't get anything

Should I not have a subroutine somewhere named SMS.OUT?

Please help.

Thank.

the service is controlled by DE.OUTWARD

Dear concern ...

Thanks for your help. I was able to start SMS.OUT successfully.

However, when I do FT the DE.O.HEADER record shows the following error

MSG.ERR.CDE........ ERROR - Address record for company (&) does not exist#BD0013218.SMS.1

Please note,
MESSAGE.TYPE....... 910
APPLICATION.FORMAT. 1
APPLICATION........ FTAC
DISPOSITION........ FORMATTED
ERROR.CODE.........
.
.
.
MSG.DISPOSITION.... REPAIR
.
.

I really need help setting up this SMS soon :)
If you do not mind can I also send you copy/screen shot of all the pertinent files?

Thanks for all your help.

Hi
is "BD0013218" your COMPANY ID?

Thanks for your reply VK. Before getting into detail ... I must salute you for the 4 fantastic books you have on the subject of T24 ...

A little bit of background regarding my test setup is in order

We have a multi company implementation of T24 R09.

BNK is BD0010001 ... the main bank
LD1 is BD0010002 .. the lead bank branch
There are few hundred branches ... one of them is
TGB is BD0013218

All the customer records are in FBNK.CUSTOMER table.
All the account records are in FLD1.ACCOUNT table

So far I have setup SMS for customer 20862132 for receiving Credit Advice. The account used for this customer is 0200002970839. Please note account record 0200002970839 has the following
CUSTOMER=20862132
CO.CODE=BD0013218

And the OFS for FT is as follows -
FUNDS.TRANSFER,/I/PROCESS/0/0,OFSLOGINID/**********/BD0013218,,TRANSACTION.TYPE=ACFT,DEBIT.ACCT.NO:1:1=0200000997916,CREDIT.CURRENCY=BDT,CREDIT.AMOUNT:1:1=500.0,CREDIT.ACCT.NO:1:1=0200002970839

I have the following
F.DE.ADDRESS has BD0010001.C-20862132.SMS.1 record

F.DE.PRODUCT has BD0010001.C-20862132.910.ALL record

F.DE.CUSOTMER.PREFERENCES has 20862132 record

I do not have any record in F.DE.ADDRESS for BD0013218.SMS.1 or for that matter BD0010001.SMS.1

If you prefer I can send all the screen shots from browser web.

Again thanks for helping me on this.

Hi
You're welcome :))

Try to create the following DE.ADDRESS record:

BD0013218.C-20862132.SMS.1

Then you can resubmit your delivery record.

If this doesn't work, try to create an account-level DE.ADDRESS, @ID then should be:

BD0013218.A-0200002970839.SMS.1

Hi,

I am getting INVALID COMPANY CODE when I try to create BD0013218.C-20862132.SMS.1 or BD0013218.A-0200002970839.SMS.1 in DE.ADDRESS

Regards.

Hi
Is it under "multi-book"? If yes, what's the "main" company?

Hi,

It is multi-book, multi-company.

The main company is BD0010001 (BNK) the customer table is FBNK.CUSTOMER
The lead company is BD0010002 (LD1) the account table is FLD1.ACCOUNT

Can I get more specific data for you from some tables? Please, let me know.

Thanks.