Tempo Ideas

Welcome to Tempo’s Idea Portal! Your suggestions are valuable to us and help us make our products even better.
Below is a list of ideas for Tempo, so please search, review and vote for those that would help you the most. We encourage you to add an idea if you don’t see it listed. You can stay updated on the work we are doing here at Tempo by contributing to this page.
To learn more and see our Frequently Asked Questions, click here.

Change Tempo Servlet to support Excel .xlsx format.

The Servlet cannot download an Excel file with more than 65,000 rows because it only supports the legacy .xls format. Adding support of the .xlsx format would eliminate this limitation. Yes we could use the REST APIs to obtain the same information. But the servlet is very powerful with it being able to pull additional information from the user and the issue. Doing that with the REST APIs would require multiple calls and matching the data among those calls. And yes we could call the servlet with smaller date ranges. But appending multiple spreadsheets together to create a monthly report is very inconvenient. We currently have approximately 80,000 worklogs a month. I’m sure this enhancement would be very useful to other large shops.

  • Jeff Schumacher
  • Jun 26 2020
  • Shipped
Tempo Platform On-Premise
Tempo Products Tempo Timesheets
  • Attach files
  • Admin
    Hlynur Johnsen commented
    21 Sep 08:22pm

    Hi Jeff,

    It is .xlsx format, but since the format=excel parameter already produces .xls files we didn't want to break functionality for anyone depending on that file ending. The file is essentially in Office Open XML, which explains the new format parameter value. Open Office XML is the format that Microsoft uses for Excel 2007 and later.

  • Jeff Schumacher commented
    21 Sep 07:01pm

    I'm concerned when you say format=ooxml.
    Is it .xml or .xlsx format?

  • Admin
    Hlynur Johnsen commented
    21 Sep 06:34pm

    I'm pleased to inform you that with Tempo Timesheets 10.20 that is now available through the Atlassian marketplace, the Tempo Servlet Export plugin supports exporting Excel 2007 format by using the format=ooxml parameter.

    https://tempo-io.atlassian.net/wiki/spaces/SERVERNEWS/pages/1279164697/2020-09-21+Tempo+Timesheets+for+Server+10.20.0+Release

  • chris geldbach commented
    27 Aug 01:14pm

    Tempo Servlet to support Excel .xlsx format. This is great to have.

  • Manoj Gupta commented
    27 Aug 08:40am

    It is easy to integrate and read .xlsx format with other development tools.

  • Divyanshu Srivastava commented
    27 Aug 06:39am

    As .xlsx is widely using, Tempo servlet should also support it. I see scope of improvement here.

  • Jyotsana Singh commented
    27 Aug 02:57am

    With a large user base and requirements of different views for Finance, managers, teams a single spreadsheet will ease out the problem of manual intervention .

  • Rose Navarro commented
    26 Aug 11:46pm

    With an increasing # of users and requirement for time entry this will provide a single download without manual manipulation, and therefore, reduce the risk of error. In addition, from an auditor's perspective, they prefer system generated with no manipulation