Evergreen Reports

Set up Subfolders

It’s important to set up folders prior to cloning or running reports. Folders are used in the Reports module to organize reports.  On the main Reports screen there are two sets of folders:

• My Folders where you will store templates, reports that you create and run using your login
• Shared Folders where you will find report templates or output that have been shared with you by another staff user at your library, library system, or consortium.

Evergreen Reports are made up of three components that are stored in three main folders: Templates, Reports (definitions), and Output. Create corresponding subfolders within each of these main folders to store and organize these components for easier use and location. For example, create a subfolder called Circulation in the Templates folder AND in the Reports folder AND in the Output folder.

Creating Report Subfolders

1. In My Folders, click on the Template folder.
2. Enter a Folder Name.  For example, “Circulation.”
3. Click Create Sub Folder.
4. Click on the Reports folder. Repeat 2 – 3. (The subfolder name will carry over from the Templates subfolder that you just created.)
5. Click on the Output folder. Repeat 2-3. 
6. To create additional subfolders, click on the main folder name again and repeat steps 2-5.

After you create subfolders, click on the grey arrow located next to the main folder name to access the list of subfolders.

Sharing an existing Template folder

(Optional) Subfolders can be shared with library branch, system, or consortium. **However, because of a known Evergreen issue, best practice is to either share all the folders in a group, or do not share any of the folders in a group.** This prevents the menu from breaking because Evergreen doesn’t know how to share a folder that has an unsharable parent.

1. Select a subfolder and Manage Folder.
2. From the “Share this folder” drop down menu, select Share.
3. From the “Share with” drop down menu, select your library branch (eg. MTP), system (eg. S_MTP), or consortium (eg. WEST).
4. Click Share.

To change a folder share

1. Click on the folder name and select Manage Folder in the upper right portion of the screen.
2. Select Hide (un-share) this folder from the drop down menu, and click Go.
3. Then use the steps above to share the folder at the desired level.

Clone a Report Template in Evergreen 

You must clone a template from a shared folder to your own folders for future use. This allows each user to manage their report templates locally.  Templates may be cloned and run “as is” or they may be modified during the cloning process.

1. Locate the shared report template that you want to clone by searching for a template (searching only the name field is often helpful) or browsing
   1. Under Shared Folders, go to Templates>
      1. evergreen.reports
      2. allisonmidgley>WLS Shared Report Templates (WEST)
   2. Click on the grey arrow to view the subfolders
   3. Click on a folder to view the templates that it contains.
2. When you see the template that you would like to clone,
   1. Click the check box next to the report.
   2. From the dropdown menu at the top of the screen, choose Clone selected template
   3. Click Submit. Your My Folders>Templates>subfolders display.
   4. From your folder list, select the folder in which you want to save the cloned template. The report template builder displays. This is where you could make changes to the template.  
   5. Change the Template Name, eg. add your initials or a version number.
      **Evergreen Pro Tip! Because templates are usually used for multiple purposes, keep the original template name and add only your initials – or copy the original template name into the description so that if you have questions later, you and WLS staff can track back issues and answer questions.**
   6. Click Save Template.  The template is now stored in your local subfolder. Proceed with the Set Up and Run a Report instructions.

Set Up and Run a Report 

There are two ways to run reports.

• Use your cloned report template to create a Report definition and output.
• Set up and run a report from an existing output. (To retrieve output for reports that are set up to auto-run, such as the Purchase Alert reports, see below.)

Run from a template

1. 1. In My Folders, click the grey arrow by Templates to see the subfolders. Open the subfolder that contains the report template you need and click it to view templates.
      OR
      Use the search at the top of the page to find matching templates. A template list loads.
   2. In the template list, click the check box next to the report template that you would like to run.
   3. From the dropdown menu at the top of the screen, choose Create a new report from the selected template, and click Submit.
      
      The report definition screen displays with the Template Name, Template Creator, and a Template Description for the report template.
   4. Assign a Report Name. Hint: copy the Template Name into the Report Name field and customize.
   5. Enter a Report Description (Optional). Hint: copy the template description into the Report Description field and customize.
   6. Choose Pivot Label Column and Pivot Data Column (optional). Your choice becomes the  columns in your report to make it easier to read and sets display preferences for a bar chart.
   7. Select a subfolder to store the report definition.
   8. Select the User Param[eters] to filter the report. There may be Field Hints that provide more information.
      — Dates Use the calendar to choose a date
      < moves 1 month. << moves 1 year
      OR enter a date in YYYY-MM-DD format
      — Lists Select one or more options and click Add
      Ctrl-select to select multiples. Ctrl-A to select all
      — Call Numbers Note the operator (between, contains, etc) to enter call number information
      
   9. Choose output options by using the check boxes
      1. Excel Output for full report
      2. HTML Output for a preview
      3. Calculate grouping subtotals to add subtotals and grand totals in count reports
      4. Bar Charts are okay for small data sets. Deselect for lists.
   10. Choose when to Run [the report]

• • • To test a report, or for a one off,  choose as soon as possible.
      After you know that your report tells you what you want to know, you can set up recurrence to run a report weekly, monthly, etc.
    • (optional) Enter an email address to be notified when large or recurring reports finish. 

1. 1. Click an Output subfolder to store the report output.
   2. Click Save Report.

Run a report from an existing output

1. Go to the output that you want to replicate.
2. Click on the name of the output. A pink bar will open with more information.
3. On the right-hand side, click Edit. The report definition screen will open.
4. Enter a new name and edit the existing filters to make a variation of the existing report.
5. Verify or edit folder locations.
6. Save as new to create a new report.

To retrieve output for reports that are set up to auto-run, such as the Purchase Alert reports,

1. Go to a subfolder under Output. This is usually in
   Shared Reports>Output>sharer.name>category subfolder> name of report
2. In Completed Items, check the box next to the output.
3. At the top of the green window, from the dropdown menu, select View report output
4. Click Submit. The output window displays.
5. Click Tabular output to preview results or see small result sets.
6. Click Excel Output to download the full report.

Uploading Multiple Barcodes For Batch Changes

You can upload multiple barcodes to Evergreen to make batch changes. Always add the Item Status column to the display so that you can verify that items are in locations that are appropriate for editing or deleting before taking any action on them.

From a report output:

1. Open the output in Excel. Reformat the barcode IDs, filter, sort, and analyze the data as needed.
2. Select up to 100 barcode IDs and copy
3. Open a Notepad file. Paste the barcodes into it and save it. It will be a .txt file.
4. Go to Circulation > Scan Item
5. Click Choose file, browse to the file, and open it. The items will load for batch changes.