| 3 | | *** This SOP does not work for Windows XP with Excel 2007 or Windows 7 with Excel 2010 *** |
| 4 | | |
| 5 | | 1. Download the word template ([http://www.molgenis.org/attachment/wiki/SopPrintScrum/BacklogSjabloon2.doc attachment]) |
| 6 | | |
| 7 | | 2. Create a query with tickets including colums: ticket, summary, importance, priority, component ([http://www.molgenis.org/query?status=assigned&status=new&status=reopened&milestone=Sprint+35+-+NGS+and+GWAS&milestone=Sprint+35+-+Compute&milestone=Sprint+35+-+Apps&milestone=Sprint+34+-+Compute&milestone=Sprint+34+-+Apps&milestone=Sprint+34+-+NGS+and+GWAS&group=milestone&col=id&col=summary&col=milestone&col=status&col=priority&col=component&col=importance&report=66&desc=1&order=importance example]) |
| 8 | | |
| 9 | | 3. Add to your query the column 'description' and 'priority' which can not be done via user interface but only by add '&col=description&col=priority' to end of url, e.g, |
| 10 | | |
| 11 | | http://www.molgenis.org/query?status=assigned&status=new&status=reopened&milestone=Sprint+35+-+Compute&milestone=Sprint+34+-+Compute&group=milestone&col=id&col=summary&col=milestone&col=status&col=priority&col=component&col=importance&report=66&desc=1&order=importance&col=description&col=priority |
| 12 | | |
| 13 | | |
| 14 | | |
| 15 | | 4. Download as 'tab delimited text' file (link on bottom of query page). |
| 16 | | |
| 17 | | 5. Right-click on downloaded file, open using Excel and save as *.xls |
| 18 | | |
| 19 | | 6. Open [http://www.molgenis.org/attachment/wiki/SopPrintScrum/BacklogSjabloon2.doc BacklogSjabloon2.doc] word template |
| 20 | | |
| 21 | | 7. Start the 'mail merge' wizard and choose your *.xls file as source ([http://office.microsoft.com/en-gb/excel-help/print-labels-by-using-excel-data-in-a-word-mail-merge-HP005203760.aspx howto]) |
| 22 | | |
| 23 | | 8. print the result **4 pages per A4** |
| | 3 | Go to Trac, Tickets, and select report number 6: Stories per milestone. |
| | 4 | At the bottom of the page, select *print scrum cards* |
