Yes Please . . . i m intrestedI am working on a VB based Hotspot Ticket system.
It will take the CSV files from RouterOS, deteman the proper printer (reachable via TCPIP) and print the ticket
with appopriate verbage, UPC code for inventory and serial numbers if needed. (Serialised by ticket and cross referanced to the user ID.)
Kick me a note if interested.
Sorry I thought you would be posting that here in the forumsI will nees a contact method..
Email etc..
Dear csickles,I will nees a contact method..
Email etc..
Your name look like Idoma man. are u?Need a copy please! onojahj@yahoo.com
Can you send me this vb script. (xsystemgr@gmail.com)I am working on a VB based Hotspot Ticket system.
It uses a POS printer to produce tickets similar to what you would see from a retail store recept.
It will take the CSV files from RouterOS, deteman the proper printer (reachable via TCPIP) and print the ticket
with appopriate verbage, UPC code for inventory and serial numbers if needed. (Serialised by ticket and cross referanced to the user ID.)
Custom Graphics can be added as desired.
The tickets are barcoded as well...
There is a sample available on the MikroTik WIKI...
Kick me a note if interested.
I am an Igala Man from Ankpa in Gogi State.Your name look like Idoma man. are u?Need a copy please! onojahj@yahoo.com
Can I just put it into this topic for download?I have sent the source code to MikroTik... (Sent it to Normunds and gave a flash to John)
Oh and to make it more interresting....
The new User Manager does not export all the needed data in the CSV format...
I had to "downgrade" my hotspot at work to 4X to get the old user manager data format....
We are still expecting the post that is if he make a head way, he is even better than some of us in programming, so we have no choice than to wait, probably endlesslyHence why I figured it as a module for "The Dude"...
Let me double check the source and verify it has no "sensitive data" and I will post it...... so that the concepts can be understood...
Please give me a few days.. Also no humor, as I am NOT a programmer.. this was a learning project..
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>User Manager Voucher Page - By Syed Jahanzaib aacable@hotmail.com</title>
<meta name="description" content="User Manager Voucher Page - By Syed Jahanzaib aacable@hotmail.com">
<meta name="Microsoft Theme" content="none, default">
</head>
<body background="http://192.168.2.3/background_compass.gif" topmargin="5" leftmargin="5" style="background-attachment: fixed">
<table style="color: black; font-size: 11px;" border="2" align="left" width="286" height="300" cellspacing="0" cellpadding="0" id="table1"> <tr>
<td colspan="2" height="69">
<p align="center">
<font size="1">
<img border="0" src="http://192.168.2.3/nae.jpg" width="107" height="67"></font></p>
</td> </tr> <tr height="5px">
<td colspan="2">
<p align="center"><u><b><font color="#0000FF" size="3">Package:
%u_actualProfileName%</font></b></u></td></tr>
<tr>
<font size="2" face="Arial">
<td>
<p align="center"><font size="2" face="Arial Black">Price</font></td> </font> <td>
<p align="center"><font size="2" face="Arial Black" color="#FF0000">%u_moneyPaid%</font></td>
</tr>
<tr>
<td>
<font size="2" face="Arial Black">
<p align="center">Prepaid time:</td> <td>
<p align="center"><font color="#FF0000" face="Arial Black" size="2"><b>%u_timeLeft%</b></font></td>
</tr>
<tr> <td>
<font size="2" face="Arial Black">
<p align="center">Login:</td> <td>
<p align="center"><font color="#FF0000"><b>
<font size="2" face="Arial Black">%u_username%</font></b></font></td> </tr>
<tr>
<font size="2" face="Arial">
<td>
<p align="center"><font size="2" face="Arial Black">Password:</font></td> <td>
<p align="center">
<font face="Arial Black" color="#FF0000"><b><font size="2">%u_password%</font></b></font></td>
</font>
</tr>
<tr height="20px">
<td colspan="2">
<p align="center"><b><u><font size="2" color="#0000FF">~ Howto Use
This Voucher ~</font></u><font color="#008000" size="2"><u><br>
</u></font></b><font size="2" color="#008000">Please open
<a href="http://ftp.local">http://ftp.local</a> and download <br>
aa-dialer.exe & install it. After installation its icon will appear
on Desktop. Double click on it, and use the above mentioned ID and
Password to connect to the internet .<br>
</font><font size="2" face="Arial Black" color="#FF0000">This ID will
expire in 30 days after its first usage.</font><font size="2" color="#008000"><br>
</font><b><font size="2">Thank You For Choosing AA~Services</font></b></td></tr> <tr>
<td colspan="2" align="right" height="50">
<p align="center"><b><font size="1">AA Network Services</font></b><font size="1"><br>
Support : 92.333.3021909<br>
Email aacable@hotmail.com<br>
Web <a href="http://aacable.com">http://aacable.wordpress.com</a> </font></td> </tr> </table>
</body>
</html>
Loking nice ... put it here for download ... this template here when is done .It would be great If mikrotik add feature of adding serial numbers with each id,
So that we can print voucher with serial numbers, and can search ids by corresponding serial number.
I have customized the vouchers but unable to add serial number.
I am working on MS ACCESS program to import ids passwds from .CSV file ,
then print it using my customized templates and add serial number to each id and store it in its database to prevent Duplication, and also add search function by serial.
I will publish it soon.
<html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Voucher</title> <meta name="description" content="Voucher"> <meta name="Microsoft Theme" content="none, default"> </head> <table style="color: black; font-size: 11px;" border="2" align="left" width="286" height="300" cellspacing="0" cellpadding="0" id="table1"> <tr> <td colspan="2" height="69"> <p align="center"> <font size="1"> <img border="0" src="/umfiles/voucher.png" width="455" height="95"></font></p> </td> </tr> <tr height="5px"> <td colspan="2"> <p align="center"><u><b><font face="calibri" size="4">Package: %u_actualProfileName%</font></b></u></td></tr> <tr height="5px"> <td colspan="2"> <p align="center"><u><b><font face="calibri" size="4">Personal Details</font></b></u></td></tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Name :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_firstName% %u_lastName%</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Address :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_location%</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Contact :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_phone%</font></td> </tr> <tr height="5px"> <td colspan="2"> <p align="center"><u><b><font face="calibri" size="4">Internet Details</font></b></u></td></tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">User ID :</font></td> </font> <td> <p align="center"><b><font size="4" face="calibri" >%u_username%</font><b></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Password :</font></td> </font> <td> <p align="center"><b><font size="4" face="calibri" >%u_password%</font><b></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Started Date :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_actualProfileStart%</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Expiry Date :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_actualProfileEnd%</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Volume Limit :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_limitDownload%</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Uptime Limit :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_limitUptime%</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="right"><font size="4" face="calibri">Caller ID :</font></td> </font> <td> <p align="center"><font size="4" face="calibri" >%u_callerId%</font></td> </tr> <tr height="5px"> <td colspan="2"> <p align="center"><u><b><font face="calibri" size="4">Financial Details</font></b></u></td></tr> <tr> <font size="2" face="calibri"> <td> <p align="center"><font size="4" face="calibri">Package Amount :</font></td> </font> <td> <p align="left"><font size="4" face="calibri" >Rs.</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="center"><font size="4" face="calibri">Received Amount :</font></td> </font> <td> <p align="left"><font size="4" face="calibri" >Rs.</font></td> </tr> <tr> <font size="2" face="calibri"> <td> <p align="center"><font size="4" face="calibri">Due Amount:</font></td> </font> <td > <p align="left"><font size="4" face="calibri" >Rs.</font></td> </tr> <tr height="5px"> <td colspan="2"> <p align="center"><u><b><font face="calibri" size="4">Instructions to use this voucher</font></b></u></td></tr> <tr height="20px"> <td colspan="2"> <p align="left"><font size="3" face="calibri" >1. Browse any webpage on your browser. (http://ace.net.np) </font><font face="calibri" size="2"><br> </font></b><font face="calibri" size="3">2. The page redirects to the ACE Homenet. <br> 3. Supply the User ID and Password provided above. <br> 4. Click on <u>Get Access</u> button. <br> </font><font size="2" face="calibri">Now you are connected to the internet via ACE Networks Pvt. Ltd. </font><font size="2" color="#008000"></b></td></tr> <tr> <td colspan="2" align="right" height="50"> <p align="center"><b><font face="calibri" size="2">Note: If you want to end your session, click on <u>Log Off </u>button in Status Page or input <u>http://ace.net.np/logout</u> in your browser. </table> </body> </html>
Where is the script in the first place! not receive by mail nor seen on the forum!OK I got it working again....
It takes some "custom" reformatting inside user manager (the user "CSV" report format) needs to be tweeked.
Also, this "CSV" has a habit of generating an empty row at the end of the "CSV" report.
I had to handle this as it was crashing the code.
Also I had to upgrade the project from VB 2005 to VB 2010.. And Active Reports 6..
Oh what "FUN"....
It would be great If mikrotik add feature of adding serial numbers with each id,
So that we can print voucher with serial numbers, and can search ids by corresponding serial number.
I have customized the vouchers but unable to add serial number.
I am working on MS ACCESS program to import ids passwds from .CSV file ,
then print it using my customized templates and add serial number to each id and store it in its database to prevent Duplication, and also add search function by serial.
I will publish it soon. Template Code:Code: Select all<html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>User Manager Voucher Page - By Syed Jahanzaib aacable@hotmail.com</title> <meta name="description" content="User Manager Voucher Page - By Syed Jahanzaib aacable@hotmail.com"> <meta name="Microsoft Theme" content="none, default"> </head> <body background="http://192.168.2.3/background_compass.gif" topmargin="5" leftmargin="5" style="background-attachment: fixed"> <table style="color: black; font-size: 11px;" border="2" align="left" width="286" height="300" cellspacing="0" cellpadding="0" id="table1"> <tr> <td colspan="2" height="69"> <p align="center"> <font size="1"> <img border="0" src="http://192.168.2.3/nae.jpg" width="107" height="67"></font></p> </td> </tr> <tr height="5px"> <td colspan="2"> <p align="center"><u><b><font color="#0000FF" size="3">Package: %u_actualProfileName%</font></b></u></td></tr> <tr> <font size="2" face="Arial"> <td> <p align="center"><font size="2" face="Arial Black">Price</font></td> </font> <td> <p align="center"><font size="2" face="Arial Black" color="#FF0000">%u_moneyPaid%</font></td> </tr> <tr> <td> <font size="2" face="Arial Black"> <p align="center">Prepaid time:</td> <td> <p align="center"><font color="#FF0000" face="Arial Black" size="2"><b>%u_timeLeft%</b></font></td> </tr> <tr> <td> <font size="2" face="Arial Black"> <p align="center">Login:</td> <td> <p align="center"><font color="#FF0000"><b> <font size="2" face="Arial Black">%u_username%</font></b></font></td> </tr> <tr> <font size="2" face="Arial"> <td> <p align="center"><font size="2" face="Arial Black">Password:</font></td> <td> <p align="center"> <font face="Arial Black" color="#FF0000"><b><font size="2">%u_password%</font></b></font></td> </font> </tr> <tr height="20px"> <td colspan="2"> <p align="center"><b><u><font size="2" color="#0000FF">~ Howto Use This Voucher ~</font></u><font color="#008000" size="2"><u><br> </u></font></b><font size="2" color="#008000">Please open <a href="http://ftp.local">http://ftp.local</a> and download <br> aa-dialer.exe & install it. After installation its icon will appear on Desktop. Double click on it, and use the above mentioned ID and Password to connect to the internet .<br> </font><font size="2" face="Arial Black" color="#FF0000">This ID will expire in 30 days after its first usage.</font><font size="2" color="#008000"><br> </font><b><font size="2">Thank You For Choosing AA~Services</font></b></td></tr> <tr> <td colspan="2" align="right" height="50"> <p align="center"><b><font size="1">AA Network Services</font></b><font size="1"><br> Support : 92.333.3021909<br> Email aacable@hotmail.com<br> Web <a href="http://aacable.com">http://aacable.wordpress.com</a> </font></td> </tr> </table> </body> </html>
Note:
I used 2 images, one is logo, second is background image,
Both files are residing on the Local web server.
You have to modify these links and files name to match according to your structure.
csickles please send me a copy olebole88@hotmail.com