Hey everyone. I'm somewhat new to XML and Cocoon, so please pardon my ignorance with the subject. :confused:
I am using Cocoon 2.1.11 on Windows XP. I've been using the Moczar & Aston book and have been able to create the static page examples in Chapter 7 within the downloaded Cocoon folder. Ultimately, I need to be able to query info from a database and output an Excel spreadsheet. Then, I need Cocoon to send out an e-mail with the Excel spreadsheet attached. I basically need help understanding what tools in Cocoon I need to use. Can someone verify these or make suggestions? Here are some of the things I listed down so far: For DB to Excel document: SQLTransformer (queries the database, passing the result back in the SAX event stream) HSSF Serializer (turns SAX events into Excel spreadsheet document) To send out the e-mail: Cocoon mail block (SendMail Transformer?) I don't really understand what generator to use. I'm trying to create an example of this offline using MySQL. So for example, I have a small table created in MySQL; I want to say, stick some data from it in some shape or form into Excel, and send out a quick e-mail to a hardcoded e-mail address with the Excel document attached. I also need to be able to run this from the offline CLI. Can someone help me understand the most optimal flow of information I would use. I want to create a sequence diagram to help me visualize this, so if someone could help me understand what info is being passed where, that would be extremely helpful. All the terminology in Cocoon is killing me, and I need help focusing on what is most important to know for these requirements. -- View this message in context: http://www.nabble.com/Query-Database---Produce-Excel-Document-tp17232331p17232331.html Sent from the Cocoon - Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
