I am in the need to export files on a regular basis to be picked up by another application on a mac running FM 5.5 or 6.0. When I run a script to export at the moment it overwrites the previous file.

Is there any way to automatically add a serial numbering system to the name of the export file, or a date, or something to distinguish it from the previous file so it doesn't delete the previous one?

Thanks,

Kieron

Yes, but not with strictly FM. You will need a file management plug-in such as Troi File (www.troi.com). It is capable of copying or renaming files.

-bd

Wel, if you, like me, are cheap and don't want to get an extension, you CAN solve the problem without it, using applescript (in other words: free tools!). Conceptually its fairly simple. Have your db do an export to a dummy file name, like tempfile, or something, to the desktop, then, make an applescript that takes the file tempfile of the desktop, and renames it and moves it, naming it the value of some field inside FMPro. Then, just have that field serialize with every export - a much simpler proposition than looking for the number outside FM, somehow

Thanks, problem solved using applescripts and iDO script scheduler.

Kieron