Best way to import XML Files

George Simon flowersoft at compuserve.com
Wed Jun 16 20:58:06 PDT 2004


What about if I import ascii but set the field and record delimiters to
something that is very unlikely to be found, such as ~.
I could import the entire big.xml file into a dummy and parse the dummy.
What's the maximum size of a dummy field and the maximum size of the import
buffer?

----- Original Message -----
From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "George Simon" <george at worldest.com>
Cc: "George Simon" <flowersoft at compuserve.com>; "filePro mailing list"
<filepro-list at seaslug.org>
Sent: Tuesday, June 15, 2004 2:20 PM
Subject: Re: Best way to import XML Files


>
> George Simon wrote:
> >
> > That is what I was going to try to do, but it seemed (still does) like a
lot
> > of work.
> [...]
> > -----Original Message-----
> > From: filepro-list-bounces at lists.celestial.com
> > [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Kenneth
Brody
> [...]
> > You could try IMPORT ASCII, with ">" as the record delimiter.  This
would
> > at least give you one tag at a time.  You would still have to parse each
> > chunk, but this would break it up into managable chunks.
>
> Well, you say that there are no record delimiters, so you can't use
> something like READLINE() to read a line at a time.  You could use
> READ() to get a certain-sized chunk at a time, but then you still
> have to break it into "logical" chunks after that.  My suggestion
> simplifies it one step by making sure that you don't get more than
> one tag at a time.
>
> --
>
+-------------------------+--------------------+----------------------------
-+
> | Kenneth J. Brody        | www.hvcomputer.com |
|
> | kenbrody at spamcop.net | www.fptech.com     | #include
<std_disclaimer.h> |
>
+-------------------------+--------------------+----------------------------
-+
>
>




More information about the Filepro-list mailing list