Please help us help you and fill where relevant:
LimeSurvey version: 6.10
Own server or LimeSurvey Cloud: Own
Survey theme/template: Fruity
==================
Hi there people, today my question is this, i start to try to connect Power bi to the Limesurvey database to make informs, i be able to do it, all right until that.

But my problem comes when i open the responses from the table of the database and all information comes with the codes of the questions, the codes of the subquestions, etc.

So my question is, where on the limesurvey databases can i get the correlationship between SGQA codes, subquestion codes and text of the subquestion?

I almost get that info from tools-- logic review, but there i dont have the SGQA on that place, can anyone help me? or tell me where can i find stored that info on lime survey or on the limesurvey database?

Thanks for the help.

Hi,

You can export VV file 2 times for example : one with new version (use EM code), one with old version (us SGQA)
Or use gitlab.com/SondagesPro/coreAndTools/getQuestionInformation plugin

Ok, first of all, thanks for the help, i try to download the vv in both versions, but i have 2 problems.
  1-I dont see the SGQA code.
  2-I dont see any difference between download on the old version or new version of vv, i attach captures.

New version of vv:  
Old version of vv: 

Ant on the other side, i try tu install the plugin, i unzip it the "getQuestionInformation-master" on the plugin folder of my Limesurvey, but im not sure how to use it, i didnt see the plugin on the plugin list or is a plugin that just add a functionality that i dont see? Can you help me on that way? 

And other thing, the link on this section of the plugin dont work:Via ZIP dowload

• Get the file getQuestionInformation.zip
• Extract :
  Code:

  unzip getQuestionInformation.zip

• Move the directory to plugins/ directory inside LimeSurvey

I have to download via code--download source code-download zip
 

Edit: I upload the plugin using the uploader from Limesurvey too, but still dont find the plugin or how to use it.

brais24 wrote:

And other thing, the link on this section of the plugin dont work:Via ZIP dowload
 

Just tested : no issue
 
 

Else : it's an helper : gitlab.com/SondagesPro/coreAndTools/getQ...ionInformation#usage

 

When i try to install it using the loader from Limesurvey gives me an error, the error say "El plugin no se pudo instalar o actualizar: No se pudo analizar el fichero config.xml." wich means "The plugin cannot install or update. the file config.xml was not able to analyze".

Any idea?

Here the screenshot.
 

Edit: I be able to install it, but i have to download the zip, unzip it, take the content out of the main folder where is located and create the same zip with the files directly, what was happening was that the plugin was trying to be installed in a loop folder, i mean it was creating 2 folders like this "getQuestionInformation-master" then another "getQuestionInformation-master" and then the files of the plugin.

I will try to test the plugin right now.

brais24 wrote:

Edit: I be able to install it, but i have to download the zip, unzip it, take the content out of the main folder where is located and create the same zip with the files directly, what was happening was that the plugin was trying to be installed in a loop folder, i mean it was creating 2 folders like this "getQuestionInformation-master" then another "getQuestionInformation-master" and then the files of the plugin.
 

Then you didn't get it via dl.sondages.pro : I test directly this one.

You get the gitlab files.