Please note:The SCons wiki is in read-only mode due to ongoing spam/DoS issues. Also, new account creation is currently disabled. We are looking into alternative wiki hosts.

Create New Spreadsheet Content

Follow the instructions either under update an existing spreadsheet in place or prepare a new spreadsheet to accomplish the indicated goal.

Update an Existing Spreadsheet in Place

Create a CSV File for Uploading

  • You'll need to have run a query at Issuezilla to get the issues you want to include in the spreadsheet. The BugParty page probably contains the query you want; if not, a wide range of queries can be constructed using the BugScheduleMacro or the (undocumented) TempBugHack macro (put the macro instantiation in a page to run it; it can be in a preview page if you don't plan to keep it). If those don't cover it, you can construct a query at Issuezilla the hard way.

  • On the Issuezilla "Issue list" page that's the result of the query, select the "Format as XML" button.
  • On the "Format as XML" page, tick the "Download as file" radio button, change the filename if you wish, and select the "Generate XML" button to download the file to your computer.
  • On your computer, run bin/xmlagenda.py from the SCons distribution. It has one optional parameter, the filename to be converted; the default is issues.xml if no parameter is present. This will create editlist.csv in the current directory.

  • If you want to keep the CSV file, rename it or it will be overwritten the next time you do this. It needs to end in .csv but otherwise there are no naming restrictions.

Upload the New Content

Tweak the Spreadsheet

  • Click on the column header for the last (empty) column (usually column H).
  • From the "Delete" menu, select "Delete column".
  • Click and sweep out all the remaining column headers (usually A to G).
  • From the "Format" menu, choose "Plain text".
  • From the "Align" menu, choose "top".
  • Click on the column header for the "Pri" column (usually column E).
  • From the "Align" menu, choose "center" (not "middle").
  • Click and sweep out the first two column headers.
  • From the "Align" menu, choose "right".
  • Select the row header for the first row.
  • Select "Bold" from the menu bar.
  • Grab the header marker (just above the "1" for the first row; do NOT grab the bar anywhere else or you will be uploading this spreadsheet again) and move it between the "1" and "2".

  • Click on any cell (i.e., anywhere so that neither a complete row or column is selected)

  • The lines between the column headers are selectable; with care you can grab them and change the width of the columns. ID, Votes, and Pri should be as tight as you dare make them; leave a reasonable space for the others and make the last column as wide as you have space.

Prepare a New Spreadsheet

Create a CSV File for Uploading

  • You'll need to have run a query at Issuezilla to get the issues you want to include in the spreadsheet. The BugParty page probably contains the query you want; if not, a wide range of queries can be constructed using the BugScheduleMacro or the (undocumented) TempBugHack macro (put the macro instantiation in a page to run it; it can be in a preview page if you don't plan to keep it). If those don't cover it, you can construct a query at Issuezilla the hard way.

  • On the Issuezilla "Issue list" page that's the result of the query, select the "Format as XML" button.
  • On the "Format as XML" page, tick the "Download as file" radio button, change the filename if you wish, and select the "Generate XML" button to download the file to your computer.
  • On your computer, run bin/xmlagenda.py from the SCons distribution. It has one optional parameter, the filename to be converted; the default is issues.xml if no parameter is present. This will create editlist.csv in the current directory.

  • If you want to keep the CSV file, rename it or it will be overwritten the next time you do this. It needs to end in .csv but otherwise there are no naming restrictions.

Upload the New Content

Tweak the Spreadsheet

  • Click on the column header for the last (empty) column (usually column H).
  • From the "Delete" menu, select "Delete column".
  • Click and sweep out all the remaining column headers (usually A to G).
  • From the "Format" menu, choose "Plain text".
  • From the "Align" menu, choose "top".
  • Click on the column header for the "Pri" column (usually column E).
  • From the "Align" menu, choose "center" (not "middle").
  • Click and sweep out the first two column headers.
  • From the "Align" menu, choose "right".
  • Select the row header for the first row.
  • Select "Bold" from the menu bar.
  • Grab the header marker (just above the "1" for the first row; do NOT grab the bar anywhere else or you will be uploading this spreadsheet again) and move it between the "1" and "2".

  • Click on any cell (i.e., anywhere so that neither a complete row or column is selected)

  • The lines between the column headers are selectable; with care you can grab them and change the width of the columns. ID, Votes, and Pri should be as tight as you dare make them; leave a reasonable space for the others and make the last column as wide as you have space.

CreateSpreadsheet (last edited 2008-06-16 16:47:51 by ip68-7-77-81)