ampEducator:Release Notes

2010-09-02T16:51:10Z

General Changes

←Older revision		Revision as of 16:51, 2 September 2010
(5 intermediate revisions not shown.)
Line 9:		Line 9:
	*Database Sandbox		*Database Sandbox
	**A mySql sandbox database is now available which will let you run sample queries for custom reports. To use the sandbox you must enable your account under Institution->Preferences.		**A mySql sandbox database is now available which will let you run sample queries for custom reports. To use the sandbox you must enable your account under Institution->Preferences.
		+	*Custom Reports
		+	**You can now create and upload custom reports for use in ampEducator. For more information see [[ampEducator:How_Do_I_ampEducator#How_do_I_add_custom_reports.3F\|Custom Reports]].
	*Course Scheduling & Attendance		*Course Scheduling & Attendance
	**You can now setup, schedule and take attendance for courses with multiple events in each day.		**You can now setup, schedule and take attendance for courses with multiple events in each day.
Line 23:		Line 25:
	*Student Attendance		*Student Attendance
	**You can now generate a student attendance report.		**You can now generate a student attendance report.
		+	*Emails
		+	**The email tab now opens up a new window to make it easier to work with emails while working on other parts of the application.
		+	**The email tab now displays the number of new emails in your inbox. This is updated every 5 minutes or whenever the screen is refreshed.
		+	**The email add/edit layouts have been changed to make emails easier to read and create.
		+	**Options to to 'Paste From Word' and 'Remove Formatting' have been added to strip out any unwanted characters when pasting.

	===Fixed===		===Fixed===

ampEducator:How Do I ampEducator

2010-09-02T03:32:12Z

How do I add custom reports?

←Older revision		Revision as of 03:32, 2 September 2010
(6 intermediate revisions not shown.)
Line 836:		Line 836:

	:#'''Built-in Reports'''. Some reports are built-in to the system. Examples of these include student lists (with grades option), attendance reports & hour reports.		:#'''Built-in Reports'''. Some reports are built-in to the system. Examples of these include student lists (with grades option), attendance reports & hour reports.
-	:#'''Pre-defined Reports'''. These are reports that come with ampEducator ~~either as examples or as defaults with new accounts~~.	+	:#'''Pre-defined Reports'''. These are reports that come with ampEducator and are available for all institutions to use. Even though they are predefined, these reports let you define the columns and add filters to get a unique report specific to your needs.
-	:#'''Custom Reports'''. ~~These you can edit~~ to create ~~your own reporting~~.	+	:#'''Custom Reports'''. Advanced users are able to create custom reports using open-source software.
		+	<br/>

	:Reports are exported in the format you choose from either EXCEL, CSV or PDF. You may also schedule reports to be emailed to users at any time. If you require a custom report to be made and are having trouble creating it on your own - please use the feature request link at the top right hand corner of the screen.		:Reports are exported in the format you choose from either EXCEL, CSV or PDF. You may also schedule reports to be emailed to users at any time. If you require a custom report to be made and are having trouble creating it on your own - please use the feature request link at the top right hand corner of the screen.
Line 854:		Line 855:
	<br/>		<br/>

-	====How do I ~~create my own custom~~ reports or add new reports?====	+	====How do I specialize the built-in reports and/or add new reports?====
	:Select Dashboard>Reports>Add New Report Type. A number of reports are available in the ampEducator application for you to choose and run. To add a new report type select the category and report from below. Once added you edit the report and select different fields and rename them. You can also add inputs to set up parameters to filter you results. Examine the columns and fields of the report you wish to add and see if it contains the fields you need to report on. If you require a report which isn't available please contact our support department at support@amperea.com for help.		:Select Dashboard>Reports>Add New Report Type. A number of reports are available in the ampEducator application for you to choose and run. To add a new report type select the category and report from below. Once added you edit the report and select different fields and rename them. You can also add inputs to set up parameters to filter you results. Examine the columns and fields of the report you wish to add and see if it contains the fields you need to report on. If you require a report which isn't available please contact our support department at support@amperea.com for help.
		+	<br/>
		+
		+	====How do I add custom reports?====
		+	'''Advanced Users'''. ''In order to create custom reports knowledge of SQL is required.'' ampEducator uses the JasperReports [http://jasperforge.org/projects/jasperreports] reporting engine to generate reports. This is an open source engine which uses an XML file to describe the report. In order to generate a custom report:
		+
		+	#Download the iReport application from here:[http://jasperforge.org/projects/ireport] - iReport is a fully featured open-source report designer which generates the XML files required by JasperReports.
		+	#Create a Sandbox Database account under Dashboard->Institution->Preferences->DB Sandbox. This will give you access to a database which you can use to create and test your queries and reports. Make a note of the IP, database name, user name and password.
		+	#In iReport create a new report and link to the Sandbox DB by creating a new JDBC datasource and using the information from the previous step. At this point you should have access to tables and fields from within the sample database.
		+	#Use iReport to create your report. There are a lot of good tutorials and examples here [http://jasperforge.org//website/ireportwebsite/IR%20Website/ir_documentation.html?header=project&target=ireport].
		+	#When you are satisfied with the report create a custom report in ampEducator under Reports->Add Custom Report. You will be asked for the report name and the JRXML file generated by iReport. ampEducator will automatically create any parameters (inputs) you defined in your report.
		+	#Once uploaded you can treat the report like any other report in ampEducator.
		+	<br/>
		+
		+	''Please note that not all the features of JasperReports / iReports have been implemented. The following is a short list of limitations.''
		+
		+	*Sub-reports are not supported.
		+	*Images embedded in reports are not supported.
		+	*Only parameters of types 'java.lang.String' and 'java.lang.Date' are supported. All other parameters will be ignored.
	<br/>		<br/>

ampEducator:Release Notes

2010-08-31T19:27:09Z

Release 2.3.25 (Anticipated Sep 3, 2010)

←Older revision		Revision as of 19:27, 31 August 2010
Line 9:		Line 9:
	*Database Sandbox		*Database Sandbox
	**A mySql sandbox database is now available which will let you run sample queries for custom reports. To use the sandbox you must enable your account under Institution->Preferences.		**A mySql sandbox database is now available which will let you run sample queries for custom reports. To use the sandbox you must enable your account under Institution->Preferences.
		+	*Course Scheduling & Attendance
		+	**You can now setup, schedule and take attendance for courses with multiple events in each day.

	===General Changes===		===General Changes===

ampEducator - Recent changes [en]

ampEducator:Release Notes

ampEducator:How Do I ampEducator

ampEducator:Release Notes