I have created a database for clients that use my Internet booking engine for selling airfares.

The user does not have admin access because the data is input in human form and then translated to the formats, strings and structure that the IBE program takes and I do not want to give the user access to mess with the calculations/scripts etc.

Is there anyway to allow a user to set their own file locations for export (even better if they can FTP them direct to our host!) without allowing them full access? Someone told me that it should be possible in FMdev but I cant find it and havent seen it mentioned in the discussions on here.... I know that the export function can have a dialogue but it includes fields and order of export which I dont wish to allow.

If not possible in FM dev itself is there a plugin that can do this?

Hi, Chalkster. For Windows installations (if you have any), i think the easiest way for you to do this would be to make all exports go to the same directory (say, C:Program FilesFilemakerFilemaker Pro 6) and use the Windows shell to move it to a specified directory. So you would make a field called userDirectory into which the user would input, say, "C:Jerrys files" (without quotes). Then make a one-step script -- Send Event, i think it's called in v7 -- will execute that command. For the calculation in that step, specify:

"cmd /c ""C:program filesfilemakerfilemaker pro 6exportname.txt"" " & userDirectory & "destinationFileName.txt"

HTH,

Jerry