Employers - Post Free Jobs
Forum guidelines
AuthorQuestion
How to export excel data to XML data ???
Posted 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

Offshore Software and Database 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.