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.
AdamM
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.