Convert script to be Server sided

[Dominic Filteau]

Hi all,

in regards to this Post,

I tried another way of doing it..

I have an Applescript that takes value of a field,

then uses the "do shell script" command to generate a txt file on the HD,

then another "do shell script" to change line endings from CR to LF, where the output goes to another directory.

This works just fine when ran from FMP,

but I need to make this Server sided, in order to have the resulted file to be updated on a schedule..

here is what I have so far:

file script is:(based on this example

copy cell "PROFESSIONNELS INTER::CalendarName" of current record to fileName

copy cell "PROFESSIONNELS INTER::tout ensemble" of current record to exportMe



set TextFilePath to "~/Desktop/TestCal/"

set CalendarFolderPath to "/Library/Webserver/Documents/phpicalendar/calendars/"



do shell script "echo -n " & quoted form of exportMe & " >" & TextFilePath & quoted form of fileName & ".txt"





set f to TextFilePath & fileName & ".txt"

set target_file to CalendarFolderPath & fileName & ".ics"

do shell script "tr r n < " & f & " > " & target_file

So

Maybe my logic is too complicated, but i tought of making it server sided like this:

1-Search record to send to file

2-Define the variables

3-pass the variables to shell script.

4-execute shell script

is there a way to actually pass the filemaker variables to a shell script?

What would be a good logic to do what i want?

Data can come from a External table, or straight from source table.. which would be best?

Should I try via PHP instead?

Thanks for your answers, (or for your reading) :wink2: