Error when loading XML
Posted: Fri Jun 27, 2008 2:12 am
I had Problem when try loading data from xml to hashed file
Error Message
The name '{0}' is not a valid NCName.
expression = '/:getcddistResponse/:getcddistResult/:ZBAPITXXPRCDDIST' Remaining tokens are: ('/')
My Structure Data at Hashed table
MANDT Decimal /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/MANDT/text()
BUKRS Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/BUKRS/text()
DIST_CODE Decimal /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/DIST_CODE/text()
DIST_DESC Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/DIST_DESC/text()
WERKS Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/WERKS/text()
and My XML
<getcddistResponse xmlns="http://tempuri.org/PerfRptWs/Service1">
<getcddistResult>
<ZBAPITXXPRCDDIST>
<MANDT xmlns="">300</MANDT>
<BUKRS xmlns="">D012</BUKRS>
<DIST_CODE xmlns="">01</DIST_CODE>
<DIST_DESC xmlns="">OFFICE 2</DIST_DESC>
<WERKS xmlns=""/>
</ZBAPITXXPRCDDIST>
<ZBAPITXXPRCDDIST>
<MANDT xmlns="">310</MANDT>
<BUKRS xmlns="">D012</BUKRS>
<DIST_CODE xmlns="">02</DIST_CODE>
<DIST_DESC xmlns="">OFFICE 1</DIST_DESC>
<WERKS xmlns=""/>
</ZBAPITXXPRCDDIST>
</getcddistResult>
</getcddistResponse>
How do i fix this problem
thx
nh
Error Message
The name '{0}' is not a valid NCName.
expression = '/:getcddistResponse/:getcddistResult/:ZBAPITXXPRCDDIST' Remaining tokens are: ('/')
My Structure Data at Hashed table
MANDT Decimal /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/MANDT/text()
BUKRS Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/BUKRS/text()
DIST_CODE Decimal /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/DIST_CODE/text()
DIST_DESC Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/DIST_DESC/text()
WERKS Varchar(255) /ns1:getcddistResponse/ns1:getcddistResult/ns1:ZBAPITXXPRCDDIST/WERKS/text()
and My XML
<getcddistResponse xmlns="http://tempuri.org/PerfRptWs/Service1">
<getcddistResult>
<ZBAPITXXPRCDDIST>
<MANDT xmlns="">300</MANDT>
<BUKRS xmlns="">D012</BUKRS>
<DIST_CODE xmlns="">01</DIST_CODE>
<DIST_DESC xmlns="">OFFICE 2</DIST_DESC>
<WERKS xmlns=""/>
</ZBAPITXXPRCDDIST>
<ZBAPITXXPRCDDIST>
<MANDT xmlns="">310</MANDT>
<BUKRS xmlns="">D012</BUKRS>
<DIST_CODE xmlns="">02</DIST_CODE>
<DIST_DESC xmlns="">OFFICE 1</DIST_DESC>
<WERKS xmlns=""/>
</ZBAPITXXPRCDDIST>
</getcddistResult>
</getcddistResponse>
How do i fix this problem
thx
nh