[ic] Automating Table Importation

Stefan Hornburg interchange-users@icdevgroup.org
Thu Feb 13 06:24:01 2003


On Thu, 13 Feb 2003 10:07:35 -0000
"Adrian P Wilkinson" <junk@puffin.org> wrote:

> Dear IC Users,
> 
> We have a custom application running under Microsoft Access to handle the
> updating of stock and pricing information against the data provided by our
> distributors.  The end result is that we end up with a products and
> inventory table containing the most up-to-date price and stock levels
> according to a formula to determine where to purchase parts from.  Once this
> processing had been done we can export the data to text files ready for
> importation into Interchange.
> 
> Is there any way that we can automate the importation of these two tables
> from a text file into the Interchange database (hosted on MySQL)?  I was
> thinking upon the lines of getting an ftp program to upload the output files
> and put them in {catalog_home}/products as inventory.txt and products.txt.
> How would I go about importing them from here?

The following should work:

rm products/inventory.sql
rm products/products.sql

interchange --reconfig=catname

Bye
       Racke