Re: bulk upload from text or csv file

Roland wrote:

> Hi,
>
> We use ASCII flat files, with comma delimited.
> Files are downloade from a AS/400 system, and uploaded with FTP to our
> website.
> We are using Pervasive PSQL2000i.
>
> Daily we receive +/- 50000 records that we need to upload in our
> database.
> Existing records must be overwritten (or first deleted).

You had me right up to the last line item. If existing records must be
cleaned out, then the "standard" Pervasive tools would not really apply.

I would, instead, strongly recommend the use of Pervasive's Integration
product line. While there are a couple of different pricing options
(depending on your other needs), the Business Integrator might be the
best all-around solution, as it includes thge ability to automatically
process the files as they get dumped into the FTP site and clean them
up after the fact. With this, you would have a fully-automated
solution!

Let me know directly via Email if I can get your more information on
exact pricing options. You can find lots of product information from
Pervasive's website at www.pervasive.com.

BTW, the Integration products may be able to interface directly with
the AS/400 data, if that makes sense and saves some steps...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - November, 2005 ***
*** Chicago: Pervasive DataExchange Class - November, 2005 ***
.

Relevant Pages

  • Re: Problems with sftp
    ... >>The reason that I mentioned Cute FTP and WS FTP Pro is because THEY DO ... >Unless I'm badly misreading the product information at ... WS_FTP Pro can be configured to use ssh/sftp protocol. ... ABS Computer Technology, Inc. - ESM, Computer & Networking Specialists ...
    (SSH)
  • Re: FTP Server - Creating Users for non-Employees ?
    ... > make use of SSL FTP as well as have integration with AD. ... perhaps just use a web site, ... Steve Foster [SBS MVP] ...
    (microsoft.public.windows.server.sbs)
  • FTP Server - Creating Users for non-Employees ?
    ... Before upgrading to SBS2k3 we have used 3rd party FTP server programs ... It was mainly our clients that used our FTP ... integration with AD etc. ...
    (microsoft.public.windows.server.sbs)
  • Re: [SLE] Install source
    ... integration (rug/zmd is not done). ... testing in my ftp dir soon. ... What will this integration do to the functionality of YOU as we ...
    (SuSE)
  • Re: [SLE] Install source
    ... testing in my ftp dir soon. ... What will this integration do to the functionality of YOU as we ... rug/zmd would be quite done. ...
    (SuSE)