I suggest Structure should ...

Allow CSV Output of Information from Structure Board

It would be nice to have the ability to dump the structure board to a csv. Thinking that it would be something quick and dirty, with ' - ' noting structure, like this:
"Name", "Est Hours", "Progress"
"Mars Colony", "10h", "80%"
" - Terraform", "6h", "50%"
" - - Make Oxygen", "2h", "100%"
" - Create Colony", "4h", "0"

Once this was CSV, it could be manipulated in other programs. Right now, I don't see a way to get the Hierarchy or estimate roll-up data out of the system for project managers to use.

3 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    AdamM shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    6 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • AdamM commented  ·   ·  Flag as inappropriate

        Good suggestions all around. My original thinking was just that once we had the data in CSV form, we could manipulate it from there. My idea with the dashes was exactly what you are talking about Igor, which is a way just a way to quickly see the hierarchy after it is exported. The intent is to make this something that our Project Managers could easily extract from the system to an Excel file. In their case, just having a screen shot, or the names of the tickets without the hierarchy is not useful, but relying on the xml export is too tech-heavy.

      • MarkusL commented  ·   ·  Flag as inappropriate

        Hello Igor,
        you are right! I was referencing to case b) only.

        For a) you might find some nice "is child of"- icons/graphics (or use "\-" :)...

        Regards,
        Markus

      • AdminIgor Sereda (Admin, ALM Works) commented  ·   ·  Flag as inappropriate

        Markus, thanks for your comment!

        I think there are two separate cases: a) export structure and print it (or otherwise use visually); b) export structure and process it with some script. In the latter case, the "depth" column is definitely better.

        We'll try to address both cases.

      • MarkusL commented  ·   ·  Flag as inappropriate

        Maybe this format is a bit more useful?!

        "Name", "Est Hours", "Progress"
        "0", "Mars Colony", "10h", "80%"
        "1", "Terraform", "6h", "50%"
        "2", "Make Oxygen", "2h", "100%"
        "1", "Create Colony", "4h", "0"

        First field would be the indentation level of the issue (or maybe starting at "1"). This would allow a bit easier script-post-processing as a dedicated field is used instead of "counting a char in string".

        Just my 2 cents.

        Regards,
        Markus

      • AdminIgor Sereda (Admin, ALM Works) commented  ·   ·  Flag as inappropriate

        Adam, thanks for an interesting idea. Right now there's structure backup that produces XML, but it is available to Administrator only and supposed to be, well, backup.

        Do you have a specific example, what would you do with this export? Would representing structure with "-" really work? If you're going to parse the exported text in other programs anyway, would a different format be better perhaps?

        Igor

      Feedback and Knowledge Base