Elastix 2.2 and RoomMaster 2000

Status
Not open for further replies.

achilles1

Joined
Oct 30, 2007
Messages
112
Reaction score
0
I want to connect Elastix to RoomMaster 2000 which is a hotel management system.
This comes with a External Posting Interface(EPI) which listens on a certain port.
This data is like serial data (Station Messaging Data Records) and is somewhat the same as CDR.
How do I port data from asterisk to EPI?
I allready have the format:
Code:
         1         2         3         4        
5123456789012345678901234567890123456789012345678901234
------------------------------------------------------
0001 TEL 03/01  7110 10:54 0002 $003.47 805-688-1000 L
^    ^   ^      ^    ^     ^    ^       ^            ^-- Long Distance Indicator
^    ^   ^      ^    ^     ^    ^       ^--------------- Phone Number
^    ^   ^      ^    ^     ^    ^----------------------- Charge Amount 
^    ^   ^      ^    ^     ^---------------------------- Duration of Call 
^    ^   ^      ^    ^---------------------------------- Time of Call
^    ^   ^      ^--------------------------------------- Extension Number
^    ^   ^---------------------------------------------- Date of Call
^    ^-------------------------------------------------- Charge Identifier
^------------------------------------------------------- Sequence Number

From their tech dep:
Sequence Number – should increment with each new record, but doesn’t matter to us.·
Charge Identifier – this will always be “TEL”.·
Date of Call – In MM/DD format.·
Extension Number – Origination point of call…usually room number. If not, extensions can be mapped to room numbers in our interface.·
Time of Call – Can be either time call was started or finished.·
Duration of Call – Length of call in minutes.·
Charge Amount – Currency symbol can be anything. If your system does not price the call, our interface can handle the pricing of the call.·
Phone Number – Digits dialed by the guest.·
Long Distance Indicator – “L” means the call was long distance. This helps us assign the correct billing code if the hotel wants to separate local vs. long distance calls.
 
i think i found a solution. :woohoo:
 
Can you share your solution?
 
Hello,

I´m verry intrested in the solucion you find , I´ve been trying to conect them for a wile now. Can you please let me have this solucion, I can pay for it. Please let me know how can i contact you
 
Hello i would like to know the solution you have found thanks :)
 
Can you share the solution you found with this issue please.
 
Hi all

Sure achilles, you could share your solution to the Elastix community.
Remember that an OpenSource community works like this. The knowledge sharing.

Please give us your feedback.

Regards
 
Yes ofcourse guys,
Actually it's quite simple:

in cdr.conf
[general]
enable = yes

in cdr_custom.conf
[mappings]
EPI.csv => ${SHELL(${IF($[${CDR(src)} > 4000 && ${CDR(src)} < 5000]?echo "TEL ${STRFTIME(${CDR(start, u)},America/New_York,%m/%d ${CDR(src)} %R)} ${FILTER(0-9,${MATH(${CDR(billsec)}/1000000,float)})} ${CDR(dst)}" | nc -w 1 10.11.12.121 6000)})}

<logically it makes no sense the order of functions/commands, but this was the only order that would work for me>

Basically it says:
If the source clid is between the above range, then build a nice string to netcat to a host(epi) on a specific port. EPI must listen to this port.
You'll have to break up the above code to understand all parts, also do some research in the asterisk FUNCTIONS.
So it is a real-time connector with no buffer and very dirty coding :). Feel free to improve.
It is also possible to port this to a text file which EPI will read.
Activate smb on pbx server and make EPI read from remote folder.

Sorry guys it took so long. Had to make things work here.
I also managed to create a autoscript to massupdate the billinglist for Roommaster EPI.
Anyone interested? This has nothing to do with elastix.

Oh yeah, you'll probably need the settings in EPI.
Header tab:
Messagetype: One-way [LF as terminator]
First line text:/ POS:7
Last line text:/ POS:7
Roomnumber: 1 [TAB] 11 [TAB] 4

Detail:
Detail line text:/
Start position:7

Amount: 0 - 0 - 0
Duration: 0 - 22 - 7 (seconds only)
Voucher1: 0 - 30 - 14
Voucher2: 0 - 22 - 7

GOOD LUCK GUYS!!!
 
gringusd said:
Hello,

I´m verry intrested in the solucion you find , I´ve been trying to conect them for a wile now. Can you please let me have this solucion, I can pay for it. Please let me know how can i contact you
don't worry about it.
 
Good job achille.

Great. :)
 
danardf said:
Good job achille.

Great. :)
:silly:
So the fun part is (maybe impossible) to start a bi-directional interface.
It should be possible to check-in/check-out a room (roomx:fantastic app from danardf) via Roommaster.
Who dares? B)
 
Maybe the day where RoomX gonna be stable. :P
Not before man. ;)
 
Nahh...i think the limitation is in EPI.
If it is possible to fire a script, then everything is possible.
I will check with the makers to enable something like this.
 
achilles said:
Nahh...i think the limitation is in EPI.
If it is possible to fire a script, then everything is possible.
I will check with the makers to enable something like this.

You mean, ....is in API?
Until Roomx will not be stable, wait..
Today, there's too many thing to check and to test from my side.

If you want to include a such script, i'm ok for that. But i'm not the best on RoomMaster 2000 and API script. ;)
If you want to working on a RoomX add-on, do it. I'm ok, sure.
 
achilles said:
:silly:
So the fun part is (maybe impossible) to start a bi-directional interface.
It should be possible to check-in/check-out a room (roomx:fantastic app from danardf) via Roommaster.
Who dares? B)

Hmmm, Remember that, the goal of RoomX was to avoid to use other software. ;) :P :laugh:
I guess that RoomMaster 2000 is very powerful. (I don't know RoomMaster),
What's difference between them?
RoomX provide only some basis functions, that's all (for the moment).
We can imagine begining with a Hotel project, RoomX should be great in this case.
Just what we need to start.
 
Status
Not open for further replies.

Members Online Now

Forum statistics

Threads
111,832
Messages
589,284
Members
164,662
Latest member
DejanMDS