WxCC Flow Editor String to Int Conversion?

[tmessenger]

Is it possible to convert a string value to an int in the WxCC Flow Editor?  We have a large qty of patient rooms that call into our Dietary contact ctr.  The staff would like WxCC to display the patient room number.  Most of the room numbers coordinate with the last 3 digits of the DN, but not all of them.  I would like to convert the NewPhoneContact.ANI to an INT variable so I can perform some basic math functions to set the Room Number field.  I have some very basic Java experience and I've looked through the Pebble documents but haven't seen a way to accomplish this. 

Any help is greatly appreciated! 

[bill.king1]

Hi, this may be a basic question, but if you try and just do something like a slice of the ANI to get the last 4 digits or whatever you need, it errors out? I wouldn't think you'd need to specify if it is int vs string or whatnot.

[tmessenger]

I beleive Slice would work if we only had one range of DNs. However, we have a few different ranges that need to be sorted and labeled appropriately. 

All calls should be coming in via our SME, so they should be presented as 5 digit ANIs. 

Standard Pt Rms 202-394 w/DNs: 63202 - 63394

ICU Pt Rms 1-8 w/DNs: 61101 - 61108

Rooms 102A/B - 116A/B wDNs: 6886 - 68879

LDR Rooms 1-7 w/DNs: 63311 - 63317

Sleep Lab Rm1 65121 & Rm2 65122

Surg Rooms 1-16 w/DNs: 65101 - 65113

Plus, we have other DNs that could get associated to a room incorrectly if we use only the leading digits to sort.  If I could convert the ANI to an INT, 

I could check the value of the ANI vs a range (using > and <), and populate the Room Number after slicing the first 2 digits off where applicable. 

[tmessenger]

I just got an updated range, which now shows that these ranges are not contiguous, so that makes this even more challenging.  Ideally, having the Flow Editor access an XML doc to designate the Room Number based off of the NewPhoneContact.ANI would be ideal. 

[bill.king1]

Is this information available that you could query it via an HTTPS web call, like a basic database lookup that room 123 = Standard but 456 is ICU?

[tmessenger]

I'm meeting with our Cisco Rep tomorrow, we're looking into BRE, as well as other solutions.  I'll update you on what we go with.  

[david.macias]

BRE would solve your problem, but my advice is to just put this on an API somewhere. It’s going to be so much easier to maintain and so much easier to just script. There are so many services out that that are dirt cheap which could house a simple DB and HTTP end point for you. The cost will probably be less than  $10 USD/month . Peanuts in the grand scheme of things.

david

[gkovanis]

@tmessenger To answer your initial question, you can type cast (convert from string to int) in Flow Designer by creating an integer variable and then using the Set Variable node (with Set Value option) and select as Variable your integer one and as Set Value use the formula {{String_variable}}. You can see an example below of how I make a string variable (Record_String) to integer one (Record_Integer).