Bonjour,
Kal_Lam
February 4, 2022, 7:21am
#2
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!Enketo Express for KoBo Toolbox 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.
Kal_Lam
February 5, 2022, 7:11am
#9
@leprince1 , isn’t this the data:
It isn’t. This data is from multricriteria question (2.1)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
