PDOXWIN 4.5 Importing
Epsgroup
comma-delimited ASCII file with a field that is longer than 255
characters. PDOXWIN happily chops everything off after 255. I was suprised
by this because of the memo field capabilities of PDOXWIN. In any event, I
need to be able to successfully import this data without data loss.
Does anyone have an idea of how this can be done?
Mike Torrence
Epsg...@aol.com
MT...@aol.com
Electronic Publishing Services, Inc.
Joe Cotellessa@Home
Epsgroup <epsg...@aol.com> wrote:
>I am attempting (unsuccessfully at this point) to import and work with a
>comma-delimited ASCII file with a field that is longer than 255
>characters. PDOXWIN happily chops everything off after 255.
Borland's documentation warns you about this. You can write a IOstream
method in OPAL, or use Conduit, a $75 product of Kallista, Inc.
Enclosed is some info & a fact sheet from Kallista about Conduit.
=========================================================================+
Conduit, a Kallista product for Paradox imports and exports ASCII
data to/from Paradox. It costs about $75 and does a great job, once you
figure it out. [CAUTION: Conduit insists on treating the pipe character (|),
one of my favorite delimiters, as a hard carriage return.] Conduit also
imports and exports (long) Memo fields, something that Paradox itself
(& FLIMPORT) doesn't do.
I'm including Kallista's Fact Sheet on Conduit. It's dated ~3/94,
& from Dan Ehrmann, their President. (E-mail: 70007...@compuserve.com)
The end of the fact sheet gives Kallista's address & phone no. -- they're
in Chicago, at 312-663-0101.
=============================================================================
"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