Closed Bug 1355246 Opened 9 years ago Closed 7 years ago

Advise on csv export for Legal Custom Bug Drop Down Menu

Categories

(bugzilla.mozilla.org :: Custom Bug Entry Forms, enhancement)

Product:
bugzilla.mozilla.org
Component:
Custom Bug Entry Forms
Version:
Production
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED INCOMPLETE

People

(Reporter: udevi, Unassigned)

Details

The legal bug has a dropdown list called "Business Unit". We use the Business Unit dropdown to provide metrics for the legal team in our executive updates. One challenge is that Business Unit doesn't show-up in reports that I run on Bugzilla, and if I export the data as a csv, the Business Unit column doesn't appear. So I'm spending time manually adding this information to excel to provide monthly and quarterly metrics. Any advice?
Can we provide this using logs on post data?
Flags: needinfo?(dylan)
Mika, thanks for your patience, there are a few forms which refer to Business Unit, which form are you asking about?
Flags: needinfo?(udevi)
(In reply to Emma Humphries ☕️ (she/her) [:emceeaich] (UTC-8) +needinfo me from comment #1) > Can we provide this using logs on post data? Going forward, we could save the data in a custom field. We could back-fill the data by parsing the comment 0's of the filed bugs. One thing that could be done is to copy this to the whiteboard status field, which could then be exported in the .csv as per normal. Even back-filling this would not take very much effort (it's on the order of adding a line of code). Depending on how much processing is already going on the reports, another simple solution could be a script that, given a list of bug ids, spits out the business unit info from the comments.
Flags: needinfo?(dylan)
Hi Emma, I'm asking about the main Mozilla Legal form, which looks like this: https://www.screencast.com/t/Im3Nh9lApV
Flags: needinfo?(udevi) → needinfo?(ehumphries)
I think copying the business unit into the whiteboard would be fine if Legal usually doesn't use whiteboard.
Do you have final advice on how I can do the BU export? I just had to manually crunch through my April metrics. Would be great to have automated process for May.
Flags: needinfo?(ehumphries)
Can we edit the current form to add the BU field to the whiteboard so that Mika could do an export of bugs and capture that?
Flags: needinfo?(ehumphries) → needinfo?(dylan)
Yes
Flags: needinfo?(dylan)
Not sure how to proceed on this.
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.