[ic] Import Products with MySQL

[Stefan Hornburg Racke]

"Andrew Rich" <a.rich@sportingpulse.com> writes:

> Hi
> 
> > Backup products.txt, append to products.txt and reconfig/restart is
> > a good solution.
> 
> How do you reconfig/restart the catalog.
> If you mean services interchange restart then just confirm please.

That would do that, but on a production system you would rather
do "Apply Changes" in the UI or interchange --reconfig=yourcat
for a smooth upgrade. Oh, don't forget to delete products.sql
if your updating products.txt manually.
 
> 
> > Another way to go is the script dbs_update from my DBIx::Easy module.
> 
> Wow thats sounds interesting! What is it?  Where can I read about this or
> can you tell me how.

You got the address already. With IC style text files, do:

dbs_update mysql DBNAME -h -t products -f addproducts.txt

(Replace DBNAME accordingly).

Ciao
        Racke

-- 
Prolific Interchange Consulting (Excellent German Quality !).
Take a look at Materialboerse (http://www.materialboerse.de/), WITT 
(http://www.witt-weiden.de/), Boxmover (http://shop.boxmover.ch/) or 
Passionshop (http://www.passionshop.com/racke). Need a shop ? Contact us.