dougw

I figured it out... I tried rewriting from scratch but that didn't work. Here's the solution that worked... The original ftp batch file that I used with FM6 looked something like this: ftp -d -i -s:GetKNF_ftp.txt 192.168.0.1 For FileMaker 9, I just had to put the full pathway for the script file. So now it looks like this: ftp -d -i -s:/C:/temp/KNF_Ftp_ Scripts/GetKNF_ftp.txt 192.168.0.1 Doug

I am currently working at updating some databases from FM6 to FM9.0 on a Windows XP PC. I have one script that uses Send Event to run a batch file that ftp's a file from a remote computer to the one running FileMaker. It works fine all the time under FM6. With FM9, it worked the first time. Then I closed the program and later opened it again. This time it just flashed the command window very quickly but didn't do anything. After trying several different combinations, I find that if I go back into the script, reselect the batch file to run, it will work until I close the file. Then when I open the file again, it quickly flashes the command window but won't actually run the batch file. In setting up Send Event... File Type displays "Windows Batch File" Send the "Open Document/Application" messages is selected Specify file is set up as the following: filewin:/C:/temp/KNF_Ftp_Scripts/GetKNF_ftp.bat Any ideas? thanks, Doug

I work for the Head Office of a group of retail stores. I will be getting 2000 records per store, per week from 45 of those stores. The information will be used for sales reporting, ranking, forcasting, etc. For various reasons I am still using FM 6.04 on Windows 2000 2.4GHZ. As a test I set up a file and started importing records from just 6 stores. It worked okay until I hit 400,000 records. At 500,000 it's gotten too slow. I see that FM9 will work with MySQL and am looking at upgrading the system anyways before June 30. Has anybody had any experience with Filemaker and MySQL where there will be approximately 4.7 million records per year (plus more as we add new stores)? I need to know though whether it will work or if I should be looking at another method of dealing with the volume of records. thanks in advance Doug