× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Sending SMSs using Delivery

  • concern
  • concern's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • R16 | TAFC | ORACLE
  • Posts: 86
  • Karma: 2
  • Thank you received: 4

concern created the topic: 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
#5638

Please Log in or Create an account to join the conversation.

  • Posts: 70
  • Thank you received: 0

yoshan replied the topic: Re: Sending SMSs using Delivery

Concern,

Did u able to config the above modification??

Thanks,
#5678

Please Log in or Create an account to join the conversation.

  • Posts: 411
  • Karma: 10
  • Thank you received: 52

kripesh replied the topic: Re: Sending SMSs using Delivery

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.

Have a great day !
#5679

Please Log in or Create an account to join the conversation.

  • concern
  • concern's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • R16 | TAFC | ORACLE
  • Posts: 86
  • Karma: 2
  • Thank you received: 4

concern replied the topic: Re: Sending SMSs using Delivery

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
#5691

Please Log in or Create an account to join the conversation.

  • Posts: 9
  • Thank you received: 0

salmanfatehali replied the topic: Re: Sending SMSs using Delivery

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

Please Log in or Create an account to join the conversation.

  • Posts: 411
  • Karma: 10
  • Thank you received: 52

kripesh replied the topic: Re: Sending SMSs using Delivery

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

Have a great day !
#5702

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Karma: 4
  • Thank you received: 9

saahmad replied the topic: Re: Sending SMSs using Delivery

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.
#5731

Please Log in or Create an account to join the conversation.

  • Posts: 1
  • Thank you received: 0

noname replied the topic: Re: Sending SMSs using Delivery

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

Regards
Noname
#8833

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Karma: 4
  • Thank you received: 9

saahmad replied the topic: Re: Sending SMSs using Delivery

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
#8839

Please Log in or Create an account to join the conversation.

  • yusuf.asif@gmail.com
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

yusuf.asif@gmail.com replied the topic: Re: Sending SMSs using Delivery

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
#20509

Please Log in or Create an account to join the conversation.

  • concern
  • concern's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • R16 | TAFC | ORACLE
  • Posts: 86
  • Karma: 2
  • Thank you received: 4

concern replied the topic: Re: Sending SMSs using Delivery

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

#20510

Please Log in or Create an account to join the conversation.

  • yusuf.asif@gmail.com
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

yusuf.asif@gmail.com replied the topic: Re: Sending SMSs using Delivery

Thanks a bunch Concern.

It seems the record has been reversed.
TSA.SERVICE SEE

     SERVICE........... SMS.OUT ; 2
 ------------------------------------------------------------------------------
   1. 1 DESCRIPTION.... DE FORMATTING SERVICE
   3. 1 WORK.PROFILE... DE.FORMATTING.SERVICE USED FOR DE FORMATTING SERVICE
   5 USER.............. INPUTTER            INPUTTER
   6 SERVICE.CONTROL... STOP
  26 RECORD.STATUS..... REVE                REVERSE Reversed
  27 CURR.NO........... 2
  28. 1 INPUTTER....... SY_COMP.IN.TSA
  29. 1 DATE.TIME...... 29 DEC 10 23:56

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.
#20511

Please Log in or Create an account to join the conversation.

  • concern
  • concern's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • R16 | TAFC | ORACLE
  • Posts: 86
  • Karma: 2
  • Thank you received: 4

concern replied the topic: Re: Sending SMSs using Delivery

the service is controlled by DE.OUTWARD
BATCH ENTRY SEE

     BATCH PROCESS..... SMS.OUT ; 2
 --------------------------------------------------------------
   3 PROCESS.STATUS.... 0                   READY
   4 BATCH.ENVIRONMENT. F                   FOREGROUND
   6. 1 JOB.NAME....... DE.OUTWARD          JOB FOR FORMATTING SERVICE
   8. 1 FREQUENCY...... D                   DAILY
   9. 1 NEXT.RUN.DATE.. 13 JUN 2011
  12. 1 JOB.STATUS..... 0                   READY
  27 RECORD.STATUS..... REVE                REVERSE Reversed
  28 CURR.NO........... 2
 --------------------------------------------------------------
#20512

Please Log in or Create an account to join the conversation.

  • yusuf.asif@gmail.com
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

yusuf.asif@gmail.com replied the topic: Sending SMSs using Delivery

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.
#20589

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 555
  • Karma: 10
  • Thank you received: 80

VK replied the topic: Sending SMSs using Delivery

Hi
is "BD0013218" your COMPANY ID?

Cheers
VK
#20597

Please Log in or Create an account to join the conversation.

  • yusuf.asif@gmail.com
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

yusuf.asif@gmail.com replied the topic: Sending SMSs using Delivery

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.
#20599

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 555
  • Karma: 10
  • Thank you received: 80

VK replied the topic: Sending SMSs using Delivery

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

Cheers
VK
#20600

Please Log in or Create an account to join the conversation.

  • yusuf.asif@gmail.com
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

yusuf.asif@gmail.com replied the topic: Sending SMSs using Delivery

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.
#20603

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 555
  • Karma: 10
  • Thank you received: 80

VK replied the topic: Sending SMSs using Delivery

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

Cheers
VK
#20607

Please Log in or Create an account to join the conversation.

  • yusuf.asif@gmail.com
  • Offline
  • New Member
  • New Member
  • Posts: 19
  • Thank you received: 1

yusuf.asif@gmail.com replied the topic: Sending SMSs using Delivery

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.
#20609

Please Log in or Create an account to join the conversation.

Time to create page: 0.725 seconds