/prog/ - excel to MySQL

Name: Anonymous 2007-03-16 19:09 ID:c0pJLpJY

I need to do a PHP job for a guy who every month receives a xls file and needs to incorporate it to a MySQL database doing as less manual work as possible, any ideas?

Name: Anonymous 2007-03-16 19:28 ID:5EfsIMks

kill yourself.

Name: Anonymous 2007-03-17 0:12 ID:2kRVsST6

Perl library, converts excel to a delimited text file.
http://search.cpan.org/~kclark/excel2txt-0.01/excel2txt

Use mysqlimport.

Also, kill yourself.

Name: Anonymous 2007-03-17 20:46 ID:JYPPxi6w

Choose the tools for the job. PHP is definitely not the tool for this job.

Perl sounds like a likely candidate though. DBI can talk to MySQL and I'm sure there's something, perhaps even the thing in >>3 , on CPAN to read .xls files.

Name: Anonymous 2007-03-17 21:25 ID:aYHWVk1w

>>4
PHP is the only thing I know, besides basic C++ and VB wich will not help

thanks for the info anyways, also 3 and 2, I might kill myself.

Name: Anonymous 2007-03-17 22:37 ID:1Nbp2QAQ

>>1
1. Stop using FailSQL database
2. Have him export the Excel file as a plain text unicode file
3. Write importer for the text file
4. ?????
5. Profit

Name: Anonymous 2007-03-19 4:38 ID:kE7sENQH

>>1
1. convert xls to csv
2. parse using your favorite language (this case PHP)
3. convert to query
4. ???
5. PROFIT!

Name: Anonymous 2009-02-25 7:40

of a single character Not nearly enough entropy to be something like IN version 1 0 and from what she was used to but it would be slow?

Name: Anonymous 2010-12-25 5:38

Name: Anonymous 2011-01-31 21:33

<-- check em dubz

Name: tray 2012-03-15 16:08

hey ya all, guten tag!

Name: Sgt.Kabu쪙⇰kiman꿖אַ 2012-05-28 23:29

Bringing /prog/ back to its people
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy

Name: Anonymous 2013-08-31 7:27

I dream I was in a jail cell. There were two guards standing and talking to another prisoner beside me. A bell rang out and I knew. The zombies had come. I pleaded with the guard to free us, but she refused. They eventually left to see what the commotion outside was. The prisoner beside me knew what was coming as well, he pulled a knife he had hidden and slit his own throat. The doors to the hallway opened. Stumbling forward were the undead. Too many to count, shuffling slowly forward, groaning as if in pain, with their white gi's and stupid red headbands.

Name: Anonymous 2013-08-31 8:12

'm told that in the Southern hemisphere cyclones are Low pressure and go anticlockwise, the opposite being true for anticyclones in the SH, and the reverse in the Northern hemisphere. In some text on the internet it says that you can tell by looking at the cyclone if you are in the Northern hemisphere. How does that work?

Name: Anonymous 2013-08-31 8:58

People post on the regular board, uses captcha, and every captcha entered, generates dollars. The page gets 10'000'000 visitors per moth... That makes a fuck ton of shekels.

excel to MySQL

1 Name: Anonymous 2007-03-16 19:09 ID:c0pJLpJY

2 Name: Anonymous 2007-03-16 19:28 ID:5EfsIMks

3 Name: Anonymous 2007-03-17 0:12 ID:2kRVsST6

4 Name: Anonymous 2007-03-17 20:46 ID:JYPPxi6w

5 Name: Anonymous 2007-03-17 21:25 ID:aYHWVk1w

6 Name: Anonymous 2007-03-17 22:37 ID:1Nbp2QAQ

7 Name: Anonymous 2007-03-19 4:38 ID:kE7sENQH

8 Name: Anonymous 2009-02-25 7:40

10 Name: Anonymous 2010-12-25 5:38

11 Name: Anonymous 2011-01-31 21:33

12 Name: tray 2012-03-15 16:08

13 Name: Sgt.Kabu쪙⇰kiman꿖אַ 2012-05-28 23:29

14 Name: Anonymous 2013-08-31 7:27

15 Name: Anonymous 2013-08-31 8:12

16 Name: Anonymous 2013-08-31 8:58