Set up email reports

Learn how to set up and run reports that can be sent via email in Amlib.

Several Reports can be sent via Email. See some examples at the end of this document.

Email templates

Borrower Reports (RepBorrower)

Circulation Reports (RepCirculation)

ILLs Reports (RepILLS)

Orders Reports (RepOrders)

Periodical Reports (RepPeriodicals)

Reservation & Bookings Reports (RepReservation)

Set up

Supervisor parameters

To begin, some settings need to be set in the Supervisor module (this need only be done once):

  1. Launch the Amlib client.
  2. Go to Main > Supervisor > Installation. The Default Installation screen will open.
  3. Select the Other tab.
  4. Scroll down to set the following: E-mails are sent using the following method: (M)API or (I)nternal or (S)MTP. Set to S, I or M.

    Generally (S) SMTP is recommended, especially as it is simple and it has advantages over the others. It also means that the email client does not need to be open on the PC running the notices and allows greater flexibility with regard to setting up “from” and BCC/CC parameters.

    Installation window

    Then the following parameters should also be set (a full table is included below):
    • SMTP Blind Carbon Copy e-mail address: You can specify the BCC address to send a copy of all notices (so that you can verify that they have been sent).
    • SMTP sender e-mail address: The email address to display on the notice sent to the borrower.
      (For example: enquiries@amlib.com.au, it can be the same as the BCC address)
    • SMTP Server name: The address of the SMTP mail server being used. This might be a server address or an IP address.

    Installation window
  5. Click the F3 Save button.
  6. Once complete, you must exit and reopen the Amlib client to allow the settings to take effect.

The complete set of parameters to consider:

description explanation example
E-mails are sent using : (M)API or (I)nternal

OR

(S)MTP or SMTPMailer (D) LL
Generally (S) SMTP is recommended, especially if the organisation is not using a Microsoft Exchange Server. It also means that the email client does not need to be open on the PC running the notices AND can display the “from” name from one of the parameters below rather than the email address from the email client. Set to S, I or M ( S is the default one for internal mail – does not use Transport Security )

OR

If using a SMTPMailer service such as Gmail.com or Outlook.com set this to D
SMTP Blind Copy e-mail address Optional: If using the SMTP for emails. Enter only if copies of the email are to sent to a chosen email address – for example: Testing purposes library@amlib.com
SMTP sender e-mail address Optional: If using the SMTP for emails, enter the Address you wish to indicate as the sender enquiries@amlib.com.au
SMTP server login Optional: From your Systems Administrator if required – required by systems using encryption For Gmail this is: smpt.gmail.com

If not using a SMTPMailer service leave blank
SMTP Server name or IP address If using the SMTP for emails, enter the Server Name or IP Address of the Server installed with the e-mail communication protocol, responsible for receiving and forwarding email messages ServerName – for example: server.amlib.com.au or your IP address such as 199..199.94.94 (this needs to be set for all email setups)
SMTP server password Optional: From your systems administrator if required – required by systems using encryption You will need to set this if using a SMTPMailer service otherwise leave blank
SMTP Server Port Number Only needs to be set for those using SMTP Transport Security or if you have selected D above (S)SL = port 465 or if using
(T)LS = Port 587
SMTP server requires a login? If Y, supply a SMTP server logon and password

If N, leave SMTP server logon and password blank
Y/N – this will be Y if you have selected D above and use a SMTPMailer service otherwise set this to N
SMTP Transport Security - (N)one, (S)SL, (T)LS The use of the Transport Layer Security (TLS) protocol over SMTP offers certificate-based authentication and helps provide security-enhanced data transfers by using encryption – this is required by SMTPMailer services. If you have selected D above set this to either T(LS) or S(SL) for an encrypted connection

The above tasks create Sender and BCC for ALL emails generated by the system. However, it is possible to set up separate SMTP parameters (Sender and CC) for individual locations, modules and reports.

Set up individual email systems by location

  1. In any Installation screen module, select Installation > Choose Location and choose a Location.
  2. Repeats steps 2-5 above. If you would like to use the Default settings, then the relevant fields for each location should be left blank.
  3. Once complete, you must exit and reopen the Amlib client to allow the settings to take effect.

Set up individual email locations, modules, and reports

We recommend leaving the email set-up for particular locations until after initial testing has been completed. Once the initial testing has been done, then:

  1. In any Supervisor module, select Library Menu > LocRepSMTP. The SMTP Parameters by Location table will open.
  2. Select the F1 New or F2 Insert button.
  3. Using the drop-down boxes available in each column, select the Location, Report Screen, and Report Type.
  4. Then type in the individual Sender’s Email and Carbon Copy Email addresses.
  5. Click the F3 Save button when complete.
  6. Once complete, you must exit and reopen the Amlib client to allow the settings to take effect.
    SMTP Parameters by Location window

 Note: It is not possible to alter a pre-existing entry in the SMTP Parameters by Location table. Entries must be deleted (using F4 Delete) and then re-entered.

Borrower settings

For borrowers to receive their overdue notices via email, the borrower record will need to have the following:

Borrower Details window

  • Email address – for example: john.smith@oclc.org
  • Use for Notices = Y (for Yes)
    Email and Use for Notices fields

Set up and run a report

Edit the template

The email report templates can be customised using Report Writer (RepWin30.exe) – a copy of which can be found in the Amlib/Utility folder on your Amlib server (see separate installation instructions). It is also possible for Amlib Support staff to modify an existing report if necessary.

Start off with an existing System Report (for example: &odemail.qrp) and adjust the wording as required – see separate Editing Text in Reports procedure. Be sure to save this customised report with a new name (without the & at the front).

 Note: Do not add logos and keep the layout simple for emails.
Library Overdue Reminder Notice - example

Save the template

  • Save the template into the Amlib/Reports folder on the Amlib server. This will make the template available for use to all users. Alternatively, you may save it into a local folder on your PC – but please be aware, that the template (once loaded) will only be available for use on that PC.
  • Ensure that the template is saved with a name that clearly identifies it as a customised email template– for example: BRODEMAIL.QRP

Load the template

  1. Go to Main > Reports > RepAddNew.
  2. The Report Files window will open.
  3. From the Report Entity drop-down, select the Report Screen (module) you would like to load a template for – for example: Circulation.
  4. Click the F1 New button.
  5. Enter in a Description.
  6. Browse to the Amlib/Reports folder on your Amlib Server and locate the template to be loaded (if the template has been loaded onto your PC – then navigate to the local folder).
  7. Click the Open button.
  8. Choose Type. Ensure you select the relevant email type – for example: Continuous - email.
  9. You can leave Default Stats Code blank.
  10. Update History (Y/N) = Y
  11. Update Entity (Y/N) = N
  12. Click the F3 Update button.
  13. Close out of the Report Files window.

The template is now loaded and available for use in a Report.

Circulation - New Report File window

Set up the report

Create report

  1. Go to a Reports screen – for example: Main > Reports > RepCirculation.
  2. Click the F1 New button.
  3. Highlight an email template (for example: Email Overdue using the &ODEMAIL.QRP print template) and click Select.
    Select Report Format window
  4. Enter a Report Description – for example: Overdue Notices by Email.
  5. If you would like the borrower record to retain a record of any notice sent, then ensure that Create Hist (Y/N) = Y
  6. If there are replacement costs involved, ensure that the Create Acct (Y/N) = Y
  7. Click the F3 Save button.
    clipboard_efa39873d0a0ffb60eb4e83c417ff1e74.png

Where statement

  1. Select the report from the list and click the F7 Where button.
  2. The statement must include the following settings:
    • Bor Email Address IS NOT NULL (Paste without placing a value in 3)
    • Bor Use Email = Y
    • Additional parameters can then be added
  3. Click the F3 Save button.
    Circulation Reports - Where window

Order

  1. Select the report from the list and click the F9 Order button.
  2. Use the arrow keys to select fields to Order By – for example: Borrower Bar No.
  3. Click the F3 Save button.
    Circulation Reports - Order By window

Print the emails

Using the Scheduler has two benefits over running reports via F8 View: It allows you to schedule regularly run reports so that staff do not have to do it manually each time, and it allows for further functions as part of the report such as updating Borrower/Stockitem history, creating financial accounts, changing records in the database and adding report information to your statistics. Email reports must be run via the Scheduler.

This section will take you through setting up a report to use RepStartSchedule.

Start the scheduler

  1. From the Report screen (Main > Reports > RepCirculation or RepReservation), select Application > RepStartSchedule.
    Circulation Reports - Application > RepStartSchedule
  2. The Report Scheduler screen will then open.
  3. Select your printing options: Ensure Email is ticked.
  4. Also decide If a report is scheduled by another user do you still want to print it? = Yes/No.
    Report Scheduler window
  5. Then click the OK button.
  6. After clicking “OK”, if you go back into the Application menu you will see that RepStartSchedule is now greyed out with a tick next to it – this indicates that the Scheduler is now running.
    clipboard_e59c10f158ea463e0b2e8ead8890e1aa8.png

 Note: If you need to restart the scheduler at any point, you will need to log out of all Report screens (Ctrl + L) and start at the beginning of these instructions.

Schedule the report

  1. With your report highlighted, select the F6 Print button.
  2. A Print box will display where you can select from the following options:
    1. From:
      • Database (to search the entire database)
    2. To:
      • E-mail (to email it to patrons)
    3. Frequency:
      • Once Only (if this is the only time you’re going to print this report)
      • Daily (if you plan to send it every day)
      • Weekly (if this is a once a week item)
      • Monthly (if this is to be printed every calendar month)
      • Every ___ days (if you want to set a specific schedule
    4. Schedule:
      • First Print Date (the day you want this report to begin its schedule)
      • First Print Time (specifies the exact minutes the report will run)
    5. Selected Printer:
      • You can specify any active printer on the network to print to – including virtual printer drivers such as a third party software that allows you to print to PDF (For example: CutePDF Writer).
        Print window
  3. Once you have selected all of your settings, select the OK button.

Check print progress

  1. You can check the progress of your reports at any time by going into Main > Reports > RepPrintProgress.
    Print Progress window
  2. If your library uses the scheduler for a lot of reports, you can select a frequency type from the Filter drop down menu at the top.
    Frequency Type filter
  3. You can also click through the three tab options at the top to see the ones that are Waiting, Running, or have already been Printed.
    Tab options
  4. Your report will show up in “Printed” when it is complete.
    Printed option

Additional items

When scheduling reports, you must remember:

Email address validation rules

When email reports are being sent a certain amount of validation is going on. Email addresses are rejected if illegal characters are found.

If the email address is invalid and if the barcode of the patron can be found by the process, the Borrower ID is written to a saved Borrower File, which can be checked later.

If the barcode of the patron cannot be found, no file can be created but an error message is written to the amdberror.log in the Amlib folder.

If the SMTP protocol is being used then any errors encountered will be logged. Neither MAPI nor the internal method support error reporting in an accessible way.

  • Must be at least 5 characters long. Shortest theoretical address is a@b.c
  • Must contain an “@”
  • Must have one or more characters before the “@”
  • Must contain a “.”
  • No more than 4 characters after the last “.”
  • No “_” after the “@”
  • Only one “@”
  • No invalid chars – the following ranges are invalid:
    • Less than ASCII 48 (except 45 and 46)
    • ASCII 57 to 65 (except 64)
    • ASCII 90 to ASCII 97 (except 95)
    • ASCII > 122

       Note: Note: 45 = "-", 46 = ".", 64 = "@" and 95 = "_"

The formatting of the email is checked against these rules, but the address may it still be invalid.

Troubleshooting

Some users may experience some initial problems with SMTP emails not being sent. This can be the result of your anti-virus agent blocking programs that relay (mass) email or your mail server blocking relay (mass) emails.

There is now a complete Setting-Up Email and Troubleshooting Guide.

Examples

Borrower Subject interests report via email (&BORINEM.QR)

Emails the items included for the Interests set in Borrower > XReferences > Subject Interests. The Borrower email address and Use for Email details need to be entered in the Borrower window. Where parameters can include a Borrower Type (for example: T for Teachers) and Received Date (for example: > Current Date – 1 month).

Borrower Subject interests report via email (&BORINEM.QR) example

Letters (&1NADDEM.QRP)

It is possible to change the text of the letter and send it out to selected borrowers. It could be useful for advertising promotions, notifying staff, welcoming letter, confirming opening times etc.

  1. To change the text of the letter click on the Text for Letter button.
  2. A dialogue box will display where the text of the note or letter can be typed.
  3. Select the F3 Save button when complete.

     Note: The F5 Query button can be selected to return the screen to the display at the last save. Therefore any changes made after the last save will not be retained.

The template for this email report has to be set to use the Type of Name & Address x 1 across Email.

Letters (&1NADDEM.QRP) example

Inter-Library Loans

It is possible to email inter-library loan reminders via email. The External Libraries table (select Application > StockExternalLibs) in the Stockitems module would need to be updated with the email addresses.

Inter-Library Loans example

Email Order with GST defined (&OSEGST.QRP)

A number of reports may be produced regarding order status. Email of Orders is now possible.

Email Order with GST defined (&OSEGST.QRP) example

Email Reservations

  • File Name = &RESEML.QRP
  • Report Entity = Reservations
  • Report Type = - Email
  • Update Entity (Y/N) = Y

Reservation statuses assist in Reports. When an item with reservations on it is returned, the reservation for the first item in the queue changes to a status of RETURN.

Reservation reports can be run with the Update column set to Y, which when used in relation with the F6 Print button updates the status to PRINTED.

This ensures that the next batch of Reservation reports are only sent to those people where the item is newly RETURNed. For those items that are on the Shelf when reserved, it would be wise to use the RESGET memos (set in Supervisor > Locations > Borrower Barcode for Memos) to alert staff to get them the reserved items from the Shelves and wand them through Returns. Alternatively, a pick list may also be run in the Reservations report screen.

Email Reservations example

Damaged Item Notice &STKMRR.QRP and E-mail (&STKMRRE.QRP)

These most recent return reports are for sites who return items from the Borrower's records when they are damaged but still want to bill people for the costs of the damaged item. It will display the LAST borrower who had the item. If a site does not return the item when it is damaged (and keeps the item on loan), then Circulation reports can still be used.

Damaged Item Notice &STKMRR.QRP and E-mail (&STKMRRE.QRP) example