Monitoring changes


I was wondering if I could tap your collective knowledge, as I have hit my technical knowledge ceiling, and think that Simon may be the answer to my prayers...!

I work for a recording company that creates musical assets for advertising and films. These assets are saved in a number of different formats (AIFF, WAV, MP3 and a few others). As new assets are created they get logged in to our database. We have an internal AJAX-based page which autoupdates as new assets get added.

The format on the page appears thus:


What I'd ideally like Simon to do is to notify me via email when assets appear in a particular file format determined by the CLIENT_NAME but delivering me both CLIENT_NAME-ASSET_NAME.

For example, if the following were to get logged:

[12:00 04/02/09] AIFF Disney-Jingle

Is it possible to set up an email notification that could take that information and deliver to me the CLIENT_NAME and ASSET_NAME, in this case Disney-Jingle? I envisage having a number of tasks running for different file formats, I thought so that the "start text" would be the file format.

I've spent all day trying to get this to work, and fear for my remaining hair. I apologise in advance if this is not clear. ANY help would be massively appreciated.

Many thanks,

Syndicate content