Automatically Export an Attendance Report

Automatically Export an Attendance Report

1.0 Introduction

This setup example explains how to automatically export a report which lists the cardholders that have badged their cards at some point during the day. For this you need to have three Licensed Features enabled in your license:

 

  • Host Schedules
  • Global Linkage
  • Professional Report Client.

 


2.0 Create the Report you Wish to Export

  1. The first thing to do is to use the Professional Report Client to create a custom report for the access granted messages at a certain door during the past day.

    Host Schedules - Image 1

  2. Execute, then preview the report and ensure it looks correct.

    Host Schedules - Image 2

 


 

3.0 Create a Global Linkage Macro

  1. From the Home tab, click on Global Linkage.
  2. On the Macros tab click the Add New button.

    Host Schedules - Image 3

  3. Highlight the New Macro name and give it a new description.

    Host Schedules - Image 4

  4. Click the Add Macro Item button.
  5. Click on the new item.
  6. Give the new item a description as well.
  7. From the Macro Item Type select Export Report.
  8. From the Report Name select the specific report that you recently created.
  9. From the Output Format select the file format you wish the report to be outputted as.
  10. In the Report Export Filename enter a default name for the report.
  11. In the To: field enter an e-mail address for the recipient of the report.

    Host Schedules - Image 5

  12. Once complete, save your settings.

 


4.0 Enter your e-mail into Global Linkage Settings

  1. From the Start Menu, go to All Programs >> Doors.NET >> click on License Manager.
  2. From within the License Manager, click on Global Linkage Service then click the Settings button.
  3. The Global Linkage Service setup window will appear.
  4. Click on the Email Settings tab.

    Host Schedules - Image 6

  5. Select your Email Type - the default option is Gmail.
  6. Enter your Account Name/Email address.
  7. Enter your Email Account Password.

    Host Schedules - Image 7

  8. Place a check mark against 'Use Simple Email' option.
  9. Click the Save button.
  10. You will then be prompted to restart the Global Linkage Service so click Yes to this.


5.0 Generating an App Password for GMail

To use a GMAIL account with the Global Linkage Service you will need to create a new, unique app password. This is done via your Gmail account security settings:

  1. Log into your Gmail account.
  2. Click on Manage your Google Account.
  3. Click on Security on the left-hand side.
  4. Click 2-step verification.
  5. Scroll to the bottom of the list until you find App passwords.

    Google App Passwords

  6. From the Select App drop-down list, select Other (Custom Name).
  7. Enter a new name. For example; DNET GLS.
  8. Click the GENERATE button and a new unique password will be created.

    App Password

  9. Copy and paste the password into the GMAIL password field (see previous section).

    Account Password



 

6.0 Test the Global Linkage Macro

  1.  Return Doors.NET Global Linkage setup page.
  2. Right-click on the Macro and choose 'Execute'.
  3. Within a couple of seconds an event will be generated in Live Events stating the macro has executed.



    Important Note: If you are using a Gmail/Googlemail email address you may receive an e-mail stating a sign-in attempt has been blocked. This is because Google have enhanced their security settings to reduce unauthorized email account access. Within the e-mail you receive you will have a link to where you can adjust you account settings. You will have to turn on Access for less secure apps. If you are not comfortable with doing this Keri recommends using a different e-mail account type for this feature.


  4. An e-mail will be sent from the GLS service to the recipient's e-mail address (along with the report included as an attachment).

    Host Schedules - 10

  5. Just like any other e-mail attachment you can choose to view the file or save it.

    Host Schedules - Image 11

 

7.0 Configure Host Schedules to Automatically Export the Report

  1. From the Home tab, click on Host Schedules in the Automation section.
  2. Click the ADD NEW button.
  3. Highlight New Host Schedule 1 and the properties will appear on the right.
  4. Give the Host Schedule a new description.
  5. From Execute Macro on Activate select the new Macro from the drop-down list.

    Host Schedules - Image 12

  6. Execute Macro on DeActivate should be left at None.
  7. In the Interval 1 section specify a start time (when you wish the report to be e-mailed).
  8. Set an end time a couple of minutes after the start time.
  9. Select the days of the week you wish the report to automatically be created and exported.

    Host Schedules - Image 13

  10. Click save and a morning attendance report will then be e-mailed automatically at 13:30 on Monday through to Friday.
  11. You could also use the Interval 2 section if you want to generate the same report again at the end of the day.

    Host Schedules - Image 14


    • Related Articles

    • Reports - Automatically Export an Attendance Report

      1.0 Introduction This setup example explains how to automatically export a report which lists the cardholders that have badged their cards at some point during the day. For this you need to have three Licensed Features enabled in your license: Host ...
    • Professional Report Client Setup

      1.0 Introduction The system has a built-in report designer that allows you to create a new report from scratch or to modify any of the default reports. You can change fonts, add your own logo, change header and footer text, add a barcode field to the ...
    • Professional Report Client Data Sheet

      Attached.
    • Time and Attendance Sync Service Setup

      1.0 Introduction The Time & Attendance Sync service pushes out access granted events from specific readers into a separate SQL database (so that these events can be used in a third-party time and attendance application. The events are stored in the ...
    • Work Hours Report

      Work Hour Calculation Report 1.0 Introduction The work hour calculation report allows you to generate a report that displays who has been at work that day (who entered the premises with a valid credential) and it accurately calculates the work hours ...