Skip to main content

VSX CSV download size limit?

6 posts / 0 new
Last post
Meeka
Meeka's picture
VSX CSV download size limit?

I've noticed that with when trying to save the results of a VSX query to a csv file, the file downloaded is empty if there are too many results. Is this a bug or is there a limit on how many results can be saved to a csv?

Thanks!

wlp
How many results?

There is no set limit, but it may be a memory problem on the server side.  How many records do you want to download?  What is the query you were using?

Patrick

Sebastian Otero
Sebastian Otero's picture
csv results

Hi Patrick,

Yes, the same happend to me, only that it was not empty, there were 2 results...
It was just a "changes in last week" search that had more than 5,000 results due to the revision to the ASAS positions. The message says that the result is truncated to 5,000 rows but the option to download the csv file will only give 2 lines.

Cheers,
Sebastian

PS: I moved this thread to the VSX forum where it belongs.

wlp
7784 records

Weird, it works for me.  I have all 7884 lines in the CSV file.

Patrick

Meeka
Meeka's picture
Workaround

So I did get the csv download working when using fewer results by breaking up my search a bit, but the csv didn't have all the fields I needed. I ended up creating a script to get what I needed via an HTTP GET query, and that seems to work for the time being. 

I also tried the csv download again this morning and there seems to be an issue with it again (all search result files have "<b>Notice</b>:  Object of class DB_Error could not be converted to int in <b>Unknown</b> on line <b>0</b><br />" as the only thing in the file).

wlp
Which query?

Hi,

Could you please detail what you were looking for, so that I may be able to reproduce the error you are getting?  (You can do so by private email if you wish).  The csv file should have all the fields of the results page.

Patrick

Log in to post comments
AAVSO 49 Bay State Rd. Cambridge, MA 02138 aavso@aavso.org 617-354-0484