Will you post back with your progress? *On Mon, Dec 01, 2008 at 10:53:04PM -0800 deepesh <[EMAIL PROTECTED]> wrote:
> Date: Mon, 1 Dec 2008 22:53:04 -0800 (PST) > From: deepesh <[EMAIL PROTECTED]> > Subject: Re: Excel to mysql > To: CakePHP <[email protected]> > > > Thankx for your support Jon I have find out my solution at > > http://devzone.zend.com/article/3336-Reading-and-Writing-Spreadsheets-with-php > > 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > > > > > > > Date: Mon, 1 Dec 2008 22:23:31 -0800 (PST) > > > From: deepesh <[EMAIL PROTECTED]> > > > Subject: Re: Excel to mysql > > > To: CakePHP <[email protected]> > > > > > 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > > > wrote: > > > > > > > Date: Mon, 1 Dec 2008 21:29:52 -0800 (PST) > > > > > From: deepesh <[EMAIL PROTECTED]> > > > > > Subject: Re:Exceltomysql > > > > > To: CakePHP <[email protected]> > > > > > > > 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 <[EMAIL PROTECTED]> 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 <[EMAIL > > > > > > PROTECTED]> wrote: > > > > > > > > > Date: Mon, 1 Dec 2008 21:15:42 -0800 (PST) > > > > > > > From: deepesh <[EMAIL PROTECTED]> > > > > > > > Subject:Exceltomysql > > > > > > > To: CakePHP <[email protected]> > > > > > > > > > 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 > > > > > > [EMAIL PROTECTED] > > > > > > if you're bored or curioushttp://rjmolesa.com > > > > > > -- > > > > Jon Molesa > > > > [EMAIL PROTECTED] > > > > if you're bored or curioushttp://rjmolesa.com > > > > -- > > Jon Molesa > > [EMAIL PROTECTED] > > if you're bored or curioushttp://rjmolesa.com > -- Jon Molesa [EMAIL PROTECTED] if you're bored or curious http://rjmolesa.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
