• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Not able to export to XML from Excel data might require some kind of coding

rhythm

rhythm

New Member
I have created an XML file and which I imported into excel using Source option in developers option. But whenever I am trying to export the data I am getting error saying "Can not save or export XML data. The XML maps in this workbook are not exportable". So I required help in this regards and also in <noofmasterinvoices></noofmasterinvoices> and <noofinvoices></noofinvoices> count of master invoice and invoice should appear which I don't know how to do it.

I have copy pasted the XML tagging for your reference and also the excel data.
<!--?xml version="1.0" encoding="UTF-8" standalone="yes"?-->
<company>
<checksum>
<noofmasterinvoices></noofmasterinvoices>
<noofinvoices></noofinvoices>
</checksum>
<masterinvoices>
<masterinvoice>
<masterinoviceno></masterinoviceno>
<masterinvoicedate></masterinvoicedate>
<draweename></draweename>
<draweecountry></draweecountry>
<invoices>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
</invoices>
</masterinvoice>
</masterinvoices>
<masterinvoices>
<masterinvoice>
<masterinoviceno></masterinoviceno>
<masterinvoicedate></masterinvoicedate>
<draweename></draweename>
<draweecountry></draweecountry>
<invoices>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
</invoices>
</masterinvoice>
</masterinvoices>
</company>


Please help
 

Attachments

Hi ,

If you click on Verify Map for Export , you will get messages on what you need to do ; most of these things need to be done when you import.

Narayan
 
Hi Narayan,

Thanks for the reply. As you instructed i cliked on "Verify Map for export" and error is "Denormalized data". I don't know much about xml any help would be much appreciated.

sample xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<COMPANY>
<checkSum>
<noOfMASTERINVOICES></noOfMASTERINVOICES>
<noOfInvoices></noOfInvoices>
</checkSum>
<MASTERINVOICES>
<MASTERINVOICE>
<MASTERINOVICENO></MASTERINOVICENO>
<MASTERINVOICEDATE></MASTERINVOICEDATE>
<DRAWEENAME></DRAWEENAME>
<DRAWEECOUNTRY></DRAWEECOUNTRY>
<invoices>
<invoice>
<invoiceNo></invoiceNo>
<invoiceDate></invoiceDate>
<INVOICEAMT></INVOICEAMT>
</invoice>
<invoice>
<invoiceNo></invoiceNo>
<invoiceDate></invoiceDate>
<INVOICEAMT></INVOICEAMT>
</invoice>
</invoices>
</MASTERINVOICE>
</MASTERINVOICES>
</COMPANY>
 
Hi ,

Normalized data is where every record is unique ; if the XML schema has set the property called maxoccurs to 1 , and if your table contains records which are not unique , then this error can come.

Basically , unless you upload the workbook for every such error , there is not much I can suggest.

Narayan
 
You must log in or register to reply here.
Back
Top