Dear All,
I've zero understanding of XML in EXCEL therefore please do not judge me.
I was trying to update one EXCEL file which already had a mapping with XML but I had no clue how to add few more columns which I can map with EXCEL table.
So I prepared an XML or Schema for excel from the scratch looking at the existing, which I think is perfectly working well.
Now when I am trying to map the schema field with EXCEL table and then I am trying to run verify Map for Export I am getting error *Denormalized Data.
What I am able to search on internet is maxocur I have increase something but I have no idea where I have to do that?
Would anybody be able to map the remaining items? OR just tell me how to do the remaining ones?
Do I need to make changes in schema or when mapping in excel I have to do something?
As mentioned I've zero knowledge of XML therefore please try to be basic as much as possible thank you so much!
I'm enclosing excel file as well as schema which I am using in this excel file.
Appreciate your kind responses and thanks in advance!!
Sorry schema file couldn't upload therefore copy & pasting the XML code
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<TWM_SAD xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Identification>
<Office_segment>
<Customs_clearance_office_code/>
</Office_segment>
<Type>
<Type_of_declaration/>
<Declaration_gen_procedure_code/>
</Type>
</Identification>
<Traders>
<Exporter>
<Exporter_name/>
</Exporter>
<Consignee>
<Consignee_code/>
</Consignee>
</Traders>
<Declarant>
<Declarant_code/>
</Declarant>
<Transport>
<Means_of_transport>
<Departure_arrival_information>
<Identity/>
<Nationality/>
</Departure_arrival_information>
</Means_of_transport>
<Delivery_terms>
<Code/>
<Place/>
</Delivery_terms>
<Place_of_loading>
<Code/>
<Name/>
</Place_of_loading>
</Transport>
<Valuation>
<Gs_Invoice>
<Amount_foreign_currency/>
<Currency_code/>
</Gs_Invoice>
</Valuation>
<Item>
<Packages>
<Number_of_packages/>
<Kind_of_packages_code/>
</Packages>
<Tarification>
<HScode>
<Commodity_code/>
<Precision_1/>
<Precision_2/>
<Precision_3/>
</HScode>
<Extended_customs_procedure/>
<National_customs_procedure/>
<Supplementary_unit>
<Supplementary_unit_quantity/>
</Supplementary_unit>
</Tarification>
<Goods_description>
<Country_of_origin_code/>
<Description_of_goods/>
</Goods_description>
<Valuation_item>
<Weight_itm>
<Gross_weight_itm/>
<Net_weight_itm/>
</Weight_itm>
<Item_Invoice>
<Amount_foreign_currency/>
</Item_Invoice>
</Valuation_item>
</Item>
</TWM_SAD>
I've zero understanding of XML in EXCEL therefore please do not judge me.
I was trying to update one EXCEL file which already had a mapping with XML but I had no clue how to add few more columns which I can map with EXCEL table.
So I prepared an XML or Schema for excel from the scratch looking at the existing, which I think is perfectly working well.
Now when I am trying to map the schema field with EXCEL table and then I am trying to run verify Map for Export I am getting error *Denormalized Data.
What I am able to search on internet is maxocur I have increase something but I have no idea where I have to do that?
Would anybody be able to map the remaining items? OR just tell me how to do the remaining ones?
Do I need to make changes in schema or when mapping in excel I have to do something?
As mentioned I've zero knowledge of XML therefore please try to be basic as much as possible thank you so much!
I'm enclosing excel file as well as schema which I am using in this excel file.
Appreciate your kind responses and thanks in advance!!
Sorry schema file couldn't upload therefore copy & pasting the XML code
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<TWM_SAD xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Identification>
<Office_segment>
<Customs_clearance_office_code/>
</Office_segment>
<Type>
<Type_of_declaration/>
<Declaration_gen_procedure_code/>
</Type>
</Identification>
<Traders>
<Exporter>
<Exporter_name/>
</Exporter>
<Consignee>
<Consignee_code/>
</Consignee>
</Traders>
<Declarant>
<Declarant_code/>
</Declarant>
<Transport>
<Means_of_transport>
<Departure_arrival_information>
<Identity/>
<Nationality/>
</Departure_arrival_information>
</Means_of_transport>
<Delivery_terms>
<Code/>
<Place/>
</Delivery_terms>
<Place_of_loading>
<Code/>
<Name/>
</Place_of_loading>
</Transport>
<Valuation>
<Gs_Invoice>
<Amount_foreign_currency/>
<Currency_code/>
</Gs_Invoice>
</Valuation>
<Item>
<Packages>
<Number_of_packages/>
<Kind_of_packages_code/>
</Packages>
<Tarification>
<HScode>
<Commodity_code/>
<Precision_1/>
<Precision_2/>
<Precision_3/>
</HScode>
<Extended_customs_procedure/>
<National_customs_procedure/>
<Supplementary_unit>
<Supplementary_unit_quantity/>
</Supplementary_unit>
</Tarification>
<Goods_description>
<Country_of_origin_code/>
<Description_of_goods/>
</Goods_description>
<Valuation_item>
<Weight_itm>
<Gross_weight_itm/>
<Net_weight_itm/>
</Weight_itm>
<Item_Invoice>
<Amount_foreign_currency/>
</Item_Invoice>
</Valuation_item>
</Item>
</TWM_SAD>