[SOLVED] How many rows "Export XLSX" supported?

cishpix

I have a query that have around more than 500 records. When I try export all the data to XLSX (I use builtin command in panel operations of query), I only got max 101 records.
I have show all the records as unlimited in my query but I cannot get all the data as XLSX.
Is it bugs in AwareIM or it have limited when export to XLSX?

johntalbott

Even though you have your query set to Unlimited, pages sizes still apply. By default the Kendo grid exports only the current page.

https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/excel.allpages

In the Init Script try this:

config.excel.allPages = true

hpl123

johntalbott wrote
Even though you have your query set to Unlimited, pages sizes still apply. By default the Kendo grid exports only the current page.

https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/excel.allpages

In the Init Script try this:
config.excel.allPages = true

John, I am curious, how do you figure out what exactly to write for these scripts? e.g in this scenario, you start with config and then figure out in some way it´s excel after that and then the actual parameter which I garther you find in the relevant documentation. Is there an index or some way of figuring out what exactly to write for the various Aware modules, components etc.? Is it possible to figure it out looking at the Aware JS files or something like that or do you have any other pointers on how to do this? I have tried to read/understand the programmers reference for this area but my JS skills are not that good so I end up guessing and rarely finding the right snippet to use.

cishpix

hpl123 wrote
In the Init Script try this:
CODE: SELECT ALL
config.excel.allPages = true

Hi Jhon, many thanks for your respond.
I have test it but unfortunately it doesn't works, still same 101 records.
I have try remove the blank space between the equal and try change it to false but still not solved. I have try in Render script and both of init script with render script too but still same result (101 records).
I have try it in query or in form that show all the records in grid (1 to many relationship) but still not solve.
Any idea??

Jaymer

the example code in this thread generates an error in the console for me.
what i have used in the past is this:

config.Excel = {
	AllPages: true,
	FileName: 'ROExports.xlsx'
}

config.PDF = {
   AllPages: true
}

I made a query that finds 331 records.
PDF exports them perfectly, but Excel is still doing 100, and does NOT change the filename.

This has worked for me in the past - I spent 45 mins on this just now and cannot spend any more time.
There must be something broken in the past 1-2 years since this worked and now in the latest 8.4.
I know its straightforward JS thats supposed to be posting into Kendo's memory, but I can't explain why its ignoring the code now.

johntalbott

hpl - It's the result of investing a massive amount of time over the past few years digging through the AIM JS code and mapping to Kendo.

cishpix / jaymer - after reviewing the AIM code, the reason it's not working is that AIM doesn't use Kendo's out of the box method of export to xlsx.

To see what Kendo approach looks like, add this in the init script:
config.toolbar = ["excel"]
config.excel.allPages = true Note: config.excel = {allPages: true} is valid syntax as well.

Line 1 above adds Kendo's default button for exporting to excel to the grid toolbar (which is different than what AIM calls the toolbar.) See highlighted button in screen clip.

I expect that you'll likely want to use AIM's export button for UI consistency. To do that, AIM's export to excel method could be overridden to do it the Kendo way. There are actually a couple of different ways this can be done. Unfortunately that would take more time that I have to explain.

cishpix

johntalbott wrote
To see what Kendo approach looks like, add this in the init script:
config.toolbar = ["excel"]
config.excel.allPages = true Note: config.excel = {allPages: true} is valid syntax as well.

Hi John, many brilliant thanks and much appreciated for your time.

Jaymer

I added
config.toolbar = ["excel"]

to Init Script, and it immediately showed a new non-aware export Button.
But at runtime, clicking that button does nothing.