SQL compatibility Level Recommendation for your Database
Jul 28, 2010
For best results we recommend you set the compatibility level of your database to match the version of SQL server you are running the database on. So if you have a SQL 2000 or 2005 db you have restored onto a new SQL 2008 server you should set it...
|
Downloading report data to Excel? Hate choosing it twice due to security prompts?
Jul 12, 2010
If you have ever tried using the “Download to Excel” button in our Reports you have probably noticed that after selecting the fields you want in the download, IE prompts you to allow the download and you have to go through your...
|
Send a link to a catalog that includes search criteria
Jun 14, 2010
Have you ever wished you could email a hyperlink to your users that would load the catalog in the Learning Center with a search already performed for them? If you have version 8.2 or greater, you can do this easily. Just customize the example...
|
How to move UniversitySite to a new Server
May 5, 2010
These steps use UniversitySite as an example but the procedure is identical for SupportSite with the exception of the folder name J. Backup your UniversitySite database, and then restore the latest backup to your new SQL server. Create the new...
|
No way they finished it that fast!
May 4, 2010
Need a quick way to find out how long people took to complete their eLearning? Use the following script to get a handy list showing the users, their eLearning records, and how long in seconds they took to complete them. Script is below: select...
|
Update multiple settings for eLearning via SQL
Dec 8, 2009
If you need to make changes to settings for all your eLearning currently loaded in UniversitySite and you have access to SQL query analyzer you can make use of scripts, after dutifully backing up your database first, to adjust them very quickly....
|
Want to set all your course prefixes to use UPPER CASE?
Dec 8, 2009
It's easy if you have access to SQL query analyzer. Just run this script. update trainingcourses set prefix = UPPER(prefix)
|
Why is the Progress Report inconsistent with other reports?
Aug 12, 2009
This article applies to versions of UniversitySite prior to 7.5.3. Many people have noticed that when they review the learning history in the Progress report in the Learning Center, the default view, which is “Achievements” may not...
|
Confused by the GMT time stamp in the body of meeting requests?
Apr 3, 2009
Some of our customers have noticed that some of their users get meeting requests that are a bit confusing since the time stamp inside the body of the meeting request is in GMT time which is not normally recognized by users. The date/time stamp...
|
“Automatically compute completion status”: What it’s for and how to use it.
Mar 27, 2009
“Automatically compute completion status” is a checkbox that can be enabled/disabled on a roster when you are recording attendance. It is typically used when you need to disable it so as to record attendance separately from course...
|