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 > suppressed > 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 Perusion 1506 E Gilbert Ave Coeur d'Alene, ID 83815 Email suppressed Phone 208-667-2442 Toll Free 800-949-1889 Fax 775-256-2231 Web http://www.perusion.com _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.