Export XLSX /CSV “Staff Scheduling” (projects/project employees, etc.)
S
Simon Winkler
Can you integrate a “Download current list” function with https://my.projo.berlin/planning2/user_lists (deployment planning employees)? It should be able to download either an XLSX or CSV file. It would be great if she would take into account the expanded status of the list:
This is currently (unfortunately...) also influenced by the filters in the new deployment planning. This is sometimes an advantage, but sometimes because the filters always have a global effect, it is also very unpleasant because information is missing. The export should be able to “ignore” the filters.
We are currently using an app developed specifically for us, with which we can map our agile working environment, in which the data is very important. That's why I've asked several times, recently without further feedback (unfortunately), for an API that would make all these requests superfluous.
Unfortunately, our workflow here must be up to date (as the flap status is also not noticed):
- Call https://my.projo.berlin/planning2/user_lists
- Open everything for around 30 employees and around 70 projects (which of course occur twice)
- hope that the filters have not been reconfigured in between
- Mark everything, paste it into an empty Excel
- hope that our individually programmed importer doesn't choke up
- Only then can we continue working with the data. Unfortunately, this is quite a high cost.
Alternative request: It should be possible to open the list with all sub-items with one click (and close) or at least the status should be remembered.
S
Simon Winkler
Since I no longer expect prompt feedback or even implementation for such requests, as with the API, I wrote a Chrome plugin myself, which does the task for me (unfold everything in order, export as XLSX). This works for all of the above views and then goes through for us (30 employees, approx. 80 projects, a great many phases to be expanded) in around 80-90 seconds.