Upload Bugs Database

I have been able to convert our current Bugs Database into a Excel or .CSV file. How can I upload these bugs into VSTS without manually entering in the information.



Answer this question

Upload Bugs Database

  • goozbee

    Export the bugs that are currently contained within your TFS team project into a new excel spreadsheet. Cut and paste the text from your current Bugs Database spreadsheet into the new excel spreadsheet, you may need to massage the data a little in order to get user id's to match and you may also need to adjust what columns are shown in order to import something not shown by default.

  • spkeller

    Works good so far but how to import bugs including their history this way Thats my problem

  • haitham ibrahim

    History wouldn't be shown coverted this way.  The only way that you would be able to do that would be to either write a program to consume the base data and call the TFS Workitems webservices or the other option would be to print out the history and put it into a field as a sort of legacy history.

  • kidnapt

    As kayers states, you would need to write a converter if you wish to keep the history, etc. There is a work item tracking object model documented in the Visual Studio Extensibility SDK March CTP (http://vsipdev.com), so you don't need to call the web services directly (using the OM is much more convenient).

    Buck



  • Upload Bugs Database