One of our customer is sending their RFQ's and PO's by xml format. (XML schema Attached)
i am importing these xml documents to my Access Database, while importing i am facing a problem, where XML document having a two fields (DocAddText, LItemLongText). these two fields are not importing completely, only the last line of the lenthy text is importing to my database. hence i have set these two fields in my database as Memo type.
Please help me to resolve this problem. i have to finish this project before 31st of this month.
please consider myselt that, i no nothing about XML.
I can see that the first bit of code <LItemInfo> is imported as the name of the table. The following are imported as the fields in this table.
In the tables that don't import proplerly eg:
<DocAddText>DEAR SUPPLIER THE COMMITMENT OF DELIVERING ON TIME IS ONE OF THE MOST</DocAddText>
<DocAddText>IMPORTANT ISSUES IN SABIC, SO MAKE SURE TO SEND YOUR QUOTATION ON</DocAddText>
<DocAddText>SABIC PURCHASING STANDARD ORDER TERMS AND CONDITIONS SHALL APPLY TO</DocAddText>
I can see that the field <DocAddText> is contstantly being over written because Access interprets this as the same field in the table.
One solution could be to do some editing of the XML documents before you import them to your Access DB. If you write some code that will edit the XML so that it will look more like this:
<DocAddText>DEAR SUPPLIER THE COMMITMENT OF DELIVERING ON TIME IS ONE OF THE MOST IMPORTANT ISSUES IN SABIC, SO MAKE SURE TO SEND YOUR QUOTATION ON IT'S DATE. SABIC PURCHASING STANDARD ORDER TERMS AND CONDITIONS SHALL APPLY TO THIS ORDER.</DocAddText>
Yes as you mensioned i realized the problem, that, it is over writing the field value. But still i don't know the way to do some coding before importing. and also when i contact the customer, who is sending this xml document, when i ask is there a any possibility to do some coding before sending this xml to me, they reply at once no.
So the coding for to get complete field (DocAddText, LItemLongText) values to be done by our side. I don't know how to do this.
Please help me any body how to get the complete field value to my data base.