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.
AdamM
shared this idea
-
Adam, thanks for the clarification! We'll keep all comments in mind when developing this feature.
-
AdamM
commented
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
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 -
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
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 -
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