TextQube wins international prize

TextQube, Web server version
Text the word 'today', for temporary workers a  message is returned detailing available work today so workers can be pro-active in making themselves available to work. For tourists a message is returned with seats available in a theatre or restaurant.
Outside a house For Sale, property to rent, text a code and details of the property are sent back to you.
Text me the balance of my account. Send me a ticket ( complex tickets could be sent to an email address with pdf attached)


If you can host a website accessible on the internet, this simple to install web version allows received messages to be pushed to you instantly. You can then connect to your own databases. Alternatively a simple response table database can be set up for you. This will still allow you to attach complex pdfs to emails to clients in your database.

A secure administrator login to your site, gives access to a simple interface where you can set up your responses to SMS queries from your own SQL server database. TextQube works in assocation with 2 SMS routing companies, TextAnywhere and Esendex. Your customers will use their mobiles to call a virtual mobile number which means the messages will go to the routing company who will then push the message instantly to your website.

Your website will then lookup the response and send it back to the messaging company who then forward this response back to the customer's original mobile. This typically takes 5 seconds for the customer to receive the reply.










Clients Edit/View

At this web page you add new customers if you want the option to only allow approved users to access the lookups. The mobile number of the requestor is checked against this list to see if they are permitted to query the database. You can do quick Find on the list to edit or view these records including a map function to show location of the users.

 


Look Ups Edit/View

At this web page, you can set up the responses to the query. You can set up a simple text response or  assign a pdf to be sent to an email address as an attachment if the customer has been set up on the above Clients database. Reynardine can work with you to create pdfs on the fly, ie dynamically create pdfs from databases for more sophisticated reporting.




Messages View

At this web page, you can view the received messages and the responses that were sent. If the requestor is in the Client database then the Person is identified.. You can also click on a row in the grid and optionally build a list of recipients for a manual SMS message that you can type in at this point and send instantly.








TextQube SMS Software, Windows application for the PC is an easily installed SMS text messaging application allowing you to send requested information from your database to a mobile phone. The mobile phone user sends a reference code to you by calling your own Inbound Text number. TextQube is sitting looking on the internet for new messages coming in sent to that number. When it receives them it strips out the reference code and uses it to lookup a data field with that reference code. It then sends the contents of the data field back to the mobile phone that requested it as a text message. TextQube can easily connect to your Access databases or SQL Server databases.
Some example scenerios for your mobile users:


Text the word 'today', for temporary workers a  message is returned detailing available work today so workers can be pro-active in making themselves available to work. For tourists a message is returned with seats available in a theatre or restaurant.
Outside a house For Sale, property to rent, text a code and details of the property are sent back to you.
Text me the balance of my account.


First choose your database server and the database:



The Data Connection
In this example we are using SQL Server name: localhost with database: northwind. Then select the table name from the database and the reference field and lookup field. In this case, the table name is ‘Orders’, if someone texts the content of the ‘OrderDate’ field in the ‘Orders’ table to your Inbound number, they will receive back the looked up contents of the ‘ShipAddress’ field. TextQube can be downloaded and installed in minutes giving instant access to your mobile clients. Because TextQube uses one field to lookup another it acts as its own firewall into your database. Only one field is accessible and only if you know what to send to TextQube.



The Lookup Table
Once you save the choice of fields then you can view your table information in the Lookup Table. The first column marked ‘Text this’ contains the reference code to text to you ( the OrderDate field in this example), the second column marked ‘Look up this and textback’ contains the information to text back ( the ShipAddress field). Each row is a record in your current database. You can add and edit rows here with TextQube and the edits will be written back to your database. For example, if a mobile user sent ‘04/07/08’ to your inbound number, seconds later they would receive the texted back message ’59 rue de l’Abbaye’. A simple function allows you to check that the message is within the 160 character limit for a single message though you can send longer messages as multiple SMS messages. What would your message be? Availability for a restaurant, show perhaps or maybe current shifts or temp jobs?





Main Message Received Screen
Here you can see all the new messages coming through into your Inbound number. If ‘Polling On’ is ticked TextQube automatically polls for messages, looks up the information and sends it back to the mobile. As well as this function, if the mobile user sends an email address, TextQube will separate it out, lookup for a .pdf file related to the reference code, attach it to an email and send it to the email address supplied. This function is especially useful if you are say outside a house for sale/rental premises/tourist information spot etc etc that you want information but you have no access to the property. A very detailed report can be sent to you that will be available when you get back home or to the office. You can also send a manual message to anyone by typing in the Message and the mobile number. They can reply to it and the reply will either be sent to this screen within TextQube or to your email address.

For more information , contact: Mike Thompson Reynardine Software
The Briers, Richdore Rd ,
Waltham,
Kent CT4 5SL
www.reynard.co.uk

t: +44 (0) 1227 700397