Unable to Export Data "Stuck in Processing"

[bilalriaz9]

Dear KOBO Team,

I am unable to export the data collected, can anyone help me out?

[Bulbulrds]

Hi @bilalriaz9,
I think it is an Internet problem. Can you give me some information to know what the actual problem is?
(a) Number of variables added to this form?
(b) How much data has been collected in this form and on the server?

“Last year, I faced this type of problem when I collected 300,000 survey responses on a server, with each form collecting around 7,0,000 survey responses. At that time, I found it took a while to process before it was able to download.”

[bilalriaz9]

Not a big data, just around 70 surveys
Questionnaire is around 300 to 500 questions with skips

[bilalriaz9]

This issue is from yesterday.

[Kal_Lam]

@bilalriaz9, so did you mean you did not have any issues downloading your data before yesterday? Could you also let us know the server you are using?

[bilalriaz9]

KoboToolbox

Can you look into this matter? i am just able to download XLS Legacy only but its not usefull.

[Kal_Lam]

@bilalriaz9, would you mind sharing with me the following information through a private message so that I could have a closer look at your case:

• Username
• Project name
• Server

Note: You could share with me a private message as outlined in the post discussed previously:

How do i send a private message to a user in the community forum?

Hi @Lavinia, You could send a private message to a user in the community forum as follows: Option 1: Sending a private message Step 1: Select the Reply button as boxed in red below. [Image 1] Step 2: Select the Reply button once again, but now from this place, as shown in the image below. [Image 2] Step 3: Now select New Message as shown in the image below. [Image 3] Option 2: Sending a private message to me Step 1: Click on my username Kal_Lam. Step 2: Then on the right, click the…

[bilalriaz9]

Dear Kal_Lam,

I have shared the requested details in private message with you 7 days ago, but no response and i am facing the same issue till now.

Please its Urgent to resolve the issue so i can able to download the data.

Thanks

[Kal_Lam]

@bilalriaz9, apologies for getting back to you lately. It seems that you are still able to download your data in XLS (legacy) format. Kindly please continue doing that until we have a fix for your XLS download issue.

Thank you once again for bringing this issue to us. We will get back to you as soon as we fix the issue or have a workaround for your issue.

[bilalriaz9]

Hello dear can you please update?

[bilalriaz9]

Its Urgent

[bilalriaz9]

Really that’s how you provide services ? issue is posted from 24 days and you started investigating 10 days ago, but the issue still persisted and there is no Update from any of your team member.

[Kal_Lam]

@bilalriaz9, thank you for the follow-up, and apologize for the delayed response. Kindly please be informed that your issue has already been forwarded to our dev team and they are investigating it. We will get back to you once we hear from the dev team.

Thank you once again for your kind patience and support as always!

[jnm]

@bilalriaz9, in addition to having 705 questions, your project has 101 deployed versions, and 840 total versions. This was exhausting the memory of the server when you attempted to export.

I see that this project akr38jpRmkEUHMeKvZW2S2 is now archived and not receiving new submissions. Please do NOT use this project for further data collection. Instead, clone the project, and collect data with the clone. This will eliminate the need for the server to keep track of such a large quantity of versions.

We have increased the memory available to export processes in order to accommodate your project. I have tested this and successfully created and XLSX export with all versions and all columns.

I cannot guarantee that this will continue to work reliably. Please safeguard this XLSX file and do as I directed above (create a new project via cloning) if you need to collect more submissions.