Community discussions

MikroTik App
 
maxcare73
newbie
Topic Author
Posts: 33
Joined: Mon Jun 26, 2006 3:47 pm
Location: Sardegna Italy

print coupon user and password for client of hotspot

Tue Jul 14, 2009 12:41 am

helloi ..
you have to ask one thing ...
how can I print the list of users and passwords from usermanager to a printer and then give them to customers dell'hotspot?
thanks for the help that you have always given me with all your post ...
thanks
 
userman
Member Candidate
Member Candidate
Posts: 196
Joined: Tue Sep 05, 2006 2:53 pm

Re: print coupon user and password for client of hotspot

Tue Jul 14, 2009 9:11 am

Depends on what you mean by "dell'hotspot". If dell'hotspot supports radius, you just have to configure it to ask user data from User Manager. If it does not, you can always export user data from User Manager by generating CSV file. But in that case there is no point to use User Manager just for username and password generation and voucher printing.
 
maxcare73
newbie
Topic Author
Posts: 33
Joined: Mon Jun 26, 2006 3:47 pm
Location: Sardegna Italy

Re: print coupon user and password for client of hotspot

Tue Jul 21, 2009 4:10 pm

thank girts

dell'hotspot is the hotspot internet service that I use ,
can I print with a thermal printer the coupon user ?
thanks
exscuse for my english ...... :( :( :( :( :( :( :( :(
max
 
User avatar
normis
MikroTik Support
MikroTik Support
Posts: 26376
Joined: Fri May 28, 2004 11:04 am
Location: Riga, Latvia

Re: print coupon user and password for client of hotspot

Tue Jul 21, 2009 4:11 pm

you must use MikroTik RouterOS hotspot with User Manager. That is the topic of this forum. If you have questions about other service, you must ask them in their (dell?) forum
 
maxcare73
newbie
Topic Author
Posts: 33
Joined: Mon Jun 26, 2006 3:47 pm
Location: Sardegna Italy

Re: print coupon user and password for client of hotspot

Thu Jul 23, 2009 3:32 pm

thank normis...
but can i print coupon with usermanager on printer ?
"I need to print the coupons of the user and password for tourists who want to surf with wifi ...
thank
max

:) :) :? :? :? :? :? :? :?
 
User avatar
normis
MikroTik Support
MikroTik Support
Posts: 26376
Joined: Fri May 28, 2004 11:04 am
Location: Riga, Latvia

Re: print coupon user and password for client of hotspot

Thu Jul 23, 2009 3:34 pm

yes of course, you can do it.
 
maxcare73
newbie
Topic Author
Posts: 33
Joined: Mon Jun 26, 2006 3:47 pm
Location: Sardegna Italy

Re: print coupon user and password for client of hotspot

Fri Jul 31, 2009 1:32 pm

hello normis
thanks for the reply
I could give a hand for this problem?
there is some guidance that I can help you do this?
thanks ...
Mikrotik of you are very patient and prepared
max :) :) :) :) :) :)
 
royco
just joined
Posts: 5
Joined: Tue May 12, 2009 7:04 am

Re: print coupon user and password for client of hotspot

Tue Aug 04, 2009 10:05 am

maxcare,

we design our vouchers/prepaid cards in adobe Illustrator and use adobe Indesign's data merge to import the usernames/pass from csv. You can make your vouchers very pretty, so pretty that a lot of business are interested in advertising on one side.

hope that helps.
 
User avatar
normis
MikroTik Support
MikroTik Support
Posts: 26376
Joined: Fri May 28, 2004 11:04 am
Location: Riga, Latvia

Re: print coupon user and password for client of hotspot

Tue Aug 04, 2009 10:05 am

maxcare,

we design our vouchers/prepaid cards in adobe Illustrator and use adobe Indesign's data merge to import the usernames/pass from csv. You can make your vouchers very pretty, so pretty that a lot of business are interested in advertising on one side.

hope that helps.
+1 for a good approach. nice!
 
maxcare73
newbie
Topic Author
Posts: 33
Joined: Mon Jun 26, 2006 3:47 pm
Location: Sardegna Italy

Re: print coupon user and password for client of hotspot

Thu Aug 06, 2009 8:53 pm

hello Royco
the idea is good but I need to print the coupons ..thanks....
I'm not interested in the beauty ...
I must absolutely resolve even paying someone ...
help ... help :( :( :( :( :( :(
tell me where I can find the guide ...
please thanks :( :( :( :( :( :(
thanks
Max

:( :( :( :( :( :( :(
 
userman
Member Candidate
Member Candidate
Posts: 196
Joined: Tue Sep 05, 2006 2:53 pm

Re: print coupon user and password for client of hotspot

Fri Aug 07, 2009 1:20 pm

What is your question? How to generate vouchers or how to print them?

To generate vouchers, select users and then Generate > Vouchers 3pp (3pp means 3 vouchers per page, you can select 1pp or 2pp also).

To print vouchers, just choose "Print" from the browsers menu.

If you want to customize vouchers, read this: http://wiki.mikrotik.com/wiki/User_Mana ... r_template
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: print coupon user and password for client of hotspot

Fri Aug 07, 2009 6:58 pm

You mean something like this...

Prints out on a point of sale printer.....
HotSpot.png
Runs as a spudo service on a windows box... waits for User-Manager CSV files.
Writes the data to an access database, serializes the tickets, deturmans the correct point of sale printer
Then prints the "ticket".. Can print to ANY printer that the automation satem can "see"...
You do not have the required permissions to view the files attached to this post.
 
royco
just joined
Posts: 5
Joined: Tue May 12, 2009 7:04 am

Re: print coupon user and password for client of hotspot

Mon Aug 10, 2009 9:05 pm

hello Royco
the idea is good but I need to print the coupons ..thanks....
I'm not interested in the beauty ...
I must absolutely resolve even paying someone ...
help ... help :( :( :( :( :( :(
tell me where I can find the guide ...
please thanks :( :( :( :( :( :(
thanks
Max

:( :( :( :( :( :( :(
Maxcare,

We print out the vouchers. The size we use is the same as a typical business card(about 10 per page). We usually generate codes 200 at a time, imports the csv from Indesign with a pre designed area for the codes. indesign places the codes and creates 200 vouchers that we either print ourselves or take to a professional printer.
 
maxcare73
newbie
Topic Author
Posts: 33
Joined: Mon Jun 26, 2006 3:47 pm
Location: Sardegna Italy

Re: print coupon user and password for client of hotspot

Mon Aug 17, 2009 3:11 pm

thanks to all the various ideas that you gave me ...
I would like to print tichet like what he did csickles ...
How can I ?.......
user manager works to create accounts and passwords but still can not get to print the coupon as csickles .... :( :( :( :( :( :( :(
I read the guide usermanager voucher template .. I created a web page with data ...
I get cell

Biu Airforce1 Wireless Tech
Time:%% u_limit_uptime
Validity u_prep_time%%
Price:%% u_tot_price
Username:%% u_username
Password:%% u_password

:( :( :( :( :( :( :( :( :( :( :( :(

what do I do with this data?
I have to add something?
we do not understand anything ... :( :( :( :( :( :( :(
thanks ..help me.......
please give me a hand ..
thanks ..
 
csickles
Forum Guru
Forum Guru
Posts: 1255
Joined: Fri May 28, 2004 8:46 pm
Location: Phoenix, AZ
Contact:

Re: print coupon user and password for client of hotspot

Tue Aug 18, 2009 5:59 am

The ticket above comes from a piece of Visual basic code running on Windows..

The steps:

1) "Read" the CSV file created by UserManager.
2) Break down the line entries to a datatable.
3) cycle thru the datatable and write the values to an Access database file. (Time stamping the records)
4) The insertion of the records will create an "identity" value. (serial number)
5) Retrieve the set of inserted records from the access table (Using the timestamp as the "where value")
6) Use the portion of the User name, IE: "MA-" to lookup the target printer stored in the access database.
7) Build the "report" based on the data.
8) Print the "report" for each record in the recordset. (datatable)..

The VB code runs as a psudo service on windows...

Could be written in other languages as well..
 
Megateq
newbie
Posts: 38
Joined: Thu Jan 08, 2009 12:33 am
Location: Nigeria
Contact:

Re: print coupon user and password for client of hotspot

Sat Sep 12, 2009 5:05 pm

pls l need more help on how to do this
Last edited by Megateq on Sat Sep 12, 2009 5:29 pm, edited 1 time in total.
 
Megateq
newbie
Posts: 38
Joined: Thu Jan 08, 2009 12:33 am
Location: Nigeria
Contact:

Re: print coupon user and password for client of hotspot

Sat Sep 12, 2009 5:26 pm

maxcare,

we design our vouchers/prepaid cards in adobe Illustrator and use adobe Indesign's data merge to import the usernames/pass from csv. You can make your vouchers very pretty, so pretty that a lot of business are interested in advertising on one side.

hope that helps.
Please l will need your assistance on this area, if possible to get a format from you
 
User avatar
interpoint
Frequent Visitor
Frequent Visitor
Posts: 92
Joined: Wed Jun 06, 2007 3:42 pm
Location: Ireland
Contact:

Re: print coupon user and password for client of hotspot

Thu Sep 17, 2009 12:52 am

maxcare,

we design our vouchers/prepaid cards in adobe Illustrator and use adobe Indesign's data merge to import the usernames/pass from csv. You can make your vouchers very pretty, so pretty that a lot of business are interested in advertising on one side.

hope that helps.

Hi royco, I am interested in getting some design work done. We print loads of vouchers everyweek for apartments, hotels and student villages. What can you do for us ? Please email shane at interpoint dot ie if you get a moment and we can hook up and discuss outside the forum.

Who is online

Users browsing this forum: No registered users and 13 guests