> My data looks like this (just 1 line pasted here) > stockcode="" chknum="" invnum="28641.00" desc="17" Philips LCD > monitor" period="" paidinv="false" ordernum="0.00" ordref="" > sperson="1" > > I have seen the xml file the client wants and it is a beautifully > formatted file (It looks like a FRX output but with color etc) > > They want it this way in order to import the information into their > accounting system. > Why they can't just use a CSV file is beyond me.
XML is the data. Open their xml file with notepad and look at the data-- there's a good chance it looks similar to your file. Their xml file also likely has a tag at the top referencing the xsl file. When you double click the xml file in Windows, it's likely opening Internet Explorer, and IE looks at the reference to the xsl file and automatically transforms the xml file to the visual display specified in the xsl file. If your xml data and their xml data is the same(same attribute names, etc.), you can copy the element specifying the xsl file from their file into yours and it should format the same way(again, the elements, attributes, etc. need to be identically named; they usually aren't, hence the reason cursortoxml doesn't work well for matching someone else's schema).. -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
