Changes between Version 1 and Version 2 of SopPrintScrum

Timestamp:

2013-05-23T08:36:43+02:00 (12 years ago)

Author:

Morris Swertz

Comment:

--

SopPrintScrum

@@ -1 +1 @@
 = How to print the scrum cards =
 
-1. You need the word template (attachment)
+1. Download the word template ([http://www.molgenis.org/attachment/wiki/SopPrintScrum/BacklogSjabloon2.doc attachment])\
+
+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]
+
+3. Add to your query the column 'description' which can not be done via user interface but only by add '&col=description' to end of url, e.g,
+
+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
+
+4. Download as 'tab delimited text' file (link on bottom of query page).
+
+5. Right-click on downloaded file, open using Excel and save as *.xls
+
+6. Open TicketSjabloon.doc word template
+
+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]
+
+8. print the result **4 pages per A4**
+
+[