[ic] Trying to import 50,000 items

[Chen Naor]

There are a few options:
1. You can try to split the file to 10 or 20 parts and import them one after
another (update).
2. you can use ODBC driver (if working from windows)
3. pgAdminII is a great program with an import option from tab delimited
files (again windows)
4. I'm not shore but maybe it is possible to do a copy from psql to an
external tab delimited file.

Good luck
Chen

----- Original Message -----
From: "Nicholas Cook" <ncook@foxmillpets.com>
To: <interchange-users@interchange.redhat.com>
Sent: Tuesday, August 06, 2002 9:06 AM
Subject: [ic] Trying to import 50,000 items


> I am trying to import a catalog of roughly 50,000 items and I am finding
> the import from the admin ui too slow (timing out on webserver).
> Database is PostgreSQL 7.1.3 and Interchange 4.8.3.  Is there a command
> line utility to allow this from a tab delineated file.  Also, curiosity
> question.  For those other people that have done the same, roughly how
> long did it take for your import to finish.
>
> Thank you,
> Nicholas Cook
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>