Long text answers not appearing?

Hi all,

I have a survey of around 120 questions. 10 of these are multi-line text responses. However, I’ve just tested these (by adding 1,900 characters of dummy text - just all in one paragraph) into these 10 questions. When I download the data, only the first two appear, and the other data is lost. I’m using the online-only collection setting in Kobo.

Is this an issue with length? If so, how would I create a constraint for (for example) 200 characters per question?

EDIT: Bizarrely, when downloading data (XLS or CSV) the data both doesn’t appear - and for the Excel, the data is split across two sheets - with some questions completely missing. Attaching the survey here.

Updated survey_anonymised.xlsx (67.4 KB)

Thanks!

Should have mentioned - Enketo is the method of data collection (not the Kobo app).

EDIT: Bizarrely, when downloading data (XLS or CSV) the data both doesn’t appear - and for the Excel, the data is split across two sheets - with some questions completely missing. Attached the survey above.

Hi all,

I have a survey of around 120 questions. 10 of these are multi-line text responses. However, I’ve just tested these (by adding 1,900 characters of dummy text - just all in one paragraph) into these 10 questions. When I download the data, only the first two appear, and the other data is lost. I’m using the online-only collection setting in Kobo.

Is this an issue with length? If so, how would I create a constraint for (for example) 200 characters per question?

Bizarrely, when downloading data (XLS or CSV) the data both doesn’t appear - and for the Excel, the data is split across two sheets - with some questions completely missing. Attaching the survey here.

Updated survey_anonymised.xlsx (67.4 KB)

Thanks!

Welcome back to the community, @AndrewXLS! Maybe this post discussed previously should help you understand the scenario and solve your issue:

Thanks, @Kal_Lam!

Just to confirm, is this 2,000 characters in total (i.e. across all of the free-text questions) - or 2,000 characters per answer?

Also, one of the responses at the end of the (very helpful!) thread you linked to mentions they were able to post 22,000+ characters. What is the Enketo limit?

1 Like

It’s 2000 characters per question.

Thanks, but maybe there’s an error with my survey? I completed it adding 1,900 characters to any free-text question - and had the above issues. Several of the longer-responses weren’t saved at all, and then all of the data was split across two Excel sheets (with the last 10 or so questions not included at all). Were you able to replicate this at all?

Hi @AndrewXLS,

Your form includes repeat groups. That might be the reason of split you’re referring.

For more information you can look to this article:
https://support.kobotoolbox.org/group_repeat.html?highlight=repeat#creating-a-roster-repeating-group-of-questions

The resulting data structure from a roster is different from the data you normally see with other variables or groups. When downloading your data, you will see a different sheet for each roster (i.e. the number of additional sheets corresponds with the number of repeating groups that you have within your survey form).

1 Like

Yup, that is the split - you’re right! But, the xls (or csv) downloads seem to not download any data from the group that comes after the repeat. It’s not in either sheet. Any idea why it’s disappearing?