hello to everyone,
could you please help me with my issue regarding xml file.
I have an example xml schema and I have my data in excel.
I want to export these data into this xml schema , so I searched into the internet and one way is to export this xml schema into excel table.
I did and when I want to save this excel into xml data I cannot ( apperars this error : cannot save or export XML data. the xml maps in this workbook are not exportable )
Also I found the problem that was :
Denormalized data
please find my xml schema below and help me if you can how to resolve it. :
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Awmds xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<General_segment>
<General_segment_id>
<Customs_office_code>323</Customs_office_code>
<Voyage_number>JANAR</Voyage_number>
<Date_of_departure>2011-01-08</Date_of_departure>
</General_segment_id>
<Totals_segment>
<Total_number_of_bols>2</Total_number_of_bols>
<Total_number_of_packages>10</Total_number_of_packages>
<Total_number_of_containers>2</Total_number_of_containers>
<Total_gross_mass>2000</Total_gross_mass>
</Totals_segment>
<Transport_information>
<Carrier>
<Carrier_code>PELIKAN</Carrier_code>
<Carrier_name>PELIKAN</Carrier_name>
<Carrier_address>RR</Carrier_address>
</Carrier>
<Mode_of_transport_code>10</Mode_of_transport_code>
<Nationality_of_transporter_code>IT</Nationality_of_transporter_code>
</Transport_information>
<Load_unload_place>
<Place_of_departure_code>ITRAN</Place_of_departure_code>
<Place_of_destination_code>ALDRZ</Place_of_destination_code>
</Load_unload_place>
</General_segment>
<Bol_segment>
<Bol_id>
<Bol_reference>ILDA12</Bol_reference>
<Line_number>1</Line_number>
<Bol_nature>23</Bol_nature>
<Bol_type_code>110</Bol_type_code>
</Bol_id>
<Load_unload_place>
<Place_of_loading_code>ITRAN</Place_of_loading_code>
<Place_of_unloading_code>ALDRZ</Place_of_unloading_code>
</Load_unload_place>
<Traders_segment>
<Exporter>
<Exporter_name> </Exporter_name>
<Exporter_address>ORMA - ORMAN MAHSULLERI VISNEZADE MAH. PROF. ALAEDDIN YAVASCA SOK. MA</Exporter_address>
</Exporter>
<Notify>
<Notify_name></Notify_name>
<Notify_address>BUNA SH.P.K. ALBANIA L.14 SHKOZET </Notify_address>
</Notify>
<Consignee>
<Consignee_name></Consignee_name>
<Consignee_address>BUNA SH. P.K. ALBANIA L.14 SHKOZET 355 DURRES/ALBANIA TEL: 00 35552 264 848 FAX:00 35552 264 262</Consignee_address>
</Consignee>
</Traders_segment>
<ctn_segment>
<Ctn_reference>ARLI1</Ctn_reference>
<Number_of_packages>5</Number_of_packages>
<Type_of_container>NO40</Type_of_container>
<Empty_Full>1/1</Empty_Full>
<Marks1>1</Marks1>
<Marks2>1</Marks2>
<Marks3>2</Marks3>
<Sealing_Party>DOG</Sealing_Party>
</ctn_segment>
<Goods_segment>
<Number_of_packages>5</Number_of_packages>
<Package_type_code>21</Package_type_code>
<Gross_mass>1000</Gross_mass>
<Shipping_marks>Marks</Shipping_marks>
<Goods_description>MELAMINE FACED CHIPBOARDS</Goods_description>
<Num_of_ctn_for_this_bol>1</Num_of_ctn_for_this_bol>
</Goods_segment>
<Value_segment>
<Customs_segment>
<Customs_value>0</Customs_value>
<Customs_currency>EUR</Customs_currency>
</Customs_segment>
</Value_segment>
</Bol_segment>
<Bol_segment>
<Bol_id>
<Bol_reference>ILDA21</Bol_reference>
<Line_number>2</Line_number>
<Bol_nature>23</Bol_nature>
<Bol_type_code>110</Bol_type_code>
</Bol_id>
<Load_unload_place>
<Place_of_loading_code>ITRAN</Place_of_loading_code>
<Place_of_unloading_code>ALDRZ</Place_of_unloading_code>
</Load_unload_place>
<Traders_segment>
<Exporter>
<Exporter_name> </Exporter_name>
<Exporter_address>ORMA - ORMAN MAHSULLERI VISNEZADE MAH. PROF. ALAEDDIN YAVASCA SOK. MA</Exporter_address>
</Exporter>
<Notify>
<Notify_name></Notify_name>
<Notify_address>BUNA SH.P.K. ALBANIA L.14 SHKOZET </Notify_address>
</Notify>
<Consignee>
<Consignee_name></Consignee_name>
<Consignee_address>BUNA SH. P.K. ALBANIA L.14 SHKOZET 355 DURRES/ALBANIA TEL: 00 35552 264 848 FAX:00 35552 264 262</Consignee_address>
</Consignee>
</Traders_segment>
<ctn_segment>
<Ctn_reference>ARLI123</Ctn_reference>
<Number_of_packages>5</Number_of_packages>
<Type_of_container>NO40</Type_of_container>
<Empty_Full>1/1</Empty_Full>
<Marks1>1</Marks1>
<Marks2>1</Marks2>
<Marks3>2</Marks3>
<Sealing_Party>DOG</Sealing_Party>
</ctn_segment>
<Goods_segment>
<Number_of_packages>5</Number_of_packages>
<Package_type_code>21</Package_type_code>
<Gross_mass>1000</Gross_mass>
<Shipping_marks>Marks</Shipping_marks>
<Goods_description>MELAMINE FACED CHIPBOARDS</Goods_description>
<Num_of_ctn_for_this_bol>1</Num_of_ctn_for_this_bol>
</Goods_segment>
<Value_segment>
<Customs_segment>
<Customs_value>0</Customs_value>
<Customs_currency>EUR</Customs_currency>
</Customs_segment>
</Value_segment>
</Bol_segment>
</Awmds>
Thank you all