exporting archive problem
Home › Forums › Advanced usage › exporting archive problem
- This topic has 6 replies, 2 voices, and was last updated 8 years, 4 months ago by strawley.
January 21, 2015 at 9:18 am #307
First of all – big thank you for creating such a useful tool. It is very much appreciated by a lot of people.
We have an archive of approx 103,000 tweets (although this problem was present at 80,000) that we are struggling to export using TAGS6.
None of the “download as” options (.csv, .tsv, excel, etc) work. After selecting them nothing appears to happen.
The dev console displays a couple of error messages;
“Failed to load resource: the server responded with a status of 500 (Internal Server Error)”
“Failed to load resource: net::ERR_CACHE_MISS”
Same problem with chrome (39.0.2171.99) or firefox on a macbook pro (OSX 10.10.1).
Any advice much appreciated.
SteveJanuary 21, 2015 at 9:46 pm #308
hmm that’s a lot of data. What happens if you right click on the file and select the download option? Another thing to try is selecting two Google Sheets in Drive (holdig the Ctrl key and clicking on them) and then right click download (this will convert and zip the files before download)January 22, 2015 at 1:51 am #309
Thanks for the quick response. Selecting the file and right clicking download option produces a “Failed – Server problem” message. Same error message when selecting two files for download.
It’s an odd one as the Archive sheet is working (albeit rather slowly)- and tweets are still being appended by TAGS. Although attempts to make a copy of that file also fail.
SteveJanuary 22, 2015 at 5:33 am #310
Is the data File > published to web ? If so there are some other export URLs you can tryJanuary 23, 2015 at 12:28 am #311
This is the link that is generated when “publish to web” is selected:
Unfortunately, that link generates a google drive error. Maybe my best bet is to try revision history and take it back to a version that can be exported?January 23, 2015 at 1:10 pm #312
Magic url https://docs.google.com/spreadsheets/d/1ikOGUQfFPvR19xxmmvFKVBr4zkYQ3cucxT3EqMT5KBI/gviz/tq?sheet=Archive&pub=1&tqx=reqId:1;out:csv
Haven’t checked the validity of the file but hitting this I got a 100MB file back. If you link doesn’t work for you let me know and I’ll upload to Drive for you to getJanuary 23, 2015 at 1:46 pm #316
It worked! You absolute star – very much appreciated.
That really is a magic url.
- You must be logged in to reply to this topic.