Forum guidelines
AuthorQuestion
How to export excel data to XML data ???
Posted By Alban Boni on 01 Apr 2013
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

Infragistics jQuery Controls

SPONSORED BY

JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.