Differences

This shows you the differences between two versions of the page.

--- questionoptionslang [2025/03/10 06:34] – gloria
+++ questionoptionslang [2025/03/10 06:34] (current) – gloria
@@ Line 24: / Line 24: @@
 | 9           | **reportopenansname**             | varchar(300)   | Text shown in the **downloadable report** for open-ended responses. This ensures clear labeling of open text answers.         |
 | 10          | **addedfrommodlangsettings**      | int            | Indicates if the option text was added automatically from **Module Language Settings**. **0** = Manually added, **1** = Automatically added. |
-====== Explanation of Key Columns ======
-. **optionid (Column 2)**:
-   - Acts as a **foreign key** to the **fw_questionnaireoptions** table.
-   - This ensures that each option has multiple language versions linked to it.
-   - Example:
-     ```
-     Option ID: 101
-     English Text: Very Satisfied
-     Dutch Text: Zeer tevreden
-     French Text: Très satisfait
-     ```
-. **graphoptionname (Column 5)**:
-   - This column holds a **short version of the option text** that will be shown in **graphs (bar, pie, etc.)**.
-   - Example:
-     ```
-     Option Name: Very Satisfied
-     Graph Option Name: Satisfied
-     ```
-. **reportoptionname (Column 6)**:
-   - This text appears in the **PDF or Excel reports** under the selected option column.
-   - Example:
-     ```
-     Option Name: Very Satisfied
-     Report Option Name: Customer expressed high satisfaction
-     ```
-. **importoptionname (Column 7)**:
-   - This text is used in the **import file** to map options when importing survey data.
-   - It is usually the column header in CSV files.
-   - Example:
-     ```
-     Import Column Name: Satisfaction_Level_5
-     ```
-. **importopenansname (Column 8)**:
-   - This column acts as the **import file header** for open text responses.
-   - Example:
-     ```
-     Import Open Answer Name: Reason_for_Satisfaction
-     ```
-. **addedfrommodlangsettings (Column 10)**:
-   - This column shows whether the option text was:
-     - **0** = Manually added.
-     - **1** = Automatically fetched from **Module Language Settings**.
-   - This is helpful for tracking system-generated texts.
-====== Example Data ======
-Here’s an example of how data appears in the **QuestionOptionsLang** table:
-| optionid | language | optionname         | graphoptionname | reportoptionname     | importoptionname | importopenansname       | reportopenansname      | addedfrommodlangsettings |
-|-----------|----------|--------------------|-----------------|---------------------|------------------|------------------------|-----------------------|-------------------------|
-| 101       | EN       | Very Satisfied      | Satisfied       | Customer is satisfied | Satisfaction_5  | Reason_for_Satisfaction | Reason for satisfaction | 0                       |
-| 101       | NL       | Zeer tevreden       | Tevreden        | Klant is tevreden    | Tevreden_5      | Reden voor tevredenheid | Reden voor tevredenheid | 0                       |
-| 101       | FR       | Très satisfait      | Satisfait       | Client satisfait     | Satisfait_5     | Raison de satisfaction | Raison de satisfaction | 0                       |