[ic] Keeping database and text files in sync

Jerry Brady interchange-users@icdevgroup.org
Wed Sep 18 09:53:02 2002


>.... I know that there is an "auto-export" checkbox in 
>the admin interface, but i'm wondering if there's some way to tell 
>interchange to grab all the info in the mysql table and overwrite the 
>current text file with it?

John,

Add export tags pages when you want to sync your database with the .txt
files stored in the products directory.  I use it in one of my catalogs
to ensure that my transactions and orderline tables are in sync.  I
simply inserted:

[export transactions]
[export orderline]

into etc/log_transaction so when orders are placed and routed my tables
get "backed-up" so to speak.  By default, the tag will generate a
standard <table_name>.txt file in the products directory.  See the tags
reference manual for further details.

Regards,
Jerry Brady
Blue Circle Technologies