Bonjour,
Je sollicite votre aide. Mes données matricielles ne s’affichent pas lorsque je les télécharge. Que faire?
Merci
Welcome back to the community, @leprince1 ! Maybe this post discussed previously should help you demonstrate how you could see the repeat group data:
@ukenfack , i was able to see the repeat groups in a different tab as highlighted in the image below:
[Image 1]
So please be informed that your repeat group data is there in the dataset and is not missing.
Hi Mr Kal_Lam!
Repeat group works well. But I’m not seen matrix data when downloading data.
Please could you look the project: Enketo Express for KoBo Toolbox
Data of the project:
BFMapping_the_career_of_the_Sahelian_groundwater_experts_Questionnaire_à_ladresse_des_établissements_de_formation.xlsx (26.9 KB)
Kal_Lam
February 4, 2022, 11:48am
4
@leprince1 , would you mind sharing with us the following through a private message so that we could have a closer look at it?
Username
Project name
Server
Kal_Lam
February 4, 2022, 12:11pm
6
Is this the matrix question that you say the data is missing from:
Yes, it is this one
Bè BONKIAN
GSM: (00226) 78 72 67 18
"L’Afrique a besoin d’un modèle de développement propre à elle même".
Yes. It is this one.
We have others like:
@leprince1 , isn’t this the data:
It isn’t. This data is from multricriteria question (2.1)
When downloading data from matrix questions, we get nothing.
Please look to Excel file. Yellow colums (matrix questions in project) no data
BFMapping_the_career_of_the_Sahelian_groundwater_experts_Questionnaire_à_ladresse_des_établissements_de_formation_03fev2022.xlsx (29.1 KB)
Kal_Lam
February 6, 2022, 2:04pm
11
@leprince1 , we will have a closer look at this and get back to you. Until then would you mind downloading your data as XLS (legacy) format?
It should solve your issue.
Wonderful. It is works!
a3dN4ydSz2mCkej4yz_test2.xlsx (26.0 KB)
Thank you!
1 Like
Josh
February 7, 2022, 10:49pm
15
Hi @leprince1 , it looks like your case is related to this issue:
opened 05:54PM - 20 Oct 21 UTC
bug
## Description
Community report: https://community.kobotoolbox.org/t/i-ve-got… -3-projects-that-are-not-downloading-mix-matrix-ranking-and-some-even-text-questions/23682/11
Zulip discussion: https://chat.kobotoolbox.org/#narrow/stream/4-KoBo-Dev/topic/Custom.20exports/near/66892
KoBo-specific question types don't export submission data correctly when filtering fields in "Advanced options".
## Steps to Reproduce
1. Use the a form with a KoBo question type (this one is from the [support page on Matrix questions](https://support.kobotoolbox.org/matrix_response.html#create-a-question-matrix-in-xlsform))
### survey
| type | name | label | required | kobo--matrix_list |
| --- | --- | --- | --- | --- |
| begin_kobomatrix | M1 | Items | | assets |
| select_one yn | Q1 | Q1. Which assets do you have at home | TRUE | |
| integer | Q2 | Q2. Number of assets | TRUE | |
| end_kobomatrix | | | | |
### choices
| list_name | name | label |
| --- | --- | --- |
| assets | car | Car |
| assets | bike | Bike |
| assets | tv | TV |
| yn | yes | Yes |
| yn | no | No |
### settings
| style |
| --- |
| theme-grid no-text-transform |
2. Submit some data
3. Export without any filter fields 👉 all data is exported
4. Export with any or all fields selected 👉 data from KoBo question type not exported. The following is is sent to the BE for filtering:
```
{
...
"fields": [
"M1/Q1",
"M1/Q2",
],
...
}
```
If we look at the asset `content.survey` JSON, we see why this is the case:
```json
[
{
"name": "M1",
"type": "begin_kobomatrix",
"$kuid": "Mex7rGeF6",
"label": [
"Items"
],
"$autoname": "M1",
"kobo--matrix_list": "assets"
},
{
"name": "Q1",
"type": "select_one",
"$kuid": "Vwi0pHZ4A",
"label": [
"Q1. Which assets do you have at home"
],
"required": true,
"$autoname": "Q1",
"select_from_list_name": "yn"
},
{
"name": "Q2",
"type": "integer",
"$kuid": "MlNQNjPMM",
"label": [
"Q2. Number of assets"
],
"required": true,
"$autoname": "Q2"
},
{
"type": "end_kobomatrix",
"$kuid": "wNIn8EeUO"
}
]
```
However, the `kobomatrix` group structure is [transformed behind the scenes](https://github.com/kobotoolbox/kpi/blob/master/kpi/utils/xlsform_preprocessors/kobomatrix_handler.py) resulting in this survey structure:
### survey
| type | name | label | appearance | required |
|---------------|----------------|------------------------------------------|-----------------------|------------|
| begin_group | M1_header | | w5 | |
| note | M1_header_note | **Items** | w1 | false |
| note | M1_header_Q1 | **Q1. Which assets do you have at home** | w2 | false |
| note | M1_header_Q2 | **Q2. Number of assets** | w2 | false |
| end_group | | | | |
| begin_group | M1_car | | w5 | |
| note | M1_car_note | ##### Car | w1 | false |
| select_one yn | M1_car_Q1 | | w2 horizontal-compact | true |
| integer | M1_car_Q2 | | w2 no-label | true |
| end_group | | | | |
| begin_group | M1_bike | | w5 | |
| note | M1_bike_note | ##### Bike | w1 | false |
| select_one yn | M1_bike_Q1 | | w2 horizontal-compact | true |
| integer | M1_bike_Q2 | | w2 no-label | true |
| end_group | | | | |
| begin_group | M1_tv | | w5 | |
| note | M1_tv_note | ##### TV | w1 | false |
| select_one yn | M1_tv_Q1 | | w2 horizontal-compact | true |
| integer | M1_tv_Q2 | | w2 no-label | true |
| end_group | | | | |
Therefore to correctly include all the matrix fields, the export data should look like this instead:
```
{
...
"fields": [
"M1_car/M1_car_Q1",
"M1_car/M1_car_Q2",
"M1_bike/M1_bike_Q1",
"M1_bike/M1_bike_Q2",
"M1_tv/M1_tv_Q1",
"M1_tv/M1_tv_Q1"
],
...
}
```
## Expected behavior
Export includes all selected data.
## Actual behavior
Data is missing.
In that case, please try exporting again using the non-legacy exports but with the switch “Select questions to be exported” toggled off (the issue is in filtering Matrix
type questions):
1 Like
Hi Josh. It is also working.
Thank you very much
1 Like
Hi @Kal_Lam and @Josh ,
I am posting here as it seems to be the consolidated thread for this kind of issue. Also, several other threads on this topic end with a private conversation, so the workarounds do not appear to be getting shared. This issue seems to have been popping up for a few years, so perhaps it would be good to make a note about it in the help article: Question Matrix Response Type — KoboToolbox documentation ?
Meanwhile, my issue is that, for my form with main language Portuguese (pt-pt), the returned data for kobomatrix type questions appear in the web app data tab, but not in the xls download. After finding the discussion here: Kobo Matrix Questions do not show up in table or downloaded XLS for Arabic forms · Issue #2860 · kobotoolbox/kpi · GitHub , and in this thread, I have found the following two workarounds:
Change the main language of the form to English (en-en) in Form/Manage translations. After doing this the data appears in the xls download (when ‘Include groups in headers’ is selected and ‘Select questions to be exported’ is not toggled - I haven’t tested other settings).
Without changing the language, use the legacy xls download.
In both cases, the column headers are xml values rather than the question labels.
So, still not ideal, Is there a better workaround or solution being worked on?
Thanks