[xwiki-devs] Automatic document generation on xwiki based on external database

[Ricardo Pinto]

Hello!

I'm planning the development of the following functionality:


   - Running xwiki instance on MySQL;
   - There will be an external database (a Datawarehouse to be more
   precise), with business indicators
   - If any of the indicators reached a predefined limit value, I' d like
   to have my xwiki generate a document with information about this event and
   send an e-mail alert to the administrator (or other users)

My strategy may be to create a IndicatorClass with some properties like
name, description, businessarea, currentvalue, limitvalue, externalTable,
externalColumn etc. Then I'll have to update these indicators on a regular
basiis, which I could do with a procedure that will check the external
database and get the latest values. For those which reached the limit
values, I'd like to generate automaticaly a document (of the class Risk for
instance) and send an e-mail to warn of these risks.

What do you think? Maybe a plugin could be a more structured way of doing
this...
Thanks in advance for your tips :)

Bye,

Ricardo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xwiki.org/pipermail/devs/attachments/20070902/bb802d7b/attachment.html 
-------------- next part --------------
_______________________________________________
devs mailing list
devs at xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs