Re: XML->ascii Conversion

Subject: Re: XML->ascii Conversion
From: Mitch Christensen <mitch_christensen@xxxxxxxxx>
Date: Thu, 19 Aug 1999 14:37:28 -0700
Hi Mike,

Thanks for responding.  I'll try to be both specific and consise.

I want to translate the following...

<orderlist>
    <order ordernum="1">
        <customer>
            <firstname>John</firstname>
            <lastname>Doe</lastname>
            <phone>(510) 555-1212</phone>
        </customer
    </order>
    <order ordernum="2">
        <customer>
            <firstname>Jane</firstname>
            <lastname>Smith</lastname>
            <phone>(916) 555-1212</phone>
        </customer
    </order>
</orderlist>

into a tab-delimited ascii file for import into QuickBooks like this...

firstname    lastname    phone
John         Doe         (510) 555-1212
Jane         Smith       (916) 555-1212

My current model is as follows...

   qbout.xml-      +-----------+
              \    |           |
               +-->+ ixslt.exe +---> outfile.txt
              /    |           |
qb2ascii.xsl-      +-----------+

I just can't seem to get this to work.

If you have an example or any advice at all, I would greatly appreciate it.

Thanks,
Mitch
 

Mike Brown wrote:

> I need to convert XML to straight ascii text.

Are you wanting to convert an XML document from one character set encoding
like UTF-8 to US-ASCII, so the document is the same, i.e. markup and data,
just with some of the characters changed to something suitable for your
display ... or are you wanting to emit, for example, just the names of
elements and their contents, perhaps like myElement: 'someValue', or what?
Be more specific, showing what you have as input and what you want as
output.

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

Current Thread