Importing/Exporting tables with Memo fields
Nasir Noor
Since Paradox does not export memo fields from a table, I use PAL code
to do the import/export routines. It works but is very slow. I was
wondering if anyone uses a method with is faster. Could you please
share it?
Thanks.
Nasir.
Peter Hyde
One of my apps does this all the time -- it just scans a tcursor through the
table and does something like this (var tc Tcursor m memo):
m=tc.memoField
m.writetofile(filename)
Personally, I don't find it slow at all, nor do our customers. Are you doing
something different?
cheers,
peter
==============================================================================
Peter Hyde, South Pacific Information Services Ltd
Christchurch, New Zealand -- last time I looked outside
<<< Please use c.d.paradox for ALL relevant messages! >>>
Nasir Noor
Yes, the table contains about 13 fields and the "whole" table has to be
exported out. So if you read every field and append together in a string
var and then write the resulting var (representing a record) to a file,
you may (or may not) find it slower. But the real slowness comes in when
its time to IMPORT that file. Try going thru that file byte by byte
searching for "\n" or chr(255).... Any ideas???
regards,
Nasir.
Peter Hyde
Well perhaps (tho it may have occurred to you already):
1. Import each record into a memo var
2. Convert to string
3. Use the string::search()/substr() or (perhaps better) the string::match()
methods to split the string at each chr(255). Won't be anywhere near as slow
as an Opal byte-by-byte search -- positively respectable in fact.
Hope this works our for you.
Joe Cotellessa@Home
Nasir Noor <nn...@muug.mb.ca> wrote:
>
>Since Paradox does not export memo fields from a table, I use PAL code
Try Conduit, a product of Kallista, Inc. A fairly length product description
follows. (Conduit's current price is $69 plus $6 shipping.)
=============================================================================
"Conduit" by Kallista, Inc. - Fact Sheet
Conduit 1.5 is a powerful Paradox import/export program for users with
sophisticated data needs. The program makes it easy to import corporate
data into Paradox for analysis, manipulation and reporting.
Conduit replaces the FLIMPORT utility that Borland used to ship with
Paradox, but which is not longer included in 4.0. ***BEST OF ALL***,
Conduit is at least 14 times faster than FLIMPORT for comparable operations!!!
Conduit consists of two modules, the project definition system and the
import/export engine. The program definition system allows users to
create and maintain project specification files. The engine reads these
files and performs the actual importing and exporting. You can embed
Conduit within turnkey applications without the full development system
using our Runtime license.
Using the Paradox Engine, Conduit provides full support for local area
networks, Paradox indexes and password protected tables. Conduit
supports the new locking model and secondary indexes added to Paradox
in version 4.0.
Feature Summary
Formats Supported
- True Fixed Length files (streaming text) - no delimiters at all!
- ASCII data - CR/LF record delimiters only (FLIMPORT compatible)
- Delimited data - record and field delimiters
- Word Perfect merge files
- Report to disk format for import. Supports skip over lines,
headers, headings, titles, borders, subtotals and footers.
Supports up to two levels of grouping, including the ability
to read group information into fields for each record.
Project Level Controls
- Specify source and destination table/file on the fly
- set maximum records to import/export for testing purposes
- set overall defaults for number/date formats, delimiters, etc.
- define custom header/trailer sequences and skip characters
- project manager and toolds to manage spec files
- optional displays and reports to monitor operation
- automatically convert FLIMPORT spec files to Conduit projects
Record Level Controls
- Valchecks to accept/reject a record: max, min and required
- Support for a Problems table for non-matching records
- Define custom begin/end record delimiters and skip characters
Field Level Controls
- specify any starting and ending position for fields
- support for complex number formats, including overpunching
- support for any date format, including julian dates
- default values if field is blank
- lookup tables and code substitution
- field level controls override project level defaults
- import text > 255 chars into a Paradox 4.0 memo field
Pricing
Conduit is priced at $159.00. A 5-user network license is also
available for $539. The Runtime license, which allows developers
and corporate users to embed Conduit's engine in their own programs,
costs $300 as a one-time fee.
[>>>> In late July, Kallista said that the price
had been REDUCED to $69, with reductions
in the network and runtime license prices. <<<<]
For more information, or to place an order, contact:
Kallista, Inc.
Suite 1402, 11 East Adams St.
Chicago, IL 60603
312-663-0101
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
... Joe Cotellessa || "We cannot comprehend [it], but we can
(the elder) || comprehend its incomprehensibility." ... I. Kant