Rachel Berenbaum Reporter
	Description • 9 years ago

Hello!

Intern headcount request by Hiring Managers is now run through bugzilla, similar to the headcount request bugzilla form for Industry Recruiting. 

We need a custom report to live under the "reports" tab on Bugzilla to see what has been requested and the status of each intern request, similar to the report that was created for Industry Recruiting (see bug for that report request below): 

https://bugzilla.mozilla.org/show_bug.cgi?id=1134765 
I've also attached a screenshot.

The Intern Recruiting request form we need to have the report created from is here:
https://bugzilla.mozilla.org/form.intern

The fields we need to populate from the bug into the report are:
Status/Hiring Manager/VP/Product Line/Business Need/name
(Jill and Michelle- please add more if needed as comments on this bug).

If possible, we need the report completed by 8/28.

I've CC'd Jill Alvarez who will be the owner of the Report, and Michelle Marovich, head of Recruiting to provide feedback on iterations of the report.

Thanks for your help!
Rachel

	:glob ✱
	Comment 1 • 9 years ago

most of this looks reasonably straight forward.

> If possible, we need the report completed by 28th August.

in order to deliver that we'd have to have it ready early next week, which unfortunately is not possible due to other work we've already committed to.

the first week of september is more likely; does that time frame work for you?

	Rachel Berenbaum Reporter
	Comment 2 • 9 years ago

Deferring to Jill & Michelle- thanks!

	Michelle Marovich
	Comment 3 • 9 years ago

Hey Byron-- Can you put a date on that first week of September?  We are thinking of extending the application process by a week, so that *could* work.  Just need to know specifically what I'm agreeing to. 

Thanks!

	:glob ✱
	Comment 4 • 9 years ago

we're looking at dev work mid/late next week, and deployment on the 1st or the 2nd of september.

	Michelle Marovich
	Comment 5 • 9 years ago

OK, as long as it's not later than September 3rd, we can flex around that timeframe.  Thanks!

	Michelle Marovich
	Comment 6 • 9 years ago

hey Byron, 

I just wanted to check in and make sure that this is still on track?  Please let me know if you need anything from me?
-Michelle

	David Lawrence [:dkl] Assignee
	Comment 7 • 9 years ago

Hi. Sorry for lack of communication on this. I will try to have something up for your review by mid-day today.

dkl

	David Lawrence [:dkl] Assignee
	Comment 8 • 9 years ago

I have put the new report on our test instance for your feedback and testing.

To ssh://gitolite3@git.mozilla.org/webtools/bmo/bugzilla.git
   70e5dc0..189ef90  development -> development

Please go to https://bugzilla-dev.allizom.org/report.cgi and click on "Internship Dashboard" to see the report.

You may need to create some test Internship requests to see any useful data in the report. Also I found a bug in the Internship form which may cause some columns to be blank in the dashboard report for old requests.

https://bugzilla-dev.allizom.org/form.intern

dkl

	Michelle Marovich
	Comment 9 • 9 years ago

Hey David, 

I can't seem to get into the test instance.  I'm logged into Bugzilla and have been in it all day, but the test instance keeps denying my user name and password.  :(

	David Lawrence [:dkl] Assignee
	Comment 10 • 9 years ago

(In reply to Michelle Marovich from comment #9)
> Hey David, 
> 
> I can't seem to get into the test instance.  I'm logged into Bugzilla and
> have been in it all day, but the test instance keeps denying my user name
> and password.  :(

Sorry for the trouble. The test instance has the passwords stripped when it is imported from the production database so people have to have an admin reset it for them. I have emailed you a password that should allow you to get in.

dkl

	Michelle Marovich
	Comment 11 • 9 years ago

OK, I took a look at the test instance. and it looks great, except it seems like the bug you found in the form is keeping all the previous submissions from being populated.  

if that is the case, that is what we need to have on the report.  If we can't get the data from the last 3-4 weeks, then there is no point in you working on this further.

	David Lawrence [:dkl] Assignee
	Comment 12 • 9 years ago

(In reply to Michelle Marovich from comment #11)
> OK, I took a look at the test instance. and it looks great, except it seems
> like the bug you found in the form is keeping all the previous submissions
> from being populated.  
> 
> if that is the case, that is what we need to have on the report.  If we
> can't get the data from the last 3-4 weeks, then there is no point in you
> working on this further.

This is because there are only 2 test Intern Requests in our test database. When this form is live
there will be substantially more entries showing up in the list.

The bug that I fixed is that the currently the Product Line and Onsite Mentorship values were not properly displayed in the bug's first comment. So even though the old intern requests will display in the dashboard, the product line column may be empty except for new requests.

dkl

	Michelle Marovich
	Comment 13 • 9 years ago

ah!  do the values for the VP Authority display?  if so, we should be good for Product line.  

We can probably do the onsite mentorship by hand if we have to, though I'm a little sad panda about it.  Oh well, live and learn.

	Mark Côté [:mcote]
	Comment 14 • 9 years ago

Sorry about that Michelle; I'm not sure how that got through our testing.

	David Lawrence [:dkl] Assignee
	Comment 15 • 9 years ago

(In reply to Michelle Marovich from comment #13)
> ah!  do the values for the VP Authority display?  if so, we should be good
> for Product line.  
> 
> We can probably do the onsite mentorship by hand if we have to, though I'm a
> little sad panda about it.  Oh well, live and learn.

Yeah I do apologize as I pushed that form myself. We do our best to test the form in various scenarios and also to have the requester to look it over and take it through the entire process to make sure it looks good as well. 

So should we go ahead and get the new dashboard as well as the fixes pushed out asap?

dkl

	Mark Côté [:mcote]
	Comment 16 • 9 years ago

Given that the deadline for intern requests is today, looks like the damage has been done with respect to the missing data.  It sounds like Michelle is okay with the dashboard, so I would put that patch up for review and see if glob wants to r+ & deploy it tonight.  Otherwise it'll have to wait until next week.

	Michelle Marovich
	Comment 17 • 9 years ago

Oh please not next week.  I'll take what I can get.

	:glob ✱
	Comment 19 • 9 years ago

Comment on attachment 8656371 [details] [diff] [review]
1196508_1.patch

Review of attachment 8656371 [details] [diff] [review]:
-----------------------------------------------------------------

r=glob

	David Lawrence [:dkl] Assignee
	Comment 20 • 9 years ago

To ssh://gitolite3@git.mozilla.org/webtools/bmo/bugzilla.git
   3cc9c73..a6c5ec6  master -> master

	:glob ✱
	Comment 21 • 9 years ago

this is now live at https://bugzilla.mozilla.org/page.cgi?id=internship_dashboard.html

	Michelle Marovich
	Comment 22 • 9 years ago

Thanks everyone for the team effort here!

We ended up with 104 intern requests, and are now working through getting them reviewed and approved.  

Your help with this report was instrumental with that.