Re: Excel to mysql

I am so sorry jon was busy with inserting code in to CAKE .

Well finally i have decided to use http://sourceforge.net/projects/phpexcelreader/
for my import method it will require

only two of the files or simply excel Folder there inside this
phpexcelreader . And thats it hoping to finish it ASAP so

that can really tell you how i finally completed it .

Best regards,
Deepesh

On Dec 2, 12:17 pm, Jon Molesa <rjmol...@gmail.com> wrote:
> Will you post back with your progress?
>
> *On Mon, Dec 01, 2008 at 10:53:04PM -0800 deepesh <deepeshgair...@gmail.com> wrote:
>
>
>
> > Date: Mon, 1 Dec 2008 22:53:04 -0800 (PST)
> > From: deepesh <deepeshgair...@gmail.com>
> > Subject: Re: Excel to mysql
> > To: CakePHP <cake-php@googlegroups.com>
>
> > Thankx for your support Jon I have find out my solution at
>
> >http://devzone.zend.com/article/3336-Reading-and-Writing-Spreadsheets...
>
> > and
>
> >http://sourceforge.net/projects/phpexcelreader/
>
> > this will read my excel file and give an array which will be inserted
> > there in Mysql.
>
> > Now i have to integrate it with cake :)
>
> > Best regards,
> > Deepesh
>
> > On Dec 2, 11:40 am, Jon Molesa <rjmol...@gmail.com> wrote:
> > > are you running linux?
>
> > > are you familiar withhttp://us.php.net/systemorhttp://us.php.net/manual/en/function.exec.php?
>
> > > *On Mon, Dec 01, 2008 at 10:23:31PM -0800 deepesh <deepeshgair...@gmail.com> wrote:
>
> > > > Date: Mon, 1 Dec 2008 22:23:31 -0800 (PST)
> > > > From: deepesh <deepeshgair...@gmail.com>
> > > > Subject: Re: Excel to mysql
> > > > To: CakePHP <cake-php@googlegroups.com>
>
> > > > Ok what i am looking for is to make a single script where an excel
> > > > sheet is browsed and submitted its data should go to mysql directly
> > > > without any intermediate step in between.
>
> > > > I have used LOAD DATA INFILE for excel but of no use . What i was
> > > > thinking of in run time convert xl file to CSV using same script and
> > > > then import data and discard it.
>
> > > > On Dec 2, 11:16 am, Jon Molesa <rjmol...@gmail.com> wrote:
> > > > > you do
> > > > > xls2csv spreadsheet.xls > spreadsheet.csv
>
> > > > > then as a separate operation I do:
> > > > > ./csv2mysql.php spreadsheet.csv
>
> > > > > but you could include the first operation as part of csv2mysql.php and
> > > > > run it all in one command.
>
> > > > > *On Mon, Dec 01, 2008 at 09:29:52PM -0800 deepesh <deepeshgair...@gmail.com> wrote:
>
> > > > > > Date: Mon, 1 Dec 2008 21:29:52 -0800 (PST)
> > > > > > From: deepesh <deepeshgair...@gmail.com>
> > > > > > Subject: Re:Exceltomysql
> > > > > > To: CakePHP <cake-php@googlegroups.com>
>
> > > > > > Hi jon ,
>
> > > > > >                thank you very much for your timely reply.
> > > > > > Is your xls2csv a standalone application i mean do you have to start
> > > > > > xls2csv then convert yourexcelin to csv format and then run your PHP
> > > > > > script forimportor its all like a php app !!
>
> > > > > > Best regards,
> > > > > > Deepesh
>
> > > > > > On Dec 2, 10:25 am, Jon Molesa <rjmol...@gmail.com> wrote:
> > > > > > > I usually use xls2csv and then a custom php script toimportthat into
> > > > > > > the database.  You can even wrap it into one operation by calling
> > > > > > > xls2csv from inside your php script.  It isn't cake specific, but if
> > > > > > > you'd like my script contact me off list.  FYI, I use linux and xls2csv
> > > > > > > is an available tool.  Not sure if there is a Windows version.  I think
> > > > > > > I ran it on Mac once using fink or port.  It's part of catdoc I believe.
>
> > > > > > > *On Mon, Dec 01, 2008 at 09:15:42PM -0800 deepesh <deepeshgair...@gmail.com> wrote:
>
> > > > > > > > Date: Mon, 1 Dec 2008 21:15:42 -0800 (PST)
> > > > > > > > From: deepesh <deepeshgair...@gmail.com>
> > > > > > > > Subject:Exceltomysql
> > > > > > > > To: CakePHP <cake-php@googlegroups.com>
>
> > > > > > > > Hi All,
> > > > > > > >             I have came across a script in my application whereExcel
> > > > > > > > data needs to be imported in toMysql. All i have come across is that
> > > > > > > > it needs to be a CSV or .txt file toimportall the data from file to
> > > > > > > >Mysql. Is there any way out forEXCELimportscript in Cake !!
>
> > > > > > > > Best regards,
> > > > > > > > Deepesh
>
> > > > > > > --
> > > > > > > Jon Molesa
> > > > > > > rjmol...@consoltec.net
> > > > > > > if you're bored or curioushttp://rjmolesa.com
>
> > > > > --
> > > > > Jon Molesa
> > > > > rjmol...@consoltec.net
> > > > > if you're bored or curioushttp://rjmolesa.com
>
> > > --
> > > Jon Molesa
> > > rjmol...@consoltec.net
> > > if you're bored or curioushttp://rjmolesa.com
>
> --
> Jon Molesa
> rjmol...@consoltec.net
> if you're bored or curioushttp://rjmolesa.com
--~--~---------~--~----~------------~-------~--~----~
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 cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---