Extracting the Data from XML File
Posted: Tue Mar 24, 2009 11:56 pm
Hi all,
I'm facing the problem while extracting the data from XML file.I've used External Source file stage and XML input stage to extract the data.I'm able to get the datat out of External Source file stage but after the XML stage no data is being fetched.I have loaded the Meta data too.Please explain me the procedure of extracting the data from this XML file which has the structure as mentioned below
Part of XML file structure(rest of the file has same structure too):
<?xml version="1.0" encoding="UTF-8"?>
<CRRDownload:allocatedCRRs xmlns:CRRDownload="http://crr.caiso.org/download/xml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://crr.caiso.org/download/xml http://ftapjbos10:8080/crr/download/xml ... esults.xsd">
<CRRDownload:crr>
<CRRDownload:NominationID>48733</CRRDownload:NominationID>
<CRRDownload:CRRID></CRRDownload:CRRID>
<CRRDownload:Category>PTP</CRRDownload:Category>
<CRRDownload:Portfolio>Allocation_S2_LT</CRRDownload:Portfolio>
<CRRDownload:AssetOwner>1014</CRRDownload:AssetOwner>
<CRRDownload:Source>MALIN_5_RNDMTN</CRRDownload:Source>
<CRRDownload:Sink>LAP_SCE</CRRDownload:Sink>
<CRRDownload:StartDate>2009-04-01</CRRDownload:StartDate>
<CRRDownload:EndDate>2009-06-30</CRRDownload:EndDate>
<CRRDownload:HedgeType>OBL</CRRDownload:HedgeType>
<CRRDownload:CRRType>LSE</CRRDownload:CRRType>
<CRRDownload:TimeOfUse>ON</CRRDownload:TimeOfUse>
<CRRDownload:NominatedMW>6.900</CRRDownload:NominatedMW>
<CRRDownload:AllocatedMW>0.000</CRRDownload:AllocatedMW>
</CRRDownload:crr>
<CRRDownload:crr>
<CRRDownload:NominationID>48734</CRRDownload:NominationID>
<CRRDownload:CRRID></CRRDownload:CRRID>
<CRRDownload:Category>PTP</CRRDownload:Category>
<CRRDownload:Portfolio>Allocation_S2_LT</CRRDownload:Portfolio>
<CRRDownload:AssetOwner>1014</CRRDownload:AssetOwner>
<CRRDownload:Source>SYLMAR_2_NOB</CRRDownload:Source>
<CRRDownload:Sink>LAP_SCE</CRRDownload:Sink>
<CRRDownload:StartDate>2009-04-01</CRRDownload:StartDate>
<CRRDownload:EndDate>2009-06-30</CRRDownload:EndDate>
<CRRDownload:HedgeType>OBL</CRRDownload:HedgeType>
<CRRDownload:CRRType>LSE</CRRDownload:CRRType>
<CRRDownload:TimeOfUse>ON</CRRDownload:TimeOfUse>
<CRRDownload:NominatedMW>174.800</CRRDownload:NominatedMW>
<CRRDownload:AllocatedMW>0.000</CRRDownload:AllocatedMW>
</CRRDownload:crr>
</CRRDownload:allocatedCRRs>
Regards,
Balakrishna
I'm facing the problem while extracting the data from XML file.I've used External Source file stage and XML input stage to extract the data.I'm able to get the datat out of External Source file stage but after the XML stage no data is being fetched.I have loaded the Meta data too.Please explain me the procedure of extracting the data from this XML file which has the structure as mentioned below
Part of XML file structure(rest of the file has same structure too):
<?xml version="1.0" encoding="UTF-8"?>
<CRRDownload:allocatedCRRs xmlns:CRRDownload="http://crr.caiso.org/download/xml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://crr.caiso.org/download/xml http://ftapjbos10:8080/crr/download/xml ... esults.xsd">
<CRRDownload:crr>
<CRRDownload:NominationID>48733</CRRDownload:NominationID>
<CRRDownload:CRRID></CRRDownload:CRRID>
<CRRDownload:Category>PTP</CRRDownload:Category>
<CRRDownload:Portfolio>Allocation_S2_LT</CRRDownload:Portfolio>
<CRRDownload:AssetOwner>1014</CRRDownload:AssetOwner>
<CRRDownload:Source>MALIN_5_RNDMTN</CRRDownload:Source>
<CRRDownload:Sink>LAP_SCE</CRRDownload:Sink>
<CRRDownload:StartDate>2009-04-01</CRRDownload:StartDate>
<CRRDownload:EndDate>2009-06-30</CRRDownload:EndDate>
<CRRDownload:HedgeType>OBL</CRRDownload:HedgeType>
<CRRDownload:CRRType>LSE</CRRDownload:CRRType>
<CRRDownload:TimeOfUse>ON</CRRDownload:TimeOfUse>
<CRRDownload:NominatedMW>6.900</CRRDownload:NominatedMW>
<CRRDownload:AllocatedMW>0.000</CRRDownload:AllocatedMW>
</CRRDownload:crr>
<CRRDownload:crr>
<CRRDownload:NominationID>48734</CRRDownload:NominationID>
<CRRDownload:CRRID></CRRDownload:CRRID>
<CRRDownload:Category>PTP</CRRDownload:Category>
<CRRDownload:Portfolio>Allocation_S2_LT</CRRDownload:Portfolio>
<CRRDownload:AssetOwner>1014</CRRDownload:AssetOwner>
<CRRDownload:Source>SYLMAR_2_NOB</CRRDownload:Source>
<CRRDownload:Sink>LAP_SCE</CRRDownload:Sink>
<CRRDownload:StartDate>2009-04-01</CRRDownload:StartDate>
<CRRDownload:EndDate>2009-06-30</CRRDownload:EndDate>
<CRRDownload:HedgeType>OBL</CRRDownload:HedgeType>
<CRRDownload:CRRType>LSE</CRRDownload:CRRType>
<CRRDownload:TimeOfUse>ON</CRRDownload:TimeOfUse>
<CRRDownload:NominatedMW>174.800</CRRDownload:NominatedMW>
<CRRDownload:AllocatedMW>0.000</CRRDownload:AllocatedMW>
</CRRDownload:crr>
</CRRDownload:allocatedCRRs>
Regards,
Balakrishna