Time Accounting: Export file showing ticket name and time units total per organization

Feature requests
1

Infos:

  • Used Zammad version: 6.3.1.85b53b810.saas
  • Used Zammad installation type: Using Zammad.com SaaS
  • Operating system: OSX
  • Browser + version: Latest Firefox

At the end of each month, we invoice our customer (a company - in Zammad terms, an ‘Organization’) based on their support time. We support several ‘Organizations’.

What I’d expect from the Time Account export is the option to export a CSV per Organization, in which the file contains the ticket title and the time units.

I tried this with the search in the UI (e.g. time_unit:* AND updated_at:>now-31d AND organization.name:LucasTestOrg ), but I can’t customize what it shows (e.g. missing time unit) and I can’t export it there.

I’m currently fighting the API, but I hope there is an easier way than to write my own script for something I think many would need when it comes to time tracking?

2

Every use case is different. I believe with very small excel effort you can use existing csv files to achieve what you want by using the ticket export file, no?

image
image2155×1008 116 KB

3

Thanks, the by_ticket export has the information, but I think I’ll stick to curl + bash before I dig into VBA :smiley:

I got the curl command to work now, maybe it’s of use for someone else too:

Get all tickets that have a time_unit AND belong to a specific Organization AND have been updated within a specific date range:
curl -H “Authorization: Token token=XXXX” “https://support.YourDomain.com/api/v1/tickets/search?query={time_unit:*+AND+organization.name:LucasTestOrg+AND+updated_at:\[2024-07-01+TO+2024-07-31\]}” | jq