187488 - no subject - Hi!\n I have a requirement wherein the

johne252 over 8 years ago

Hi!
I have a requirement wherein the client wants the raw data from database to be downloadable (CSV or EXCEL format) by the user. The problem is that the table is quite large (~80 columns. Client requirement as well). We've tried using the plugins available (cloud-certified) modules but we get stuck at around 4k rows. As I understood it, there is a limit on the size of the queried object as well as the processing time when using these smart services.

Short of doing a manual export (using MySQL Admin Console), is there a better way of doing/fulfilling this requirement?

Discussion posts and replies are publicly visible

Parents

0 johne252 over 8 years ago

Thanks for the tip guys! I found this plug-in on shared components (Export SQL and Report Data to EXCEL - V2 ) and it works for 10k rows. Only downside I see is that this module will write the document to document directory and does not initiate an automatic download. We're trying to work around that now and exploring the module further to test it's limits.

Has anyone used this module(forum.appian.com/.../summary) comments on using this?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 johne252 over 8 years ago

Thanks for the tip guys! I found this plug-in on shared components (Export SQL and Report Data to EXCEL - V2 ) and it works for 10k rows. Only downside I see is that this module will write the document to document directory and does not initiate an automatic download. We're trying to work around that now and exploring the module further to test it's limits.

Has anyone used this module(forum.appian.com/.../summary) comments on using this?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data