[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML to ASCII format

• To: xml-dev@l...
• Subject: Re: XML to ASCII format
• From: "Thomas B. Passin" <tpassin@c...>
• Date: Sat, 13 Apr 2002 09:56:53 -0400
• References: <EBEPLGMHCDOJJJPCFHEFCEPKFJAA.danny666@v...>

[Danny Ayers]

>
> >> Can any body help me For Converting XML file  to ASCII file.
> >> so that ASCII format later can be upload into RDBMS system.
> >
> >It's very easy to do this kind of thing using XSLT. There's a bit of a
> >learning curve, but if you're planning to use XML in your system then you
> >ought to become familiar with what XSLT is capable of.
>
> For an alternative, pretty much every language now has SAX API, which can
be
> used without much work to get ASCII out (DOM can be used but this is
rather
> a heavyweight aproach). Most can be run server- or client-side. There's a
> simple example of doing this with Java here :
> http://www.isacat.net/2001/code/CSVtoXML.htm
>
> One thing that you might want to consider is going straight from XML to
> RDBMS, which can be done in Java using JDBC. An example of this
(XMLToJDBC)
> can be found here : http://www.isacat.net/2001/code/index.htm

I've used xslt to create SQL Data Definition Language statements (i.e.,
CREATE TABLE statements), which I ran using the database's management
interface.  I've also used xslt to create Python scripts that insert data
with the Python database API.  I was very happy with both approaches.

Cheers,

Tom P

• References:
  • RE: XML to ASCII format
    • From: "Danny Ayers" <danny666@v...>

• Prev by Date: Re: Re: SVG
• Next by Date: SV: XML to ASCII format
• Previous by thread: RE: XML to ASCII format
• Next by thread: Re: XML to ASCII format
• Index(es):
  • Date
  • Thread