Details

    • Type: New Feature New Feature
    • Status: Patch Pending Patch Pending
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Actions
    • Labels:
      None

      Description

      Stories can be imported from an Excel spreadsheet, but tasks can't.
      1. taskImport.patch
        71 kB
        Cliff R.
      2. taskImport with unitTests.patch
        77 kB
        Cliff R.

        Activity

        Hide
        Cliff R. added a comment -
        I'm working on implementing this for my team. If one of the committers opens this issue, I'll assign it to myself and check it in when I'm done
        Show
        Cliff R. added a comment - I'm working on implementing this for my team. If one of the committers opens this issue, I'll assign it to myself and check it in when I'm done
        Hide
        Jacques Morel added a comment -
        This is great! How are you handling the distinction between stories and tasks?
        Make sure you maintain backward compatibility with a story only import.
        As you are doing this, could you take a look at doing XPR-374 at the same time?

        What version are you basing your implementation on? 0.7b7 branch or TRUNK?

        Thanks again!
        Show
        Jacques Morel added a comment - This is great! How are you handling the distinction between stories and tasks? Make sure you maintain backward compatibility with a story only import. As you are doing this, could you take a look at doing XPR-374 at the same time? What version are you basing your implementation on? 0.7b7 branch or TRUNK? Thanks again!
        Hide
        Cliff R. added a comment -
        Just as there is an "Import" button on the view/iteration page, I'm going to add one to the view/userstory page. That way, they don't conflict.

        I'm working from the TRUNK.

        I'll take a look at including the XPR-374, but my hands are slightly tied by what is of value for my team (since I'm doing this at work and I don't have time to work on it outside). I think if I can get our manager to use import for both stories and tasks that he will find that of value.
        Show
        Cliff R. added a comment - Just as there is an "Import" button on the view/iteration page, I'm going to add one to the view/userstory page. That way, they don't conflict. I'm working from the TRUNK. I'll take a look at including the XPR-374 , but my hands are slightly tied by what is of value for my team (since I'm doing this at work and I don't have time to work on it outside). I think if I can get our manager to use import for both stories and tasks that he will find that of value.
        Hide
        Cliff R. added a comment -
        How do I assign this to myself? Or am I unable to?
        Show
        Cliff R. added a comment - How do I assign this to myself? Or am I unable to?
        Hide
        Cliff R. added a comment -
        Here's my patch for it. Sorry there aren't any test cases, but my schedule for completing this is a bit tight.

        I had to refactor the Story import code a bit so that I could reuse the existing work done for my addition. I also changed the worksheet for the story's excel template (as it seemed to be a pitfall for users).

        I'll be working on some more features in the next couple of weeks...
        Show
        Cliff R. added a comment - Here's my patch for it. Sorry there aren't any test cases, but my schedule for completing this is a bit tight. I had to refactor the Story import code a bit so that I could reuse the existing work done for my addition. I also changed the worksheet for the story's excel template (as it seemed to be a pitfall for users). I'll be working on some more features in the next couple of weeks...
        Hide
        Cliff R. added a comment -
        I'm working on adding the tests for this. I have some unit tests that test the happy path and a couple of the negative paths.

        Were there any acceptance tests for the Story Import? I don't see anything like that...
        Show
        Cliff R. added a comment - I'm working on adding the tests for this. I have some unit tests that test the happy path and a couple of the negative paths. Were there any acceptance tests for the Story Import? I don't see anything like that...
        Hide
        Cliff R. added a comment -
        I've added a few unit tests that test the parsing of the Excel file.

        I tried to get a happy-path acceptance test, but between most of them being broken (and therefore not really having a working example) and the 30-minute test duration, it was a bit much for me to do. Sorry. My unit tests cover almost as much as what the acceptance test would have covered (they start just below the UI layer).
        Show
        Cliff R. added a comment - I've added a few unit tests that test the parsing of the Excel file. I tried to get a happy-path acceptance test, but between most of them being broken (and therefore not really having a working example) and the 30-minute test duration, it was a bit much for me to do. Sorry. My unit tests cover almost as much as what the acceptance test would have covered (they start just below the UI layer).
        Hide
        Olivier Vierlinck added a comment -
        This would be a great feature. Any idea about when it would be released (even beta) ?
        Show
        Olivier Vierlinck added a comment - This would be a great feature. Any idea about when it would be released (even beta) ?
        Hide
        Olivier Vierlinck added a comment -
        A very nice variation would be to import all together Stories + Activities, from one single Excel sheet (one need to find a compatible format, as described by Jacques above)
        Show
        Olivier Vierlinck added a comment - A very nice variation would be to import all together Stories + Activities, from one single Excel sheet (one need to find a compatible format, as described by Jacques above)

          People

          • Assignee:
            Unassigned
            Reporter:
            Cliff R.
          • Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: