How Do I Automate Reports

With Tempora you can automate reports to run daily, weekly or monthly. These reports will then be emailed to a selection of users. This is often used by project managers to see the number of hours added to a project month by month. The finance team to check staff cost rates and the late timesheet email to remind staff to complete any overdue timesheets.

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

Index
Report Profile
Email
Schedules
Scheduled tasks

1. Adding A Report Profile
   Report profiles are used to store report settings, this is especially beneficial for custom export reports you have created.
   Click on Reports
   
   
   
   
   
2. Click the report you would like to store settings for we will use Time Reports > Time By Client > Total Time By Person By Month
   
   
   
   
   
   Configure the settings you would like to store these are most frequently Client/Time entry level, Detail Level, From Period, and To Period. These may be different depending on your chosen report.
   
   
3. Tick Show profiles in the top right
   
   
   
   
   
4. Select the Profile Location this will most frequently be Personal or your company name and click Add New.
   
   
   
   
   
   Please note if your profile is set to Personal only you will be able to see this report profile. If the report profile is set to company all users with the appropriate permissions will be able to see this report profile.
   
   
5. Add a Profile Name and click Save
   
   
   
   
   
   This profile will now be available in Reports > Saved Profiles
   
   
   
   

1. Adding A Email
   Emails are most frequently used with report profiles to automate a report to selected users. Emails are also used by the holiday system and the late timesheet report.
   Click on Admin
   
   
   
2. Click Reporting > Email > Add New 
   This section will allow you to set who the email should be sent to, each section is explained below.
   
   
   
   
   
   Description - Email name for use in Tempora
   Default From - If <None> Is selected it will be sent from support@temporasoftware.com
   Email Type - All custom emails should be set to Scheduled Task 
   Send as attachment - If this is ticked the report information for this email will be sent as an attachment
   Summary To - If multiple staff are selected in the To field This staff member will 
   To - Select the staff member this email should be sent to use control+click to select multiple staff
   Subject - The subject line of the email
   Header - Optional. Text entered here will appear at the top of the email underlined  
   Footer - Optional. Text entered here will appear at the bottom of the email in italics 
   
   
3. Click Save once you have made your changes
   
   
   
   
   

1. Adding A Schedule
   Schedules are used to set when an automated email will be sent this is most often monthly or weekly. The example below will show you how to Schedule a report monthly. 
   Click on Admin
   
   
   
   
   
2. Click Reporting > Schedules > Add New
   
   
   
   
   
3. This section will allow you to set when the schedule should be run
   
    
   
   
   Name - This will help you Identify this schedule from other schedules 
   Enabled - If this is not ticked the schedule will not be active
   Occurs - This section will set the frequency of this schedule, for this example, we have selected to run the schedule monthly on the first day of the month.
   Daily Frequency - This section will set how many times this schedule should be run on an occurring day. We have selected once at 9 am 
   
   
4. Click Save once you have made your changes
   
   
   
    

1. Adding A Scheduled task

   Scheduled tasks are used to link a report profile, email, and schedule together creating the automation.
   Click on Admin
   
   
   
   
   
2. Click Reporting >Scheduled tasks > Add New
   
   
   
    
3. This section will allow you to combine all the elements required to create a report automation
   Name - This will help you identify this scheduled task from other scheduled tasks
   Email - Please select the email profile to assign to this scheduled task
   Schedule - Please select the schedule to assign to this scheduled task
   Profile Location - Please select company or personal depending on where your report profile is saved
   Profile Location - Please select the report profile to assign to this scheduled task
   
    
   
   
   
   
4. Click Save once you have made your changes
   
   
   
   
    

You may also be interested in the following guides

Using the Tempora Export engine
Exporting Time Data to Excel