Survey Solutions

Support portal and knowledge base

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Data Export

Rabelani Shandukani May 03, 2018 12:03PM EDT

Good day

We have a survey in field that has already started collecting data. My question is when we export, some questionnaires/assignments are generating blank rosters (that is some assignments are generating extra rosters with no information from all questions in the roster). When I check the assignments on the dashboard as supervisor or headquarters the questionnaire for example which is showing 3 persons in questionnaire now has 5 persons in the export with 2 blank extra rows. What could be the problem?

I would highly your assistance in this regard.

regards
Rabelani

Up 0 rated Down
Michael Lokshin May 03, 2018 01:03PM EDT Survey Solutions Agent

Rabelani,

Are you running your survey on local server or our cloud? If on the cloud, what is the name of that server? If local, what version of Survey Solutions you are using?

Misha

Up 0 rated Down
Rabelani May 03, 2018 01:47PM EDT
Hello Misha,

We are running the survey on local server and we are using version 18.04.2 (build 20992)

Regards
Rabelani
Up 0 rated Down
Michael Lokshin May 03, 2018 02:40PM EDT Survey Solutions Agent

Rabelani,

More complicated way: please let us know what is the name of your questionnaire and where exactly (what roster) you observe these blank rows. We will try replicating it on our side.

Easier way: if you can give us temporary access to your server, we can just go in and look what is going on.

But, please confirm that this is an inconvenience rather than a problem. In a worst case scenario you can just delete these empty rows after you export your data. No data loss is here. Please confirm if my understanding is correct.

Misha

Up 0 rated Down
Sergiy Radyakin May 03, 2018 03:27PM EDT Survey Solutions Agent

Hello Rabelani,

please inspect the paradata for this interview and see if the roster was earlier set to a larger number of items (persons), which were subsequently deleted.

Best, Sergiy

Up 0 rated Down
Rabelani May 04, 2018 02:39AM EDT
Hello Misha and Sergiy,

Thank you for the prompt response.

I fully agree with you Misha, its rather an inconvenience rather than a problem and currently we have resorted to deleting the empty rows after the export. The questionnaire we are using is KZN CSS 2018_Final and the problem is with the Household member Roster (NCSSPersons_1). I will

Sergiy, we will look into the paradata as well and see what is going on with those specific questionnaires.

regards
Rabelani
Up 0 rated Down
Aleksandra Komarovskaya May 04, 2018 08:59AM EDT Survey Solutions Agent

Dear Rabelani,

Can you send me the data files we were talking about?

Best regards,

Aleksandra

Up 0 rated Down
Michael Lokshin May 04, 2018 10:45AM EDT Survey Solutions Agent

Rabelani,

We managed to reproduce your problem. This is a bug in our system. We will release a fix in the upcoming release 18.06 at around June 4th.

Misha

Post Your Public Answer

Your name (required)
Your email address (required)
Answer (required)
support@mysurvey.solutions
http://assets0.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete?b_id=12728