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

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
cishpix
Posts: 183
Joined: Fri Nov 06, 2015 5:07 am
Location: Indonesia

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

Post by 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?
Last edited by cishpix on Fri Mar 20, 2020 4:46 am, edited 2 times in total.
Regards,

Suwandy
-----------------
Kisaran - Indonesia
johntalbott
Posts: 619
Joined: Wed Jun 17, 2015 11:16 pm
Location: Omaha, Nebraska
Contact:

Re: How many rows "Export XLSX" supported?

Post by 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/j ... l.allpages

In the Init Script try this:

Code: Select all

config.excel.allPages = true
VocalDay Solutions - Agility - Predictability - Quality

We specialize in enabling business through the innovative use of technology.

AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: How many rows "Export XLSX" supported?

Post by 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/j ... l.allpages

In the Init Script try this:

Code: Select all

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.
Henrik (V8 Developer Ed. - Windows)
cishpix
Posts: 183
Joined: Fri Nov 06, 2015 5:07 am
Location: Indonesia

Re: How many rows "Export XLSX" supported?

Post by 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??
Regards,

Suwandy
-----------------
Kisaran - Indonesia
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: How many rows "Export XLSX" supported?

Post by Jaymer »

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

Code: Select all

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.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
johntalbott
Posts: 619
Joined: Wed Jun 17, 2015 11:16 pm
Location: Omaha, Nebraska
Contact:

Re: How many rows "Export XLSX" supported?

Post by 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.
ExportExcel.png
ExportExcel.png (45.11 KiB) Viewed 10592 times
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.
VocalDay Solutions - Agility - Predictability - Quality

We specialize in enabling business through the innovative use of technology.

AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
cishpix
Posts: 183
Joined: Fri Nov 06, 2015 5:07 am
Location: Indonesia

Re: How many rows "Export XLSX" supported?

Post by 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.
Regards,

Suwandy
-----------------
Kisaran - Indonesia
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

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

Post by 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.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply