Global server, data export and download issue

Hello All

I am reaching out to you for requesting your support in exporting and downloading dataset from global server account. There are 827 submissions. While exporting the server get stuck at processing and end up sowing “export failed”. Can anyone please help me to resolve this.

We are working for Government for this project and we need these data urgently for the report.

Please help….

Thanks a lot!

Darshna

@Kal_Lam

Otherwise you can just send him direct message

1 Like

@pruzige Thanks for your response. I am following up with @Kal_Lam since last two week, unfortunately haven’t got any response till now.

Could you please suggest any other way to resolve this?

Try Downloading in this ways::

Download direct in excel/power bi : Data → Get Data → From Web

Or Download using API link.
Login on you kobo account and on the same browser open a new tab and paste this link

https://kf.kobotoolbox.org/api/v2/assets/*aBYFoheeHRd95nLBgLb5QH*/data/?format=xml

on the link change the bold part with you own form ID and then press enter; Now a page to download via api will open .

Press on get . now it will download or open an xml webpge. On your browser press CNRTL+S t0 save the page and then OPEN EXEL the saved xml with Excel.

Try and get back please

1 Like

@pruzige

Thanks for guidance, I tried downloading the data using both methods,

  1. Download direct in excel/power bi : Data → Get Data → From Web —-Screenshot attached
  2. Download using API link.—- Using this method, the web page get responding (Screenshot attached)

Please suggest…….

Nice now its like we are getting there.. On your second sreenshot on the browser,
Sava the page as XML. or Press CNTRL+S to save that XML.


1 Like

@pruzige

I can see the web page opened for the data but because the page is not responding neither right click and save nor ctrl+s works. Is there any other way to do this ?

Please suggest..

Looks like the page is too big and eventually the browser cant handle. Can you try to on the web interface of kobo and try different file format. On the meantime am trying something. soon i will get back to you

From the browser here i can see the link (which you have hidden the form id). Now try to copy the link and put in download manager like IDM it will download the XML. i have tried on my data it worked

1 Like

Hello,
Error 404 “File not found”
appears when in the “Settings” section, under “Share via link,”
the “Everyone can view data submitted to this form” switch is turned off.
Set the status to enabled.
Error 404 will disappear and the data will be exported to Excel.

Hola @SerhilSerhilSerhilSerhil. ya intentaste hacer la descarga desde XLS (anterior/legacy) que hay en la zona de descargas?, a mi me paso lo mismo que indicas y nunca pude descargar, lo hice desde allí y funciono sin problemas e incluso un poco mas rapido, eso si, debes revisar la versión que te descarga y si ya venias trabajando con la descarga de excel homologar a la necesidad.