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