Re: CSV importer tool

On Tue, Nov 27, 2012 at 4:11 PM, tamouse mailing lists <tamouse.lists@gmail.com> wrote: > On Tue, Nov 27, 2012 at 4:09 PM, tamouse mailing lists > <tamouse.lists@gmail.com> wrote: >> On Tue, Nov 27, 2012 at 2:56 PM, Leandro Dardini <ldardini@gmail.com> wrote: >>> Hello, >>> I am going to write a PHP page to allow the client to upload a CSV file and >>> assign each column to one or more fields of a mysql table. Quite simple, >>> but I feel like I am reinventing the wheel... is it possible there is no >>> library to do it, maybe using AJAX or similar cute techniques? >>> >>> Leandro >> >> This has been asked a few times, I wrote up a how-to and posted it on my wiki: >> >> >> http://wiki.tamaratemple.com/Technology/UsingUploadedTempFilesToPopulateATableInPHP >> >> It's such a few actual lines of code, I wonder if no one thinks it's >> such a big deal to just write it over and over again. Basically it's >> handled pretty much entirely in SQL rather than PHP. > > Ah, sorry, in the time i was writing this our net went down, then came > back up, and I saw your earlier replies. Although on third thought, the technique of storing the entire CSV uploaded in a temp table to let the user decide what to do with the actual data has some possible use...