Saving grid as csv file email attachment

[nhdspres]

We're hoping SQLyog is the answer!

Following is our objective and we would like to know which functions SQLyog can provide.

Numerous e-mails are received by the server. They each contain a zipped csv file attachment. Then the server does the followign automatically/unattended:

> Each e-mail is accessed

> The attachment files are unzipped and opened

> The file’s contents are added to database tables

> When all the attachment files have been processed as per above, certain data sets, consisting of numeric values and alphanumeric strings, are accessed from the tables

> Calculations performed on the values

> The calculated values and strings are stored in particular cells in a grid object

> The grid object’s contents are saved as a csv file

> The csv file is zipped and attached to an e-mail that is sent automatically to particular users whose e-mail addresses appear in a table.

We’ve been able to do all this using Excel run server-side, but we no longer want to use Excel on the server and are looking for an alternative.

Is SQLyog is the answer? 😕

Thanks so much!

Steve

[Shadow]

Definitely not. SQLyog does not provide any scripting abilities, or any programmable API. It is a MySql admin tool, the only task it is capable of automating is the synchronization of databases.

[CalEvans]

Personally, I'd do it in PHP.

Open the email, suck the contents into mySQL, do the calculation dance, send it back out. http://www.zend.com has about a dozen or so email controls that make sending emails easier.

HTH,

=C=

[nhdspres]

Cool!

Thanks, Cal.

If we could use your services, are you available as a consultant/outsource?

Steve

[Author]

Posts