File Format
The import file is a standard Excel spreadsheet. The first row contains column headings. The order of the columns is not important, but the column names must exactly match the list below. If the spreadsheet contains the 'ixBug' (case number) column and that case exists, that case will be updated.
Two spreadsheets are included with the application download to provide examples for import and update functionality.
Columns
Not all columns are required. Omitted columns will default. Some columns will default if you misspell the entry (sFixFor, for example)
The data must start on the second row, and must contain only following columns:
- ixbug (number) For updates only, contains the case number. If this column is included and does not match a case number in FogBugz, a new case will be inserted.
- sProject (string) If this does not exactly match a valid project, it will default to the default project.
- sTitle (string)
- sFixFor (string) The Milestone
- sEvent (string) May contain Line Feeds
- sPersonAssignedTo (string)
- sArea (string)
- sVersion (string)
- sComputer (string)
- ixPriority (number)
- sTags (string)
- hrsCurrEst (FogBugz time format)
- sCategory (string)
- dtDue (date)
- ChildOfLastCase (string) *** this is a special column, see below
ChildOfLastCase column
'ChildOfLastCase' is a special column that may be included in the import spreadsheet in order to make a line the child of the previous line. In order to do this:
- Add a column to the spreadsheet and name the column 'ChildOfLastCase'
- For each 'child' row, put 'TRUE' in the childOfLastCase column.
- As the file imports, these lines will be marked as the child of the previous line