Wiki source code of Competent - iTrivio integration
Version 30.1 by Josef Vencl on 2020/10/12 12:39
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
2.1 | 1 | = Software to be installed = |
| 2 | |||
| 3 | //Unless stated otherwise, newer stable versions of the program should work.// | ||
| 4 | |||
 |
26.1 | 5 | ==== [[iTrivio 2.9.017>>doc:Main.Official manuals.iTrivio installation manual.WebHome]] ==== |
| |
2.1 | 6 | |
| 7 | ==== [[Competent 33>>doc:Main.Official manuals.Competent installation manual.WebHome]] ==== | ||
| 8 | |||
| 9 | |||
| |
5.1 | 10 | = Introduction = |
| 11 | |||
| |
13.1 | 12 | //On this page we use the term "Course" for both: course and test in iTrivio.// |
| |
5.1 | 13 | |
| |
12.1 | 14 | The integration of Competent and iTrivio provides features from both softwares merged together and accessible through Competent. |
| |
5.1 | 15 | |
| |
13.1 | 16 | When specific objects are created (and deleted) in Competent, they are automatically created (and deleted) in iTrivio as well. Competent stores the ID references to the iTrivio objects in it's database. |
| |
5.1 | 17 | |
| |
7.1 | 18 | This applies to creation of: |
| |
5.1 | 19 | |
| |
6.1 | 20 | * Users |
| |
7.1 | 21 | * Courses (Activities with the specific launch type iTrivio) |
| |
6.1 | 22 | * User-Course assignments |
| 23 | * User-Course attempts | ||
| |
5.1 | 24 | |
| |
7.1 | 25 | iTrivio application is accessible only throught specific links in Competent when: |
| |
5.1 | 26 | |
| |
7.1 | 27 | * editing a content of Course |
| 28 | * playing a Course | ||
| |
6.1 | 29 | * displaying specific User-Course reports |
| |
5.1 | 30 | |
| |
7.1 | 31 | The links to iTrivio contain a one time auto-login security token that approves the current user's action in iTrivio. There is no need for the user to log into iTrivio system manually. |
| |
5.1 | 32 | |
| |
7.1 | 33 | By default the password of a user in iTrivio is different (random) from his password in Competent to prevent direct access to iTrivio. We recommend to disable iTrivio emailing and to keep iTrivio user's password secret to the user. |
| 34 | |||
| |
6.1 | 35 | (% class="box warningmessage" %) |
| 36 | ((( | ||
| 37 | **Modifying iTrivio directly (out of Competent platform) can cause synchronization issues, especially when manipulating with Users, Courses, User-Course attempts and assignments.** | ||
| 38 | ))) | ||
| |
2.1 | 39 | |
| |
7.1 | 40 | The configuration below describes the basic scenario where |
| |
2.1 | 41 | |
| |
5.1 | 42 | * both iTrivio and Competent are fresh installations |
| |
7.1 | 43 | * login with the default iTrivio and Competent admin accounts were successfully tested |
| 44 | * Competent will be the main platform to handle course creation/deletion, user management and user-course management. | ||
| |
2.1 | 45 | |
| |
7.1 | 46 | Contact Educasoft for specific configuration procedure in other, more complex scenarios (e.g. Competent is going to use existing iTrivio application already filled with course/user data). |
| |
3.1 | 47 | |
| |
7.2 | 48 | = Systems preparation = |
| 49 | |||
| 50 | In order for the two systems to work together, we first have to create the basic structures they will operate with - users, folders etc. | ||
| 51 | |||
| 52 | === __Competent__ === | ||
| 53 | |||
| 54 | If you have both systems as a fresh installations and you will use them only throught the Competent system, you can skip this step and go to the iTrivio preparation. | ||
| 55 | |||
| 56 | 1. We need to decide what subtypes we want to use for new Users and new Activites in the use case, when we would need to synchronize users and courses from iTrivio into Competent. This will not typically happen if you will use the systems as described above. | ||
| |
14.1 | 57 | 1*. If you want new Users and Activities to be of default subtype, you don't need to create anything. |
| 58 | 1*. If you want new Users and Activities to be of some other subtype | ||
| |
7.2 | 59 | 1**. Log into Competent as the admin user |
| 60 | 1**. switch to the Admin view | ||
| 61 | 1**. go to the page Settings, to the tab Subtypes and create new subtypes for User and Activity (click on the green plus icon, fill in the new subtype name and hit the Create button). | ||
| 62 | 1. Furthermore we need to create a folder, that would hold all the iTrivio courses in case of synchronization from iTrivio, so | ||
| 63 | 1*. Log into Competent as the admin user and switch to the Admin view (if you didn't already) | ||
| 64 | 1*. Go to the Competent page Activities and create a new folder named for example iTrivio Courses (click on the green plus icon, choose Folder, fill in it's name and click Save). | ||
| |
18.1 | 65 | 1. If you want some other user than the default Competent admin to be able to edit the iTrivio courses, create this user. Note that this user should have appropriate admin rights. We recommend to use the default admin for now. |
| |
7.2 | 66 | |
| 67 | === __iTrivio__ === | ||
| 68 | |||
| 69 | Here we need to create the users that will manipulate iTrivio courses and a folder to store them. | ||
| 70 | |||
| 71 | 1. Log into iTrivio as admin user and go to the **Courses & Tests** | ||
| 72 | 1. **Create a new folder** named for example Competent courses - this is where all your courses will be stored | ||
| |
7.4 | 73 | 1. If you want the company default admin user to manage all the courses and users creation in iTrivio, skip to step 7), otherwise |
| |
7.2 | 74 | 1. Go to **Administration **to the section **Users** |
| |
7.4 | 75 | 1. **Create new user** that will be responsible for manipulating all objects in iTrivio (courses and users). Fill just his email, name and surename and assign him the role Administrator. |
| |
7.2 | 76 | 1. Optionally you can create another new user that will be responsible only for creating new users in iTrivio |
| |
14.1 | 77 | 1. Go to the **Usergroups administration** and create new usergroup (for example Competent users) - this is where all your new users will be assigned. |
| |
7.2 | 78 | |
| |
7.4 | 79 | === __Databases info__ === |
| |
7.2 | 80 | |
| |
14.1 | 81 | Now we need to write down IDs of all the objects we just created (and some more). If you have both systems as fresh installations, you did not create any specific subtypes in Competent and users in iTrivio, you can just use the default values from brackets. |
| |
7.2 | 82 | |
| |
14.1 | 83 | 1. __Competent__ database, in the table __subtype__ write down |
| |
7.2 | 84 | 1*. **USER_SUBTYPE **(by default 1) = subtype ID of the default_user (column "name") or if you created a specific subtype, find it by its name and write down it's ID |
| 85 | 1*. **ACTIVITY_SUBTYPE **(by default 2) = subtype ID of the default_timeless_activity (column "name") that has "activity_type_id" = 1. If you created a specific subtype, find it by its name and write down it's ID | ||
| |
14.1 | 86 | 1. __Competent__ database, in the table __activity_set__ write down |
| |
7.4 | 87 | 1*. **ACTIVITY_FOLDER **(by default 1) = ID of the folder you created for new itrivio courses (find by name in the column "name") |
| |
14.1 | 88 | 1. __iTrivio__ database, in the table __company__ write down |
| |
20.1 | 89 | 1*. **COMPANY_ID **(by default 1) = ID of the company that will be synchronized with Competent (find by name in the column "name") |
| |
7.4 | 90 | 1*. **COMPANY_URL **(by default empty) = value from the column "urlContext" of the company that will be synchornized with Competent (find by name in the column "name") |
| |
14.1 | 91 | 1. __iTrivio__ database, in the table __course__ write down |
| |
7.4 | 92 | 1*. **COURSE_FOLDER **(by default 1) = ID of the folder that you created for new courses created from Competent (find by name in the column "name") |
| |
14.1 | 93 | 1. __iTrivio__ database, in the table __itrivio_user__ write down |
| |
7.4 | 94 | 1*. If you skipped the steps 4) - 6) in iTrivio preparation and you are using fresh iTrivio instalation, just write down the default values |
| 95 | 1*. **ADMIN_CREATOR **(by default 2) = ID of the user that will be creating all the users and courses in iTrivio | ||
| 96 | 1*. **ADMIN_USER_CREATOR **(by default 2) = ID of the user that will be creating all the users in iTrivio | ||
| |
14.1 | 97 | 1. __iTrivio__ database, in the table __usergroup__ write down |
| |
7.4 | 98 | 1*. **USERGROUP **(by default 1) = ID of the usegroup that all your new users will be assigned to |
| |
7.2 | 99 | |
| |
30.1 | 100 | Beside these ids from database you might need these two optional course ids: |
| |
28.1 | 101 | |
| |
30.1 | 102 | * **COURSE_TEMPLATE_ID** - a course id that will be used as a template for newly created courses. |
| 103 | * **TEST_TEMPLATE_ID** - a test id for newly created tests | ||
| 104 | |||
| |
7.4 | 105 | = Configuration = |
| |
3.1 | 106 | |
| |
7.5 | 107 | Now you can modify the systems configuration files, use the values written down from databases. |
| 108 | |||
| |
7.4 | 109 | === __Competent__ === |
| |
3.1 | 110 | |
| |
18.1 | 111 | First we need to manually connect the first two users: |
| |
7.4 | 112 | |
| |
21.1 | 113 | * Go to the Competent database once more, to the table __user_mt__ and find either the default Competent admin (by login "admin" and typically it will be the user with ID=1) or the other user you created in the Competent preparation step (for editing your iTrivio courses). |
| 114 | * Find the column external_id and instead of NULL fill in the **<ADMIN_CREATOR>** value. | ||
| |
19.1 | 115 | * For now, this user will be the **only one** in your company that will be able to edit the iTrivio courses. Other users with appropriate rights can only create/delete/run them. |
| |
18.1 | 116 | |
| 117 | Now open the **application.properties** file and set the following propeties: | ||
| 118 | |||
| |
7.5 | 119 | {{code language="properties"}} |
| 120 | #-# set to true if enabled | ||
| 121 | competentItrivioIntegration.enabled=true | ||
| |
3.1 | 122 | |
| |
7.5 | 123 | #-# itrivio company url context, leave empty if company has no url context |
| 124 | competentItrivioIntegration.itrivioCompanyUrlContext=<COMPANY_URL> | ||
| 125 | |||
| 126 | #-# url of iTrivio app (for integration API communication - accessible from Competent server location) | ||
| 127 | competentItrivioIntegration.url=http://localhost:8080/ | ||
| 128 | |||
| 129 | #-# url of iTrivio app (for generating user links - accessible from browser of users) | ||
| 130 | competentItrivioIntegration.linkUrl=http://localhost:8080 | ||
| 131 | |||
| 132 | #-# integrated iTrivio db company ID | ||
| 133 | competentItrivioIntegration.itrivioCompanyId=<COMPANY_ID> | ||
| 134 | |||
| |
28.1 | 135 | #-# iTrivio db course ID, which will be used as a template for new test |
| 136 | # can be null, than the test will be empty | ||
| |
30.1 | 137 | competentItrivioIntegration.itrivioTestTemplateId=<COURSE_TEMPLATE_ID or EMPTY> |
| |
28.1 | 138 | |
| 139 | #-# iTrivio db course ID, which will be used as a template for new course | ||
| 140 | # can be null, than the course will be empty | ||
| |
30.1 | 141 | competentItrivioIntegration.itrivioCourseTemplateId=<TEST_TEMPLATE_ID or EMPTY> |
| |
28.1 | 142 | |
| |
7.5 | 143 | #-# -------------- COMPETENT INTEGRATION ------------ |
| 144 | #-# --- From Competent to iTrivio synchronization --- | ||
| 145 | |||
| 146 | #-# iTrivio db user ID, which will be used as a creator iTrivio ID when creating new users in iTrivio | ||
| 147 | competentItrivioIntegration.userCreatorItrivioUserId=<ADMIN_USER_CREATOR> | ||
| 148 | |||
| 149 | #-# iTrivio db user ID, which account will be used to perform actions in iTrivio (such as creating courses and users) | ||
| 150 | competentItrivioIntegration.auth.userId=<ADMIN_CREATOR> | ||
| 151 | |||
| 152 | #-# need to be same as "environment.id" property in iTrivio "settings.properties" file | ||
| 153 | competentItrivioIntegration.auth.environment=PROD | ||
| 154 | |||
| 155 | #-# need to be same as "jwt.key" property in iTrivio "settings.properties" file | ||
| |
22.1 | 156 | competentItrivioIntegration.auth.key=SECRET_CODE_CHANGE_IT |
| |
7.5 | 157 | |
| 158 | #-# -------------- COMPETENT INTEGRATION ------------ | ||
| 159 | #-# --- From iTrivio to Competent synchronization --- | ||
| 160 | |||
| 161 | #-# competent db subtype ID, which will be used when creating new Users in Competent | ||
| 162 | competentItrivioIntegration.newUserSubtypeId=<USER_SUBTYPE> | ||
| 163 | |||
| 164 | #-# competent db subtype ID, which will be used when creating new Activities in Competent | ||
| 165 | competentItrivioIntegration.newActivitySubtypeId=<ACTIVITY_SUBTYPE> | ||
| 166 | |||
| 167 | #-# competent db activitySet (folder) ID, which will be used when creating new Activities in Competent as parent folder ID | ||
| 168 | competentItrivioIntegration.newActivityTargetFolderId=<ACTIVITY_FOLDER> | ||
| 169 | {{/code}} | ||
| 170 | |||
| |
3.1 | 171 | = iTrivio part = |
| 172 | |||
| |
7.5 | 173 | Run the url "http(s):~/~/<yourdomain>:<port>/(companyUrl/)setCompanyConfig.html" on the domain and port your iTrivio runs and with the companyUrl of the company you are setting this for. |
| |
3.1 | 174 | |
| |
7.5 | 175 | Fill in the settings COMPETENT_INTEGRATION_XXX: |
| |
3.1 | 176 | |
| |
7.5 | 177 | * **COMPETENT_INTEGRATION_ENABLED// //**//check the box to be set to true// |
| 178 | * **COMPETENT_INTEGRATION_TARGET_FOLDER_ID** = <COURSE_FOLDER> | ||
| 179 | * **COMPETENT_INTEGRATION_API_URL **//(url where Competent is running eg.: //[[http:~~/~~/localhost:9000/>>url:http://localhost:9000/]]//)// | ||
| 180 | * **COMPETENT_INTEGRATION_USERGROUP_ID** = <USERGROUP> | ||
| |
18.1 | 181 | * **COMPETENT_INTEGRATION_COURSE_TEMPLATE** = //leave this option blank, for now it has no effect on the system// |
| |
3.1 | 182 | |
| |
7.6 | 183 | Save the setting with the **Odeslat **button (nothing visible will happen, don't be worried, it was saved) |
| |
3.1 | 184 | |
| |
7.5 | 185 | Now open the file "/com.itrivio/src/main/resources/settings.properties" and set the two following properties: |
| |
3.1 | 186 | |
| |
7.5 | 187 | {{code language="properties"}} |
| |
24.1 | 188 | # custom environment name, e.g. PROD,DEV,TEST... |
| 189 | # (must match the competentItrivioIntegration.auth.environment property from Competent) | ||
| |
7.5 | 190 | environment.id=PROD |
| |
3.1 | 191 | |
| |
7.5 | 192 | # secret part of you JWT key - used for communication with the Competent system and creating auto-login links |
| 193 | # (must match the competentItrivioIntegration.auth.key property from Competent) | ||
| |
23.1 | 194 | jwt.key=SECRET_CODE_CHANGE_IT |
| |
7.5 | 195 | {{/code}} |
| |
3.1 | 196 | |
| 197 | = Final setting test = | ||
| 198 | |||
| |
15.1 | 199 | * Now run (or restart) both Systems, **but from now on do not touch iTrivio **apart from making changes in the course creator tool when redirected there from Competent. |
| |
18.1 | 200 | * Log into Competent (as the user able to edit iTrivio courses), go to the Admin view to the Activities page. |
| |
7.7 | 201 | * Create an Activity (of whatever subtype) and go to it's tab Details |
| 202 | * Edit the Launch type property, set it to iTrivio and hit the Save and Create in iTrivio button | ||
| 203 | * If you get any errors, check the configuration if all is set properly | ||
| |
8.1 | 204 | * Click the Edit button, it should take you to the iTrivio course editor, so add one new slide here, save it and close the browser tab. |
| 205 | * Click the Start button, it should launch the iTrivio course for you. | ||
| 206 | * If all this works, everything is set correctly |