Sending a message to users.

[tomlepk]

My system imports from an Oracle Database via ODBC every 1.5 hours to get new pending orders. When it imports it erases the entire pending database and imports new entries. Just before it imports I would like to send a message to the users stating that in 1 min the database will be imported then another warning in 10 secs. I don't need it to go to every user just particular ones. Is there a way to send an individual a message popup like when you are needing them to close out for some field editing?

I looked at 'Send Message' script step and it looks more like a commmand line instigator rather then a message sender.

Any ideas?

Thanx,

Thomas Lepkowski

[ November 14, 2001: Message edited by: Thomas Lepkowski ]

[FUBAR]

What about 'Show Message' ?

[tomlepk]

I'm sorry I should have elaborated.

On the workstation running Filemaker Server I have Filemaker Pro 5 running a maintenance script that does the importing and keeps track of inventory levels. The importing does not happen on the individual workstations, When the import script runs I want it to send out a message to a user letting them know that it's about to happen so they can wrap up what ever they are doing. Because right now it just happens and it freaks them out.

[FUBAR]

I haven't touched FileMaker for creating multi-user databases, but wouldn't you be able to pause the script, use 'Show Message' to send out the warning, then the user saves everything they need to, clicks OK and then the script resumes?

[tomlepk]

No, the 'Show Message' script-step on would only show a message on the unattended server where the import script runs from.

[FUBAR]

Ohhh I understand...don't mind my mindless ramblings

Sorry can't help ya but hopefully one of the resident experts can.

[tomlepk]

No, thanx for trying anyway.

[Vaughan]

The only way to send messages to users s through the Sharing command in FMP. I don't think it is mscriptable though.

[SteveB]

If you're running on Windows platforms (any OS) consider using WinBatch. It has netware & email extenders and is pretty easy to use. See www.wilsonware.com for a downloadable trial copy.

[ November 14, 2001: Message edited by: Steveinvegas ]