Jump to content

Programmatically create and name a file export


Mariano Peterson
 Share

This topic is 6520 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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! smile.gif

Version: Developer v6

Platform: Windows 2000

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6520 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.