Unattended record import in FM7,8,9 possible?

[rstone]

I'm an old hand at FM4,5, and 6, but our office just recently upgraded to FM9. Most things are working just fine, but the new importing dialogue box is driving me crazy.

On our old system, I had some files that I'd run on a processing machine. The files would launch, import records from our hosted databases, then I'd run a script to process those records, run SQL commands to update a mysql database, then the records would delete. The processing machine was unattended, and the databases would launch on a scheduler, and close themselves out when they were done via FM scripts.

Now that we're on FM9, I can't get away from the username/password prompt whenever I try to import records. I've tried creating admin accounts in the processing files that match the files I'm importing from, selecting "perform without dialog" in the import step, but nothing works. It's really frustrating, and I'm not sure how I can have an unattended process now. I have to remote into that machine to select either 'guest' or enter a username/password before records will import.

Any clues would be appreciated. Thanks!

[bcooney]

With FMS10, you can use server-side scripting.