2014-10-07 - Re: [GRASE-Hotspot] How to Import CSV file in to Microsoft Word, and edit labels your self…

Header Data

From: Dražen Žuvela <dr***a@radez.hr>
Message Hash: 3d447d7aa02dd3d24a3c663f22ccce8014e2e1082c761b6fb9e2b887039ebb97
Message ID: <543395F1.9070808@radez.hr>
Reply To: <543391C8.8020400@radez.hr>
UTC Datetime: 2014-10-07 00:27:45 UTC
Raw Date: Tue, 07 Oct 2014 09:27:45 +0200

Raw message 

Ah stupid me. I forgot the main and possible best way.

It is necessary to make label template in Word or Libre/Openoffice and 
instead CSV connect to MySql database directly.
It is necessary to add new database source (Windows) for MySql database. 
Use that connection when creating label template in Word. Similar is for 
Libre Office.

Whenever you add new users to Grase, open that template and check 
"from-to" records you wish labels print out.

For proof access, it would be OK to add new user to MySql database which 
will have read access only.

I may try this one day and  explain whole procedure here.


Dana 7.10.2014. 9:10, Dra\u017een \u017duvela je napisao:
> Since Grase itself doesn't have much possibilities at this area, we 
> need to use other ways to do this.
> Label template as suggested by @bartosz with some variants are most 
> handy so far.
> However, this method is not always effective.
> It depends of how fast and how frequent you need to release new tickets.
>
> 1. School case.
> If  you need to generate mass vouchers for school kids you can use 
> this "label/csv way", actually it is best way for that. Here we assume 
> that vouchers will have duration during the whole school year, and it  
> would be nice if we have control of Internet use by kid name. So it is 
> necessary to enter each unique name for each pupil divided in class 
> (as group) . Quite a lot of work but there is a time enough to prepare 
> all that in advance.
> Some mass import/export of users would help here a lot. Especially 
> when new school year starts we need to move all pupils to higher 
> class,  so group need to be changed. Some LDAP integration here would 
> help if exist.
>
> 2. Company guests case
> When you wish to give access for partners which are visiting your 
> company for a day then you need quickly to print out couple of 
> vouchers, with partner name on it, and you wish that to looks good.  
> Here you don't have much time if you need to open new user first.
> I suggest here to have pre-finished sheet (.doc, .odt) with labels  
> designed but with empty fields. Then copy/paste username and password 
> from grase page to this label fields and print whole page out. Cut 
> them and give to your guests. Down side, you are wasting whole page 
> for one or just couple of users.
> I found convenient to have preprinted some spare nice looking labels 
> with single user/password and multiple connections allowed. This is 
> for case when Grase admin is not at site when guest arrived.
>
> 3. Coffee bar case
> Here you have many new users each day and they need voucher as fast as 
> they will get their drink. I don't see other way then prepare in 
> advance a huge number of users/tickets, with very limited 
> time/traffic, but extended end date in the future.  This give us 
> ability   to prepare number of tickets 3 or more months in advance.
> Then use csv export and import into label's template document as 
> @bartosz suggested.
>
> 2.A There is one more way similar to case 2 above. Labels are 
> preprinted but fields left empty. Upon opening new user in Grase, fill 
> up empty fields at pre-printed labels by hand.  If anybody here still 
> know how to use a pen :)
>
> Of course, graphical design of labels, company logo and other fancy 
> decoration assumed. But this is artwork outside the Grase totally.
>
>
>
> Dana 7.10.2014. 2:17, bartosz je napisao:
>> Hi guys, Ive been looking for the ways how to improve lables/tickets 
>> for wifi, so this is what ive found and it looks quite good, you can 
>> mod your tickets as you like...
>>
>> https://www.youtube.com/watch?v=K5RjTt74JMQ
>>
>> have you got any other ways to do it ?
>> -- 
>> This mailing list is for the Grase Hotspot Project 
>> http://grasehotspot.org
>> ---
>> You received this message because you are subscribed to the Google 
>> Groups "Grase Hotspot" group.
>> To unsubscribe from this group and stop receiving emails from it, 
>> send an email to gr***e@grasehotspot.org 
>> <mailto:gr***e@grasehotspot.org>.
>> To post to this group, send email to gr***t@grasehotspot.org 
>> <mailto:gr***t@grasehotspot.org>.
>> Visit this group at 
>> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>> To view this discussion on the web visit 
>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/3b21287f-1644-4c0c-826e-392051674712%40grasehotspot.org 
>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/3b21287f-1644-4c0c-826e-392051674712%40grasehotspot.org?utm_medium=email&utm_source=footer>.
>
> -- 
> This mailing list is for the Grase Hotspot Project http://grasehotspot.org
> ---
> You received this message because you are subscribed to the Google 
> Groups "Grase Hotspot" group.
> To unsubscribe from this group and stop receiving emails from it, send 
> an email to gr***e@grasehotspot.org 
> <mailto:gr***e@grasehotspot.org>.
> To post to this group, send email to gr***t@grasehotspot.org 
> <mailto:gr***t@grasehotspot.org>.
> Visit this group at 
> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
> To view this discussion on the web visit 
> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/543391C8.8020400%40radez.hr 
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/543391C8.8020400%40radez.hr?utm_medium=email&utm_source=footer>.

Thread