Borrower update report

Learn how to create and print a Borrower update report in Amlib.

Borrower update reports can now be run to change borrower status, add memos and delete the address 3 field (for those borrowers that are changing to adult status).

In the following example, we are changing the Borrower Type of Young Adult members to an Adult Type and deleting the Guardian Address.

Template

  1. Launch the Amlib client.
  2. Go to Main > Reports > RepAddNew – the Report Files screen will display:
    clipboard_eee73fa3f98544c1b1419ceaf83ee4895.png
  3. Locate and highlight the &BORUPD.QRP template.
  4. Click the F2 Modify button – the Borrower – Modify Report File screen will display:
    clipboard_e0fb5d34729c8b80af47ce130ad121707.png
  5. Check the following settings:
    1. Choose Type = Borrower Automatic Update
    2. Update Entity (Y/N) = Y
  6. Click the F3 Update when complete.

Create the Report

  1. Go to Main > Reports > RepBorrower – the Borrower Reports screen will display.
  2. Click the F1 New button – the Select Report Format list will display:
    clipboard_e39e4037274c46cac21684d8afbce9b09.png
  3. Highlight the &BORUPD.QRP template and click the Select button.
  4. A new report will be added to the list of reports.
  5. Type in a Description – for example: Update Borrower Address 3.
  6. The Update Entity (Y/N) column setting must be set to Y
  7. Click the F3 Save button when complete.

clipboard_e84d6bf50c31fdab057a7941d5428ed60.png

Set Where Parameters

Your where parameters can be set according to the changes you need to make to your database, and which group(s) of people these changes apply to.

The Where statement here selects those borrowers with a YA borrower type who are now over 18.

If you are unsure of how to set your where parameters for the update you wish to carry out, please contact Amlib support.

  1. Highlight the Report.
  2. Click the F7 Where button – the Borrower Reports – Where screen will display:
    clipboard_e3d936034618c89509dfc03f0c2b1a29c.png
  3. Enter the following details:
    1. BorType – for example: BorType = YA
    2. BirthDate – for example: BirthDate <= Current Date – 18 Years (use the Special button to insert Current Date – 216 months)
  4. Click the F3 Save button when complete (the Where screen will close).

Update Parameters (F10 More)

The F10 More button is used to set up the new values and whether a Memo is to be sent.

A report employing F10 More parameters must be run via the Scheduler.

  Column 1 Column 2 Column 3 Column 4 Column 5
HEADING Report Line Number Column New Value Send Memo Address 3
EXAMPLE 1 T A Y <leave blank>
  2 <leave blank> <leave blank> <leave blank> Y
COMMENT

Line 1 is used for updates

Line 2 is used to delete Borrower Address 3

 Borrower field - can be Borrower Types (T), Classes (C), Groups (G) or Status (S) The new value - must be a valid code for the selected column If Y, create the memo in Text for Letter, found at the top of the Borrower Reports screen If Y, can be used to delete Address 3 (Guardian Address) from Borrower record
  1. Highlight the report.
  2. Click the F10 More button – the More screen will display.
  3. Click the F1 New or F2 Insert button.
  4. Enter the following Line 1 parameters (see Notes below):
    1. Report Line Number = 1
    2. Column = T
    3. New Value = A (for Adult)
    4. Send Memo = Y (optional)
  5. Click the F3 Save button when complete.
  6. Enter the following Line 2 parameters (see Notes below):
    1. Address 3 = Y (this will delete the Borrower’s Guardian Address)
  7. Click the F3 Save button when complete.

clipboard_e8e5dca2fa3afc58525ed1eeb56c3e012.png


Notes

Updates: The new value is the new Borrower Type (or Borrower Status, Borrower Class or Borrower Group) that you wish to change the Borrowers to.

In the example given above, the Borrower Type would be changed to Adult, or A. The value entered in this column will depend on your Borrower Type settings. If you unsure, check your settings before proceeding: Go to Main > Borrower > BorrowerTypes:

clipboard_ece972bc1eb8e166f2a56e463a82d5f9c.png

Memo: If you wish to add a memo to each borrower record that is changed, type a Y in the Send Memo column. Otherwise, type N in the Send Memo column.

Delete Guardian Address: Type a Y in the Address 3 column if you wish to have the guardian address deleted (for example in the case where YA members are changed to A members, for these records you may prefer to have the guardian address deleted as this is no longer required).

Memos

If you have placed a Y in the Send Memo column, then the Memo text must then be set up.

  1. Highlight the report.
    clipboard_e2627c1183552b20ea5ebe502cd00b78c.png
  2. Click the Text for Letter button – the Letter Text screen will display:
    clipboard_e0bf9ac823155b8fc65fd411374b13ad6.png
  3. Type in the text that you would like to see in the Borrower Memo – for example: Borrower to sign register and present ID.
  4. Click the F3 Save button when complete

View Report

Once the report is set up, you can then preview the report as follows:

  1. Highlight the report and click the F8 View button.
  2. The Select File for View pop-up will appear:
    clipboard_edbe81a73883ae783982d6935bddf4687.png
  3. Click the No button to run this report against all borrowers.
  4. The report will open in the Report – View window:
    clipboard_ebe14b2f7d727cacf4755407799e3b05c.png
  5. If you wish to print a hardcopy, click on the print icon.

Print Report (via Scheduler)

Borrower Update reports MUST be run via the Scheduler.

Start the Scheduler

  1. From the Reports screen, select Application > RepStartSchedule.
    clipboard_e0333c20176f191c0cb260e04ac982dab.png
  2. The Report Scheduler screen will then open.
  3. Select your printing options: Ensure Save to File is ticked (you can tick all three if you intend on printing up multiple reports using multiple formats during a session).
    clipboard_e4d01ed5b3481dffb2cfb705bbfc4486a.png
  4. Then click the OK button.
  5. 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_e6219939f0e1af17974b02dd102fa32aa.png

Schedule the Report

  1. With your report highlighted, select the F6 Print button – the Print dialogue box will open.
  2. Select from the following options:
    1. From:
      • Database (to search the entire database)
    2. To:
      • File (to save a report as a file)
    3. Frequency:
      • Once Only
        clipboard_e72194a094c780380e7148c37e93820ed.png
  3. Once you have selected all of your settings, click the OK button – the Report – Save As screen will display:
    clipboard_ea81fed42af0e066c0a4a93f3e5477303.png
  4. Select a Save in: location and type in a File name:
  5. Click the Save button when complete

Check Print Progress

  1. You can check the progress of your reports at any time by going into Main > Reports > RepPrintProgress.
    clipboard_e4b63a76a42dbcdbd6ac18a6a1ec15f1f.png
  2. 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.
  3. Your report will show up in Printed when it is complete.
    clipboard_e2aaf6ac19b0ccc9e2d39044baaeb17b7.png

The matching Borrower details should then be updated.

Updated Borrower Record:
clipboard_e308fd1f1453911a13b3cb3a146072c34.png

Memo that appears in Circulation:

clipboard_ed45d31189165f3e6161353593db32dc5.png