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

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.