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