Manage questions-skills links

Understand the Questions-Skills Links page

Open the menu Skills >  Question-skills connections

This page describes and allows, according to your privileges, to view, modify or delete the links between questions and skills.

On this page, you have an Import button and an Export button at the top, followed by a filter to search for a question or skill level.

Questions/skills access and management

• Access the edit card for a skill by clicking on its name.

• To access a question's edit card, the following visibility management rules are applied:

  • The question sheets included in your scope are accessible by clicking on their name.

  • The out-of-scope question sheets are visible for information purposes but are not clickable.

• To change the level of a question-skill link, click the ⏷ icon next to "Level."

• For any other action, use the kebab menu to the right of the question.

Simple import or full import?

• The simple import only imports question-skills links. Fields are defines in this order: QuestionExternalId ; SkillExternalId ; Level

• The full import is the one that allows you to import a question and all the links to the various skills at once.

For more details on values and rules please read the following sections.

Understand the import file

We recommend using Excel to better handle the format and special characters for you .csv import and export files.

The export file has exactly the same format as the import file. It is therefore also strongly recommended to start from an export file before re-importing.

Understand single- and multi-valued columns

There are two types of columns:

• those that accept only one value at a time and,

• those who accept several.

Columns with only one possible value cannot contain any special characters, other than those specific to the csv format. Either the value is valid as is, or it will report an error during the import.

Columns with the ability to enter multiple values at once use the same format:

• Each value must be separated directly by the '|' character (Alt gr + 6).

• There should be no space between the value and '|', or an error may occur.

• Columns work as a group: if one of these columns displays 3 values, the other columns in the group must have exactly 3 values, or have none.

• Any line that does not comply with these rules will be reported in error and will not be imported.

Columns with a single value

• QuestionType

• ExternalId

• Name

• Quick

• Feedback

• MaxChoices

• MinChoices

• Code

• ScoringType

• PrimaryDomain.GroupView.ExternalId

• Keywords

• Author

• UpdatedOn

• ToDelete

Columns with multiple values:

Columns of the group of proposals:

• Proposals.Text

• Proposals.Points

• Proposals.Feedback

• Proposals.IsSelected

Columns in the Skill Links group:

• Skills.ExternalId

• SkillsLevel

Column values

Constraint on characters:

It will be specified which characters are allowed for each field. Note that this includes special characters specific to the csv format: if it is not explicitly specified that these characters are denied, then they are allowed, but only if they are properly escaped.

By using a spreadsheet, the problem should not arise. However, if an entry has an error, check the characters ';', '"' and line breaks and make sure that they are properly escaped.

Interpretation of values and language of the application:

The handling of some fields depends on the language of the application. For example, for decimal values, if the application is in French, you should use a comma to indicate the decimals. Using a point will throw an error.

If the application is in English, the period will indicate decimals and commas will be ignored (1.5 will become 15).

NB: This also applies to exports.

• QuestionType: Indicates the type of the question. Only the "QCU" and "MCQ" values are possible. The field cannot be empty.

• ExternalId: The external identifier of the question to be modified. If the identifier matches a question in the database, it will be changed. Otherwise, a new question will be created with this identifier. If no value is entered, it will be generated. All characters are accepted, although it is recommended to limit the use of special characters.

• Name: The title of the question. All characters are accepted.

• Prompt: The question itself. All characters are accepted.

• Feedback: The text providing additional information after the user's answer choice. All characters are accepted.

• MaxChoices: The maximum number of answer choices. Must be positive and higher than MinChoices, but less than the number of proposals. Can only contain numeric characters.

• MinChoices: The minimum number of answer choices. This number must be positive and less than MaxChoices and the number of proposals. Can only contain numeric characters.

• Proposals.Text: All the texts of the different proposals. Texts must be separated by '|'. The number of texts must correspond to the total number of proposals and must be the same between the different fields related to the proposals, or be entirely empty. Apart from the '|' character, all characters are accepted.

• Proposals.Points: All the points of the different proposals. Values must be separated by '|'. The number of values must match the total number of proposals and must be the same across the different fields related to the proposals, or be entirely empty. If the field is empty, then the value of the proposals will be set to 0 by default. Negative and decimal values are accepted.

• Proposals.Feedback: All the feedback specific to the different proposals. Texts must be separated by '|'. The number of texts must correspond to the total number of proposals and must be the same between the different fields related to the proposals, or be entirely empty. Apart from the '|' character, all characters are accepted.

• Proposals.IsSelected: The set of selection values for the different proposals. Values must be separated by '|'. The number of values must match the total number of proposals and must be the same across the different fields related to the proposals, or be entirely empty. If the field is empty, then the value of the propositions will be set to false by default. Only True and False values are accepted. The breakage is not important.

• Code: Question code. All characters are accepted.

• ScoringType: The type of evaluation of the score of the question. Only the values RightOrWrong, Proportional and AdvancedScoring, as well as their numerical counterparts (0, 1 and 2 respectively) are accepted.

• PrimaryDomain.GroupView.ExternalId: The external identifier of the domain where the issue is handled. All characters are accepted. However, the value entered must match an existing domain.

• Keywords: Keywords of the question. All characters are accepted

• Author: The name of the author of the question. All characters are accepted.

• UpdatedOn: The date the question was updated. Present to keep the correspondence with the format of the export. Ignored on import.

• ToDelete: Indicates whether the question is to be deleted. This field cannot be empty. Only True and False values are accepted. The breakage is not important.

• Skills.ExternalId: A set of external skills identifiers to link to the question. Values must be separated by '|'. The number of identifiers must equal the number of skills. This field cannot be empty. Apart from the '|' character, all characters are accepted.

• SkillsLevel: The set of skill levels associated with the question. Values must be separated by '|'. The number of levels must be equal to the number of skills. This field cannot be empty. Only whole numbers between 1 and the maximum possible skill level, as well as the word 'delete', are allowed. Skills marked 'delete' will be deleted.

Perform a complete import

For complete imports, simply provide a document in csv format whose columns correspond to those listed on the pop-up. Note that the export has exactly the same format: it is therefore possible to reimport the file you have just exported.

Note that the number and order of the columns is important: if the format is not strictly followed, the file may not be processed, or the data may be incorrectly processed.

Procedure:

1. Open the Skills >  Question-skills connections.

2. Click the Import button.

3. In the mode that opens, select the .csv file you want to import by dropping it into the square or clicking the Select File button.

4. Click the Import button at the top of the modal.

   • A toast is displayed with a summary of the import processing. A downloadable file also allows a detailed view of this import.

Perform an export

You can export all the skill questions or perform a partial export based on the use of filters. In the example below, we're only exporting questions with the skill level = 3.

Procedure

1. Open Skills >  Question-skills connections.

2. Click the Export button.

3. In the toast that appears, click on the [Download] link to retrieve the exported .csv file.

4. Modify the contents of this file as necessary and import the .csv file.