I am having a difficult time understanding what's going on inside my sitemap. I made this XML file which is what I assume I would want passed through the HSSF serializer:
main.xml: <?xml version="1.0"?> <Workbook xmlns="http://www.gnome.org/gnumeric/v7";> <SheetNameIndex> <SheetName>Sheet1</SheetName> </SheetNameIndex> <Sheets> <Sheet> <Name>Sheet1</Name> <MaxCol>-1</MaxCol> <MaxRow>-1</MaxRow> <Cells> <Cell Col="1" Row="1" ValueType="60"> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> <query>select * from test_table</query> </execute-query> </Cell> </Cells> </Sheet> </Sheets> </Workbook> Should that work? I simply want to make a sample excel document that has one cell of data queried from my database. Here is my sitemap: <map:match pattern="*.xls"> <map:generate type="file" src="content/main.xml" /> <map:transform type="sql"> <map:parameter name="use-connection" value="eta" /> </map:transform> <map:serialize type="xls" /> </map:match> Here is what I thought happens: When I ask for a .xls file, the file generator reads the main.xml file, the sqltransformer executes the queries in the xml and the HSSFserializer creates an excel file out of the altered xml document. But it's not working; I think I'm really confused. Is that how the pipeline works? Or is it nonsensical? (I wouldn't know at this point.) :-( - Matt Jasha Joachimsthal-2 wrote: > > Hi Matthew, > > > It looks like you're on the right track. > I assume > <map:match pattern="*.xls"> > Will be followed with something like > <map:generate type="file" src="content/{1}.xml" /> > > So the wildcard is being used. > I don't know what your xml file looks like, but if it's only replacing > one lookup value for your SQL query, try using the JX Generator [1]. > > Your generator may look like: > <map:generate type="jx" src="content/query.xml"> > <map:parameter name="record" value="{1}" /> > </map:generate> > > [1] http://cocoon.apache.org/2.1/userdocs/jx-generator.html > > Regards, > > Jasha Joachimsthal > > www.onehippo.com > Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam +31(0)20-5224466 > San Francisco - Hippo USA Inc. 101 H Street, suite Q Petaluma CA > 94952-3329 +1 (707) 773-4646 > > > >> -----Original Message----- >> From: Matthew Monkan [mailto:[EMAIL PROTECTED] >> Sent: vrijdag 30 mei 2008 18:02 >> To: [email protected] >> Subject: Database to Excel Spreadsheet >> >> >> Windows XP / Cocoon 2.1.11 / running inside Cocoon's >> build\webapp folder >> >> As an elementary user of Cocoon, I am still have trouble >> dealing with the sitemap and being confident with it. I'm >> always scared that I've messed up some syntax. My ultimate >> goal is to do some simple selects to an Oracle DB and put it >> on an Excel spreadsheet, which I feel should be really simple. >> But before I get into the XML and XSLT, I simply want to >> design the most optimal sitemap, and at the same time get a >> better concept of what's going on with it. From what I >> understand, I need the file generator, SQLTransformer, XSLT >> transformer, and HSSF Serializer. (If there is anything >> easier that I do not know, feel free to let me know.) >> >> Today I tried writing one from scratch: >> >> <?xml version="1.0"?> >> <map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0";> >> >> <map:components> >> >> <map:generators default="file"/> >> >> <map:transformers default="xslt"> >> <map:transform type="sql"> >> <map:parameter name="use-connection" value="acuworld_test"> >> <map:parameter name="show-nr-of-rows" value="true"> >> <map:parameter name="clob-encoding" value="UTF-8"> >> </map:transform> >> </map:transformers> >> >> <map:readers default="resource" /> >> >> <map:serializers default="html"> >> <map:serializer >> name="xls" >> src="org.apache.cocoon.serialization.HSSFSerializer" >> locale="us" /> >> </map:serializers> >> >> <map:selectors default="browser" /> >> >> <map:matchers default="wildcard" /> >> >> </map:components> >> >> <map:pipelines> >> <map:pipeline> >> >> <map:match pattern="*.xls"> >> <map:generate type="file" src="content/MYCONTENT.xml" /> >> <map:transform type="sql"> >> <map:parameter name="use-connection" >> value="CONNECTIONNAME" /> >> </map:transform> >> <map:transform type="xslt" src="style/MYSTYLE.xsl" /> >> <map:serialize type="xls" /> >> </map:match> >> >> </map:pipeline> >> </map:pipelines> >> >> </map:sitemap> >> >> Am I on the right track? I just want to have peace of mind >> with the sitemap so I'm not going back and forth between >> different files later trying to debug my little application. >> >> Any help and recommendations are appreciated. :-) >> -- >> View this message in context: >> http://www.nabble.com/Database-to-Excel-Spreadsheet-tp17562564 > p17562564.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] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Database-to-Excel-Spreadsheet-tp17562564p17608055.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]
