Thingspeak "data export" button not working

Of only one of my channels I am not able to retrieve data of the last days via the data export button. The other channels gave me a downloadable CSV file.

But my first channel just gave me an empty HTML page after I press the download button. After a few seconds waiting, sounds almost like a time out of the ThingSpeak server.

This problem happend to me in different internet browsers and on the last few days

I checked my logging and I was able to retrieve the data via the same button on 4 November 2019; but could not do it 15 and 16 Nov 2019. Is something changed on the ThingSpeak server?

I need the data from this week.

Any hints how?

Answer 1

[Christopher Stapels]

If your channel is public, can you share the channel number so someone else can try it? Are you sure there is data in the channel? Is it a large amount of data?

Are you able to use the API for Read data to export your channel data? You can export in csv format, but only up to 8000 data points.

Answer 2

[Roelof Klunder]

It is not a public channel.

And yes I'm sure there is data in there. I can see the nice plots, but I would like to do some math with it so I also need the raw data.

There is a lot of data in there. On the 4th of November (the time the web-button stil worked) it was 416,823 data points.

I can read it with API, but than (like you stated) I only get 8,000 points.

So I have to do many API commands with different time settings after which I have to attached all these files.

Is there maybe a new data-point limit per channel for this download button?

The channels I which I'm still able to download are all less than 400,000 data points.

Answer 3

[Christopher Stapels]

We are able to reproduce this issue and we are working on a fix. In the meantime, if you need access to the data from this channel, we can output a csv file and send it via a secure FTP. Send an email to cstapels 'at' mathworks dot com. Please include the channel ID and read API key.

Answer 4

[Roelof Klunder]

Great

I have created my own work-around for the mean time: The data that I needed this week I collected now manually by retrieving a number of times via API and combine the CSV files. So I can continue.

But it would be great when it is working "normally" again.

Answer 5

[Roelof Klunder]

Today it is worse: none of my channels have a workable download.

I have to retrieve all data manual via API.

Anything changed the last 2 weeks?

[Vinod]

The problem manifests when a channel has a large number of datapoints and takes a long time to download all the data. We're working on a bug fix that will resolve this issue.

Answer 6

[Vinod]

This has been fixed. For those who are having trouble, you should now be able to go to the "Data Import/Export" tab of your channel and export the data.

[Jaap Verhoeven]

The issue either is back or not yet resolved. The export button doesn't seem to do anything for me.

[Christopher Stapels]

I checked on one of my channels, it worked fine for me. Can you try again?

[Tim Hodges]

I've been seeing the problem for the last 24 hours on the Excel data export page. Click on the download button and no response. Eventually page times out - http 504. Still occurring today.

[Jaap Verhoeven]

I've checked again, still doesn't work. Timeout & 504.

[Kuzip Zwölf]

I also get a gateway timeout after 66 seconds.

[Jaap Verhoeven]

Btw for staffs information; in my case im trying to download around 600.000 datapoints. It's a lot but has worked before for me.

[Tim Hodges]

I'm trying to download 869000 data points. Was working for me last on 19th April. Then I tried on 26th April and been 504 error since.

[Christopher Stapels]

We have been able to reproduce the issue. As before the problem only happens for larger channels, which is why I initially failed to reproduce it. We are aware of the problem and are working on a fix.Thank you for your patience and reporting.