Community discussions

MikroTik App
 
User avatar
aacable
Member
Member
Topic Author
Posts: 435
Joined: Wed Sep 17, 2008 11:58 am
Location: ISLAMIC Republic of PAKISTAN
Contact:

Voucher with Serial Numbers !

Sat Oct 04, 2008 2:59 pm

Hi,
I have to generate 300 vouchers per month, UM doesn't print serial numbers with. How can I customize it to print serial numbers on every voucher. I am using this voucher ttemplate from wiki:

<table style="color: black; font-size: 11px;" border="2" height="10">
<tr>
<td colspan="2" bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">YOUR COMPANY NAME GOES HERE!</font></b>
</td>
</tr>
<tr>
<td bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">Time:</font></b>
</td>
<td bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">%u_limit_uptime%</font></b>
</td>
</tr>
<tr>
<td bordercolorlight="#000000" bordercolordark="#000000">
<font face="Arial" size="2"><b>Validity</b></font>
</td>
<td bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">%u_prep_time%</font></b>
</td>
</tr>
<tr>
<td bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">Price:</font></b>
</td>
<td bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">%u_tot_price%</font></b>
</td>
</tr>
<tr>
<td bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">Username:</font></b>
</td>
<td bordercolorlight="#000000" bordercolordark="#000000">
</font><b><font size="2" face="Arial">%u_username%</font></b>
</td>
</tr>
<tr>
<td bordercolorlight="#000000" bordercolordark="#000000">
<b><font size="2" face="Arial">Password:</font></b>
</td>
<td bordercolorlight="#000000" bordercolordark="#000000">
<font face="Arial"><b><font size="2">%u_password%</font></b></font>
</td>
</tr>
</table>
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Tue Oct 07, 2008 7:06 am

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.
 
User avatar
aacable
Member
Member
Topic Author
Posts: 435
Joined: Wed Sep 17, 2008 11:58 am
Location: ISLAMIC Republic of PAKISTAN
Contact:

Re: Voucher with Serial Numbers !

Tue Oct 07, 2008 9:03 am

I 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.
Yes Please . . . :lol: i m intrested
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Tue Oct 07, 2008 9:03 pm

I will nees a contact method..

Email etc..
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Tue Oct 07, 2008 9:18 pm

Sample Ticket..
You do not have the required permissions to view the files attached to this post.
 
User avatar
aacable
Member
Member
Topic Author
Posts: 435
Joined: Wed Sep 17, 2008 11:58 am
Location: ISLAMIC Republic of PAKISTAN
Contact:

Re: Voucher with Serial Numbers !

Wed Oct 08, 2008 8:13 am

I will nees a contact method..

Email etc..
Sorry I thought you would be posting that here in the forums

My email address is > aacable@hotmail.com

thx & waiting . . .
 
User avatar
aacable
Member
Member
Topic Author
Posts: 435
Joined: Wed Sep 17, 2008 11:58 am
Location: ISLAMIC Republic of PAKISTAN
Contact:

Re: Voucher with Serial Numbers !

Fri Oct 10, 2008 9:48 am

I will nees a contact method..

Email etc..
Dear csickles,
Any updates ??
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Fri Oct 10, 2008 5:17 pm

Working on it...

Needs "finishing"..
 
erhardt
just joined
Posts: 1
Joined: Wed May 30, 2007 10:32 am

Re: Voucher with Serial Numbers !

Thu Nov 27, 2008 12:33 pm

Hi there i would like to know, have you been able to get thi sworking with mikrotik, will we be able to use it on our systems?

wil you please be so kind to let me know

erhardt@seaviewmedia.co.za
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Thu Nov 27, 2008 9:40 pm

It was designed for use with the RouterOS hotspot ".CSV" files.

It runs as a "psudo service". In that you leave it running on some windows machine and it watches for CSV files and processes them as they appear.

I have some more things I want to add IE reporting and mailn from the application rather then having to lic. Microsoft Access..
 
Cillys
just joined
Posts: 18
Joined: Sat Nov 29, 2008 6:54 pm

Re: Voucher with Serial Numbers !

Sun Nov 30, 2008 8:01 pm

Hi ...

may i ask about your VB script ... and particular brand and such of your POS printer ...

i would like to be able as i manually add authenticated users to the hotspot ... in turn print a receipt for them
with all the aaa stuff ...

thanks
 
kourkoulis
just joined
Posts: 2
Joined: Sat Jun 02, 2007 10:03 am

Re: Voucher with Serial Numbers !

Sun Feb 01, 2009 12:53 pm

please send it to gk@theplanet.gr
thnx
 
User avatar
m4rk0
Member Candidate
Member Candidate
Posts: 196
Joined: Sat Feb 16, 2008 8:30 pm
Location: BA
Contact:

Re: Voucher with Serial Numbers !

Fri Feb 06, 2009 9:02 pm

Hello!

Can You post function how do You watch for CSV on RB and of course fetch that file... FTP?
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Fri Feb 06, 2009 10:15 pm

here is the short of it..

I use a windows pc to create the users (add batch).
the CSV file is written to a speciffic folder on the windows box.
my code wathces this filder and parces the CSV file.
The code bounces this data against a database and figures out
what printer to output to. and obtaines other information IE contact information, logos etc.
it then creates database records for the data (inserted records IDs) and then prints the ticket.

All of the preceding is working fine..

I just need to build some reporting and some management screens, so that ACCESS from Microsoft is not needed to maintain the system.

I am hoping to make a few $$ for the project as it has taken ALOT of time to write..

I havent put a bunch of time into it lately as there wasnt a scream for it at the last USA MUM...

If there is a need,,, let me know..
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Tue Feb 17, 2009 6:56 pm

Now that got quiet in a hurry !!


:lol:
 
User avatar
smarag
newbie
Posts: 27
Joined: Fri Jun 04, 2004 9:06 am
Location: Piraeus - Athens - Greece
Contact:

Re: Voucher with Serial Numbers !

Mon Sep 21, 2009 6:37 pm

Please send me in smarag @ gmail.com

thank you
 
User avatar
bax
Member Candidate
Member Candidate
Posts: 268
Joined: Mon Dec 20, 2004 8:45 pm
Location: Croatia

Re: Voucher with Serial Numbers !

Sat Dec 12, 2009 9:25 pm

csickles please sen me a copy on damir@wisp.hr !
Thanks
 
proggams2
Member Candidate
Member Candidate
Posts: 140
Joined: Wed Mar 14, 2007 10:15 pm

Re: Voucher with Serial Numbers !

Tue Dec 15, 2009 10:00 am

 
firewallrule
Member Candidate
Member Candidate
Posts: 118
Joined: Tue Oct 13, 2009 9:23 pm

Re: Voucher with Serial Numbers !

Wed Dec 16, 2009 1:22 pm

i need it too.

my email is netwaytech@gmail.com
 
User avatar
aacable
Member
Member
Topic Author
Posts: 435
Joined: Wed Sep 17, 2008 11:58 am
Location: ISLAMIC Republic of PAKISTAN
Contact:

Re: Voucher with Serial Numbers !

Wed Dec 16, 2009 1:48 pm

Why not make it publically available ??
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Wed Dec 16, 2009 4:30 pm

I can make it available, but I have to pay for some of the object code..

Will see what I can do,,
 
dingsingo
Member Candidate
Member Candidate
Posts: 116
Joined: Sun Jul 24, 2005 9:47 pm
Location: Germany

Re: Voucher with Serial Numbers !

Wed Feb 24, 2010 11:42 am

@csickles

i'am interess, form print simple Ticket via a POS IP-Printer. When you must have some Money for this, i thing is not an Problem. A Serialnumber and so is not so inportants My Dream is the sam Funktion of the Handlink WSG-5000.

Finally the Important Point is, ist must work in my System :-)


Thy

dingsingo
 
egaole
just joined
Posts: 3
Joined: Thu Feb 25, 2010 12:29 pm
Location: Norway

Re: Voucher with Serial Numbers !

Mon Mar 01, 2010 8:11 pm

csickles please send me a copy :) olebole88@hotmail.com
 
User avatar
JP_Wireless
Member Candidate
Member Candidate
Posts: 276
Joined: Thu Dec 13, 2007 4:31 pm
Location: Lagos Nigeria
Contact:

Re: Voucher with Serial Numbers !

Sat Mar 06, 2010 6:39 pm

Need a copy please! onojahj@yahoo.com
 
firewallrule
Member Candidate
Member Candidate
Posts: 118
Joined: Tue Oct 13, 2009 9:23 pm

Re: Voucher with Serial Numbers !

Sat Mar 06, 2010 9:36 pm

Need a copy please! onojahj@yahoo.com
Your name look like Idoma man. are u?
 
xsystem
just joined
Posts: 3
Joined: Wed Sep 07, 2005 3:46 pm
Location: Athens

Re: Voucher with Serial Numbers !

Wed Apr 28, 2010 12:44 pm

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.
Can you send me this vb script. (xsystemgr@gmail.com)

Thanx a lot
 
User avatar
JP_Wireless
Member Candidate
Member Candidate
Posts: 276
Joined: Thu Dec 13, 2007 4:31 pm
Location: Lagos Nigeria
Contact:

Re: Voucher with Serial Numbers !

Tue May 04, 2010 11:07 pm

Hi Firewallrule!
Need a copy please! onojahj@yahoo.com
Your name look like Idoma man. are u?
I am an Igala Man from Ankpa in Gogi State.

You can reach me via:onojahj@yahoo.com
 
Cefielle
just joined
Posts: 1
Joined: Tue May 04, 2010 11:06 am

Re: Voucher with Serial Numbers !

Tue May 11, 2010 10:57 am

me too send to yuda.winandar@yahoo.com

thx
 
Myron
Member Candidate
Member Candidate
Posts: 253
Joined: Sat Sep 05, 2009 3:17 am
Location: Boracay, Philippines

Re: Voucher with Serial Numbers !

Fri May 21, 2010 6:57 am

me to please myronray.sy.evasco@hotmail.com :D

thanks thanks
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Fri May 21, 2010 8:01 am

OK I give...

Forget the time I have spent..

I will provide the source to MikroTik..

They are welcome to add the code as a plug in to "The Dude"...

It is written in VB.net 2005.
It relies on ActiveReports.net (for 2005) and a set of Access tables (For config storrage and logging).

I will contact Normis and see if they want it...
 
Fl3tch
just joined
Posts: 22
Joined: Mon May 24, 2010 11:59 am

Re: Voucher with Serial Numbers !

Wed Feb 16, 2011 3:32 pm

HI csickles

Just want to know if MikroTik accepted your program?

If not would you please be so kind and send it to me or give me a link from where i can download it.

fox[at]safrica[dot]com

Thanks in advanced
 
alfagius
Frequent Visitor
Frequent Visitor
Posts: 53
Joined: Mon Feb 21, 2011 4:07 pm

Re: Voucher with Serial Numbers !

Mon Feb 21, 2011 4:32 pm

Is it still possible to get a copy of this program?

alfagius@gmail.com
 
nifter53
just joined
Posts: 5
Joined: Tue Oct 05, 2010 11:22 pm

Re: Voucher with Serial Numbers !

Tue Feb 22, 2011 6:29 am

Don't want to be 'that' guy, but, me too please.

Thanks!

Nifter53@Gmail.com
 
Megateq
newbie
Posts: 38
Joined: Thu Jan 08, 2009 12:33 am
Location: Nigeria
Contact:

Re: Voucher with Serial Numbers !

Wed Feb 23, 2011 2:35 pm

csickles please send me a copy :) aluko_isaac@yahoo.com
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Fri Feb 25, 2011 2:11 am

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....
 
User avatar
normis
MikroTik Support
MikroTik Support
Posts: 26376
Joined: Fri May 28, 2004 11:04 am
Location: Riga, Latvia

Re: Voucher with Serial Numbers !

Fri Feb 25, 2011 10:37 am

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....
Can I just put it into this topic for download?
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Wed Mar 02, 2011 3:46 am

The issue is that it depends on an object from DataDynamics. (The ticket format is a "report object")

This oject is NOT free..

It is free to re-distibute if you have a developer's license and you make it part of a compiled project.

So.... You could strip out the report portion and build your own page layout and it would work just fine...

As being at least partialy a Software company you have better resources to re-create the "report" portion..

Also I use an Access file to log the data to... there is prob a better open source option... IE Dude database..

Hence 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..
 
crazy007
just joined
Posts: 10
Joined: Sat Feb 19, 2011 8:54 pm

Re: Voucher with Serial Numbers !

Wed Aug 03, 2011 2:58 pm

Is it still possible to get a copy of this program?

ashiwp@gmail.com
 
sleimanr
Member Candidate
Member Candidate
Posts: 176
Joined: Mon Oct 18, 2010 9:31 am

Re: Voucher with Serial Numbers !

Fri Aug 05, 2011 2:21 am

plz any body make this program to me i can pay as you want....
thxxxx

my email: slaimanroumie@Hotmail.com
 
User avatar
JP_Wireless
Member Candidate
Member Candidate
Posts: 276
Joined: Thu Dec 13, 2007 4:31 pm
Location: Lagos Nigeria
Contact:

Re: Voucher with Serial Numbers !

Fri Aug 05, 2011 12:54 pm

I doubt if anybody has actually gotton it!
Hence 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..
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 endlessly :lol:

But very suprised that mikrotik is not helping matter at all. No news on all the sensitive request or suggestion as to make MT/UM better. It is frustrating!!!
 
User avatar
communicaters
just joined
Posts: 18
Joined: Sat May 14, 2011 10:12 am
Location: Lahore, Pakistan
Contact:

Re: Voucher with Serial Numbers !

Sat Aug 06, 2011 8:21 am

Plz make a copy for me at askcom.pk@gmail.com
 
erick7007
just joined
Posts: 7
Joined: Wed Nov 18, 2009 5:38 pm
Location: South Africa

Re: Voucher with Serial Numbers !

Tue Aug 30, 2011 2:13 pm

Hi

We are in the end stretch of a standalone program for widows to do ticketing for hotspot which it will get eventually from the hotspot itself. Tickets will be available in POS printer to A4 size setup for hotels and lodges to resell internet. A4 voucher (ticket) will be customizable to have logos, background pictures, menu of establishment and also place for people to advertise on. Most B&B and lodges do leave advertisements at front desks for clients to take like pizza places and so on. We have a couple of small glidges to work our as we want it fully integrated to comunicate with a mikrotik board for import reasons and simplify the "order of tickets" when you want to print a batch. Importing csv files manually into system already works.

If you have ideas or stuff to add = all suggestions will be welcome as 2 heads are better than one..... :D
 
User avatar
aacable
Member
Member
Topic Author
Posts: 435
Joined: Wed Sep 17, 2008 11:58 am
Location: ISLAMIC Republic of PAKISTAN
Contact:

Re: Voucher with Serial Numbers !

Mon Sep 05, 2011 11:09 am

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.
mt-voucher (2).png
Template Code:
<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&nbsp; 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.
You do not have the required permissions to view the files attached to this post.
Last edited by aacable on Tue Sep 06, 2011 11:58 am, edited 5 times in total.
 
User avatar
bax
Member Candidate
Member Candidate
Posts: 268
Joined: Mon Dec 20, 2004 8:45 pm
Location: Croatia

Re: Voucher with Serial Numbers !

Mon Sep 05, 2011 4:46 pm

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.
Loking nice ... put it here for download ... this template here when is done .
 
User avatar
Bigfoot
Frequent Visitor
Frequent Visitor
Posts: 76
Joined: Sat Jan 15, 2011 10:41 am
Location: South Africa

Re: Voucher with Serial Numbers !

Sun Dec 04, 2011 2:37 pm

HI csickles

Can you please be so kind to send me a copy to stephan.booyzen@gmail.com

Thx
 
User avatar
JP_Wireless
Member Candidate
Member Candidate
Posts: 276
Joined: Thu Dec 13, 2007 4:31 pm
Location: Lagos Nigeria
Contact:

Re: Voucher with Serial Numbers !

Mon Dec 12, 2011 3:36 pm

csickles, is the code or script actually ready?
 
Lenz
just joined
Posts: 1
Joined: Mon Apr 02, 2012 11:11 pm

Re: Voucher with Serial Numbers !

Tue Apr 03, 2012 7:10 pm

Can someone send me the script?
lenz0904@online.de

Thank you
Lenz
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Fri Apr 13, 2012 11:59 pm

Sorry folks...

I have NOT been looking at this for quite SOME time..

I have recently HAD to upgrade the hotspot router (RB433) to Ver 5.x...

Thus forced me to the new user manager... (IT DOES NOT CREATE THE SAME CSV FORMAT BU DEFAULT)..

So....

I have updated the project to VB 2010.. with Active reports Ver 6.0 (Data Dynamics) (it creates the report layout)

And have figured out how to alter the CSV output template...

I just need to know the variable names... in particular the "Price" variable....


Once done.... I can post the results.....

Craig
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: Voucher with Serial Numbers !

Mon Apr 23, 2012 8:13 pm

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"....
 
User avatar
arjuneu
Member Candidate
Member Candidate
Posts: 173
Joined: Fri Oct 07, 2011 10:24 am

Re: Voucher with Serial Numbers !

Sat May 05, 2012 5:11 pm

This is mine.

<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>
 
User avatar
JP_Wireless
Member Candidate
Member Candidate
Posts: 276
Joined: Thu Dec 13, 2007 4:31 pm
Location: Lagos Nigeria
Contact:

Re: Voucher with Serial Numbers !

Sat May 05, 2012 6:11 pm

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"....
Where is the script in the first place! not receive by mail nor seen on the forum!
 
ericsimpson
just joined
Posts: 6
Joined: Mon Jun 18, 2012 9:10 pm

Re: Voucher with Serial Numbers !

Mon Jun 18, 2012 9:17 pm

Hi csickles

Can you please be so kind to send me a copy to eric @ keric.co.uk

Thanks
 
User avatar
rahulmkhj
Member Candidate
Member Candidate
Posts: 135
Joined: Wed Mar 09, 2011 10:54 am

Re: Voucher with Serial Numbers !

Wed Jul 04, 2012 8:33 pm

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.
mt-voucher (2).png
Template Code:
<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&nbsp; 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.

This feature is already built into Access Manager: accessmanager.in :)
 
eday
just joined
Posts: 1
Joined: Sun Jun 24, 2012 4:57 pm

Re: Voucher with Serial Numbers !

Mon Jul 16, 2012 4:01 am

Send Me Script Please Eday1607@yahoo.com
Thanks...
 
apnaazam
just joined
Posts: 2
Joined: Fri Dec 10, 2010 5:32 pm

Re: Voucher with Serial Numbers !

Wed Nov 07, 2012 12:58 pm

csickles please send me a copy :) olebole88@hotmail.com

Please send me a copy as well
apnaazam@yahoo.com
 
aleprolit
just joined
Posts: 18
Joined: Thu Apr 11, 2013 11:36 am

Re: Voucher with Serial Numbers !

Sat Aug 03, 2013 12:49 pm

Please send me a copy
aleprolit@gmail.com
 
senton1
just joined
Posts: 1
Joined: Mon Aug 05, 2013 11:19 am

Re: Voucher with Serial Numbers !

Mon Aug 05, 2013 11:41 am

csickles please sen me a copy on sentonpark1@yahoo.com !Thanks
 
Nanflexal
Member Candidate
Member Candidate
Posts: 120
Joined: Wed Sep 16, 2009 7:34 am

Re: Voucher with Serial Numbers !

Tue Aug 06, 2013 1:58 am

Please send me a copy. nanflexal@gmail.com

thank you very much.
 
jmllh513
just joined
Posts: 8
Joined: Fri Aug 09, 2013 6:49 pm

Re: Voucher with Serial Numbers !

Fri Aug 09, 2013 7:12 pm

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.) :shock: :o :o
 
abr120
just joined
Posts: 3
Joined: Sun Aug 11, 2013 8:50 pm

Re: Voucher with Serial Numbers !

Sun Aug 11, 2013 11:57 pm

csickles please send me a copy abrahemm_20007@hotmail.com
 
orgtopus
just joined
Posts: 5
Joined: Thu Dec 06, 2012 1:01 am

Re: Voucher with Serial Numbers !

Sun Oct 13, 2013 8:21 pm

Please send me a copy. orgtopus[@t]gmail.com

thank you very much.
 
alferrar
just joined
Posts: 13
Joined: Thu Mar 27, 2014 2:50 pm

Re: Voucher with Serial Numbers !

Wed Feb 18, 2015 8:22 pm

I use readyVoucher (http://www.ferrariehijos.com/readyVoucher) to generate and print vouchers to a ticket printer with serial numbers:
Sample2.jpg
You do not have the required permissions to view the files attached to this post.
 
Mohammed91k
just joined
Posts: 21
Joined: Sun Aug 17, 2014 3:42 am

Re: Voucher with Serial Numbers !

Sun Feb 22, 2015 10:25 pm

Need a copy please mkezzh91@gmail.com

Who is online

Users browsing this forum: No registered users and 19 guests