lms-canvas-reports-dashboard

LTI tool which displays a dashboard of customizable reports

Building with custom variable replacement service

The default implementation does basic variable replacements with information gathered from LTI launch details. Anything beyond that needs to be done with a custom implementation.
Build the tool, while enabling a custom variable replacement service:

mvn clean install -P var-repl-ser -Dvariable-replacement-service.groupId=edu.iu.uits.lms -Dvariable-replacement-service.artifactId=lms-iu-variable-replacement-service -Dvariable-replacement-service.version=5.0.2

Running standalone

Add env vars or system properties as desired.

ENV Property	System Property	Default Value	Description
APP_FULLFILEPATH	app.fullFilePath	/usr/src/app/config	Directory for configuration files
APP_OVERRIDESFILENAME	app.overridesFileName	overrides.properties	Customizable filename for additional configurations. Would be located in the above directory.
SPRING_PROFILES_ACTIVE	spring.profiles.active		Supply spring profiles to activate. See configuration details below for potential values.
APP_ENV	app.env	dev	Environment designator. Free-form and can be used for your own purposes. Shows up in the application footer.
LTI_CLIENTREGISTRATION_DEFAULTCLIENT	lti.clientregistration.defaultClient	canvas	Specify the launching configuration to expect (canvas/saltire)
APP_CUSTOMSERVICEPACKAGE	app.customServicePackage		Specify the package where the variable replacement service config is located

Setup Database

After compiling, see target/generated-resources/sql/ddl/auto/postgresql9.sql for appropriate ddl. Insert a record into the LTI_13_AUTHZ table with your tool's registration_id (lms_reports), along with the client_id and secret from Canvas's Developer Key. An env designator is also required here, and allows a database to support multiple environments simultaneously (dev and reg, for example).

Test a local launch

Startup the application with the LTI_CLIENTREGISTRATION_DEFAULTCLIENT value set to saltire. Use an LTI tool consumer launcher, like https://saltire.lti.app/platform. Default values are fine, with the below exceptions...

In the Message section, set the following:

Property	Value
Custom parameters	canvas_course_id=123456 canvas_user_login_id=johnsmith instructure_membership_roles=http://purl.imsglobal.org/vocab/lis/v2/membership#Instructor

Use an appropriate canvas_course_id and canvas_user_login_id.

From the Security Model section, set the following:

Property	Value
LTI version	1.3.0
Message URL	http://localhost:8080/app/launch
Client ID	dev (or whatever is appropriate based on the record inserted in the database table from above)
Initiate login URL	http://localhost:8080/lti/login_initiation/lms_reports
Redirection URI(s)	http://localhost:8080/lti/login

Canvas JSON

Example json for the tool can be found in the examples directory.

Configuration

If choosing to use properties files for the configuration values, the default location is /usr/src/app/config, but that can be overridden by setting the APP_FULLFILEPATH value via system property or environment variable. You may use security.properties, overrides.properties, or set the APP_OVERRIDESFILENAME value with your desired file name.

Canvas Configuration

The following properties need to be set to configure the communication with Canvas and Canvas Catalog. They can be set in a properties file, or overridden as environment variables.

Property	Default Value	Description
canvas.host		Hostname of the Canvas instance
canvas.sso.host		Hostname of the Canvas OIDC auth domain
canvas.baseUrl	https://${canvas.host}	Base URL of the Canvas instance
canvas.baseApiUrl	${canvas.baseUrl}/api/v1	Base URL for the Canvas API
canvas.token		Token for access to Canvas instance
canvas.accountId		Your institution's root accountId in your Canvas instance
catalog.baseUrl		Base URL of the Canvas Catalog instance
catalog.baseApiUrl	${catalog.baseUrl}/api/v1	Base URL for the Canvas Catalog API
catalog.token		Token for access to the Canvas Catalog instance

Database Configuration

The following properties need to be set to configure the communication with a database. They can be set in a properties file, or overridden as environment variables.

Property	Description
lms.db.user	Username used to access the database
lms.db.url	JDBC URL of the database. Will have the form jdbc:<dbtype>://<host>:<port>/<database>
lms.db.password	Password for the user accessing the database
lms.db.poolType	Fully qualified name of the connection pool implementation to use. By default, it is auto-detected from the classpath.

Configure support contact information

The following properties need to be set to configure the contact information on the global error page. They can be set in a security.properties file, or overridden as environment variables.

Property	Description
lti.errorcontact.name	Display name for your support organization
lti.errorcontact.link	Contact mechanism - URL or mailto:email (e.g. http://support.school.edu or mailto:support@school.edu)

LTI issuer configuration

Be sure to configure an environment appropriate issuer for the Canvas instance that is launching the tool.

See https://canvas.instructure.com/doc/api/file.lti_dev_key_config.html#overview-of-an-lti-launch for details.

Property	Description
canvas.issuer	Issuer for the Canvas instance doing the LTI tool launch

Denodo Configuration

To enable the Denodo configuration, include the value denodo into the SPRING_PROFILES_ACTIVE environment variable. Be aware that if the tool requires multiple values, that there could be more than one profile value in there. Make sure when you build with maven that you use the -P denodo parameter. Also, make sure if you run this locally in IntelliJ that you enable the denodo profile in the maven tab list of profiles. The following properties need to be set to configure the communication with the Denodo database.
They can be set in a properties file, or overridden as environment variables.

Property	Description
denodo.db.driverClass	JDBC Driver class name
denodo.db.url	JDBC URL of the Denodo database. Will have the form jdbc:vdb://<host>:<port>/<database>
denodo.db.user	Username used to access the Denodo database
denodo.db.password	Password for the user accessing the Denodo database

Redis Configuration (optional)

If you would like to use Redis for session storage, you will need to enable it by including the value redis-session into the SPRING_PROFILES_ACTIVE environment variable. Be aware that if the tool requires multiple values, that there could be more than one profile value in there.

Additionally, the following properties need to be set to configure the communication with Redis. Then can be set in a properties file, or overridden as environment variables.

Property	Description
spring.redis.host	Redis server host.
spring.redis.port	Redis server port.
spring.redis.database	Database index used by the connection factory.
spring.redis.password	Login password of the redis server.

Vault Configuration (optional)

If you would like to use HasiCorp's Vault for secure property storage, you will need to enable it by including the value vault into the SPRING_PROFILES_ACTIVE environment variable. Be aware that if the tool requires multiple values, that there could be more than one profile value in there. Include any spring.cloud.vault.* properties that your environment requires in a properties file, or override as environment variables.

Exposing the LTI authz REST endpoints

If you would like to expose the LTI authz endpoints in this tool (for CRUD operations on the LTI authorizations), you will need to enable it by including the value ltirest into the SPRING_PROFILES_ACTIVE environment variable. Be aware that if the tool requires multiple values, that there could be more than one profile value in there.

Enabling swagger-ui for the LTI authz REST endpoints

⚠️ Experimental ⚠️

If you would like to enable the swagger-ui for interacting with the endpoints, include the value swagger into the SPRING_PROFILES_ACTIVE environment variable. Once enabled, the ui will be available at /api/lti/swagger-ui.html. There are some additional OAuth2 considerations that need to be accounted for while using this setup.

This is marked as experimental due to the fact that we aren't running with this option at IU. We are running into CORS issues when trying to talk to our OAuth2 service via swagger, so we can't verify if it really works or not!

Using variables in the report URLs

Variables can be used in report URLs which the system will replace with appropriate values.
Supported variables in the default implementation:

• ${USER_ID}
• ${USER_EID}
• ${USER_FIRST_NAME}
• ${USER_LAST_NAME}
• ${USER_ROLE}
• ${CANVAS_COURSE_ID}

Variables requiring a custom implementation:

• ${SIS_COURSE_ID}
• ${CLASS_NBR}
• ${SIS_TERM_ID}
• ${SIS_CAMPUS}