[Koha-devel] How do I generate more than 10, 000 koha report reords using excel?

[Ian Bays]

Hi Peter,
I believe there is a built-in default limit of 10000 for sql reports "to 
protect users from downloading too much or filling the server with an 
error"...
I also understand that if you add a LIMIT statement to the sql then that 
takes precedence.
So for example you could add " LIMIT 99999" to your sql and see if that 
works.
It might be nice to have something either on-screen or in help about this.
Good luck.
Ian
PS if you are subscribed to the normal Koha list that might be a better 
list for this question rather than development...

On 25/11/2010 09:09, Peter Mwangi wrote:
>
> Dear all,
> We have been trying to generate reports from KOHA. However, after
> building our report, we download it in excel and only get 10000 records
> (rows). We expect to get at least 40,000 records. Where could we be
> going wrong or rather what are we doing or not doing? Is this a koha or
> excel- related challenge?
>
>
> _______________________________
> Peter Mwangi Gichiri
> Systems Librarian, NEGST/ Africa International University P.O.Box, 24686
> - 00502 Karen, Nairobi
> Tel: 254 (02) 882104/5; Cell: 0721 - 621692
> Email: peter.mwangi at negst.edu
> Website: www.negst.edu
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>


-- 
Ian Bays
Director of Projects
PTFS Europe.com
mobile: +44 (0) 7774995297
phone: +44 (0) 800 756 6803
skype: ian.bays
email: ian.bays at ptfs-europe.com