This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 227359 - Create NetCAT sign up form automatically populating NetCAT team
Summary: Create NetCAT sign up form automatically populating NetCAT team
Status: VERIFIED FIXED
Alias: None
Product: qa
Classification: Unclassified
Component: Dashboard (show other bugs)
Version: 7.3
Hardware: PC Linux
: P3 normal (vote)
Assignee: Vladimir Riha
URL:
Keywords:
Depends on: 227481
Blocks: 227413
  Show dependency tree
 
Reported: 2013-03-12 13:26 UTC by Jiri Kovalsky
Modified: 2013-03-20 13:54 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jiri Kovalsky 2013-03-12 13:26:29 UTC
For the next NetCAT program (7.4/8.0) it would be great to have a sign up form which would automatically:

* assure that NetCAT applicant has a valid netbeans.org account
* subscribe applicant's e-mail address to the NetCAT mailing list
* add the person to the new NetCAT team in the dashboard
* create an HTML page with all registered participants ideally with bug/rfe/emails statistics

Such a form should require:

- name
- surname
- username (or disable the form for not logged in applicants)
- country
- tribe (2 lists of areas plus "no specific focus" option)
- CPU counts
- RAM size
- operating system (primary and secondary)
- t-shirt size (S/M/L/XL/XXL/XXXL)
- sex (male/female)
- availability (minimum hours per week)
Comment 1 Vladimir Riha 2013-03-12 13:41:08 UTC
(In reply to comment #0)
> * assure that NetCAT applicant has a valid netbeans.org account

What to check exactly? I might be able to check only if username exists. If this is enough, no problem :)

> * subscribe applicant's e-mail address to the NetCAT mailing list

This is tricky :) Is there some API or do I need to add record to some database? The point is we would probably need to request this access for dashboard. But I'm not sure about that.

> * add the person to the new NetCAT team in the dashboard

Sure, easy to do

> * create an HTML page with all registered participants ideally with
> bug/rfe/emails statistics

So table header would be like this?

#| Name | Reported bugs | Reported RFE | Emails stats

And add option to limit data by given date range (so you can review last month only for instance). But again, there are the emails, which I don't know where to get :)


As for the form:
No problem, but I'd prefer to make it read-only for everyone (+ option to sign up of course) and move its possible update to dashboard administration.
Comment 2 Jiri Kovalsky 2013-03-12 13:56:52 UTC
> > * assure that NetCAT applicant has a valid netbeans.org account
> 
> What to check exactly? I might be able to check only if username exists. If
> this is enough, no problem :)

Yes, that would be enough or as I said hide the form for not logged in users.

> > * subscribe applicant's e-mail address to the NetCAT mailing list
> 
> This is tricky :) Is there some API or do I need to add record to some
> database? The point is we would probably need to request this access for
> dashboard. But I'm not sure about that.

It would be enough if you could send an e-mail FROM applicant's e-mail address to sympa@netbeans.org with subject "subscribe netcat".

> > * create an HTML page with all registered participants ideally with
> > bug/rfe/emails statistics
> 
> So table header would be like this?
> 
> #| Name | Reported bugs | Reported RFE | Emails stats

The table would be like this:

> #| Name | Reported useful bugs | Reported other bugs | Reported RFEs | Sent e-mails

where "useful" means bugs with New or Reopened status or Fixed resolution. Other means other bugs (invalid, worksforme, duplicate...).

> And add option to limit data by given date range (so you can review last month
> only for instance). But again, there are the emails, which I don't know where
> to get :)

Yes, the statistic would display data from given date (NetCAT start) to "now" or given date.
Comment 3 Vladimir Riha 2013-03-12 14:02:41 UTC
OK, I'll do what I can :) I already played with sending mails from dashboard but one solution I know using mail() function fails because sendmail is not installed on the server. I'll try to come up with different way.

Testing if user is logged in is a good idea, at least I can test implementation of the SSO I've made :)
Comment 4 Vladimir Riha 2013-03-12 20:35:48 UTC
Thinking about it, I can let user to re-send the form again and update his/her data by this. Of course the same will be possible in administration.
Comment 5 Jiri Kovalsky 2013-03-13 08:53:12 UTC
Sure. Thanks for the good idea.
Comment 6 Vladimir Riha 2013-03-13 13:01:31 UTC
OK, so what's done for now:

- new "home" page for NetCAT in dashboard 
quality2.netbeans.org/dashboard/web/netcat.php

- signup form (with the re-submit to change) - Not tested yet :) Because I'm really not sure about working mail capabilities, there is a Subscribe button once the form is submitted with standard "mailto:". Another thing is that because we don't have access to user's email address, the auto subscribe would allow anybode to subscribe any email address and that's not a good idea.


- list of participants
quality2.netbeans.org/dashboard/web/participants.php


These changes will be propagated within 20 minutes. I'll try it then.

Please notice that reason why NetCAT participants is empty is that user has to be in 2 DB tables to be listed there:
 - in users in dashboard (in any team, signup action will move him to NetCAT)
 - in new DB table with data from the signup form => this is empty for now as no one has signed yet.
Comment 7 Jiri Kovalsky 2013-03-13 17:40:33 UTC
Thanks Lada! Can you please change the "Availability" from text field to pulldown with values "1, 2, 3, ... 10+"? Also please remove the "Free Riders" option from both Tribe pulldowns. "No specific focus" choice will transform into membership in that tribe. Also, do you check against two same selections?
Comment 8 Vladimir Riha 2013-03-13 17:58:24 UTC
(In reply to comment #7)
> Thanks Lada! Can you please change the "Availability" from text field to
> pulldown with values "1, 2, 3, ... 10+"? 

Sure, no problem

> Also please remove the "Free Riders"
> option from both Tribe pulldowns. "No specific focus" choice will transform
> into membership in that tribe.

They are already gone, maybe browser cache issue. I added tribes to dashboard administration so it is up to you which tribes will be displayed. As for the membership, dashboard doesn't know anything like this. These tribes are used only  for the sign up form and list of participants

> Also, do you check against two same selections?

Not yet :-)
Comment 9 Vladimir Riha 2013-03-14 13:17:54 UTC
(In reply to comment #0)
> * create an HTML page with all registered participants ideally with
> bug/rfe/emails statistics

Done (except for the emails), as mentioned above, there is a page with participants and now page with statistics (and custom time range at the bottom)

http://quality2.netbeans.org/dashboard/web/netcat_stats.php

Please note that both pages have standard dashboard caching (100 minutes) and to refresh page without cache, use Reload from menu (or just add noCache parameter to URL

http://quality2.netbeans.org/dashboard/web/netcat_stats.php?noCache


Above requests for sign-up form have been implemented as well. 


Just a minor comment. All these NetCAT statistics are composed from people in NetCAT team. In other words, it doesn't matter if user used the sign-up form or not. I'd prefer to keep it that way because all other teams are using it as well. If user uses sign-up form (or if you add him to PARTICIPANTS in administration), it is moved (if in other team) or created as a new member of NetCAT. So sign-up form is synced with NetCAT team, but not vice versa.
Comment 10 Vladimir Riha 2013-03-20 08:28:38 UTC
Seems to be working. The parser is in nb-quality repository. Without any arguments, it parses all mails in current month and sends data to dashboard. I created hudson job for it, so once a day emails will be updated. If you need older data, check job's description or just tell me :)

Please note that although [1] shows members of NetCAT team, in order to see emails, they need to sign up using the form (to get their email address).

I tried and now dashboard has data for March 2013.



Jirko, could you please signup as NetCAT participant and check that

[1] http://quality2.netbeans.org/dashboard/web/netcat_stats.php?noCache

lists you and that there is 1 email from you? You can then switch yourself back to QE in administration. Thanks a lot
Comment 11 Jiri Kovalsky 2013-03-20 10:15:59 UTC
Thank you Lado! I subscribed to NetCAT successfully. However, I must reopen this RFE, due to the following reasons:

* the statistic only showed 1 sent e-mail in my row even though I changed date range from 2013-01-01 to 2013-03-31
* list of tribes has only 3 items and it does not list "No specific focus" option
* if somebody has 4 GB RAM, should s/he select 2-4 or 4-6? It would be better to have 0 - 1.9, 2 - 3.9, 4 - 5.9 etc.
* is http://quality2.netbeans.org/dashboard/web/netcat.php linked from somewhere?
Comment 12 Vladimir Riha 2013-03-20 10:26:24 UTC
(In reply to comment #11)
> Thank you Lado! I subscribed to NetCAT successfully. However, I must reopen
> this RFE, due to the following reasons:
> 
> * the statistic only showed 1 sent e-mail in my row even though I changed date
> range from 2013-01-01 to 2013-03-31

But that is correct, check [1], you have sent only 1 email in March and as I said, the parser parses by default only current month (see previous comment, I can parse older data as well if you want) and send it to dashboard. Dashboard stores ALL data (so it keeps track about previous month)

> * list of tribes has only 3 items and it does not list "No specific focus"
> option

Please go to dashboard administration, you need to set up list of tribes (link "Manage Tribes" on main admin page). Btw I guess I misunderstood comment #7 about Free riders and no specific focus, I thought it is the same. Nevertheless tribes have administration

> * if somebody has 4 GB RAM, should s/he select 2-4 or 4-6? It would be better
> to have 0 - 1.9, 2 - 3.9, 4 - 5.9 etc.

OK, I'll change it.

> * is http://quality2.netbeans.org/dashboard/web/netcat.php linked from
> somewhere?

Not yet, I've been thinking about it and I'll remove NetBeans cube logo from main menu and put NetCAT above "Hall of fame". Would do you think?


[1] http://netbeans.org/projects/www/lists/netcat/archive/2013-03/chrono/1
Comment 13 Jiri Kovalsky 2013-03-20 10:48:22 UTC
(In reply to comment #12)
> > range from 2013-01-01 to 2013-03-31
> 
> But that is correct, check [1], you have sent only 1 email in March and as I
> said, the parser parses by default only current month (see previous comment, I
> can parse older data as well if you want) and send it to dashboard. Dashboard
> stores ALL data (so it keeps track about previous month)

Yes, that would be exactly what I wanted. Thanks.

> > * list of tribes has only 3 items and it does not list "No specific focus"
> > option
> 
> Please go to dashboard administration, you need to set up list of tribes (link
> "Manage Tribes" on main admin page). Btw I guess I misunderstood comment #7
> about Free riders and no specific focus, I thought it is the same.
> Nevertheless tribes have administration

Excellent. Works like a charm.

> > * if somebody has 4 GB RAM, should s/he select 2-4 or 4-6? It would be better
> > to have 0 - 1.9, 2 - 3.9, 4 - 5.9 etc.
> 
> OK, I'll change it.

Great, thanks.

> > * is http://quality2.netbeans.org/dashboard/web/netcat.php linked from
> > somewhere?
> 
> Not yet, I've been thinking about it and I'll remove NetBeans cube logo from
> main menu and put NetCAT above "Hall of fame". Would do you think?

Please do so. Thanks a lot.
Comment 14 Vladimir Riha 2013-03-20 11:00:04 UTC
OK, menu and form changes will be visible in 30minutes (make sure to use ?noCache :) just to be sure)

I'll change the job configuration temporary to parse older data once. Locally when I was testing I got into a state where server started to refuse my requests so hopefully it will work for larger number of data (in worst case scenario, I'll decrease number of threads that make requests)

Thanks
Comment 15 Jiri Kovalsky 2013-03-20 13:32:58 UTC
Cool, verified. Thanks a lot Lado! BTW, Is it possible to change registered participants' data? In case somebody makes a mistake when specifying his/her e-mail, or wants to step out of some tribe etc.
Comment 16 Vladimir Riha 2013-03-20 13:50:56 UTC
You're welcome.

Yes, in this case simply user can again submit the sign up form and already existing data will be replaced with just submitted. About leaving tribe, if it is sufficient to join Free riders (or No specific focus) instead, again simply submit form one more time. 

Btw there were one last culprit with dashboard and bugzilla both using case sensitive usernames and for instance macksix was not correctly parsed because in BZ he has MackSix while in DB macksix. This is fixed (visible in 25min)
Comment 17 Jiri Kovalsky 2013-03-20 13:54:12 UTC
OK, resubmitting the form is usable workaround. Thanks again.