Programmatically create and name a file export

[Mariano Peterson]

I'd like to export data from FileMaker, have the script seamlessly export the data without any user interaction, and have the data saved to a file whose filename is stored in a field (the file will not exist, the script will have to create the file).

I think this can be done using the Troi File plug-in, but I haven't figured it out yet. Does anybody have any suggestions? Thanks!

Version: Developer v6

Platform: Windows 2000

[Fenton]

Basically Filemaker exports to a "fixed" file name, so it always overwrites any existing file of that name. Which is fine if you know it's going to happen. You then rename the file to what you want. The not-so-intuitive bit is that you use the "move" function in Troi to both rename or move a file, 'cause it's basically the same thing.

External("TrFile-MoveFile", gTheFilePath & "|" & gDestFilePath)

I'm not sure exactly where exported files go when you're using hosted files. Perhaps at the root level of the FileMaker application folder. I should test this, as I have to know soon myself.