Overview:
Creation of a MIKROTIK wireless hotspot script system for a motel using specific windows based property management software package (which can only communicate using flat text files).
From the end-user perspective:
The user will be able to connect to the wireless network without and wireless security, where they will be redirected to the hotspot page. The user will then be able to authenticate with their unit number and last name after which they will receive 2 hours of complementary internet. At the end of this period they will be redirected to the same page giving them paid option only, specifically the package they would like (in hours). The system then will then allow their computer to gain access to the internet and will alert the billing system to the appropriate charge, as well as to do a simple http:// post / get with the same information to get into our billing logs.
Some Constraints:
Based on Mikrotik’s built in hotspot system and the current abilities of the windows based billing system, I need to be able to:
1. query a flat text file (on a samba share or ftp service) (perhaps each time that a request of the script is made) that will extract the unit numbers and last names out of the file and then use these credentials to:
2. Add a hotspot user for (x) hours and activate them
3. Create a new formatted text file on another share of ftp file location that will contain the billing information
4. Report back to a database though web or ftp on the charge that was entered into their billing system so it can be entered into our billing system.
I am hoping that we can do all of the above using mikrotik scripting rather than having to put in a local LAMP server or rely on an external LAMP server. If this is not possible then a LAMP server can be provided.
The windows package that does not have an API, the best they are able to do is when a person checks in is write their details out into a flat text file. And as for billing, when the person checks out it processes any flat text files in a certain folder on the server and uses the information to create the charges for the guest.
This being the case the easiest way to interface / get and put files with a windows box is samba or ftp, so that is the constraint at this point.
POSSIBLE SOLUTION:
Upon any end user visiting the hotspot page (hosted on the MikROTIK ) the script will look for check for the flat text file in a specific location (getting them from ftp perhaps) it would then process the file and add all of the users to the mikrotok database, without activating them. In the format username=room number password = guest last name
A guest then will authenticate through the hotspot with their credentials where they account will be activated for the complementary time of 2 hours, after this time the guest will have the option of choosing the chosen about of time (1 day, 2 days 7 days etc) The hotspot would open up access in the normal way. The Script will then (at the time of this activation) via ftp create a file for the charge on the windows box and to a http post to our billing server for reconciliation.
FLAT TEXT FILE Information (IN and OUT):
FILE FORMAT
Date Format: DD/MM/YY
Time format: HH:MM:SS
Transno: Not required
Condition: B009 B=Broadband P=Movies
Unit Number
Revenue Code : 1 = Charge
Description : This description is not displayed on Folio but is displayed on posting ie Movie Name
Charge : This is dollars and cents, no decimal point. Max would be $99,999.99 => 9999999 $12.50 would be 1250
(may be space padded on left, no negative charges)
File Method data format available upon Hiring.
Please only bid if you have prior workings with Mikrotik.
Just check PMB for more details. click to the attachment here our best projects I have linked. We are having 8 years experience development. Please check PMB.
Hello
I am Certified Mikrotik Trainer and Consultant. I have years experience in Deploying HotSpot systems as well.
I can help with this project
Regards
Pawel Cieplinski