Hi,
Castor XML is an XML data binding framework that does *not* cover XML
transformation.
Regards
Werner
daeo wrote:
> hi all,
> I m working on a project, and found that i need to convert columns to rows
> otherwise the next step wouldn't work properly.
>
> My original xml is like:
> -------------------------------------------------------------------------------
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <xflow-location>
> <location>
> <document>
> <page>
> <datacell>
> <pk_datacell_id>1</pk_datacell_id>
> <last_updated>2009-02-10T11:21:28.000+11:00</last_updated>
> <datacell_name>Consignment</datacell_name>
> <datacell_value>SL140660</datacell_value>
> </datacell>
> <datacell>
> <pk_datacell_id>2</pk_datacell_id>
> <last_updated>2009-02-10T11:21:28.000+11:00</last_updated>
> <datacell_name>customer_ref</datacell_name>
> <datacell_value>948272</datacell_value>
> </datacell>
> <datacell>
> <pk_datacell_id>3</pk_datacell_id>
> <last_updated>2009-02-10T11:21:58.000+11:00</last_updated>
> <datacell_name>Job</datacell_name>
> <datacell_value>5454</datacell_value>
> </datacell>
> </page>
> <page>
> <datacell>
> <pk_datacell_id>4</pk_datacell_id>
> <last_updated>2009-02-10T11:21:58.000+11:00</last_updated>
> <datacell_name>Invoice_num</datacell_name>
> <datacell_value>94827223323</datacell_value>
> </datacell>
> </page>
> </document>
> </location>
> </xflow-location>
> ------------------------------------------------------------------
>
>
> i want to make it:
>
> ------------------------------------------------------------------
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <xflow-location>
> <location>
> <document>
> <pkid>1</pkid>
> <Consignment>SL140660</Consignment>
> <customer_re>948272</customer_re>
> <Job>5454</Job>
> <Invoice_num>94827223323</Invoice_num>
> </document>
> <document>
> <pkid>1</pkid>
> <Consignment>SL140660</Consignment>
> <customer_re>948272</customer_re>
> <Job>5454</Job>
> <Invoice_num>94827223323</Invoice_num>
> </document>
> </location>
> </xflow-location>
> -----------------------------------------------------------------------------
> the convertion is generally grab all the datacell_name text content, make
> them the node names, and make all datacell_value the new content text. This
> is just to turn lots of datacells into a row of datacell with different
> column names.
>
> has anyone tried and succeeded to do this? please help! thank you!
>
> best regards
>
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
