I have a large text file that is downloaded every day and resides on a server. I need to have FM7 automatically import this file every night after hours. The imported file is a pricebook with over 200,000 records. Since the first searches performed on the imported file trigger time-consuming indexing on each field, I would like to have several of the main search fields indexed after the import so that the users do not have to wait. So in a nutshell, I am looking to design a script that will automatically import the file in the middle of the night and index the fields so that each morning we have a newly updated pricebook that is already indexed. If it matters, since the new data will be a complete replacement, the old data can be trashed. Any suggestions would be appreciated!

Write a script in your pricebook file that imports the data how you need it. Now make a new blank file, with one script, which does nothing but call that new script in the pricebook file. If you set that script to run upon opening the new file (File > File Options), then you can set up Windows Task Scheduler to open that file every night at, say, midnight.

As far as indexing goes, once the field has been indexed, it should stay that way, unless this behavior has changed from v6 to v7.

HTH,

Jerry