User Tools
support:weekly_reports
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| support:weekly_reports [2022/11/23 15:07] – 10.91.129.7 | support:weekly_reports [2023/11/07 14:40] (current) – [Step 1: Export Ticket Data] 10.91.120.100 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======How To Run The Weekly Report====== | ======How To Run The Weekly Report====== | ||
| - | [[https:// | + | [[https:// |
| + | |||
| + | |||
| ===== Step 1: Export Ticket Data ===== | ===== Step 1: Export Ticket Data ===== | ||
| Line 12: | Line 14: | ||
| __**Internal Tickets (Jira)**__ | __**Internal Tickets (Jira)**__ | ||
| - | Bookmark this Jira filter | + | Bookmark this Jira filter. Export it with the " |
| [[https:// | [[https:// | ||
| Line 19: | Line 21: | ||
| ===== Step 2: Update The Ticket Files ===== | ===== Step 2: Update The Ticket Files ===== | ||
| - | [[https:// | + | [[https:// |
| - | Select Yes to the prompt when the google sheet opens. This will clear the previous weeks tickets. | ||
| - | |||
| - | |||
| - | ===== Step 3: Run Report ===== | ||
| * Update the 2 Ticket google sheets located in the Ticket File folder with the data from their corresponding report. | * Update the 2 Ticket google sheets located in the Ticket File folder with the data from their corresponding report. | ||
| - | * Each Sheet will autorun a Macro that will clear the sheet of last week's data, select yes when prompted. | + | * Each Sheet will autorun a Macro that will clear the sheet of last week's data, you must select yes when prompted |
| - | * Paste in data from the report into cell A1 ensuring | + | * Paste in data from the report into cell A1. Before pasting make sure that all columns with hash symbols are adjusted so data is visible. |
| - | + | ||
| - | * Open the Weekly Report Google Sheet. ( Important to only open report at this point ) | + | |
| - | + | ||
| - | * The report will do some initial checks and you will then get options to run. | + | |
| - | + | ||
| - | * Wait for the report to finish. | + | |
| - | + | ||
| - | * The Report will send itself automatically. | + | |
| - | + | ||
| - | ===== Step 4: Update ExteNet Slides ===== | + | |
| - | + | ||
| - | + | ||
| - | On the ExteNet [[https:// | + | |
| - | + | ||
| - | Check the Awaiting Response slide, this will have the labels in the first column updated based on the contents of the latest update field. | + | |
| - | + | ||
| - | If the " | + | |
| - | + | ||
| - | * Add a number 1 to the Filter column for any ticket that is awaiting ExteNet to verify something. | + | |
| - | + | ||
| - | * Add a number 2 to the Filter column for any ticket that is awaiting information from ExteNet. | + | |
| - | * Select “Sort”. | + | The report is set on a schedule and will run itself between 1pm and 2pm, if I can't run for some reason an email will be sent to support@errigal.com |
| - | Go back to the slide and update. | ||
| - | Inform Anthony that the slides are updated. | ||
support/weekly_reports.1669216070.txt.gz · Last modified: 2022/11/23 15:07 by 10.91.129.7
Page Tools
