This is an old revision of the document!

Introduction:

The QuestionOptionsLang table is responsible for storing multilingual text data for the options (answer choices) associated with each question option in the survey. This table allows each option to have different text based on the language selected by the respondent.

It contains multiple versions of the option text, including:

Graph Option Name: Text used in graphical reports.
Report Option Name: Text shown in the downloadable reports.
Import Option Name: Text displayed when importing the survey data.
Open Answer Name: Text for open-ended responses associated with the option.

The table is linked to the QuestionnaireDetailsOptions table via the optionid column and supports multilingual data based on the language column.

Below is the detailed structure of the QuestionOptionsLang table along with descriptions.

Sr. No.	Name	Type	Description
1	id	int	Unique identifier for each language record for the option. This is AUTO_INCREMENT.
2	optionid	int	Foreign key referring to the id of the fw_questionnaireoptions table. This links the text to a specific option.
3	language	varchar(20)	Stores the language code for the option text. Example: 'EN', 'NL', 'FR', etc.
4	optionname	varchar(250)	Contains the option text shown to the respondent in the survey. This text varies based on language.
5	graphoptionname	varchar(250)	Text used in graphical reports to represent the option. Often a shorter or summarized version.
6	reportoptionname	varchar(300)	Text that appears in downloadable reports when this option is selected. It can differ from the survey text to make the report more clear.
7	importoptionname	varchar(300)	Text used during data import as the column header for the option in import files.
8	importopenansname	varchar(300)	Text used in data import files for open text responses associated with the option. This appears as a separate column header.
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

1. 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
   ```

2. 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
   ```

3. 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
   ```

4. 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
   ```

5. importopenansname (Column 8):

This column acts as the import file header for open text responses.
Example:

```

   Import Open Answer Name: Reason_for_Satisfaction
   ```

6. 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

Performitor

Table of Contents

Introduction:

Explanation of Key Columns

Example Data