Email > Zip > Excel > MySQL

Hello All.

First post! Yay!

Ok heres the thing. you will have to bare with this wild idea...

I get sent reports daily in zip format, that zip contains 1 file
called erh...report.xls

with me so far?

What i propose to do is, have a php script that automatically recieves
the email, downloads the attachment, extracts the zip, opens the xls
doc, reads the data and inserts it into a mysql database... This
sounds like a right mission to me but i thought maybe you php pros
might see it differently. I know you can extract zip files. Can you
read xls files? can you get it to automatically download the
attachments???

Basically....Is this possible? if so can you point me in the right
direction please.

Also i need a script to keep checking for in a database, is it
unstable to have the browser keep refreshing all day long, 24/7
really??? is there a better way to do it?

That concludes my rather long first post....

Thanks your time.

Dappa.



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

Hello,

On 04/22/2004 10:46 AM, Dappa wrote:
> I get sent reports daily in zip format, that zip contains 1 file
> called erh...report.xls
>
> with me so far?
>
> What i propose to do is, have a php script that automatically recieves
> the email, downloads the attachment, extracts the zip, opens the xls
> doc, reads the data and inserts it into a mysql database... This
> sounds like a right mission to me but i thought maybe you php pros
> might see it differently. I know you can extract zip files. Can you
> read xls files? can you get it to automatically download the
> attachments???

I think you can get it all from here:

http://www.phpclasses.org/browse/


--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

Can you send me your code as a personel message so I can have alook at
you have .. and add to it .... I hope I can help you ... waiting for
your e-mail .... GOOD LUCK ..



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums