Re: Mass edit in CakePHP?
I'm not exactly sure if this is what you're looking for, but you can have your code write directly to an XLS file.I used this bakery post as a starting point: http://bakery.cakephp.org/articles/view/generate-excel-spreadsheets-from-your-database One caveat: be sure to write the excel file to your server, rather than attempt to send headers to the browser. Good luck! -M On Apr 29, 11:27 am, SumanRS <[EMAIL PROTECTED]> wrote: > Hi, > > I've been using CakePHP for creating an online version of a listing > that has long been maintained using Excel. There are several hundred > rows in this table. > > However, one thing where the Excel UI wins is in allowing a new field > (column) to be added. After that, it is easy to update the field for > all rows. If I wanted to do this in Cake, I would have to click "Edit" > on each row and edit the value for the field for each row. > > One way I can think of solving this is: > 1. Export the CakePHP values to a CSV > 2. Edit the CSV in Excel > 3. Write PHP to open the edited CSV and update the fields (I've done > this before) > > Is there a way to do this natively (and easily) in CakePHP? > > Thanks, > SumanRS --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: cakephp, extending to a subdomain?
We run cake under subdomains on our server. We have 3 instances of our site, www.CLIENT.com, staging.CLIENT.com, and dev.CLIENT.com each subdomain has it's own 'installation' of cake. it's not a "true" extension, but it will work. -matt On Dec 2, 3:33 am, "Louie Miranda" <[EMAIL PROTECTED]> wrote: > *cakephp, extending to a subdomain?* > > Would it be possible to extend cakephp on a subdomain like this.. > > primary: example.com > sub: about.example.com > > where about is under > /home/example/www/ -- main, where cake php is located index.php > /home/example/www/about > > at first i actually encountered 500 errors when visiting about.example.com, > but figured it would actually be great if i can use that on a sub domain. > > -- > Louie Miranda ([EMAIL PROTECTED])http://www.axishift.com > > Security Is A Series Of Well-Defined Steps > chmod -R 0 / ; and smile :) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Session problem in app_controller
Post the code from your app controller so we can take a look. -m On Oct 24, 2:37 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I'm using cake 1.1.17, and am following the Simple User Authentication > example from the manual (http://manual.cakephp.org/appendix/ > simple_user_auth), and I get the following error when I write the > checkSession function in the app_controller.php file: > > Notice: Undefined property: PagesController::$Session in /var/www/ > cakestuff/clientes/app/app_controller.php on line 19 > > Fatal error: Call to a member function check() on a non-object in /var/ > www/cakestuff/clientes/app/app_controller.php on line 19 > > Anyone know what I'm doing wrong?? I've google and asked on IRC, but > nothing. > > Thanks > dave --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Looking for a great feelance CakePHP developer
Hello Group. We would like to ask if you (or someone you know) could help us finalize a web application built with CakePHP 1.1. Please respond off the group if you are interested in helping, learning, and making some $ thanks! Matt Kosoy Flat, Inc. 391 Broadway, 3rd. fl. New York, NY 10013 T: 646.613.8833 ext. 14 http://www.flat.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Cakephp - generating excel files.
Hey Everyone - thanks for your suggestions and help
Mr. Xeeton -- we're developing on a redhat linux box running PHP 4.4
-- i'm not sure which version of PEAR is installed, but i do know that
we're getting some Open_basedir warnings/errors when trying to
access PEAR from cake.i think it's a permissions issue.
Mr. Grant Cox -- thanks for your advice, as soon as I get into the
office I will try what you suggest. Seems to be the most promising
lead thus far, and i hope it works.
Mr. Mike Green -- ha! you're probably right, and I am trying too
hard. I just want to reiterate that we have been able to create xls
files, but there have been inconsistencies in how those file output &
render.
here are the headers we're using:
header('Pragma: public');
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); //
Date in the past
header('Last-Modified: '.gmdate('D, d M Y H:i:s') . ' GMT');
header('Cache-Control: no-store, no-cache, must-revalidate'); //
HTTP/1.1
header('Cache-Control: pre-check=0, post-check=0, max-age=0');//
HTTP/1.1
header ("Pragma: no-cache");
header("Expires: 0");
header('Content-Transfer-Encoding: none');
header('Content-Type: application/vnd.ms-excel;'); //
This should work for IE & Opera
header("Content-type: application/x-msexcel");
header("Content-Disposition: attachment;filename=".$file.".xls");
--
Thanks again for any suggestions you guys might have. It's greatly
appreciated.
On Oct 12, 4:43 am, Mike Green <[EMAIL PROTECTED]> wrote:
> You may be trying too hard with what you are trying to achieve
>
> Excel will take a file made up basically of tables in html.
>
> as long as you send a header like:
>
> ContentType = "application/vnd.ms-excel"
>
> then the following format for the data (note, no HTML, HEAD or other
> tags)
>
>
> 2
> 3
> =SUM(A1:A2)
>
>
> This will output a file that is perfectly acceptable by excel
>
> Mike
>
> On Oct 11, 11:34 pm, Matt Kosoy <[EMAIL PROTECTED]> wrote:
>
> > Hello.
>
> > I'm having a ton of problems trying to get cakephp to generate excel
> > files correctly, and I was wondering if anyone out there has any info/
> > suggestions.
>
> > So far I have tried the following:
>
> > 1. Re-writing a class I found on phpclasses.org (http://
> > phpclasses.promoxy.com/browse/package/2037.html)
> > this method generates the files correctly, but the problem is that
> > the xls files that are created do not open on Windows machines. This
> > class works perfect from outside of cakephp -- it's a shame.
>
> > 2. I attempted to implement this helper:
> > http://bakery.cakephp.org/articles/view/excel-xls-helper
> > using this method is ok, but for larger result sets (more than 100
> > rows returned) "bad" files are created which can not be opened by
> > Excel on any platform.
>
> > 3. The "Generate Excel spreadsheets from your database" method
> > --http://bakery.cakephp.org/articles/view/generate-excel-spreadsheets-f...
>
> > I can not make this method work for the life of me. With debugging
> > set to 0 the only result that's returned is complete gobbeldygook.
>
> > 4. I have attempted to use PEAR's spreadsheet_excel_writer
> > module, but we are hitting an open_basedir error/warning. We're
> > trying to work that out right now.
>
> > I can post code examples. Any help, suggestion, or advice would be
> > greatly appreciated. I'm tearing my eyeballs out over this.
>
> > Thanks World
>
> > -matt
>
> > 4. Using the raw PEAR 'Spreadsheet_Excel_Writer' module -- this
> > method is producing an open_basedir warning/error, and we are
> > attempting to work out the problem with our server ppl.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Cakephp - generating excel files.
Did you mean method # 3? Method #2 is used as a component - sorry. On Oct 11, 7:20 pm, Grant Cox <[EMAIL PROTECTED]> wrote: > We use a modified version of the helper on the Bakery (#2 in your > list). We found that same issue of larger files being invalid - this > was fixed by just removing the > > $this->workbook->setVersion(8); > > call from the constructor of the helper. > > On Oct 12, 8:34 am, Matt Kosoy <[EMAIL PROTECTED]> wrote: > > > Hello. > > > I'm having a ton of problems trying to get cakephp to generate excel > > files correctly, and I was wondering if anyone out there has any info/ > > suggestions. > > > So far I have tried the following: > > > 1. Re-writing a class I found on phpclasses.org (http:// > > phpclasses.promoxy.com/browse/package/2037.html) > > this method generates the files correctly, but the problem is that > > the xls files that are created do not open on Windows machines. This > > class works perfect from outside of cakephp -- it's a shame. > > > 2. I attempted to implement this helper: > > http://bakery.cakephp.org/articles/view/excel-xls-helper > > using this method is ok, but for larger result sets (more than 100 > > rows returned) "bad" files are created which can not be opened by > > Excel on any platform. > > > 3. The "Generate Excel spreadsheets from your database" method > > --http://bakery.cakephp.org/articles/view/generate-excel-spreadsheets-f... > > > I can not make this method work for the life of me. With debugging > > set to 0 the only result that's returned is complete gobbeldygook. > > > 4. I have attempted to use PEAR's spreadsheet_excel_writer > > module, but we are hitting an open_basedir error/warning. We're > > trying to work that out right now. > > > I can post code examples. Any help, suggestion, or advice would be > > greatly appreciated. I'm tearing my eyeballs out over this. > > > Thanks World > > > -matt > > > 4. Using the raw PEAR 'Spreadsheet_Excel_Writer' module -- this > > method is producing an open_basedir warning/error, and we are > > attempting to work out the problem with our server ppl. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Cakephp - generating excel files.
Hello. I'm having a ton of problems trying to get cakephp to generate excel files correctly, and I was wondering if anyone out there has any info/ suggestions. So far I have tried the following: 1. Re-writing a class I found on phpclasses.org (http:// phpclasses.promoxy.com/browse/package/2037.html) this method generates the files correctly, but the problem is that the xls files that are created do not open on Windows machines. This class works perfect from outside of cakephp -- it's a shame. 2. I attempted to implement this helper: http://bakery.cakephp.org/articles/view/excel-xls-helper using this method is ok, but for larger result sets (more than 100 rows returned) "bad" files are created which can not be opened by Excel on any platform. 3. The "Generate Excel spreadsheets from your database" method -- http://bakery.cakephp.org/articles/view/generate-excel-spreadsheets-from-your-database I can not make this method work for the life of me. With debugging set to 0 the only result that's returned is complete gobbeldygook. 4. I have attempted to use PEAR's spreadsheet_excel_writer module, but we are hitting an open_basedir error/warning. We're trying to work that out right now. I can post code examples. Any help, suggestion, or advice would be greatly appreciated. I'm tearing my eyeballs out over this. Thanks World -matt 4. Using the raw PEAR 'Spreadsheet_Excel_Writer' module -- this method is producing an open_basedir warning/error, and we are attempting to work out the problem with our server ppl. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
