[ic] Storing variable database in SQL database

Greg Hanson greg at valuemedia.com
Fri Sep 2 12:49:05 EDT 2005

Tim Nelson wrote:

> The tables I want to reload on reconfig are read-only and are imported
> from another system.  I consider them static tables that are never
> written to by Interchange.  The basic idea is that I can bring over
> the text files in the middle of the night and force a reconfig.  That
> way any new data from the other system appears the next morning. 
> Nothing in the docs imply that the <table>.sql is auto-generated by
> the import event...
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
You could easily set up a script to bring in the new data at night,
replace whichever .txt files you are going to replace, and remove the
related .sql files.  The tables would then be recreated with the new
data whenever they were accessed next. 

The tables are auto-generated from the .txt file if there is no .sql
file present and the table is properly defined in the configuration and
the .txt file is present.

Greg Hanson
Interchange Consulting
1506 E Gilbert Ave
Coeur d'Alene, ID 83815

Email		greg at perusion.com
Phone		208-667-2442
Toll Free	800-949-1889
Fax		775-256-2231
Web		http://www.perusion.com

More information about the interchange-users mailing list