FMSA Server-side script to get data into table

[xochi]

I have an encryption computation that exists as a command-line tool that I can call from the OS X shell (e.g. `/usr/bin/myEncrypt xyz` returns a value: 12345 ).

I need to use this on a server-scheduled script to use this to populate a field in my database.

I see that in FMSA11 there is a new class of scripts which has pre and post scripts -- It runs a FileMaker script, then a Shell script, then a FileMaker script -- so I could probably use this to export records, process them in the shell, then re-import. But this seems like overkill.

Is there perhaps a simpler way to do this? Maybe using PHP or ODBC in the shell script itself?

[Wim Decorte]

or one of the many encryption plugins...