Hello,
Currently, I have a datasubset in an interface that is used with the function plug-in "getdatasubsetdownloadlinkfromprocess"
As it works now, the users selects from a dropdown, the data he or she wants to see, the data is populated in a grid and there is a link to click "Click here to export this data to Excel"
This works fine with a small amount of data (up to 1000 rows) but when it gets to 3,000 rows of data, it fails.
I have read on some posts here that "getdatasubsetdownloadlinkfromprocess" doesnt work well with large sets of data
My question is, what is the best way to export data from a mySQL database to excel. I see a SQL to Excel smart service but I am having trouble setting that up.
Any help or advice would be greatly appreciated.
Thanks!
Discussion posts and replies are publicly visible