Rally Software

  • 1.  Only UserStories Are Getting Exported In Excel

    Posted Oct 11, 2018 03:22 AM

    Hi CA (Rally) Team,

     

    Is there any way to export all Data including UserStories and Tasks under it .(to external Excel Sheet)???

     

    I am at "Iteration Status" tab ,

    1. I expanded all UserStories so that Task's CheckBox get enabled .

    2. I checked all check boxes.

    3. Exported It.

    Result :  Only UserStory rows are getting enabled , which is disappointing.

    I Want Both UserStories And Tasks Under It.

     

    Request To Rally Team :  There should be one way from which we can export the  data to external Excel which contains UserStory And Its Tasks And Also Its Feature Number ..

     

     

    Waiting Response From Experts 

    Thanks 

    Abbas



  • 2.  Re: Only UserStories Are Getting Exported In Excel

    Broadcom Employee
    Posted Oct 11, 2018 09:43 AM

    Hello Zaheer,

     

    Thank you for posting your question.  The following link will help explain what fields are exported for each artifact type when using Excel.

     

    https://docs.ca.com/en-us/ca-agile-central/saas/importing-and-exporting-data 

     

    For user stories the following values will be imported or exported.

     

    Data Import Specifications

    Different work items offer different levels of data import. Use the following table to guide you when importing work items.

    Note: If you are attempting to import test cases that contain multiple test steps, we recommend that you use the CA Agile Central Add-in for Excel.
    ImportImported FieldsField-Level Specifications
    User stories
    NameLimited to 256 characters
    DescriptionLimited to 32K (imported through a CSV file)
    Package 
    Risk 
    Backlog State 
    Backlog Rank 
    OwnerDesired owner's username
    Notes 

    We do have a beta version of excel that will accomplish what you are wanting to do

     

    I have included the link below on how to part of the beta.

     

     

    New Excel Plugin - Open Beta 

     

    Please let us know if you have any questions.

     

    Thank you,

     

    Christian 



  • 3.  Re: Only UserStories Are Getting Exported In Excel

    Posted Oct 13, 2018 06:55 AM

    Thank You Very Much  



  • 4.  Re: Only UserStories Are Getting Exported In Excel

    Broadcom Employee
    Posted Oct 11, 2018 11:12 AM

    Zaheer, just to add on to this topic, you can also use the app, Custom List With Deep Export.  It is a Community App that allows you to export User Stories and Tasks in one export file.  It also allows you to export from the Portfolio Item level down to tasks.  Here is a KB with screenshots and Instructions on how to add and use the app.

     

    Agile Central: Export Portfolio Items, User Storie - CA Knowledge 



  • 5.  Re: Only UserStories Are Getting Exported In Excel

    Posted Oct 13, 2018 06:55 AM

    Thanks Edwin