From 0499ac7d75812369fadc115806c2ebc32fa15d31 Mon Sep 17 00:00:00 2001
From: Nicole Engard TIP: Use manual credits to pay partial fines. The dictionary provides a way that you can define custom criteria for reporting by combining existing criteria. Step 1: Name At this step you will need to fill out the following details: Definition Name: Short name that is used for display and selection Definition Description: Used within the dictionary only to provide further detail about the definition Now you will need to select the area that you are binding the definition to. Definitions can only be bound to one area. If you wish to use a similar definition in say, Circulation and Patrons, you will need to create two definitions - one for each area Now select the criteria that you wish to use to build your definition. Click on the database column name and then press the add button. Once you have selected all your desired columns, press Next. Note: Definitions can be deleted easily, and if you are still learning the structure of the Koha data, it may take a little while to sort out which fields you require. Some trial and error may be required. Step 2: Area Now you will need to select the area that you are binding the definition to. IMPORTANT: Definitions can only be bound to one area. TIP: If you wish to use a similar definition in say, Circulation and Patrons, you will need to create two definitions - one for each area Step 3: Columns Now select the criteria that you wish to use to build your definition. TIP: Definitions can be deleted easily, and if you are still learning the structure of the Koha data, it may take a little while to sort out which fields you require. Some trial and error may be required Step 4: Values Now you need to select the values for each column that will make up your new criteria. There are different ways to define the values, based on the type of data in the column you have selected Step 5: Confirmation You will be presented with a confirmation once you have finished step 4 Click 'Save' Once you have created your new definition and it shows on in the Dictionary, you can use the definition for reporting. When you go to create a new report, the criteria for the area you are reporting on will automatically show as limits in the Guided Reports wizard Once you have created your new definition and it shows on in the Dictionary, you can use the definition for reporting. For help with the Reports Dictionary - see online help within the Dictionary Pages Select one of the module areas to report on. Guided reports can only generate reports from within one module. For reports across modules, you will need to use either a compound report, or build a custom report using SQL statements. There are 3 types of reports that can be generated: Select the columns to draw the report data from. Click the column to add in the left hand box and then click the "Add" button. Your column will now show up in the right hand box. To remove a selected column, click the column name on the right hand side and then click the delete button. Once you are happy with the columns, select the "Choose Columns" button to proceed to the next step. Be careful selecting columns. The guided reports feature expects that you have some knowledge of the Koha database structure and what each field is used for. Be careful selecting columns as a poor choice may lead to a report that is so large that it either times out before it can be generated, or it will require a large amount of system resources to generate and slow down the operation of Koha. There is no sanity checker in the reports engine Criteria allow you to limit your report to display results to a given criteria.Criteria are bound to a specific reporting area. Now choose operations that you want to preform on each column. The operations that can be selected are: Select how you wish to order the report. You can select multiple criteria to order against and the hierarchy that the are applied. For example order alphabetically by Surname, and then alphabetically by First Name Once you have generated a report, you can now choose to save the report definition so that you can run it again when required, or setup the Task Scheduler to run the report for you. A report can be generated directly using from an SQL statement. On the "Create from SQL" page, give the report a Title and Description (using the notes field) and then paste your SQL statement into the text area. Reports can be scheduled to run either at a one off time, or repeatedly at a defined period using the task scheduler. The task scheduler is found under Tools >Task Scheduler If the report you need is not already available, the 'Guided Reports' Wizard will walk anyone through creating a custom report. There are three elements of a standard 'guided' report: columns, rows and filters. For issues and acquisitions, desired data is placed in each cell (count or amount, or loan length). Now, you can build a report in 6 easy steps! Step 1: Choose a Module to Report on Step 2: Pick a Report Type
+
@@ -84,7 +88,7 @@ TIP: If this preference is turned OFF after being ON, the system reverts to the
-
Reports Dictionary Help
-What is the Reports Dictionary
-Adding A New Definition
-Step 1 of 4 Name
+
+
-
-
- Step 2 of 4 Area
-Step 3 of 4 Columns
-Step 4 of 4 Values
+
+
+
+
+
+
+
+
-
-
+
+
-
+
+
+
+Using A Definition
-
+
\ No newline at end of file
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tmpl
index b1c61f3cbe..55dc4982a2 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tmpl
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tmpl
@@ -1,56 +1,57 @@
-
-Guided Reports Help
-
-
\ No newline at end of file
+
+
-
-
-
-
-
-
Building A New Report
Step 1 of 6: Choose a Module to Report on
-Step 2 of 6: Pick a Report Type
-Step 3 of 6: Select Columns for Display
-Step 4 of 6: Select Criteria to Limit on
-Step 5 of 6: Pick which columns to total
-Step 6 of 6: Select how you want the report ordered
-
-Back To Top
-
-
-Saving A Report
-
-Back To Top
-
-
-Generating A New Report From SQL
-
-Back To Top
-
-
-Scheduling A Report
-
-Back To Top
-
- Add a Custom Report
+
+
+
+
+
+
+
+
Step 3: Select Columns for Display
+Step 4: Select Criteria to Limit
+This is optional, if you don't want to limit results by any one field, just leave this section blank.
+Step 5: Pick which columns to total
+This is optional, if you don't want to do any math on the results, just leave this section blank.
+Step 6: Choose how you want the report ordered
+This is optional, if you want the results to come out as they are in the table, just leave this section blank.
+ +Custom reports can be edited in their entirety from the Saved Guided Reports page.
+ +Can I have reports run on a schedule?
+ +Yes, you can use the Task Scheduler tool.
+ +Is there a repository for reports?
+ +There is a page on the Koha Wiki: http://wiki.koha.org/doku.php?id=sql_library with reports written by Koha libraries around the world.
+ +NEKLS also has a great page (http://www.nexpresslibrary.org/training/reports-training/) with a list of reports they have written.
+ + + \ No newline at end of file diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/tools/holidays.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/help/tools/holidays.tmpl index f3d3e46fa2..3f13158e4e 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/tools/holidays.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/tools/holidays.tmpl @@ -1,47 +1,43 @@ -The Holidays Calendar allows the library to define days where the library is closed. Circulation rules are then recalculated to taken in to account that library is closed and there will be no one present to return items.
-There are 2 types of holiday:
-You can make use of the Holidays Calendar by turning on the proper system preferences
-\ No newline at end of file +
Why do I want to add holidays for my branch?
+ +After holidays are entered on the calendar, circulation rules are then recalculated to taken in to account that library is closed and there will be no one present to return items. + + +How do I enable the Holiday Calendar?
+ +You can make use of the Holidays Calendar by turning on the proper system preferences +How is the dropbox date is determined?
+ +Is it the last open date for the checkout branch? Is it today's date minus one? Can the dropbox checkin date be set? If the library is closed for four days for repairs, for example, there would be more than one day needed for the dropbox date.
+ +You will only have one dropbox date and that will be the last day that the library open (determined by the holiday calendar) because there is no real way to know what day the books were dropped into the box during the 4 closed days. The only way to change the effective checkin date in dropbox mode is to modify the calendar.
+ + \ No newline at end of file -- 2.39.5