Best way to import XML Files
Yussef ElSirgany
yussef at nybusinesslink.com
Thu Jun 17 08:26:18 PDT 2004
George Simon wrote:
>I have to import and process several XML files at a time.
>What I'm planning to do now, since I don't know the name of the files, is:
>copy *.xml big.xml
>and parse the big.xlm file.
>Since there are no single-character field and record delimiters, what is the best way to import this big.xml file?
>
>Thank
>
A two second google search on xml to csv found many entries which show
how to convert a xml file to a csv using xslt. This way you could
easily import your files into filepro.
http://www.scit.wlv.ac.uk/~jphb/xml/xmlcsv.html is an example. You can
even find java code to do the above which would obviously run on either
win or *nix.
Again take a look into xslt which sole purpose is to transform XML
documents into other documents (like XML, HTML, and plain text).
--
Best Regards,
Yussef.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Yussef M. ElSirgany NY Business Link Corporation
Software Engineer/Unix System Administrator 116 7th Street, Hicksville
NY - 11801 - USA
New viruses and security exploits are discovered Phone: 516-620-2544
every day, ask me about how we can secure your network! Fax : 516-620-0052
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20040617/1970b037/attachment.html
More information about the Filepro-list
mailing list