Script Schedule

[Mental]

Hi,

I am trying to create a script schedule but it seems that I've found another of Filemaker's billions of bugs and limitations. I am trying to make the file import records from a file in same folder once a day. I've tried it using using a local path, a relative path, a windows path, and a networked path. The server utility shows that the script was performed without error but no files are imported. Also, I tried to get it to send an email to me (Just the simple mail function in the script maker) and it won't do that. As you can probably tell I am getting pretty frustrated so if someone could help I would appreciate it. Thanks a bunch!

- Randall

[Fitch]

Are you running the script from the server (FMS9)? Server 9 can only run script steps that are web compatible.

Look at your script in Scriptmaker. Click the "Indicate web compatibility" checkbox. Notice that Import Records (among other script steps) is now dimmed.

The workaround is to run your script on some sort of loop or timer on a "robot" machine with a FMP client installed.

[Vaughan]

"I've found another of Filemaker's billions of bugs and limitations."

Another ID-10T error. You'd think FMI would have fixed all these by now! ;)

[Mental]

As a possible work-around, is there any way to have a standard version of filemaker pro running at the same time as the server? Can filemaker Server and Filemaker Pro both have the same file open on the same machine? That's the only solution I've been able to come up with so hopefully someone smarter than me will have an idea ;)

[mr_vodka]

Although recently FMI has contradicted its long standing objection to doing when they released FMS9 and FM9, I would still not do it. Their example was for cases where you had no choice in working remotely. It was better to run it on the samre box rather than a remote desktop session where you could loose connectivity... But again, I wouldnt do it.

[Mental]

Sorry, I'm not exactly clear on your answer. When you are referring to "box" are you meaning the same computer? If I had a filemaker pro running on the same machine I probably wouldn't connect via remote access but try to open the file directly. Can the file be open by two different programs directly on the same computer?

[mr_vodka]

If I had a filemaker pro running on the same machine I probably wouldn't connect via remote access but try to open the file directly. Can the file be open by two different programs directly on the same computer?

NO NO NO!

Never do that. That is precisely why for years it has been discouraged to even have a copy on the same box (computer). If you open files that are being served and not going through FMP's open remote, you will most likely corrupt them. Never do this. ;)

[Jalz]

Hi Mental,

Are you trying to import from one FileMaker file to Another FileMaker file? If this is the case, the scheduled import will not work because the Import command is not web enabled. As far as I know only web enabled commands work with FMS schedules.

In regarding getting data across one filemaker table to the other, I would suggest creating a relationship between the two files which will allow you to create records into the second file.

You can the use a loop with a set field command mapping all fields you want to import.

HTH...I've used this method for my ODBC file ;)

[Mental]

Thank you so much for helping. Corrupting my file would have been a disaster (I've done it before and now keep hourly backups) That solves the import problem (Brilliant idea by the way) and the only other problem I have is that after the records are imported, the system creates an account for the user and emails him or her their login information. Is there any way to send an email using server 9 advanced?

[Jalz]

Yep, you can read this link, and learn how to configure FMSAdvanced to email out

http://www.grahamsprague.com/server_side_email/server_side_email.html

I just wish someone could help me with my problem of PHP and SSL on Windows....That has been a real head scratcher....unfortunately I think I'm the only one thats trying to attempt this on Windows