My Views-table contains 200 rows (50 rows x 4 page, pagination set to 25), but exported XLS only contains first 50 rows.

Also, when using Views Custom Fields then Row Number starting from 51.

CommentFileSizeAuthor
#6 views_export_xls.png481.2 KBsupriyarajgopal
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

drupalnesia’s picture

I mean 200 rows (50 rows x 4 page, pagination set to 50)

ann_s’s picture

I am getting the same error. Even if i click the icon on the second page and try exporting the results again.
Is this by design?

Anyone knows of a possible solution or another module that could help?

scotwith1t’s picture

Title: Only Export First Page » Only Exports First Page of multi-page result sets

confirmed this behavior also, had to turn pagination off, set results to unlimited (or at least enough to accommodate all results, but this is a serious performance hit on the page i'm dealing with, which is a user list on a site with 3000+ subscribers and it takes forever to display them all. even if it was just a couple hundred, this would be a problem. can this be corrected to pull the full results of the view instead of just the page you're viewing within the view? i would change to a feature request, but it doesn't even export the page you're on, only the first page of the view every time...

thanks for this awesome module. hopefully this one shortcoming can be corrected soon?!

scotwith1t’s picture

Category: bug » task
Priority: Major » Normal

note also that you can set the view that the XLS feed is attached to to anything as far as pagination goes, but as long as the feed itself is set to unlimited, you will get all the results in the view and not just the first page...so really it's more about how you configure it than anything...once i figured this out, it works beautifully. i think it would suffice to add this to the readme.txt instructions, so i changed to a task and normal priority instead. if anyone disagrees, feel free to modify.

Marko B’s picture

Version: 6.x-1.1-beta1 » 7.x-1.x-dev
Category: task » bug

In drupal 7 this is not working. In pager section of views you can't select pager. Only show all nodes or particular number of nodes. So you can't export page 2 like you could in drupal 6.

supriyarajgopal’s picture

Issue summary: View changes
FileSize
481.2 KB

Hello,

Set 'Items to display' to 'Display all items' only in Feed display of Views. (Refer attached file)
Similarly, in Page display, set pagers for 'This page'.

Hope this helps.