The Web-SP project

Release notes 3.0 upgrade

Upgrade notes(from 2.2):
		Because the 3.0 release uses a more flexible way of displaying localized data through the use of templates, a few changes 
		needs to be done to the database.
		It is our recommendation that a complete backup of the database should be performed prior to upgrading.

		After upgrading by unpacking the entire zip/tgz into the correct directory and changing the systems preferred 
		language (see: for more information on this) 
		to your desired language, you will notice that some menus and top level category names are displayed in english.
		Even if english is the language you want, it is possible that some of this default data is incorrect, so we advise
		you to go through this following section even if you are in fact using the english version.
		In order to fix this you will need to be somewhat comfortable	with editing the SQL-database by hand.

		Step 1(changing the "top-level" menus):
			Take a look at the table "TemplateMenuItem" with the SQL command: 
			SELECT DISTINCT name from TemplateMenuItem;
			You should get output similar to:
			| name                 |
			| introduction         | 
			| patient interview    | 
			| physical examination | 
			| lab tests            | 
			| diagnosis            | 
			| therapy              | 
			| feedback             | 
			| performed exams      | 
			| references           | 
			| activity log         | 
			10 rows in set (0.01 sec)
		These are the same strings that appear in the main menu of WebSP after selecting a patient, in order to 
		change one of them you can use a command similar to:
		UPDATE TemplateMenuItem SET name="new-name" WHERE name="old-name";
		You will need to do this for each of the items in this table, for example:
		UPDATE TemplateMenuItem SET name="aktivitetslogg" WHERE name="activity log";
		UPDATE TemplateMenuItem SET name="återkoppling" WHERE name="feedback";

		Step 2(changing supercategories in MedicalHistory/LabTest/Physical):
			The three tables involved here are "MhqCategoryEntity","LtCategoryEntity" and
			PhysicalExamCategory". First use a command to display the number of unique supercategories:
			SELECT DISTINCT categoryName FROM LtCategoryEntity WHERE superCategory IS NULL;
			| categoryName |
			| biochemistry | 
			| hematology   | 
			| immunology   | 
			| microbiology | 
			| pathology    | 
			| pharmacology | 
			| radiology    | 
			| misc         | 
			8 rows in set (0.00 sec)
			For each of these entries, use the following command to alter it:
			UPDATE PhysicalExamCategory SET categoryName="new-name" WHERE categoryName="old-name" AND superCategory IS NULL;
			Repeat this for the other two tables, and you should be finished with the upgrade.

			Start the server and verify that all menus and categories are displayed correctly.

© LIME, Karolinska Institutet