queenielow
Posts: 11
|
| Posted: 02/07/2010, 6:34 PM |
|
Hi,
I am facing a problem with large data. I got more then 3K data need to be exported out to Excel, by doing the normal export to excel, it will jam my spreadsheet.
If u export to csv format, it turns to be smaller (backend export) but how can i do that with Code charge? I tried change the header file to csv but all the codes will be displayed, which is incorrect.
Please help.
Thanks
|
 |
 |
damian
Posts: 838
|
| Posted: 02/08/2010, 2:15 AM |
|
who is your target?
is it for an internal application?
if so - you could use excel get data function....
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
queenielow
Posts: 11
|
| Posted: 02/08/2010, 5:18 PM |
|
It's for end user..
What is the excel get data function?
care to point me some light?
Cheers!
|
|
|
|
damian
Posts: 838
|
| Posted: 02/09/2010, 6:09 PM |
|
i have a couple of apps that the client likes to manipulate thedata in excel.
we use office 2007 and do thefollowing.
create an odbc connection to thedatabase.
in excel click Data, From Other Sources, from Microsoft Query...
you can do lots ofthings like write a sql query, have it refresh every xx minutes, refresh on open, refresh only when asked, then you can use all your excel functions to play with data.
i suggest that you put all your functions, calcs etc on a second worksheet and leave data on its own.
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
queenielow
Posts: 11
|
| Posted: 02/16/2010, 5:50 PM |
|
Hi Damian,
Thanks for the suggestion. But it won't work for my situation as it's not only 1 person using the report it is a sharing report.
Thanks anyway.. I'll check on other solution
|
|
|
|
damian
Posts: 838
|
| Posted: 02/17/2010, 4:08 AM |
|
if its a small number of people it should be ok
if there are large numbers of people or unknown people then this wont work
back to your original post - what does "jam my spreadsheet" mean?
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
jacem
Posts: 87
|
| Posted: 02/17/2010, 9:17 PM |
|
With respect to "jam my spreadsheet": do you mean the report in your page generated by Codecharge? If so set your page length and max number of rows to a high number (obviously over 3000. You might also have to up your max)execution time php variable higher than 30 seconds.
Alternative you could use php: open a simple text file on the after initialize page event trigger, then on the before row event trigger write your controls out to this text file, closing the file on the page unload event trigger. Putting commas in between each field makes this a simple csv file and easy for excel to import. Hope this helps.
|
|
|
|
queenielow
Posts: 11
|
| Posted: 02/18/2010, 6:06 PM |
|
Hi Damian,
Jamming means, when i open my excel with the exported data, it's loading very slowing and almost no responds.. means all the CPU resources are used to load all the data..for me i can wait for it to after process, but my users their CPU are not as good as mine, so they would have it worst. Anyway , thanks for the advice..
Hi Jacem,
Thanks for the head ups.. i'll try that suggestion u gave me on the alternative..
Thanks alot guys,
|
|
|
|
|
