How Do I Use The Tempora Export engine

The Tempora Export engine can be used to create your own reports based on data that you wish to see. This guide will show you how to use the export engine and which export profile is most likely suited to your needs.

If you are unable to complete any of the steps in this guide please use the Submit a request button at the top right of this page to contact our team for help.

Index
Export Time and Time Costs (Report on time and costs for any time entry-level)
Export Staff Update (Report on staff account information)

Export Time and Time Costs
This report is useful for creating a custom report to see how staff have spent their time on clients. it is also used for looking at large sets of data and creating custom reports, this report can also be used to extract data from Tempora to upload into other systems. 

1. Click on the Reports button:
   
   
   
   
   
2. Select Export and click Export Time and Time Costs.
    
3. The top section will allow you to select the data you would like to export. We will leave these values at their default settings.
   Company - This can only be changed if you are able to report on multiple companies
   Office - This will allow you to report on a select Office
   Department - This will allow you to report on a select Department
   Client - This will allow you to report on a select Client
   Staff - This will allow you to report on a select staff member
   Filters - This will allow you to select a filter for your report, please see the guide Report Filters for how to create a filter.
   Export Type - Most exports will be a CSV but this option will allow you to export to a TXT or XML file
   From Period - This can be set to report on data from a month
   To Period - This can be set to report on data to a month
   From Date - This can be set to report on data from a set day
   To Date - This can be set to report on data to a set day
   Include Unposted - This can be used to include unposted time, this time could be changed by a staff member 
   
   
   
   
   
4. Use the >> button to move across the information you wish to export from Excluded Columns to Included Columns. In the example below, we have exported the Staff Name, Client, Project, Activity, Hours, and Date.
   
   
   
   
   
5. Click Export :
   
   
   
   
   
6. An Excel spreadsheet will then be downloaded, containing the data you have chosen to export. You can then use filters  in this Excel spreadsheet to quickly obtain the information you require:

  Export Staff Update

This report is useful for creating a custom report of staff account data, Departments, Job titles, and Leaving dates. You can also edit the data you have exported and import your changes to Tempora with the Import Staff Update report. 

1. Click on the Reports button:
   
   
   
   
   
2. Select Export and click Export Staff Update.
   
   
3. The top section will allow you to select the data you would like to export. We will leave these values at their default settings.
   Company - This can only be changed if you are able to report on multiple companies
   Department - This will allow you to report on a select Department
   Staff -This will allow you to report on a select staff member
   Export Type - Most exports will be a CSV but this option will allow you to export to a TXT or XML file
   All - This will report on all staff
   Current - This will report on all active staff members
   Leavers -  This will report on all expired staff members
   
   
   
    
4. Use the >> button to move across the information you wish to export from Excluded Columns to Included Columns. In the example below, we have exported the Display Name of each staff member, their Tempora Joining Date, their External Ref which is often used to match accounts between systems when importing data, their Department, Job Title, and Business Email.
   
   
   
   
   
5. Click Export :
   
   
   
   
   
6. An Excel spreadsheet will then be downloaded, containing the data you have chosen to export. You can then use filters  in this Excel spreadsheet to quickly obtain the information you require:
   
   

You may also be interested in the following guides

Total Time By Client By Month Report
Report Filters